upgrade/account/update.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 "* press ^D to start import"
   8 cat
   9
  10 echo -n "* copying tables "
  11 ./copy_tables.php || die "ERROR"
  12 echo "OK"
  13
  14 for sql in ../newdirectory-0.0.1/*.sql
  15 do
  16     echo -n "* running $sql "
  17     (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE &>/dev/null) || die "ERROR"
  18     echo "OK"
  19 done
  20
  21 for sql in *.sql
  22 do
  23     echo -n "* running $sql "
  24     (sed -e "s/#\([0-9a-z]*\)#/${DBPREFIX}\1/g" < $sql | $MYSQL $DATABASE &>/dev/null) || die "ERROR"
  25     echo "OK"
  26 done
  27
  28 ###########################################################
  29 echo -n "Importing phone numbers "
  30
  31 ./newdirectory-0.0.1/phones.php || die "ERROR"
  32 echo "OK"
  33
  34 ###########################################################
  35 echo "Updating birthday dates "
  36
  37 ./birthday.php || die "ERROR"
  38 echo "OK"