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

#!/bin/bash

. ../inc/pervasive.sh

###########################################################
[ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat"

confirm "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""

echo "* create database"
mysql_exec_nodb "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 .

###########################################################
confirm "* Running upgrade scripts"
script_run ../newdirectory-0.0.1/phones.php
script_run ../newdirectory-0.0.1/addresses.php
script_run ../account/birthday.php
Commit	Line	Data
a90ca862 RB	1	#!/bin/bash
	2
	3	. ../inc/pervasive.sh
	4
bb9d47f4 FB	5	###########################################################
	6	[ "$DATABASE" != "x4dat" ] \|\| die "Cannot target x4dat"
	7
	8	confirm "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
	9
01bb23e6	10	echo "* create database"
652f22ee	11	mysql_exec_nodb "CREATE DATABASE IF NOT EXISTS $DATABASE;"
bb9d47f4 FB	12	echo "OK"
bb9d47f4 FB	13
01bb23e6 RB	14	echo "* copying tables "
01bb23e6 RB	15	(../account/copy_tables.sh \| while read line; do mysql_exec "$line"; done) \|\| die "ERROR"
bb9d47f4 FB	16	echo "OK"
	17
	18	mysql_run_directory ../newdirectory-0.0.1
	19	mysql_run_directory ../account
	20	mysql_run_directory .
a90ca862 RB	21
a90ca862 RB	22	###########################################################
01bb23e6	23	confirm "* Running upgrade scripts"
bb9d47f4 FB	24	script_run ../newdirectory-0.0.1/phones.php
bb9d47f4 FB	25	script_run ../newdirectory-0.0.1/addresses.php
bb9d47f4	26	script_run ../account/birthday.php