upgrade/1.0.1/update.sh

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