[platal.git] / upgrade / account / upgrade.sh

#!/bin/bash

. ../inc/pervasive.sh

###########################################################
echo "Setting up new database: target db is $DATABASE, source prefix is $DBPREFIX"
echo -n "* copying tables"
./copy_tables.php || die "ERROR"
echo " OK"

for sql in *.sql
do
    echo -n "* running $sql"
    (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE &>/dev/null) || die "ERROR"
    echo " OK"
done

###########################################################
echo "Updating birthday dates"

./birthday.php
Commit	Line	Data
06490196	1	#!/bin/bash
7e735012	2
06490196	3	. ../inc/pervasive.sh
7e735012	4
06490196	5	###########################################################
100e66fc FB	6	echo "Setting up new database: target db is $DATABASE, source prefix is $DBPREFIX"
	7	echo -n "* copying tables"
	8	./copy_tables.php \|\| die "ERROR"
	9	echo " OK"
	10
06490196 VZ	11	for sql in *.sql
06490196 VZ	12	do
100e66fc FB	13	echo -n "* running $sql"
	14	(sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql \| $MYSQL $DATABASE &>/dev/null) \|\| die "ERROR"
	15	echo " OK"
06490196 VZ	16	done
	17
	18	###########################################################
	19	echo "Updating birthday dates"
	20
	21	./birthday.php