| 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 . |
| 14 | cd $CIVISOURCEDIR |
| 15 | # svn up . |
| 16 | cd $CIVISOURCEDIR/bin |
| 17 | ./setup.sh |
| 18 | cd $CIVISOURCEDIR/sql |
| 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 |
| 41 | cd $CIVISOURCEDIR |
| 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 | |
| 46 | cd $CIVISOURCEDIR/sql |
| 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 |
| 57 | popd |