upgrade/account/update.sh

   1 #!/bin/bash
   2
   3 . ../inc/pervasive.sh
   4
   5 ###########################################################
   6 [ "$DATABASE" != "x4dat" ] || die "Cannot target x4dat"
   7
   8 echo "Setting up new database: target db is \"$DATABASE\", source prefix is \"$DBPREFIX\""
   9 echo "* press ^D to start import (^C to cancel)"
  10 cat
  11
  12 echo -n "* create database "
  13 (echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | mysql_run) || die "ERROR"
  14 echo "OK"
  15
  16 echo -n "* copying tables "
  17 (./copy_tables.sh | mysql_run) || die "ERROR"
  18 echo "OK"
  19
  20 for sql in ../newdirectory-0.0.1/*.sql *.sql
  21 do
  22     echo -n "* running $sql "
  23     (cat $sql | mysql_run) || die "ERROR"
  24     echo "OK"
  25 done
  26
  27 ###########################################################
  28 echo -n "Importing phone numbers "
  29
  30 ../newdirectory-0.0.1/phones.php || die "ERROR"
  31 echo "OK"
  32
  33 ###########################################################
  34 echo "Updating birthday dates "
  35
  36 ./birthday.php || die "ERROR"
  37 echo "OK"