[platal.git] / upgrade / 1.0.1 / update.sh

#!/bin/bash

. ../inc/pervasive.sh

###########################################################
[ "$DATABASE" != "x5dat" ] || die "Cannot target x5dat"
copy_db

echo "* switching engines to InnoDB"
(./innodb.sh | while read line; do mysql_exec "$line"; done) || die "ERROR"
echo "OK"

confirm "* Running database upgrade scripts"
mysql_run_directory .

confirm "* Running upgrade scripts"
script_run ./phone.php
script_run ./xnet_directory_name.php
script_run ./sectors_as_terms.php
script_run ./positions_as_terms.php
script_run ./tokenize_job_terms.php

confirm "* Running post-PHP database upgrade script"
mysql_run ./99_jobs.sql.postphp

confirm "* Upgrading search table (reindex user names for quick search)"
pushd ../../bin
./search.rebuild_db.php
popd
Commit	Line	Data
f73d9281 FB	1	#!/bin/bash
	2
	3	. ../inc/pervasive.sh
	4
	5	###########################################################
b6731d4b	6	[ "$DATABASE" != "x5dat" ] \|\| die "Cannot target x5dat"
cc9dc1dd	7	copy_db
f73d9281	8
b6731d4b SJ	9	echo "* switching engines to InnoDB"
	10	(./innodb.sh \| while read line; do mysql_exec "$line"; done) \|\| die "ERROR"
	11	echo "OK"
	12
f73d9281 FB	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
85d16d6a FB	25
	26	confirm "* Upgrading search table (reindex user names for quick search)"
	27	pushd ../../bin
	28	./search.rebuild_db.php
	29	popd