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 confirm "* Running pre-engine switch database upgrade script"
  10 mysql_run ./99_keys.sql.pre
  11
  12 confirm "* switching engines to InnoDB"
  13 ./innodb.sh | mysql_pipe
  14
  15 confirm "* Running database upgrade scripts"
  16 mysql_run_directory .
  17
  18 confirm "* Running upgrade scripts"
  19 script_run ./phone.php
  20 script_run ./xnet_directory_name.php
  21 script_run ./sectors_as_terms.php
  22 script_run ./positions_as_terms.php
  23 script_run ./tokenize_job_terms.php
  24
  25 confirm "* Running post-PHP database upgrade script"
  26 mysql_run ./99_jobs.sql.postphp
  27
  28 confirm "* Upgrading search table (reindex user names for quick search)"
  29 pushd ../../bin
  30 ./search.rebuild_db.php
  31 popd