4 -- ================================================================
5 -- Prefix for table names.
7 -- You should set this to the same value you specify for
8 -- $DBParams['prefix'] in index.php.
10 -- You have to use a prefix, because some phpWiki tablenames are
11 -- Oracle reserved words!
13 define prefix=phpwiki_
15 -- ================================================================
17 -- Don't modify below this point unless you know what you are doing.
19 -- ================================================================
21 -- ================================================================
22 -- Note on Oracle datatypes...
24 -- Most of the 'NOT NULL' constraints on the character columns have been
25 -- dropped since they can contain empty strings which are seen by
27 -- Oracle CLOBs are used for TEXTs/MEDUIMTEXTs columns.
30 prompt Initializing PhpWiki tables with:
31 prompt prefix = &prefix
33 prompt Expect some 'ORA-00942: table or view does not exist' unless you are
34 prompt overwriting existing tables.
37 define page_tbl=&prefix.page
38 define version_tbl=&prefix.version
39 define recent_tbl=&prefix.recent
40 define nonempty_tbl=&prefix.nonempty
41 define link_tbl=&prefix.link
42 define session_tbl=&prefix.session
43 define pref_tbl=&prefix.pref
44 define user_tbl=&prefix.user
45 define member_tbl=&prefix.member
46 define rating_tbl=&prefix.rating
47 define accesslog_tbl=&prefix.accesslog
49 prompt Dropping &page_tbl
52 prompt Dropping &version_tbl
53 DROP TABLE &version_tbl;
55 prompt Dropping &recent_tbl
56 DROP TABLE &recent_tbl;
58 prompt Dropping &nonempty_tbl
59 DROP TABLE &nonempty_tbl;
61 prompt Dropping &link_tbl
64 prompt Dropping &session_tbl
65 DROP TABLE &session_tbl;
67 -- Optional DB Auth and Prefs
68 -- For these tables below the default table prefix must be used
69 -- in the DBAuthParam SQL statements also.
71 prompt Dropping &pref_tbl
74 -- better use the extra pref table where such users can be created easily
77 prompt Dropping &user_tbl
80 prompt Dropping &member_tbl
81 DROP TABLE &member_tbl;
83 -- if you plan to use the wikilens theme
84 prompt Dropping &rating_tbl
85 DROP TABLE &rating_tbl;
87 prompt Dropping &accesslog_tbl
88 DROP TABLE &accesslog_tbl;