-cd "$CALLEDPATH/../sql"
-echo; echo "Dropping civicrm_* tables from database $DBNAME"
-# mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
-MYSQLCMD="mysql -u$DBUSER $PASSWDSECTION $HOSTSECTION $PORTSECTION $DBARGS $DBNAME"
-echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \
- | $MYSQLCMD \
- | grep '^\(civicrm_\|log_civicrm_\)' \
- | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \
- | $MYSQLCMD
-echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \
- | $MYSQLCMD \
- | grep '^\(civicrm_\|log_civicrm_\)' \
- | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \
- | $MYSQLCMD
-
-
-echo; echo Creating database structure
-$MYSQLCMD < civicrm.mysql
-
-# load civicrm_generated.mysql sample data unless special DBLOAD is passed
-if [ -z $DBLOAD ]; then
- echo; echo Populating database with example data - civicrm_generated.mysql
- $MYSQLCMD < civicrm_generated.mysql
-else
- echo; echo Populating database with required data - civicrm_data.mysql
- $MYSQLCMD < civicrm_data.mysql
- echo; echo Populating database with $DBLOAD data
- $MYSQLCMD < $DBLOAD
+if [ -n "$DO_DATA" ]; then
+ pushd "$CALLEDPATH/../sql"
+ # load default data set unless system is configured with override
+ if [ -z $DBLOAD ]; then
+ echo;
+ echo "Populating database with dataset - $DEFAULT_DATA"
+ $MYSQLCMD < "$DEFAULT_DATA"
+ else
+ echo; echo Populating database with required data - civicrm_data.mysql
+ $MYSQLCMD < civicrm_data.mysql
+ echo; echo Populating database with $DBLOAD data
+ $MYSQLCMD < $DBLOAD
+ fi
+
+ # load additional script if DBADD defined
+ if [ ! -z $DBADD ]; then
+ echo; echo Loading $DBADD
+ $MYSQLCMD < $DBADD
+ fi
+ popd