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