#!/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