/[libdata]/trunk/pg/install.sh
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/pg/install.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 39 by dpavlin, Thu Mar 4 21:29:00 2004 UTC revision 40 by dpavlin, Thu Mar 4 22:24:31 2004 UTC
# Line 1  Line 1 
1  #!/bin/sh  #!/bin/sh
2    
3  dropdb libdata  dropdb libdata || (
4            sudo /etc/init.d/apache restart
5            dropdb libdata || exit;
6    )
7  createdb libdata  createdb libdata
8    
9  psql libdata < libdata.pgsql  psql libdata < libdata.pgsql
10  psql libdata < libstats.pgsql  psql libdata < libstats.pgsql
11  psql libdata < libsession.pgsql  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"
Legend:
Removed from v.39  
changed lines
  Added in v.40
  ViewVC Help
Powered by ViewVC 1.1.26