#!/bin/sh

# This script creates 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 to a file

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