upgrade/1.0.1/update.sh

   1 #!/bin/bash
   2
   3 . ../inc/pervasive.sh
   4
   5 ###########################################################
   6 [ "$DATABASE" != "x5dat" ] || die "Cannot target x5dat"
   7 copy_db
   8
   9 echo "* switching engines to InnoDB"
  10 (./innodb.sh | while read line; do mysql_exec "$line"; done) || die "ERROR"
  11 echo "OK"
  12
  13 confirm "* Running database upgrade scripts"
  14 mysql_run_directory .
  15
  16 confirm "* Running upgrade scripts"
  17 script_run ./phone.php
  18 script_run ./xnet_directory_name.php
  19 script_run ./sectors_as_terms.php
  20 script_run ./positions_as_terms.php
  21 script_run ./tokenize_job_terms.php
  22
  23 confirm "* Running post-PHP database upgrade script"
  24 mysql_run ./99_jobs.sql.postphp
  25
  26 confirm "* Upgrading search table (reindex user names for quick search)"
  27 pushd ../../bin
  28 ./search.rebuild_db.php
  29 popd