--- trunk/pg/install.sh	2004/03/04 21:29:00	35
+++ trunk/pg/install.sh	2004/03/04 22:24:31	40
@@ -1,9 +1,15 @@
 #!/bin/sh
 
-dropdb libdata
+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"