#!/bin/sh
#
#  Change the names of the database etc here
##
DBASE='FGDC';
LOG='Load.log';
#
echo ' ';
echo ' Performing the FGDC schema load. Log file is ' $LOG;
echo ' ';
if [ -f $LOG ] 
then 
  rm $LOG;
fi;
#
echo ' '>> $LOG;
echo ' mondropping the database ' $DBASE ' at ' `date`>> $LOG;
echo ' '>> $LOG;
mondropdb $DBASE>> $LOG;
#
echo ' '>> $LOG;
echo ' moncreating the database ' $DBASE>> $LOG;
echo ' '>> $LOG;
moncreatedb $DBASE >> $LOG;
#
echo ' ' >> $LOG;
echo ' Running the schema install scripts at '`date` >> $LOG;
echo ' '>> $LOG;
#
for i in `ls FGDC_Meta*`
do
  echo ' Loading ' $i>> $LOG;
  msql $DBASE < $i >> $LOG;
done
echo ' '>> $LOG;
echo ' Finished' `date`>> $LOG;
echo ' '>> $LOG;
#