#!/bin/sh

# This script will create our
# sample concerts database.
# It assumes that  mSQL has been
# installed in
# /usr/local/Minerva.

MSQLHOME=/usr/local/Minerva

# Create the database

$MSQLHOME/bin/msqladmin create concerts

# Load the schema

$MSQLHOME/bin/msql concerts << EOF
	drop table listings
	\p\g
	
 	create table listings (
		show_date	char(10),
		headliner	char(30),
		opening_act	char(30),
		location	char(30),
		ticket_price	char(10)
	)
	\p\g
EOF

# Load the sample data.

$MSQLHOME/bin/msql concerts << EOF

INSERT INTO listings VALUES ('07-06-1996','Black Sabbath','Amy Grant','Boston','11.50')\g
INSERT INTO listings VALUES ('07-07-1996','Black Sabbath','Amy Grant','Chicago','11.50')\g
INSERT INTO listings VALUES ('07-08-1996','Black Sabbath','Amy Grant','New York','11.50')\g
INSERT INTO listings VALUES ('07-09-1996','Black Sabbath','Amy Grant','Tampa','11.50')\g
INSERT INTO listings VALUES ('07-10-1996','Black Sabbath','Amy Grant','Seattle','11.50')\g
INSERT INTO listings VALUES ('07-11-1996','Black Sabbath','Amy Grant','Dallas','11.50')\g
INSERT INTO listings VALUES ('07-09-1996','The Jonathan Gross Band','Smashing Windows','Dallas','24.50')\g
INSERT INTO listings VALUES ('08-14-1996','The Jonathan Gross Band','Smashing Windows','New York','19.95')\g
INSERT INTO listings VALUES ('08-18-1996','The Jonathan Gross Band','Smashing Windows','Los Angeles','24.50')\g
INSERT INTO listings VALUES ('07-02-1996','Hootie and the NT Blowsfish','The Linux Torvalds Quartet','Munich','DM -32.00')\g
INSERT INTO listings VALUES ('07-04-1996','Hootie and the NT Blowsfish','The Linux Torvalds Quartet','London','18 quid')\g
INSERT INTO listings VALUES ('07-05-1996','Hootie and the NT Blowsfish','The Linux Torvalds Quartet','New York','12.00')\g
INSERT INTO listings VALUES ('07-08-1996','Hootie and the NT Blowsfish','The Linux Torvalds Quartet','Chicago','12.00')\g
INSERT INTO listings VALUES ('07-09-1996','Hootie and the NT Blowsfish','The Linux Torvalds Quartet','Detroit','12.00')\g

EOF