added primary keys
[webpac2] / sql / Makefile
1 db=webpac2
2
3 init:
4         dropdb $(db) || true
5         createdb $(db)
6         ./mkindex.pl schema.sql | psql $(db)
7         test -f data.sql && psql $(db) < data.sql
8
9 save:
10         pg_dump -c $(db) > $(db).sql
11
12 load:
13         psql $(db) < $(db).sql