Use mysql_run, mysql_exec in update scripts

[platal.git] / upgrade / 1.0.0 / update.sh

diff --git a/upgrade/1.0.0/update.sh b/upgrade/1.0.0/update.sh
index 928d1e4..d7f6f65 100755 (executable)
--- a/upgrade/1.0.0/update.sh
+++ b/upgrade/1.0.0/update.sh
@@ -2,14 +2,26 @@
 
 . ../inc/pervasive.sh
 
-mailman_stop
-mailman_templates
-mailman_start
+###########################################################
+[ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat"
+
+confirm "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
+
+echo "* create database"
+mysql_exec "CREATE DATABASE IF NOT EXISTS $DATABASE;"
+echo "OK"
+
+echo "* copying tables "
+(../account/copy_tables.sh | while read line; do mysql_exec "$line"; done) || die "ERROR"
+echo "OK"
+
+mysql_run_directory ../newdirectory-0.0.1
+mysql_run_directory ../account
+mysql_run_directory .
 
 ###########################################################
-for sql in *.sql
-do
-    echo -n $sql
-    $MYSQL $DATABASE < $sql &>/dev/null || echo -n " ERROR"
-    echo .
-done
+confirm "* Running upgrade scripts"
+script_run ../newdirectory-0.0.1/phones.php
+script_run ../newdirectory-0.0.1/addresses.php
+script_run ../newdirectory-0.0.1/alternate_subsubsectors.php
+script_run ../account/birthday.php