#!/bin/sh

# This script will create a simple report called "concert.listings". The
# report is merely a dump of the mSQL database. This script assumes that
# mSQL was installed in /usr/local/Minerva

MSQLHOME=/usr/local/Minerva

# Select all records from the database and dump them out to a file

$MSQLHOME/bin/msql concerts > concert.listings << EOF
	select * from listings
	\p\g
EOF