Merge pull request #18928 from demeritcowboy/left-right-up-down
[civicrm-core.git] / bin / regen.sh
index f975c2e88aa67d8c582a3de2e854b96d61c973c3..42cb64cdc35d9d99e74cd1259fdb96b67197aff5 100755 (executable)
@@ -39,8 +39,6 @@ echo "SELECT table_name FROM information_schema.TABLES  WHERE TABLE_SCHEMA='${DB
 $MYSQLCMD < civicrm.mysql
 $MYSQLCMD < civicrm_data.mysql
 $MYSQLCMD < civicrm_sample.mysql
-echo "DROP TABLE IF EXISTS zipcodes" | $MYSQLCMD
-$MYSQLCMD < zipcodes.mysql
 
 ## For first boot on fresh DB, boot CMS before CRM.
 cms_eval 'civicrm_initialize();'
@@ -48,7 +46,8 @@ cms_eval 'civicrm_initialize();'
 php GenerateData.php
 
 ## Prune local data
-$MYSQLCMD -e "DROP TABLE zipcodes; DROP TABLE IF EXISTS civicrm_install_canary; UPDATE civicrm_domain SET config_backend = NULL; DELETE FROM civicrm_extension; DELETE FROM civicrm_cache; DELETE FROM civicrm_setting;"
+$MYSQLCMD -e "DROP TABLE IF EXISTS civicrm_install_canary; DELETE FROM civicrm_cache; DELETE FROM civicrm_setting;"
+$MYSQLCMD -e "DELETE FROM civicrm_extension WHERE full_name NOT IN ('sequentialcreditnotes', 'eventcart', 'greenwich', 'search', 'flexmailer', 'financialacls');"
 TABLENAMES=$( echo "show tables like 'civicrm_%'" | $MYSQLCMD | grep ^civicrm_ | xargs )
 
 cd $CIVISOURCEDIR/sql