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