#!/bin/sh
# Filename..........: $RCSfile: create_dbs.sh,v $
# Original Author...: Anthony L. Awtrey
# Version...........: $Revision: 1.5 $
# Last Modified By..: $Author: aawtrey $
# Last Modified On..: $Date: 2005/05/19 02:24:21 $
#
# Copyright 2003 I.D.E.A.L. Technology Corporation
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# Purpose: Create the tables and load the data files into the Worship
# Organizer database.

MYSQL='/usr/bin/mysql'
HOST='localhost'
USER='worship'
PASS='organizer'
DB='worship'

for i in *.sql; do
  ${MYSQL} -h${HOST} -u${USER} -p${PASS} ${DB} < ${i}
  if [ $? != 0 ]; then
    echo Error in ${i}!
  fi
done

for i in *.dat; do
  if [ -s ${i} ]; then
    ${MYSQL} -h${HOST} -u${USER} -p${PASS} ${DB} < ${i}
    if [ $? != 0 ]; then
      echo Error in ${i}!
    fi
  fi
done

echo All Done!

# End