upgrade/account/upgrade.sh

   1 #!/bin/bash
   2
   3 . ../inc/pervasive.sh
   4
   5 ###########################################################
   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
  11 for sql in *.sql
  12 do
  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"
  16 done
  17
  18 ###########################################################
  19 echo "Updating birthday dates"
  20
  21 ./birthday.php