1 -- $Id: oci8-destroy.sql,v 1.1 2004-07-22 16:50:07 dfrankow 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.
12 -- You have to use a prefix, because some phpWiki tablenames are
13 -- Oracle reserved words!
15 define prefix=phpwiki_
17 --================================================================
19 -- Don't modify below this point unless you know what you are doing.
21 --================================================================
23 --================================================================
24 -- Note on Oracle datatypes...
26 -- Most of the 'NOT NULL' constraints on the character columns have been
27 -- dropped since they can contain empty strings which are seen by
29 -- Oracle CLOBs are used for TEXTs/MEDUIMTEXTs columns.
32 prompt Initializing PhpWiki tables with:
33 prompt prefix = &prefix
35 prompt Expect some 'ORA-00942: table or view does not exist' unless you are
36 prompt overwriting existing tables.
39 define page_tbl=&prefix.page
40 define page_id=&prefix.page_id
41 define page_nm=&prefix.page_nm
43 define version_tbl=&prefix.version
44 define vers_id=&prefix.vers_id
45 define vers_mtime=&prefix.vers_mtime
47 define recent_tbl=&prefix.recent
48 define recent_id=&prefix.recent_id
50 define nonempty_tbl=&prefix.nonempty
51 define nonmt_id=&prefix.nonmt_id
53 define link_tbl=&prefix.link
54 define link_from=&prefix.link_from
55 define link_to=&prefix.link_to
57 define session_tbl=&prefix.session
58 define sess_id=&prefix.sess_id
59 define sess_date=&prefix.sess_date
60 define sess_ip=&prefix.sess_ip
62 define pref_tbl=&prefix.pref
63 define pref_id=&prefix.pref_id
65 define user_tbl=&prefix.user
66 define user_id=&prefix.user_id
68 define member_tbl=&prefix.member
69 define member_userid=&prefix.member_userid
70 define member_groupname=&prefix.member_groupname
72 define rating_tbl=&prefix.rating
73 define rating_id=&prefix.rating_id
76 prompt Dropping &page_tbl
79 prompt Dropping &version_tbl
80 DROP TABLE &version_tbl;
82 prompt Dropping &recent_tbl
83 DROP TABLE &recent_tbl;
85 prompt Dropping &nonempty_tbl
86 DROP TABLE &nonempty_tbl;
88 prompt Dropping &link_tbl
91 prompt Dropping &session_tbl
92 DROP TABLE &session_tbl;
94 -- Optional DB Auth and Prefs
95 -- For these tables below the default table prefix must be used
96 -- in the DBAuthParam SQL statements also.
98 prompt Dropping &pref_tbl
101 -- better use the extra pref table where such users can be created easily
104 prompt Dropping &user_tbl
105 DROP TABLE &user_tbl;
107 prompt Dropping &member_tbl
108 DROP TABLE &member_tbl;
110 -- if you plan to use the wikilens theme
111 prompt Dropping &rating_tbl
112 DROP TABLE &rating_tbl;