| 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 |