Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | #!/usr/bin/env /bin/bash |
2 | ||
3 | source `dirname $0`/setup.conf | |
4 | ||
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 | |
8 | PASSWDSECTION="" | |
9 | else | |
10 | PASSWDSECTION="-p$DBPASS" | |
11 | fi | |
12 | ||
13 | pushd . | |
b8b65506 | 14 | cd $CIVISOURCEDIR |
8f1445ea | 15 | # svn up . |
b8b65506 | 16 | cd $CIVISOURCEDIR/bin |
6a488035 | 17 | ./setup.sh |
b8b65506 | 18 | cd $CIVISOURCEDIR/sql |
6a488035 TO |
19 | |
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'" \ | |
24 | | $MYSQLCMD \ | |
25 | | grep '^\(civicrm_\|log_civicrm_\)' \ | |
26 | | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \ | |
27 | | $MYSQLCMD | |
28 | echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \ | |
29 | | $MYSQLCMD \ | |
30 | | grep '^\(civicrm_\|log_civicrm_\)' \ | |
31 | | awk -v NOFOREIGNCHECK='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \ | |
32 | | $MYSQLCMD | |
33 | ||
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 | |
38 | php GenerateData.php | |
39 | ||
40 | # run the cli script to build the menu and the triggers | |
b8b65506 | 41 | cd $CIVISOURCEDIR |
6a488035 TO |
42 | "$PHP5PATH"php bin/cli.php -e System -a flush --triggers 1 --session 1 |
43 | ||
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';" | |
45 | ||
b8b65506 | 46 | cd $CIVISOURCEDIR/sql |
6a488035 TO |
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 | |
f078ea51 | 52 | cat civicrm_dummy_processor.mysql >> civicrm_generated.mysql |
6a488035 TO |
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 | |
57 | popd |