1 -- $Id: oci8-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.
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 version_tbl=&prefix.version
41 define recent_tbl=&prefix.recent
42 define nonempty_tbl=&prefix.nonempty
43 define link_tbl=&prefix.link
44 define session_tbl=&prefix.session
45 define pref_tbl=&prefix.pref
46 define user_tbl=&prefix.user
47 define member_tbl=&prefix.member
48 define rating_tbl=&prefix.rating
49 define accesslog_tbl=&prefix.accesslog
51 prompt Dropping &page_tbl
54 prompt Dropping &version_tbl
55 DROP TABLE &version_tbl;
57 prompt Dropping &recent_tbl
58 DROP TABLE &recent_tbl;
60 prompt Dropping &nonempty_tbl
61 DROP TABLE &nonempty_tbl;
63 prompt Dropping &link_tbl
66 prompt Dropping &session_tbl
67 DROP TABLE &session_tbl;
69 -- Optional DB Auth and Prefs
70 -- For these tables below the default table prefix must be used
71 -- in the DBAuthParam SQL statements also.
73 prompt Dropping &pref_tbl
76 -- better use the extra pref table where such users can be created easily
79 prompt Dropping &user_tbl
82 prompt Dropping &member_tbl
83 DROP TABLE &member_tbl;
85 -- if you plan to use the wikilens theme
86 prompt Dropping &rating_tbl
87 DROP TABLE &rating_tbl;
89 prompt Dropping &accesslog_tbl
90 DROP TABLE &accesslog_tbl;