-cd "$CALLEDPATH/../sql"
-echo; echo "Dropping civicrm_* tables from database $DBNAME"
-# mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
-MYSQLCMD=$(mysql_cmd)
-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_SCHEMA" ]; then
+ pushd "$CALLEDPATH/../sql"
+ echo; echo "Dropping civicrm_* tables from database $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
+ popd