1 -- $Id: psql-destroy.sql,v 1.2 2005-02-27 09:33:05 rurban Exp $
6 --================================================================
7 -- Prefix for table names.
9 -- You should set this to the same value you specify for
10 -- $DBParams['prefix'] in index.php.
14 --================================================================
15 -- Which postgres user gets access to the tables?
17 -- You should set this to the name of the postgres
18 -- user who will be accessing the tables.
20 -- Commonly, connections from php are made under
21 -- the user name of 'nobody', 'apache' or 'www'.
25 --================================================================
27 -- Don't modify below this point unless you know what you are doing.
29 --================================================================
31 \set qprefix '\'' :prefix '\''
32 \set qhttp_user '\'' :httpd_user '\''
33 \echo Initializing PhpWiki tables with:
34 \echo ' prefix = ' :qprefix
35 \echo ' httpd_user = ' :qhttp_user
37 \echo 'Expect some \'Relation \'*\' does not exists\' errors unless you are'
38 \echo 'overwriting existing tables.'
40 \set page_tbl :prefix 'page'
41 \set version_tbl :prefix 'version'
42 \set recent_tbl :prefix 'recent'
43 \set nonempty_tbl :prefix 'nonempty'
44 \set link_tbl :prefix 'link'
45 \set session_tbl :prefix 'session'
46 \set pref_tbl :prefix 'pref'
47 -- \set user_tbl :prefix 'user'
48 -- \set member_tbl :prefix 'member'
49 \set rating_tbl :prefix 'rating'
50 \set accesslog_tbl :prefix 'accesslog'
52 \echo Dropping :page_tbl
55 \echo Dropping :version_tbl
56 DROP TABLE :version_tbl;
58 \echo Dropping :recent_tbl
59 DROP TABLE :recent_tbl;
61 \echo Dropping :nonempty_tbl
62 DROP TABLE :nonempty_tbl;
64 \echo Dropping :link_tbl
67 \echo Dropping :session_tbl
68 DROP TABLE :session_tbl;
70 \echo Dropping :pref_tbl
73 -- DROP TABLE :user_tbl;
74 -- DROP TABLE :member_tbl;
76 \echo Dropping :rating_tbl
77 DROP TABLE :rating_tbl;
79 \echo Dropping :accesslog_tbl
80 DROP TABLE :accesslog_tbl;