1 -- $Id: psql-destroy.sql,v 1.3 2005-04-07 06:13:57 rurban Exp $
5 --================================================================
6 -- Prefix for table names.
8 -- You should set this to the same value you specify for
9 -- $DBParams['prefix'] in index.php.
13 --================================================================
15 -- Don't modify below this point unless you know what you are doing.
17 --================================================================
19 \set qprefix '\'' :prefix '\''
20 \echo Dropping all PhpWiki tables with:
21 \echo ' prefix = ' :qprefix
24 \set page_tbl :prefix 'page'
25 \set version_tbl :prefix 'version'
26 \set recent_tbl :prefix 'recent'
27 \set nonempty_tbl :prefix 'nonempty'
28 \set link_tbl :prefix 'link'
29 \set session_tbl :prefix 'session'
30 \set pref_tbl :prefix 'pref'
31 -- \set user_tbl :prefix 'user'
32 -- \set member_tbl :prefix 'member'
33 \set rating_tbl :prefix 'rating'
34 \set accesslog_tbl :prefix 'accesslog'
36 \echo Dropping :page_tbl
39 \echo Dropping :version_tbl
40 DROP TABLE :version_tbl;
42 \echo Dropping :recent_tbl
43 DROP TABLE :recent_tbl;
45 \echo Dropping :nonempty_tbl
46 DROP TABLE :nonempty_tbl;
48 \echo Dropping :link_tbl
51 \echo Dropping :session_tbl
52 DROP TABLE :session_tbl;
54 \echo Dropping :pref_tbl
57 -- DROP TABLE :user_tbl;
58 -- DROP TABLE :member_tbl;
60 \echo Dropping :rating_tbl
61 DROP TABLE :rating_tbl;
63 \echo Dropping :accesslog_tbl
64 DROP TABLE :accesslog_tbl;