1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
-- $Id: oci8-destroy.sql,v 1.2 2005/02/27 09:33:05 rurban Exp $
set verify off
set feedback off
--================================================================
-- Prefix for table names.
--
-- You should set this to the same value you specify for
-- DATABASE_PREFIX in config.ini
--
-- You have to use a prefix, because some phpWiki tablenames are
-- Oracle reserved words!
define prefix=phpwiki_
--================================================================
--
-- Don't modify below this point unless you know what you are doing.
--
--================================================================
--================================================================
-- Note on Oracle datatypes...
--
-- Most of the 'NOT NULL' constraints on the character columns have been
-- dropped since they can contain empty strings which are seen by
-- Oracle as NULL.
-- Oracle CLOBs are used for TEXTs/MEDUIMTEXTs columns.
prompt Initializing PhpWiki tables with:
prompt prefix = &prefix
prompt
prompt Expect some 'ORA-00942: table or view does not exist' unless you are
prompt overwriting existing tables.
prompt
define page_tbl=&prefix.page
define version_tbl=&prefix.version
define recent_tbl=&prefix.recent
define nonempty_tbl=&prefix.nonempty
define link_tbl=&prefix.link
define session_tbl=&prefix.session
define pref_tbl=&prefix.pref
define user_tbl=&prefix.user
define member_tbl=&prefix.member
define rating_tbl=&prefix.rating
define accesslog_tbl=&prefix.accesslog
prompt Dropping &page_tbl
DROP TABLE &page_tbl;
prompt Dropping &version_tbl
DROP TABLE &version_tbl;
prompt Dropping &recent_tbl
DROP TABLE &recent_tbl;
prompt Dropping &nonempty_tbl
DROP TABLE &nonempty_tbl;
prompt Dropping &link_tbl
DROP TABLE &link_tbl;
prompt Dropping &session_tbl
DROP TABLE &session_tbl;
-- Optional DB Auth and Prefs
-- For these tables below the default table prefix must be used
-- in the DBAuthParam SQL statements also.
prompt Dropping &pref_tbl
DROP TABLE &pref_tbl;
-- better use the extra pref table where such users can be created easily
-- without password.
prompt Dropping &user_tbl
DROP TABLE &user_tbl;
prompt Dropping &member_tbl
DROP TABLE &member_tbl;
-- if you plan to use the wikilens theme
prompt Dropping &rating_tbl
DROP TABLE &rating_tbl;
prompt Dropping &accesslog_tbl
DROP TABLE &accesslog_tbl;
|
