trunk/my2pg/install.sh

#!/bin/sh

dropdb libdata || (
        sudo /etc/init.d/apache restart
        dropdb libdata || exit;
)
createdb libdata

psql libdata < libdata.pgsql
psql libdata < libstats.pgsql
psql libdata < libsession.pgsql

# reset all passwords to libdata (password file format isn't compatibile
# because MySQL is using password function and we are using md5 hash
psql libdata -c "update staff set password=md5('libdata') where staff_id > 1"
1	#!/bin/sh
2
3	dropdb libdata \|\| (
4	sudo /etc/init.d/apache restart
5	dropdb libdata \|\| exit;
6	)
7	createdb libdata
8
9	psql libdata < libdata.pgsql
10	psql libdata < libstats.pgsql
11	psql libdata < libsession.pgsql
12
13	# reset all passwords to libdata (password file format isn't compatibile
14	# because MySQL is using password function and we are using md5 hash
15	psql libdata -c "update staff set password=md5('libdata') where staff_id > 1"