pear-db/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	dpavlin	35	#!/bin/sh
2
3	dpavlin	40	dropdb libdata \|\| (
4			sudo /etc/init.d/apache restart
5			dropdb libdata \|\| exit;
6			)
7	dpavlin	35	createdb libdata
8
9			psql libdata < libdata.pgsql
10			psql libdata < libstats.pgsql
11			psql libdata < libsession.pgsql
12
13	dpavlin	40	# 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"