1 #!/usr/bin/env /bin/bash
3 source `dirname $0`/setup.conf
5 # someone might want to use empty password for development,
6 # let's make it possible - we asked before.
7 if [ -z $DBPASS ]; then # password still empty
10 PASSWDSECTION
="-p$DBPASS"
20 echo; echo "Dropping civicrm_* tables from database $DBNAME"
21 # mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
22 MYSQLCMD
="mysql -u$DBUSER $PASSWDSECTION $DBARGS $DBNAME"
23 echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \
25 |
grep '^\(civicrm_\|log_civicrm_\)' \
26 |
awk -v NOFOREIGNCHECK
='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \
28 echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \
30 |
grep '^\(civicrm_\|log_civicrm_\)' \
31 |
awk -v NOFOREIGNCHECK
='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \
34 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm.mysql
35 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_data.mysql
36 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_sample.mysql
37 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < zipcodes.mysql
40 # run the cli script to build the menu and the triggers
42 "$PHP5PATH"php bin
/cli.php
-e System
-a flush
--triggers 1 --session 1
44 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME -e "DROP TABLE zipcodes; UPDATE civicrm_domain SET config_backend = NULL; UPDATE civicrm_setting SET value = NULL WHERE name = 'userFrameworkResourceURL' OR name = 'imageUploadURL';"
47 mysqldump
-cent --skip-triggers -u $DBUSER $PASSWDSECTION $DBARGS $DBNAME > civicrm_generated.mysql
48 #cat civicrm_sample_report.mysql >> civicrm_generated.mysql
49 cat civicrm_sample_custom_data.mysql
>> civicrm_generated.mysql
50 #cat civicrm_devel_config.mysql >> civicrm_generated.mysql
51 cat ..
/CRM
/Case
/xml
/configuration.sample
/SampleConfig.mysql
>> civicrm_generated.mysql
52 cat civicrm_dummy_processor.mysql
>> civicrm_generated.mysql
53 mysqladmin
-f -u$DBUSER $PASSWDSECTION $DBARGS drop
$DBNAME
54 mysqladmin
-u$DBUSER $PASSWDSECTION $DBARGS create
$DBNAME
55 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm.mysql
56 mysql
-u$DBUSER $PASSWDSECTION $DBARGS $DBNAME < civicrm_generated.mysql