443
by dcoles
Added Forum application along with unmodifed version of phpBB3 "Olympus" 3.0.0 |
1 |
/*
|
2 |
||
3 |
$Id: oracle_schema.sql,v 1.103 2007/12/05 15:18:21 acydburn Exp $
|
|
4 |
||
5 |
*/
|
|
6 |
||
7 |
/*
|
|
8 |
This first section is optional, however its probably the best method
|
|
9 |
of running phpBB on Oracle. If you already have a tablespace and user created
|
|
10 |
for phpBB you can leave this section commented out!
|
|
11 |
||
12 |
The first set of statements create a phpBB tablespace and a phpBB user,
|
|
13 |
make sure you change the password of the phpBB user before you run this script!!
|
|
14 |
*/
|
|
15 |
||
16 |
/*
|
|
17 |
CREATE TABLESPACE "PHPBB"
|
|
18 |
LOGGING
|
|
19 |
DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora'
|
|
20 |
SIZE 10M
|
|
21 |
AUTOEXTEND ON NEXT 10M
|
|
22 |
MAXSIZE 100M;
|
|
23 |
||
24 |
CREATE USER "PHPBB"
|
|
25 |
PROFILE "DEFAULT"
|
|
26 |
IDENTIFIED BY "phpbb_password"
|
|
27 |
DEFAULT TABLESPACE "PHPBB"
|
|
28 |
QUOTA UNLIMITED ON "PHPBB"
|
|
29 |
ACCOUNT UNLOCK;
|
|
30 |
||
31 |
GRANT ANALYZE ANY TO "PHPBB";
|
|
32 |
GRANT CREATE SEQUENCE TO "PHPBB";
|
|
33 |
GRANT CREATE SESSION TO "PHPBB";
|
|
34 |
GRANT CREATE TABLE TO "PHPBB";
|
|
35 |
GRANT CREATE TRIGGER TO "PHPBB";
|
|
36 |
GRANT CREATE VIEW TO "PHPBB";
|
|
37 |
GRANT "CONNECT" TO "PHPBB";
|
|
38 |
||
39 |
COMMIT;
|
|
40 |
DISCONNECT;
|
|
41 |
||
42 |
CONNECT phpbb/phpbb_password;
|
|
43 |
*/
|
|
44 |
/*
|
|
45 |
Table: 'phpbb_attachments'
|
|
46 |
*/
|
|
47 |
CREATE TABLE phpbb_attachments ( |
|
48 |
attach_id number(8) NOT NULL, |
|
49 |
post_msg_id number(8) DEFAULT '0' NOT NULL, |
|
50 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
51 |
in_message number(1) DEFAULT '0' NOT NULL, |
|
52 |
poster_id number(8) DEFAULT '0' NOT NULL, |
|
53 |
is_orphan number(1) DEFAULT '1' NOT NULL, |
|
54 |
physical_filename varchar2(255) DEFAULT '' , |
|
55 |
real_filename varchar2(255) DEFAULT '' , |
|
56 |
download_count number(8) DEFAULT '0' NOT NULL, |
|
57 |
attach_comment clob DEFAULT '' , |
|
58 |
extension varchar2(100) DEFAULT '' , |
|
59 |
mimetype varchar2(100) DEFAULT '' , |
|
60 |
filesize number(20) DEFAULT '0' NOT NULL, |
|
61 |
filetime number(11) DEFAULT '0' NOT NULL, |
|
62 |
thumbnail number(1) DEFAULT '0' NOT NULL, |
|
63 |
CONSTRAINT pk_phpbb_attachments PRIMARY KEY (attach_id) |
|
64 |
)
|
|
65 |
/
|
|
66 |
||
67 |
CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime) |
|
68 |
/
|
|
69 |
CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id) |
|
70 |
/
|
|
71 |
CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id) |
|
72 |
/
|
|
73 |
CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id) |
|
74 |
/
|
|
75 |
CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan) |
|
76 |
/
|
|
77 |
||
78 |
CREATE SEQUENCE phpbb_attachments_seq |
|
79 |
/
|
|
80 |
||
81 |
CREATE OR REPLACE TRIGGER t_phpbb_attachments |
|
82 |
BEFORE INSERT ON phpbb_attachments |
|
83 |
FOR EACH ROW WHEN ( |
|
84 |
new.attach_id IS NULL OR new.attach_id = 0 |
|
85 |
)
|
|
86 |
BEGIN
|
|
87 |
SELECT phpbb_attachments_seq.nextval |
|
88 |
INTO :new.attach_id |
|
89 |
FROM dual; |
|
90 |
END; |
|
91 |
/
|
|
92 |
||
93 |
||
94 |
/*
|
|
95 |
Table: 'phpbb_acl_groups'
|
|
96 |
*/
|
|
97 |
CREATE TABLE phpbb_acl_groups ( |
|
98 |
group_id number(8) DEFAULT '0' NOT NULL, |
|
99 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
100 |
auth_option_id number(8) DEFAULT '0' NOT NULL, |
|
101 |
auth_role_id number(8) DEFAULT '0' NOT NULL, |
|
102 |
auth_setting number(2) DEFAULT '0' NOT NULL |
|
103 |
)
|
|
104 |
/
|
|
105 |
||
106 |
CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id) |
|
107 |
/
|
|
108 |
CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id) |
|
109 |
/
|
|
110 |
CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id) |
|
111 |
/
|
|
112 |
||
113 |
/*
|
|
114 |
Table: 'phpbb_acl_options'
|
|
115 |
*/
|
|
116 |
CREATE TABLE phpbb_acl_options ( |
|
117 |
auth_option_id number(8) NOT NULL, |
|
118 |
auth_option varchar2(50) DEFAULT '' , |
|
119 |
is_global number(1) DEFAULT '0' NOT NULL, |
|
120 |
is_local number(1) DEFAULT '0' NOT NULL, |
|
121 |
founder_only number(1) DEFAULT '0' NOT NULL, |
|
122 |
CONSTRAINT pk_phpbb_acl_options PRIMARY KEY (auth_option_id) |
|
123 |
)
|
|
124 |
/
|
|
125 |
||
126 |
CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option) |
|
127 |
/
|
|
128 |
||
129 |
CREATE SEQUENCE phpbb_acl_options_seq |
|
130 |
/
|
|
131 |
||
132 |
CREATE OR REPLACE TRIGGER t_phpbb_acl_options |
|
133 |
BEFORE INSERT ON phpbb_acl_options |
|
134 |
FOR EACH ROW WHEN ( |
|
135 |
new.auth_option_id IS NULL OR new.auth_option_id = 0 |
|
136 |
)
|
|
137 |
BEGIN
|
|
138 |
SELECT phpbb_acl_options_seq.nextval |
|
139 |
INTO :new.auth_option_id |
|
140 |
FROM dual; |
|
141 |
END; |
|
142 |
/
|
|
143 |
||
144 |
||
145 |
/*
|
|
146 |
Table: 'phpbb_acl_roles'
|
|
147 |
*/
|
|
148 |
CREATE TABLE phpbb_acl_roles ( |
|
149 |
role_id number(8) NOT NULL, |
|
150 |
role_name varchar2(765) DEFAULT '' , |
|
151 |
role_description clob DEFAULT '' , |
|
152 |
role_type varchar2(10) DEFAULT '' , |
|
153 |
role_order number(4) DEFAULT '0' NOT NULL, |
|
154 |
CONSTRAINT pk_phpbb_acl_roles PRIMARY KEY (role_id) |
|
155 |
)
|
|
156 |
/
|
|
157 |
||
158 |
CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type) |
|
159 |
/
|
|
160 |
CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order) |
|
161 |
/
|
|
162 |
||
163 |
CREATE SEQUENCE phpbb_acl_roles_seq |
|
164 |
/
|
|
165 |
||
166 |
CREATE OR REPLACE TRIGGER t_phpbb_acl_roles |
|
167 |
BEFORE INSERT ON phpbb_acl_roles |
|
168 |
FOR EACH ROW WHEN ( |
|
169 |
new.role_id IS NULL OR new.role_id = 0 |
|
170 |
)
|
|
171 |
BEGIN
|
|
172 |
SELECT phpbb_acl_roles_seq.nextval |
|
173 |
INTO :new.role_id |
|
174 |
FROM dual; |
|
175 |
END; |
|
176 |
/
|
|
177 |
||
178 |
||
179 |
/*
|
|
180 |
Table: 'phpbb_acl_roles_data'
|
|
181 |
*/
|
|
182 |
CREATE TABLE phpbb_acl_roles_data ( |
|
183 |
role_id number(8) DEFAULT '0' NOT NULL, |
|
184 |
auth_option_id number(8) DEFAULT '0' NOT NULL, |
|
185 |
auth_setting number(2) DEFAULT '0' NOT NULL, |
|
186 |
CONSTRAINT pk_phpbb_acl_roles_data PRIMARY KEY (role_id, auth_option_id) |
|
187 |
)
|
|
188 |
/
|
|
189 |
||
190 |
CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data (auth_option_id) |
|
191 |
/
|
|
192 |
||
193 |
/*
|
|
194 |
Table: 'phpbb_acl_users'
|
|
195 |
*/
|
|
196 |
CREATE TABLE phpbb_acl_users ( |
|
197 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
198 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
199 |
auth_option_id number(8) DEFAULT '0' NOT NULL, |
|
200 |
auth_role_id number(8) DEFAULT '0' NOT NULL, |
|
201 |
auth_setting number(2) DEFAULT '0' NOT NULL |
|
202 |
)
|
|
203 |
/
|
|
204 |
||
205 |
CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id) |
|
206 |
/
|
|
207 |
CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id) |
|
208 |
/
|
|
209 |
CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id) |
|
210 |
/
|
|
211 |
||
212 |
/*
|
|
213 |
Table: 'phpbb_banlist'
|
|
214 |
*/
|
|
215 |
CREATE TABLE phpbb_banlist ( |
|
216 |
ban_id number(8) NOT NULL, |
|
217 |
ban_userid number(8) DEFAULT '0' NOT NULL, |
|
218 |
ban_ip varchar2(40) DEFAULT '' , |
|
219 |
ban_email varchar2(300) DEFAULT '' , |
|
220 |
ban_start number(11) DEFAULT '0' NOT NULL, |
|
221 |
ban_end number(11) DEFAULT '0' NOT NULL, |
|
222 |
ban_exclude number(1) DEFAULT '0' NOT NULL, |
|
223 |
ban_reason varchar2(765) DEFAULT '' , |
|
224 |
ban_give_reason varchar2(765) DEFAULT '' , |
|
225 |
CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id) |
|
226 |
)
|
|
227 |
/
|
|
228 |
||
229 |
CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end) |
|
230 |
/
|
|
231 |
CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude) |
|
232 |
/
|
|
233 |
CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude) |
|
234 |
/
|
|
235 |
CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude) |
|
236 |
/
|
|
237 |
||
238 |
CREATE SEQUENCE phpbb_banlist_seq |
|
239 |
/
|
|
240 |
||
241 |
CREATE OR REPLACE TRIGGER t_phpbb_banlist |
|
242 |
BEFORE INSERT ON phpbb_banlist |
|
243 |
FOR EACH ROW WHEN ( |
|
244 |
new.ban_id IS NULL OR new.ban_id = 0 |
|
245 |
)
|
|
246 |
BEGIN
|
|
247 |
SELECT phpbb_banlist_seq.nextval |
|
248 |
INTO :new.ban_id |
|
249 |
FROM dual; |
|
250 |
END; |
|
251 |
/
|
|
252 |
||
253 |
||
254 |
/*
|
|
255 |
Table: 'phpbb_bbcodes'
|
|
256 |
*/
|
|
257 |
CREATE TABLE phpbb_bbcodes ( |
|
258 |
bbcode_id number(3) DEFAULT '0' NOT NULL, |
|
259 |
bbcode_tag varchar2(16) DEFAULT '' , |
|
260 |
bbcode_helpline varchar2(765) DEFAULT '' , |
|
261 |
display_on_posting number(1) DEFAULT '0' NOT NULL, |
|
262 |
bbcode_match clob DEFAULT '' , |
|
263 |
bbcode_tpl clob DEFAULT '' , |
|
264 |
first_pass_match clob DEFAULT '' , |
|
265 |
first_pass_replace clob DEFAULT '' , |
|
266 |
second_pass_match clob DEFAULT '' , |
|
267 |
second_pass_replace clob DEFAULT '' , |
|
268 |
CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id) |
|
269 |
)
|
|
270 |
/
|
|
271 |
||
272 |
CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting) |
|
273 |
/
|
|
274 |
||
275 |
/*
|
|
276 |
Table: 'phpbb_bookmarks'
|
|
277 |
*/
|
|
278 |
CREATE TABLE phpbb_bookmarks ( |
|
279 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
280 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
281 |
CONSTRAINT pk_phpbb_bookmarks PRIMARY KEY (topic_id, user_id) |
|
282 |
)
|
|
283 |
/
|
|
284 |
||
285 |
||
286 |
/*
|
|
287 |
Table: 'phpbb_bots'
|
|
288 |
*/
|
|
289 |
CREATE TABLE phpbb_bots ( |
|
290 |
bot_id number(8) NOT NULL, |
|
291 |
bot_active number(1) DEFAULT '1' NOT NULL, |
|
292 |
bot_name varchar2(765) DEFAULT '' , |
|
293 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
294 |
bot_agent varchar2(255) DEFAULT '' , |
|
295 |
bot_ip varchar2(255) DEFAULT '' , |
|
296 |
CONSTRAINT pk_phpbb_bots PRIMARY KEY (bot_id) |
|
297 |
)
|
|
298 |
/
|
|
299 |
||
300 |
CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active) |
|
301 |
/
|
|
302 |
||
303 |
CREATE SEQUENCE phpbb_bots_seq |
|
304 |
/
|
|
305 |
||
306 |
CREATE OR REPLACE TRIGGER t_phpbb_bots |
|
307 |
BEFORE INSERT ON phpbb_bots |
|
308 |
FOR EACH ROW WHEN ( |
|
309 |
new.bot_id IS NULL OR new.bot_id = 0 |
|
310 |
)
|
|
311 |
BEGIN
|
|
312 |
SELECT phpbb_bots_seq.nextval |
|
313 |
INTO :new.bot_id |
|
314 |
FROM dual; |
|
315 |
END; |
|
316 |
/
|
|
317 |
||
318 |
||
319 |
/*
|
|
320 |
Table: 'phpbb_config'
|
|
321 |
*/
|
|
322 |
CREATE TABLE phpbb_config ( |
|
323 |
config_name varchar2(255) DEFAULT '' , |
|
324 |
config_value varchar2(765) DEFAULT '' , |
|
325 |
is_dynamic number(1) DEFAULT '0' NOT NULL, |
|
326 |
CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name) |
|
327 |
)
|
|
328 |
/
|
|
329 |
||
330 |
CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic) |
|
331 |
/
|
|
332 |
||
333 |
/*
|
|
334 |
Table: 'phpbb_confirm'
|
|
335 |
*/
|
|
336 |
CREATE TABLE phpbb_confirm ( |
|
337 |
confirm_id char(32) DEFAULT '' , |
|
338 |
session_id char(32) DEFAULT '' , |
|
339 |
confirm_type number(3) DEFAULT '0' NOT NULL, |
|
340 |
code varchar2(8) DEFAULT '' , |
|
341 |
seed number(10) DEFAULT '0' NOT NULL, |
|
342 |
CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id) |
|
343 |
)
|
|
344 |
/
|
|
345 |
||
346 |
CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type) |
|
347 |
/
|
|
348 |
||
349 |
/*
|
|
350 |
Table: 'phpbb_disallow'
|
|
351 |
*/
|
|
352 |
CREATE TABLE phpbb_disallow ( |
|
353 |
disallow_id number(8) NOT NULL, |
|
354 |
disallow_username varchar2(765) DEFAULT '' , |
|
355 |
CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id) |
|
356 |
)
|
|
357 |
/
|
|
358 |
||
359 |
||
360 |
CREATE SEQUENCE phpbb_disallow_seq |
|
361 |
/
|
|
362 |
||
363 |
CREATE OR REPLACE TRIGGER t_phpbb_disallow |
|
364 |
BEFORE INSERT ON phpbb_disallow |
|
365 |
FOR EACH ROW WHEN ( |
|
366 |
new.disallow_id IS NULL OR new.disallow_id = 0 |
|
367 |
)
|
|
368 |
BEGIN
|
|
369 |
SELECT phpbb_disallow_seq.nextval |
|
370 |
INTO :new.disallow_id |
|
371 |
FROM dual; |
|
372 |
END; |
|
373 |
/
|
|
374 |
||
375 |
||
376 |
/*
|
|
377 |
Table: 'phpbb_drafts'
|
|
378 |
*/
|
|
379 |
CREATE TABLE phpbb_drafts ( |
|
380 |
draft_id number(8) NOT NULL, |
|
381 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
382 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
383 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
384 |
save_time number(11) DEFAULT '0' NOT NULL, |
|
385 |
draft_subject varchar2(300) DEFAULT '' , |
|
386 |
draft_message clob DEFAULT '' , |
|
387 |
CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id) |
|
388 |
)
|
|
389 |
/
|
|
390 |
||
391 |
CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time) |
|
392 |
/
|
|
393 |
||
394 |
CREATE SEQUENCE phpbb_drafts_seq |
|
395 |
/
|
|
396 |
||
397 |
CREATE OR REPLACE TRIGGER t_phpbb_drafts |
|
398 |
BEFORE INSERT ON phpbb_drafts |
|
399 |
FOR EACH ROW WHEN ( |
|
400 |
new.draft_id IS NULL OR new.draft_id = 0 |
|
401 |
)
|
|
402 |
BEGIN
|
|
403 |
SELECT phpbb_drafts_seq.nextval |
|
404 |
INTO :new.draft_id |
|
405 |
FROM dual; |
|
406 |
END; |
|
407 |
/
|
|
408 |
||
409 |
||
410 |
/*
|
|
411 |
Table: 'phpbb_extensions'
|
|
412 |
*/
|
|
413 |
CREATE TABLE phpbb_extensions ( |
|
414 |
extension_id number(8) NOT NULL, |
|
415 |
group_id number(8) DEFAULT '0' NOT NULL, |
|
416 |
extension varchar2(100) DEFAULT '' , |
|
417 |
CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id) |
|
418 |
)
|
|
419 |
/
|
|
420 |
||
421 |
||
422 |
CREATE SEQUENCE phpbb_extensions_seq |
|
423 |
/
|
|
424 |
||
425 |
CREATE OR REPLACE TRIGGER t_phpbb_extensions |
|
426 |
BEFORE INSERT ON phpbb_extensions |
|
427 |
FOR EACH ROW WHEN ( |
|
428 |
new.extension_id IS NULL OR new.extension_id = 0 |
|
429 |
)
|
|
430 |
BEGIN
|
|
431 |
SELECT phpbb_extensions_seq.nextval |
|
432 |
INTO :new.extension_id |
|
433 |
FROM dual; |
|
434 |
END; |
|
435 |
/
|
|
436 |
||
437 |
||
438 |
/*
|
|
439 |
Table: 'phpbb_extension_groups'
|
|
440 |
*/
|
|
441 |
CREATE TABLE phpbb_extension_groups ( |
|
442 |
group_id number(8) NOT NULL, |
|
443 |
group_name varchar2(765) DEFAULT '' , |
|
444 |
cat_id number(2) DEFAULT '0' NOT NULL, |
|
445 |
allow_group number(1) DEFAULT '0' NOT NULL, |
|
446 |
download_mode number(1) DEFAULT '1' NOT NULL, |
|
447 |
upload_icon varchar2(255) DEFAULT '' , |
|
448 |
max_filesize number(20) DEFAULT '0' NOT NULL, |
|
449 |
allowed_forums clob DEFAULT '' , |
|
450 |
allow_in_pm number(1) DEFAULT '0' NOT NULL, |
|
451 |
CONSTRAINT pk_phpbb_extension_groups PRIMARY KEY (group_id) |
|
452 |
)
|
|
453 |
/
|
|
454 |
||
455 |
||
456 |
CREATE SEQUENCE phpbb_extension_groups_seq |
|
457 |
/
|
|
458 |
||
459 |
CREATE OR REPLACE TRIGGER t_phpbb_extension_groups |
|
460 |
BEFORE INSERT ON phpbb_extension_groups |
|
461 |
FOR EACH ROW WHEN ( |
|
462 |
new.group_id IS NULL OR new.group_id = 0 |
|
463 |
)
|
|
464 |
BEGIN
|
|
465 |
SELECT phpbb_extension_groups_seq.nextval |
|
466 |
INTO :new.group_id |
|
467 |
FROM dual; |
|
468 |
END; |
|
469 |
/
|
|
470 |
||
471 |
||
472 |
/*
|
|
473 |
Table: 'phpbb_forums'
|
|
474 |
*/
|
|
475 |
CREATE TABLE phpbb_forums ( |
|
476 |
forum_id number(8) NOT NULL, |
|
477 |
parent_id number(8) DEFAULT '0' NOT NULL, |
|
478 |
left_id number(8) DEFAULT '0' NOT NULL, |
|
479 |
right_id number(8) DEFAULT '0' NOT NULL, |
|
480 |
forum_parents clob DEFAULT '' , |
|
481 |
forum_name varchar2(765) DEFAULT '' , |
|
482 |
forum_desc clob DEFAULT '' , |
|
483 |
forum_desc_bitfield varchar2(255) DEFAULT '' , |
|
484 |
forum_desc_options number(11) DEFAULT '7' NOT NULL, |
|
485 |
forum_desc_uid varchar2(8) DEFAULT '' , |
|
486 |
forum_link varchar2(765) DEFAULT '' , |
|
487 |
forum_password varchar2(120) DEFAULT '' , |
|
488 |
forum_style number(4) DEFAULT '0' NOT NULL, |
|
489 |
forum_image varchar2(255) DEFAULT '' , |
|
490 |
forum_rules clob DEFAULT '' , |
|
491 |
forum_rules_link varchar2(765) DEFAULT '' , |
|
492 |
forum_rules_bitfield varchar2(255) DEFAULT '' , |
|
493 |
forum_rules_options number(11) DEFAULT '7' NOT NULL, |
|
494 |
forum_rules_uid varchar2(8) DEFAULT '' , |
|
495 |
forum_topics_per_page number(4) DEFAULT '0' NOT NULL, |
|
496 |
forum_type number(4) DEFAULT '0' NOT NULL, |
|
497 |
forum_status number(4) DEFAULT '0' NOT NULL, |
|
498 |
forum_posts number(8) DEFAULT '0' NOT NULL, |
|
499 |
forum_topics number(8) DEFAULT '0' NOT NULL, |
|
500 |
forum_topics_real number(8) DEFAULT '0' NOT NULL, |
|
501 |
forum_last_post_id number(8) DEFAULT '0' NOT NULL, |
|
502 |
forum_last_poster_id number(8) DEFAULT '0' NOT NULL, |
|
503 |
forum_last_post_subject varchar2(300) DEFAULT '' , |
|
504 |
forum_last_post_time number(11) DEFAULT '0' NOT NULL, |
|
505 |
forum_last_poster_name varchar2(765) DEFAULT '' , |
|
506 |
forum_last_poster_colour varchar2(6) DEFAULT '' , |
|
507 |
forum_flags number(4) DEFAULT '32' NOT NULL, |
|
508 |
display_on_index number(1) DEFAULT '1' NOT NULL, |
|
509 |
enable_indexing number(1) DEFAULT '1' NOT NULL, |
|
510 |
enable_icons number(1) DEFAULT '1' NOT NULL, |
|
511 |
enable_prune number(1) DEFAULT '0' NOT NULL, |
|
512 |
prune_next number(11) DEFAULT '0' NOT NULL, |
|
513 |
prune_days number(8) DEFAULT '0' NOT NULL, |
|
514 |
prune_viewed number(8) DEFAULT '0' NOT NULL, |
|
515 |
prune_freq number(8) DEFAULT '0' NOT NULL, |
|
516 |
CONSTRAINT pk_phpbb_forums PRIMARY KEY (forum_id) |
|
517 |
)
|
|
518 |
/
|
|
519 |
||
520 |
CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id) |
|
521 |
/
|
|
522 |
CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id) |
|
523 |
/
|
|
524 |
||
525 |
CREATE SEQUENCE phpbb_forums_seq |
|
526 |
/
|
|
527 |
||
528 |
CREATE OR REPLACE TRIGGER t_phpbb_forums |
|
529 |
BEFORE INSERT ON phpbb_forums |
|
530 |
FOR EACH ROW WHEN ( |
|
531 |
new.forum_id IS NULL OR new.forum_id = 0 |
|
532 |
)
|
|
533 |
BEGIN
|
|
534 |
SELECT phpbb_forums_seq.nextval |
|
535 |
INTO :new.forum_id |
|
536 |
FROM dual; |
|
537 |
END; |
|
538 |
/
|
|
539 |
||
540 |
||
541 |
/*
|
|
542 |
Table: 'phpbb_forums_access'
|
|
543 |
*/
|
|
544 |
CREATE TABLE phpbb_forums_access ( |
|
545 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
546 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
547 |
session_id char(32) DEFAULT '' , |
|
548 |
CONSTRAINT pk_phpbb_forums_access PRIMARY KEY (forum_id, user_id, session_id) |
|
549 |
)
|
|
550 |
/
|
|
551 |
||
552 |
||
553 |
/*
|
|
554 |
Table: 'phpbb_forums_track'
|
|
555 |
*/
|
|
556 |
CREATE TABLE phpbb_forums_track ( |
|
557 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
558 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
559 |
mark_time number(11) DEFAULT '0' NOT NULL, |
|
560 |
CONSTRAINT pk_phpbb_forums_track PRIMARY KEY (user_id, forum_id) |
|
561 |
)
|
|
562 |
/
|
|
563 |
||
564 |
||
565 |
/*
|
|
566 |
Table: 'phpbb_forums_watch'
|
|
567 |
*/
|
|
568 |
CREATE TABLE phpbb_forums_watch ( |
|
569 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
570 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
571 |
notify_status number(1) DEFAULT '0' NOT NULL |
|
572 |
)
|
|
573 |
/
|
|
574 |
||
575 |
CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id) |
|
576 |
/
|
|
577 |
CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id) |
|
578 |
/
|
|
579 |
CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status) |
|
580 |
/
|
|
581 |
||
582 |
/*
|
|
583 |
Table: 'phpbb_groups'
|
|
584 |
*/
|
|
585 |
CREATE TABLE phpbb_groups ( |
|
586 |
group_id number(8) NOT NULL, |
|
587 |
group_type number(4) DEFAULT '1' NOT NULL, |
|
588 |
group_founder_manage number(1) DEFAULT '0' NOT NULL, |
|
589 |
group_name varchar2(255) DEFAULT '' , |
|
590 |
group_desc clob DEFAULT '' , |
|
591 |
group_desc_bitfield varchar2(255) DEFAULT '' , |
|
592 |
group_desc_options number(11) DEFAULT '7' NOT NULL, |
|
593 |
group_desc_uid varchar2(8) DEFAULT '' , |
|
594 |
group_display number(1) DEFAULT '0' NOT NULL, |
|
595 |
group_avatar varchar2(255) DEFAULT '' , |
|
596 |
group_avatar_type number(2) DEFAULT '0' NOT NULL, |
|
597 |
group_avatar_width number(4) DEFAULT '0' NOT NULL, |
|
598 |
group_avatar_height number(4) DEFAULT '0' NOT NULL, |
|
599 |
group_rank number(8) DEFAULT '0' NOT NULL, |
|
600 |
group_colour varchar2(6) DEFAULT '' , |
|
601 |
group_sig_chars number(8) DEFAULT '0' NOT NULL, |
|
602 |
group_receive_pm number(1) DEFAULT '0' NOT NULL, |
|
603 |
group_message_limit number(8) DEFAULT '0' NOT NULL, |
|
604 |
group_legend number(1) DEFAULT '1' NOT NULL, |
|
605 |
CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id) |
|
606 |
)
|
|
607 |
/
|
|
608 |
||
609 |
CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend) |
|
610 |
/
|
|
611 |
||
612 |
CREATE SEQUENCE phpbb_groups_seq |
|
613 |
/
|
|
614 |
||
615 |
CREATE OR REPLACE TRIGGER t_phpbb_groups |
|
616 |
BEFORE INSERT ON phpbb_groups |
|
617 |
FOR EACH ROW WHEN ( |
|
618 |
new.group_id IS NULL OR new.group_id = 0 |
|
619 |
)
|
|
620 |
BEGIN
|
|
621 |
SELECT phpbb_groups_seq.nextval |
|
622 |
INTO :new.group_id |
|
623 |
FROM dual; |
|
624 |
END; |
|
625 |
/
|
|
626 |
||
627 |
||
628 |
/*
|
|
629 |
Table: 'phpbb_icons'
|
|
630 |
*/
|
|
631 |
CREATE TABLE phpbb_icons ( |
|
632 |
icons_id number(8) NOT NULL, |
|
633 |
icons_url varchar2(255) DEFAULT '' , |
|
634 |
icons_width number(4) DEFAULT '0' NOT NULL, |
|
635 |
icons_height number(4) DEFAULT '0' NOT NULL, |
|
636 |
icons_order number(8) DEFAULT '0' NOT NULL, |
|
637 |
display_on_posting number(1) DEFAULT '1' NOT NULL, |
|
638 |
CONSTRAINT pk_phpbb_icons PRIMARY KEY (icons_id) |
|
639 |
)
|
|
640 |
/
|
|
641 |
||
642 |
CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting) |
|
643 |
/
|
|
644 |
||
645 |
CREATE SEQUENCE phpbb_icons_seq |
|
646 |
/
|
|
647 |
||
648 |
CREATE OR REPLACE TRIGGER t_phpbb_icons |
|
649 |
BEFORE INSERT ON phpbb_icons |
|
650 |
FOR EACH ROW WHEN ( |
|
651 |
new.icons_id IS NULL OR new.icons_id = 0 |
|
652 |
)
|
|
653 |
BEGIN
|
|
654 |
SELECT phpbb_icons_seq.nextval |
|
655 |
INTO :new.icons_id |
|
656 |
FROM dual; |
|
657 |
END; |
|
658 |
/
|
|
659 |
||
660 |
||
661 |
/*
|
|
662 |
Table: 'phpbb_lang'
|
|
663 |
*/
|
|
664 |
CREATE TABLE phpbb_lang ( |
|
665 |
lang_id number(4) NOT NULL, |
|
666 |
lang_iso varchar2(30) DEFAULT '' , |
|
667 |
lang_dir varchar2(30) DEFAULT '' , |
|
668 |
lang_english_name varchar2(300) DEFAULT '' , |
|
669 |
lang_local_name varchar2(765) DEFAULT '' , |
|
670 |
lang_author varchar2(765) DEFAULT '' , |
|
671 |
CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id) |
|
672 |
)
|
|
673 |
/
|
|
674 |
||
675 |
CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso) |
|
676 |
/
|
|
677 |
||
678 |
CREATE SEQUENCE phpbb_lang_seq |
|
679 |
/
|
|
680 |
||
681 |
CREATE OR REPLACE TRIGGER t_phpbb_lang |
|
682 |
BEFORE INSERT ON phpbb_lang |
|
683 |
FOR EACH ROW WHEN ( |
|
684 |
new.lang_id IS NULL OR new.lang_id = 0 |
|
685 |
)
|
|
686 |
BEGIN
|
|
687 |
SELECT phpbb_lang_seq.nextval |
|
688 |
INTO :new.lang_id |
|
689 |
FROM dual; |
|
690 |
END; |
|
691 |
/
|
|
692 |
||
693 |
||
694 |
/*
|
|
695 |
Table: 'phpbb_log'
|
|
696 |
*/
|
|
697 |
CREATE TABLE phpbb_log ( |
|
698 |
log_id number(8) NOT NULL, |
|
699 |
log_type number(4) DEFAULT '0' NOT NULL, |
|
700 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
701 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
702 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
703 |
reportee_id number(8) DEFAULT '0' NOT NULL, |
|
704 |
log_ip varchar2(40) DEFAULT '' , |
|
705 |
log_time number(11) DEFAULT '0' NOT NULL, |
|
706 |
log_operation clob DEFAULT '' , |
|
707 |
log_data clob DEFAULT '' , |
|
708 |
CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id) |
|
709 |
)
|
|
710 |
/
|
|
711 |
||
712 |
CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type) |
|
713 |
/
|
|
714 |
CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id) |
|
715 |
/
|
|
716 |
CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id) |
|
717 |
/
|
|
718 |
CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id) |
|
719 |
/
|
|
720 |
CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id) |
|
721 |
/
|
|
722 |
||
723 |
CREATE SEQUENCE phpbb_log_seq |
|
724 |
/
|
|
725 |
||
726 |
CREATE OR REPLACE TRIGGER t_phpbb_log |
|
727 |
BEFORE INSERT ON phpbb_log |
|
728 |
FOR EACH ROW WHEN ( |
|
729 |
new.log_id IS NULL OR new.log_id = 0 |
|
730 |
)
|
|
731 |
BEGIN
|
|
732 |
SELECT phpbb_log_seq.nextval |
|
733 |
INTO :new.log_id |
|
734 |
FROM dual; |
|
735 |
END; |
|
736 |
/
|
|
737 |
||
738 |
||
739 |
/*
|
|
740 |
Table: 'phpbb_moderator_cache'
|
|
741 |
*/
|
|
742 |
CREATE TABLE phpbb_moderator_cache ( |
|
743 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
744 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
745 |
username varchar2(765) DEFAULT '' , |
|
746 |
group_id number(8) DEFAULT '0' NOT NULL, |
|
747 |
group_name varchar2(765) DEFAULT '' , |
|
748 |
display_on_index number(1) DEFAULT '1' NOT NULL |
|
749 |
)
|
|
750 |
/
|
|
751 |
||
752 |
CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index) |
|
753 |
/
|
|
754 |
CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id) |
|
755 |
/
|
|
756 |
||
757 |
/*
|
|
758 |
Table: 'phpbb_modules'
|
|
759 |
*/
|
|
760 |
CREATE TABLE phpbb_modules ( |
|
761 |
module_id number(8) NOT NULL, |
|
762 |
module_enabled number(1) DEFAULT '1' NOT NULL, |
|
763 |
module_display number(1) DEFAULT '1' NOT NULL, |
|
764 |
module_basename varchar2(255) DEFAULT '' , |
|
765 |
module_class varchar2(10) DEFAULT '' , |
|
766 |
parent_id number(8) DEFAULT '0' NOT NULL, |
|
767 |
left_id number(8) DEFAULT '0' NOT NULL, |
|
768 |
right_id number(8) DEFAULT '0' NOT NULL, |
|
769 |
module_langname varchar2(255) DEFAULT '' , |
|
770 |
module_mode varchar2(255) DEFAULT '' , |
|
771 |
module_auth varchar2(255) DEFAULT '' , |
|
772 |
CONSTRAINT pk_phpbb_modules PRIMARY KEY (module_id) |
|
773 |
)
|
|
774 |
/
|
|
775 |
||
776 |
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id) |
|
777 |
/
|
|
778 |
CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled) |
|
779 |
/
|
|
780 |
CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id) |
|
781 |
/
|
|
782 |
||
783 |
CREATE SEQUENCE phpbb_modules_seq |
|
784 |
/
|
|
785 |
||
786 |
CREATE OR REPLACE TRIGGER t_phpbb_modules |
|
787 |
BEFORE INSERT ON phpbb_modules |
|
788 |
FOR EACH ROW WHEN ( |
|
789 |
new.module_id IS NULL OR new.module_id = 0 |
|
790 |
)
|
|
791 |
BEGIN
|
|
792 |
SELECT phpbb_modules_seq.nextval |
|
793 |
INTO :new.module_id |
|
794 |
FROM dual; |
|
795 |
END; |
|
796 |
/
|
|
797 |
||
798 |
||
799 |
/*
|
|
800 |
Table: 'phpbb_poll_options'
|
|
801 |
*/
|
|
802 |
CREATE TABLE phpbb_poll_options ( |
|
803 |
poll_option_id number(4) DEFAULT '0' NOT NULL, |
|
804 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
805 |
poll_option_text clob DEFAULT '' , |
|
806 |
poll_option_total number(8) DEFAULT '0' NOT NULL |
|
807 |
)
|
|
808 |
/
|
|
809 |
||
810 |
CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id) |
|
811 |
/
|
|
812 |
CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id) |
|
813 |
/
|
|
814 |
||
815 |
/*
|
|
816 |
Table: 'phpbb_poll_votes'
|
|
817 |
*/
|
|
818 |
CREATE TABLE phpbb_poll_votes ( |
|
819 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
820 |
poll_option_id number(4) DEFAULT '0' NOT NULL, |
|
821 |
vote_user_id number(8) DEFAULT '0' NOT NULL, |
|
822 |
vote_user_ip varchar2(40) DEFAULT '' |
|
823 |
)
|
|
824 |
/
|
|
825 |
||
826 |
CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id) |
|
827 |
/
|
|
828 |
CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id) |
|
829 |
/
|
|
830 |
CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip) |
|
831 |
/
|
|
832 |
||
833 |
/*
|
|
834 |
Table: 'phpbb_posts'
|
|
835 |
*/
|
|
836 |
CREATE TABLE phpbb_posts ( |
|
837 |
post_id number(8) NOT NULL, |
|
838 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
839 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
840 |
poster_id number(8) DEFAULT '0' NOT NULL, |
|
841 |
icon_id number(8) DEFAULT '0' NOT NULL, |
|
842 |
poster_ip varchar2(40) DEFAULT '' , |
|
843 |
post_time number(11) DEFAULT '0' NOT NULL, |
|
844 |
post_approved number(1) DEFAULT '1' NOT NULL, |
|
845 |
post_reported number(1) DEFAULT '0' NOT NULL, |
|
846 |
enable_bbcode number(1) DEFAULT '1' NOT NULL, |
|
847 |
enable_smilies number(1) DEFAULT '1' NOT NULL, |
|
848 |
enable_magic_url number(1) DEFAULT '1' NOT NULL, |
|
849 |
enable_sig number(1) DEFAULT '1' NOT NULL, |
|
850 |
post_username varchar2(765) DEFAULT '' , |
|
851 |
post_subject varchar2(300) DEFAULT '' , |
|
852 |
post_text clob DEFAULT '' , |
|
853 |
post_checksum varchar2(32) DEFAULT '' , |
|
854 |
post_attachment number(1) DEFAULT '0' NOT NULL, |
|
855 |
bbcode_bitfield varchar2(255) DEFAULT '' , |
|
856 |
bbcode_uid varchar2(8) DEFAULT '' , |
|
857 |
post_postcount number(1) DEFAULT '1' NOT NULL, |
|
858 |
post_edit_time number(11) DEFAULT '0' NOT NULL, |
|
859 |
post_edit_reason varchar2(765) DEFAULT '' , |
|
860 |
post_edit_user number(8) DEFAULT '0' NOT NULL, |
|
861 |
post_edit_count number(4) DEFAULT '0' NOT NULL, |
|
862 |
post_edit_locked number(1) DEFAULT '0' NOT NULL, |
|
863 |
CONSTRAINT pk_phpbb_posts PRIMARY KEY (post_id) |
|
864 |
)
|
|
865 |
/
|
|
866 |
||
867 |
CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id) |
|
868 |
/
|
|
869 |
CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id) |
|
870 |
/
|
|
871 |
CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip) |
|
872 |
/
|
|
873 |
CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id) |
|
874 |
/
|
|
875 |
CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved) |
|
876 |
/
|
|
877 |
CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time) |
|
878 |
/
|
|
879 |
||
880 |
CREATE SEQUENCE phpbb_posts_seq |
|
881 |
/
|
|
882 |
||
883 |
CREATE OR REPLACE TRIGGER t_phpbb_posts |
|
884 |
BEFORE INSERT ON phpbb_posts |
|
885 |
FOR EACH ROW WHEN ( |
|
886 |
new.post_id IS NULL OR new.post_id = 0 |
|
887 |
)
|
|
888 |
BEGIN
|
|
889 |
SELECT phpbb_posts_seq.nextval |
|
890 |
INTO :new.post_id |
|
891 |
FROM dual; |
|
892 |
END; |
|
893 |
/
|
|
894 |
||
895 |
||
896 |
/*
|
|
897 |
Table: 'phpbb_privmsgs'
|
|
898 |
*/
|
|
899 |
CREATE TABLE phpbb_privmsgs ( |
|
900 |
msg_id number(8) NOT NULL, |
|
901 |
root_level number(8) DEFAULT '0' NOT NULL, |
|
902 |
author_id number(8) DEFAULT '0' NOT NULL, |
|
903 |
icon_id number(8) DEFAULT '0' NOT NULL, |
|
904 |
author_ip varchar2(40) DEFAULT '' , |
|
905 |
message_time number(11) DEFAULT '0' NOT NULL, |
|
906 |
enable_bbcode number(1) DEFAULT '1' NOT NULL, |
|
907 |
enable_smilies number(1) DEFAULT '1' NOT NULL, |
|
908 |
enable_magic_url number(1) DEFAULT '1' NOT NULL, |
|
909 |
enable_sig number(1) DEFAULT '1' NOT NULL, |
|
910 |
message_subject varchar2(300) DEFAULT '' , |
|
911 |
message_text clob DEFAULT '' , |
|
912 |
message_edit_reason varchar2(765) DEFAULT '' , |
|
913 |
message_edit_user number(8) DEFAULT '0' NOT NULL, |
|
914 |
message_attachment number(1) DEFAULT '0' NOT NULL, |
|
915 |
bbcode_bitfield varchar2(255) DEFAULT '' , |
|
916 |
bbcode_uid varchar2(8) DEFAULT '' , |
|
917 |
message_edit_time number(11) DEFAULT '0' NOT NULL, |
|
918 |
message_edit_count number(4) DEFAULT '0' NOT NULL, |
|
919 |
to_address clob DEFAULT '' , |
|
920 |
bcc_address clob DEFAULT '' , |
|
921 |
CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id) |
|
922 |
)
|
|
923 |
/
|
|
924 |
||
925 |
CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip) |
|
926 |
/
|
|
927 |
CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time) |
|
928 |
/
|
|
929 |
CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id) |
|
930 |
/
|
|
931 |
CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level) |
|
932 |
/
|
|
933 |
||
934 |
CREATE SEQUENCE phpbb_privmsgs_seq |
|
935 |
/
|
|
936 |
||
937 |
CREATE OR REPLACE TRIGGER t_phpbb_privmsgs |
|
938 |
BEFORE INSERT ON phpbb_privmsgs |
|
939 |
FOR EACH ROW WHEN ( |
|
940 |
new.msg_id IS NULL OR new.msg_id = 0 |
|
941 |
)
|
|
942 |
BEGIN
|
|
943 |
SELECT phpbb_privmsgs_seq.nextval |
|
944 |
INTO :new.msg_id |
|
945 |
FROM dual; |
|
946 |
END; |
|
947 |
/
|
|
948 |
||
949 |
||
950 |
/*
|
|
951 |
Table: 'phpbb_privmsgs_folder'
|
|
952 |
*/
|
|
953 |
CREATE TABLE phpbb_privmsgs_folder ( |
|
954 |
folder_id number(8) NOT NULL, |
|
955 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
956 |
folder_name varchar2(765) DEFAULT '' , |
|
957 |
pm_count number(8) DEFAULT '0' NOT NULL, |
|
958 |
CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id) |
|
959 |
)
|
|
960 |
/
|
|
961 |
||
962 |
CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id) |
|
963 |
/
|
|
964 |
||
965 |
CREATE SEQUENCE phpbb_privmsgs_folder_seq |
|
966 |
/
|
|
967 |
||
968 |
CREATE OR REPLACE TRIGGER t_phpbb_privmsgs_folder |
|
969 |
BEFORE INSERT ON phpbb_privmsgs_folder |
|
970 |
FOR EACH ROW WHEN ( |
|
971 |
new.folder_id IS NULL OR new.folder_id = 0 |
|
972 |
)
|
|
973 |
BEGIN
|
|
974 |
SELECT phpbb_privmsgs_folder_seq.nextval |
|
975 |
INTO :new.folder_id |
|
976 |
FROM dual; |
|
977 |
END; |
|
978 |
/
|
|
979 |
||
980 |
||
981 |
/*
|
|
982 |
Table: 'phpbb_privmsgs_rules'
|
|
983 |
*/
|
|
984 |
CREATE TABLE phpbb_privmsgs_rules ( |
|
985 |
rule_id number(8) NOT NULL, |
|
986 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
987 |
rule_check number(8) DEFAULT '0' NOT NULL, |
|
988 |
rule_connection number(8) DEFAULT '0' NOT NULL, |
|
989 |
rule_string varchar2(765) DEFAULT '' , |
|
990 |
rule_user_id number(8) DEFAULT '0' NOT NULL, |
|
991 |
rule_group_id number(8) DEFAULT '0' NOT NULL, |
|
992 |
rule_action number(8) DEFAULT '0' NOT NULL, |
|
993 |
rule_folder_id number(11) DEFAULT '0' NOT NULL, |
|
994 |
CONSTRAINT pk_phpbb_privmsgs_rules PRIMARY KEY (rule_id) |
|
995 |
)
|
|
996 |
/
|
|
997 |
||
998 |
CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id) |
|
999 |
/
|
|
1000 |
||
1001 |
CREATE SEQUENCE phpbb_privmsgs_rules_seq |
|
1002 |
/
|
|
1003 |
||
1004 |
CREATE OR REPLACE TRIGGER t_phpbb_privmsgs_rules |
|
1005 |
BEFORE INSERT ON phpbb_privmsgs_rules |
|
1006 |
FOR EACH ROW WHEN ( |
|
1007 |
new.rule_id IS NULL OR new.rule_id = 0 |
|
1008 |
)
|
|
1009 |
BEGIN
|
|
1010 |
SELECT phpbb_privmsgs_rules_seq.nextval |
|
1011 |
INTO :new.rule_id |
|
1012 |
FROM dual; |
|
1013 |
END; |
|
1014 |
/
|
|
1015 |
||
1016 |
||
1017 |
/*
|
|
1018 |
Table: 'phpbb_privmsgs_to'
|
|
1019 |
*/
|
|
1020 |
CREATE TABLE phpbb_privmsgs_to ( |
|
1021 |
msg_id number(8) DEFAULT '0' NOT NULL, |
|
1022 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1023 |
author_id number(8) DEFAULT '0' NOT NULL, |
|
1024 |
pm_deleted number(1) DEFAULT '0' NOT NULL, |
|
1025 |
pm_new number(1) DEFAULT '1' NOT NULL, |
|
1026 |
pm_unread number(1) DEFAULT '1' NOT NULL, |
|
1027 |
pm_replied number(1) DEFAULT '0' NOT NULL, |
|
1028 |
pm_marked number(1) DEFAULT '0' NOT NULL, |
|
1029 |
pm_forwarded number(1) DEFAULT '0' NOT NULL, |
|
1030 |
folder_id number(11) DEFAULT '0' NOT NULL |
|
1031 |
)
|
|
1032 |
/
|
|
1033 |
||
1034 |
CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id) |
|
1035 |
/
|
|
1036 |
CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to (author_id) |
|
1037 |
/
|
|
1038 |
CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to (user_id, folder_id) |
|
1039 |
/
|
|
1040 |
||
1041 |
/*
|
|
1042 |
Table: 'phpbb_profile_fields'
|
|
1043 |
*/
|
|
1044 |
CREATE TABLE phpbb_profile_fields ( |
|
1045 |
field_id number(8) NOT NULL, |
|
1046 |
field_name varchar2(765) DEFAULT '' , |
|
1047 |
field_type number(4) DEFAULT '0' NOT NULL, |
|
1048 |
field_ident varchar2(20) DEFAULT '' , |
|
1049 |
field_length varchar2(20) DEFAULT '' , |
|
1050 |
field_minlen varchar2(255) DEFAULT '' , |
|
1051 |
field_maxlen varchar2(255) DEFAULT '' , |
|
1052 |
field_novalue varchar2(765) DEFAULT '' , |
|
1053 |
field_default_value varchar2(765) DEFAULT '' , |
|
1054 |
field_validation varchar2(60) DEFAULT '' , |
|
1055 |
field_required number(1) DEFAULT '0' NOT NULL, |
|
1056 |
field_show_on_reg number(1) DEFAULT '0' NOT NULL, |
|
1057 |
field_hide number(1) DEFAULT '0' NOT NULL, |
|
1058 |
field_no_view number(1) DEFAULT '0' NOT NULL, |
|
1059 |
field_active number(1) DEFAULT '0' NOT NULL, |
|
1060 |
field_order number(8) DEFAULT '0' NOT NULL, |
|
1061 |
CONSTRAINT pk_phpbb_profile_fields PRIMARY KEY (field_id) |
|
1062 |
)
|
|
1063 |
/
|
|
1064 |
||
1065 |
CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type) |
|
1066 |
/
|
|
1067 |
CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order) |
|
1068 |
/
|
|
1069 |
||
1070 |
CREATE SEQUENCE phpbb_profile_fields_seq |
|
1071 |
/
|
|
1072 |
||
1073 |
CREATE OR REPLACE TRIGGER t_phpbb_profile_fields |
|
1074 |
BEFORE INSERT ON phpbb_profile_fields |
|
1075 |
FOR EACH ROW WHEN ( |
|
1076 |
new.field_id IS NULL OR new.field_id = 0 |
|
1077 |
)
|
|
1078 |
BEGIN
|
|
1079 |
SELECT phpbb_profile_fields_seq.nextval |
|
1080 |
INTO :new.field_id |
|
1081 |
FROM dual; |
|
1082 |
END; |
|
1083 |
/
|
|
1084 |
||
1085 |
||
1086 |
/*
|
|
1087 |
Table: 'phpbb_profile_fields_data'
|
|
1088 |
*/
|
|
1089 |
CREATE TABLE phpbb_profile_fields_data ( |
|
1090 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1091 |
CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id) |
|
1092 |
)
|
|
1093 |
/
|
|
1094 |
||
1095 |
||
1096 |
/*
|
|
1097 |
Table: 'phpbb_profile_fields_lang'
|
|
1098 |
*/
|
|
1099 |
CREATE TABLE phpbb_profile_fields_lang ( |
|
1100 |
field_id number(8) DEFAULT '0' NOT NULL, |
|
1101 |
lang_id number(8) DEFAULT '0' NOT NULL, |
|
1102 |
option_id number(8) DEFAULT '0' NOT NULL, |
|
1103 |
field_type number(4) DEFAULT '0' NOT NULL, |
|
1104 |
lang_value varchar2(765) DEFAULT '' , |
|
1105 |
CONSTRAINT pk_phpbb_profile_fields_lang PRIMARY KEY (field_id, lang_id, option_id) |
|
1106 |
)
|
|
1107 |
/
|
|
1108 |
||
1109 |
||
1110 |
/*
|
|
1111 |
Table: 'phpbb_profile_lang'
|
|
1112 |
*/
|
|
1113 |
CREATE TABLE phpbb_profile_lang ( |
|
1114 |
field_id number(8) DEFAULT '0' NOT NULL, |
|
1115 |
lang_id number(8) DEFAULT '0' NOT NULL, |
|
1116 |
lang_name varchar2(765) DEFAULT '' , |
|
1117 |
lang_explain clob DEFAULT '' , |
|
1118 |
lang_default_value varchar2(765) DEFAULT '' , |
|
1119 |
CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id) |
|
1120 |
)
|
|
1121 |
/
|
|
1122 |
||
1123 |
||
1124 |
/*
|
|
1125 |
Table: 'phpbb_ranks'
|
|
1126 |
*/
|
|
1127 |
CREATE TABLE phpbb_ranks ( |
|
1128 |
rank_id number(8) NOT NULL, |
|
1129 |
rank_title varchar2(765) DEFAULT '' , |
|
1130 |
rank_min number(8) DEFAULT '0' NOT NULL, |
|
1131 |
rank_special number(1) DEFAULT '0' NOT NULL, |
|
1132 |
rank_image varchar2(255) DEFAULT '' , |
|
1133 |
CONSTRAINT pk_phpbb_ranks PRIMARY KEY (rank_id) |
|
1134 |
)
|
|
1135 |
/
|
|
1136 |
||
1137 |
||
1138 |
CREATE SEQUENCE phpbb_ranks_seq |
|
1139 |
/
|
|
1140 |
||
1141 |
CREATE OR REPLACE TRIGGER t_phpbb_ranks |
|
1142 |
BEFORE INSERT ON phpbb_ranks |
|
1143 |
FOR EACH ROW WHEN ( |
|
1144 |
new.rank_id IS NULL OR new.rank_id = 0 |
|
1145 |
)
|
|
1146 |
BEGIN
|
|
1147 |
SELECT phpbb_ranks_seq.nextval |
|
1148 |
INTO :new.rank_id |
|
1149 |
FROM dual; |
|
1150 |
END; |
|
1151 |
/
|
|
1152 |
||
1153 |
||
1154 |
/*
|
|
1155 |
Table: 'phpbb_reports'
|
|
1156 |
*/
|
|
1157 |
CREATE TABLE phpbb_reports ( |
|
1158 |
report_id number(8) NOT NULL, |
|
1159 |
reason_id number(4) DEFAULT '0' NOT NULL, |
|
1160 |
post_id number(8) DEFAULT '0' NOT NULL, |
|
1161 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1162 |
user_notify number(1) DEFAULT '0' NOT NULL, |
|
1163 |
report_closed number(1) DEFAULT '0' NOT NULL, |
|
1164 |
report_time number(11) DEFAULT '0' NOT NULL, |
|
1165 |
report_text clob DEFAULT '' , |
|
1166 |
CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) |
|
1167 |
)
|
|
1168 |
/
|
|
1169 |
||
1170 |
||
1171 |
CREATE SEQUENCE phpbb_reports_seq |
|
1172 |
/
|
|
1173 |
||
1174 |
CREATE OR REPLACE TRIGGER t_phpbb_reports |
|
1175 |
BEFORE INSERT ON phpbb_reports |
|
1176 |
FOR EACH ROW WHEN ( |
|
1177 |
new.report_id IS NULL OR new.report_id = 0 |
|
1178 |
)
|
|
1179 |
BEGIN
|
|
1180 |
SELECT phpbb_reports_seq.nextval |
|
1181 |
INTO :new.report_id |
|
1182 |
FROM dual; |
|
1183 |
END; |
|
1184 |
/
|
|
1185 |
||
1186 |
||
1187 |
/*
|
|
1188 |
Table: 'phpbb_reports_reasons'
|
|
1189 |
*/
|
|
1190 |
CREATE TABLE phpbb_reports_reasons ( |
|
1191 |
reason_id number(4) NOT NULL, |
|
1192 |
reason_title varchar2(765) DEFAULT '' , |
|
1193 |
reason_description clob DEFAULT '' , |
|
1194 |
reason_order number(4) DEFAULT '0' NOT NULL, |
|
1195 |
CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id) |
|
1196 |
)
|
|
1197 |
/
|
|
1198 |
||
1199 |
||
1200 |
CREATE SEQUENCE phpbb_reports_reasons_seq |
|
1201 |
/
|
|
1202 |
||
1203 |
CREATE OR REPLACE TRIGGER t_phpbb_reports_reasons |
|
1204 |
BEFORE INSERT ON phpbb_reports_reasons |
|
1205 |
FOR EACH ROW WHEN ( |
|
1206 |
new.reason_id IS NULL OR new.reason_id = 0 |
|
1207 |
)
|
|
1208 |
BEGIN
|
|
1209 |
SELECT phpbb_reports_reasons_seq.nextval |
|
1210 |
INTO :new.reason_id |
|
1211 |
FROM dual; |
|
1212 |
END; |
|
1213 |
/
|
|
1214 |
||
1215 |
||
1216 |
/*
|
|
1217 |
Table: 'phpbb_search_results'
|
|
1218 |
*/
|
|
1219 |
CREATE TABLE phpbb_search_results ( |
|
1220 |
search_key varchar2(32) DEFAULT '' , |
|
1221 |
search_time number(11) DEFAULT '0' NOT NULL, |
|
1222 |
search_keywords clob DEFAULT '' , |
|
1223 |
search_authors clob DEFAULT '' , |
|
1224 |
CONSTRAINT pk_phpbb_search_results PRIMARY KEY (search_key) |
|
1225 |
)
|
|
1226 |
/
|
|
1227 |
||
1228 |
||
1229 |
/*
|
|
1230 |
Table: 'phpbb_search_wordlist'
|
|
1231 |
*/
|
|
1232 |
CREATE TABLE phpbb_search_wordlist ( |
|
1233 |
word_id number(8) NOT NULL, |
|
1234 |
word_text varchar2(765) DEFAULT '' , |
|
1235 |
word_common number(1) DEFAULT '0' NOT NULL, |
|
1236 |
word_count number(8) DEFAULT '0' NOT NULL, |
|
1237 |
CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_id), |
|
1238 |
CONSTRAINT u_phpbb_wrd_txt UNIQUE (word_text) |
|
1239 |
)
|
|
1240 |
/
|
|
1241 |
||
1242 |
CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist (word_count) |
|
1243 |
/
|
|
1244 |
||
1245 |
CREATE SEQUENCE phpbb_search_wordlist_seq |
|
1246 |
/
|
|
1247 |
||
1248 |
CREATE OR REPLACE TRIGGER t_phpbb_search_wordlist |
|
1249 |
BEFORE INSERT ON phpbb_search_wordlist |
|
1250 |
FOR EACH ROW WHEN ( |
|
1251 |
new.word_id IS NULL OR new.word_id = 0 |
|
1252 |
)
|
|
1253 |
BEGIN
|
|
1254 |
SELECT phpbb_search_wordlist_seq.nextval |
|
1255 |
INTO :new.word_id |
|
1256 |
FROM dual; |
|
1257 |
END; |
|
1258 |
/
|
|
1259 |
||
1260 |
||
1261 |
/*
|
|
1262 |
Table: 'phpbb_search_wordmatch'
|
|
1263 |
*/
|
|
1264 |
CREATE TABLE phpbb_search_wordmatch ( |
|
1265 |
post_id number(8) DEFAULT '0' NOT NULL, |
|
1266 |
word_id number(8) DEFAULT '0' NOT NULL, |
|
1267 |
title_match number(1) DEFAULT '0' NOT NULL, |
|
1268 |
CONSTRAINT u_phpbb_unq_mtch UNIQUE (word_id, post_id, title_match) |
|
1269 |
)
|
|
1270 |
/
|
|
1271 |
||
1272 |
CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id) |
|
1273 |
/
|
|
1274 |
CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch (post_id) |
|
1275 |
/
|
|
1276 |
||
1277 |
/*
|
|
1278 |
Table: 'phpbb_sessions'
|
|
1279 |
*/
|
|
1280 |
CREATE TABLE phpbb_sessions ( |
|
1281 |
session_id char(32) DEFAULT '' , |
|
1282 |
session_user_id number(8) DEFAULT '0' NOT NULL, |
|
1283 |
session_last_visit number(11) DEFAULT '0' NOT NULL, |
|
1284 |
session_start number(11) DEFAULT '0' NOT NULL, |
|
1285 |
session_time number(11) DEFAULT '0' NOT NULL, |
|
1286 |
session_ip varchar2(40) DEFAULT '' , |
|
1287 |
session_browser varchar2(150) DEFAULT '' , |
|
1288 |
session_forwarded_for varchar2(255) DEFAULT '' , |
|
1289 |
session_page varchar2(765) DEFAULT '' , |
|
1290 |
session_viewonline number(1) DEFAULT '1' NOT NULL, |
|
1291 |
session_autologin number(1) DEFAULT '0' NOT NULL, |
|
1292 |
session_admin number(1) DEFAULT '0' NOT NULL, |
|
1293 |
CONSTRAINT pk_phpbb_sessions PRIMARY KEY (session_id) |
|
1294 |
)
|
|
1295 |
/
|
|
1296 |
||
1297 |
CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time) |
|
1298 |
/
|
|
1299 |
CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id) |
|
1300 |
/
|
|
1301 |
||
1302 |
/*
|
|
1303 |
Table: 'phpbb_sessions_keys'
|
|
1304 |
*/
|
|
1305 |
CREATE TABLE phpbb_sessions_keys ( |
|
1306 |
key_id char(32) DEFAULT '' , |
|
1307 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1308 |
last_ip varchar2(40) DEFAULT '' , |
|
1309 |
last_login number(11) DEFAULT '0' NOT NULL, |
|
1310 |
CONSTRAINT pk_phpbb_sessions_keys PRIMARY KEY (key_id, user_id) |
|
1311 |
)
|
|
1312 |
/
|
|
1313 |
||
1314 |
CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys (last_login) |
|
1315 |
/
|
|
1316 |
||
1317 |
/*
|
|
1318 |
Table: 'phpbb_sitelist'
|
|
1319 |
*/
|
|
1320 |
CREATE TABLE phpbb_sitelist ( |
|
1321 |
site_id number(8) NOT NULL, |
|
1322 |
site_ip varchar2(40) DEFAULT '' , |
|
1323 |
site_hostname varchar2(255) DEFAULT '' , |
|
1324 |
ip_exclude number(1) DEFAULT '0' NOT NULL, |
|
1325 |
CONSTRAINT pk_phpbb_sitelist PRIMARY KEY (site_id) |
|
1326 |
)
|
|
1327 |
/
|
|
1328 |
||
1329 |
||
1330 |
CREATE SEQUENCE phpbb_sitelist_seq |
|
1331 |
/
|
|
1332 |
||
1333 |
CREATE OR REPLACE TRIGGER t_phpbb_sitelist |
|
1334 |
BEFORE INSERT ON phpbb_sitelist |
|
1335 |
FOR EACH ROW WHEN ( |
|
1336 |
new.site_id IS NULL OR new.site_id = 0 |
|
1337 |
)
|
|
1338 |
BEGIN
|
|
1339 |
SELECT phpbb_sitelist_seq.nextval |
|
1340 |
INTO :new.site_id |
|
1341 |
FROM dual; |
|
1342 |
END; |
|
1343 |
/
|
|
1344 |
||
1345 |
||
1346 |
/*
|
|
1347 |
Table: 'phpbb_smilies'
|
|
1348 |
*/
|
|
1349 |
CREATE TABLE phpbb_smilies ( |
|
1350 |
smiley_id number(8) NOT NULL, |
|
1351 |
code varchar2(150) DEFAULT '' , |
|
1352 |
emotion varchar2(150) DEFAULT '' , |
|
1353 |
smiley_url varchar2(50) DEFAULT '' , |
|
1354 |
smiley_width number(4) DEFAULT '0' NOT NULL, |
|
1355 |
smiley_height number(4) DEFAULT '0' NOT NULL, |
|
1356 |
smiley_order number(8) DEFAULT '0' NOT NULL, |
|
1357 |
display_on_posting number(1) DEFAULT '1' NOT NULL, |
|
1358 |
CONSTRAINT pk_phpbb_smilies PRIMARY KEY (smiley_id) |
|
1359 |
)
|
|
1360 |
/
|
|
1361 |
||
1362 |
CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies (display_on_posting) |
|
1363 |
/
|
|
1364 |
||
1365 |
CREATE SEQUENCE phpbb_smilies_seq |
|
1366 |
/
|
|
1367 |
||
1368 |
CREATE OR REPLACE TRIGGER t_phpbb_smilies |
|
1369 |
BEFORE INSERT ON phpbb_smilies |
|
1370 |
FOR EACH ROW WHEN ( |
|
1371 |
new.smiley_id IS NULL OR new.smiley_id = 0 |
|
1372 |
)
|
|
1373 |
BEGIN
|
|
1374 |
SELECT phpbb_smilies_seq.nextval |
|
1375 |
INTO :new.smiley_id |
|
1376 |
FROM dual; |
|
1377 |
END; |
|
1378 |
/
|
|
1379 |
||
1380 |
||
1381 |
/*
|
|
1382 |
Table: 'phpbb_styles'
|
|
1383 |
*/
|
|
1384 |
CREATE TABLE phpbb_styles ( |
|
1385 |
style_id number(4) NOT NULL, |
|
1386 |
style_name varchar2(765) DEFAULT '' , |
|
1387 |
style_copyright varchar2(765) DEFAULT '' , |
|
1388 |
style_active number(1) DEFAULT '1' NOT NULL, |
|
1389 |
template_id number(4) DEFAULT '0' NOT NULL, |
|
1390 |
theme_id number(4) DEFAULT '0' NOT NULL, |
|
1391 |
imageset_id number(4) DEFAULT '0' NOT NULL, |
|
1392 |
CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id), |
|
1393 |
CONSTRAINT u_phpbb_style_name UNIQUE (style_name) |
|
1394 |
)
|
|
1395 |
/
|
|
1396 |
||
1397 |
CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id) |
|
1398 |
/
|
|
1399 |
CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id) |
|
1400 |
/
|
|
1401 |
CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id) |
|
1402 |
/
|
|
1403 |
||
1404 |
CREATE SEQUENCE phpbb_styles_seq |
|
1405 |
/
|
|
1406 |
||
1407 |
CREATE OR REPLACE TRIGGER t_phpbb_styles |
|
1408 |
BEFORE INSERT ON phpbb_styles |
|
1409 |
FOR EACH ROW WHEN ( |
|
1410 |
new.style_id IS NULL OR new.style_id = 0 |
|
1411 |
)
|
|
1412 |
BEGIN
|
|
1413 |
SELECT phpbb_styles_seq.nextval |
|
1414 |
INTO :new.style_id |
|
1415 |
FROM dual; |
|
1416 |
END; |
|
1417 |
/
|
|
1418 |
||
1419 |
||
1420 |
/*
|
|
1421 |
Table: 'phpbb_styles_template'
|
|
1422 |
*/
|
|
1423 |
CREATE TABLE phpbb_styles_template ( |
|
1424 |
template_id number(4) NOT NULL, |
|
1425 |
template_name varchar2(765) DEFAULT '' , |
|
1426 |
template_copyright varchar2(765) DEFAULT '' , |
|
1427 |
template_path varchar2(100) DEFAULT '' , |
|
1428 |
bbcode_bitfield varchar2(255) DEFAULT 'kNg=' NOT NULL, |
|
1429 |
template_storedb number(1) DEFAULT '0' NOT NULL, |
|
1430 |
CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id), |
|
1431 |
CONSTRAINT u_phpbb_tmplte_nm UNIQUE (template_name) |
|
1432 |
)
|
|
1433 |
/
|
|
1434 |
||
1435 |
||
1436 |
CREATE SEQUENCE phpbb_styles_template_seq |
|
1437 |
/
|
|
1438 |
||
1439 |
CREATE OR REPLACE TRIGGER t_phpbb_styles_template |
|
1440 |
BEFORE INSERT ON phpbb_styles_template |
|
1441 |
FOR EACH ROW WHEN ( |
|
1442 |
new.template_id IS NULL OR new.template_id = 0 |
|
1443 |
)
|
|
1444 |
BEGIN
|
|
1445 |
SELECT phpbb_styles_template_seq.nextval |
|
1446 |
INTO :new.template_id |
|
1447 |
FROM dual; |
|
1448 |
END; |
|
1449 |
/
|
|
1450 |
||
1451 |
||
1452 |
/*
|
|
1453 |
Table: 'phpbb_styles_template_data'
|
|
1454 |
*/
|
|
1455 |
CREATE TABLE phpbb_styles_template_data ( |
|
1456 |
template_id number(4) DEFAULT '0' NOT NULL, |
|
1457 |
template_filename varchar2(100) DEFAULT '' , |
|
1458 |
template_included clob DEFAULT '' , |
|
1459 |
template_mtime number(11) DEFAULT '0' NOT NULL, |
|
1460 |
template_data clob DEFAULT '' |
|
1461 |
)
|
|
1462 |
/
|
|
1463 |
||
1464 |
CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id) |
|
1465 |
/
|
|
1466 |
CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename) |
|
1467 |
/
|
|
1468 |
||
1469 |
/*
|
|
1470 |
Table: 'phpbb_styles_theme'
|
|
1471 |
*/
|
|
1472 |
CREATE TABLE phpbb_styles_theme ( |
|
1473 |
theme_id number(4) NOT NULL, |
|
1474 |
theme_name varchar2(765) DEFAULT '' , |
|
1475 |
theme_copyright varchar2(765) DEFAULT '' , |
|
1476 |
theme_path varchar2(100) DEFAULT '' , |
|
1477 |
theme_storedb number(1) DEFAULT '0' NOT NULL, |
|
1478 |
theme_mtime number(11) DEFAULT '0' NOT NULL, |
|
1479 |
theme_data clob DEFAULT '' , |
|
1480 |
CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id), |
|
1481 |
CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name) |
|
1482 |
)
|
|
1483 |
/
|
|
1484 |
||
1485 |
||
1486 |
CREATE SEQUENCE phpbb_styles_theme_seq |
|
1487 |
/
|
|
1488 |
||
1489 |
CREATE OR REPLACE TRIGGER t_phpbb_styles_theme |
|
1490 |
BEFORE INSERT ON phpbb_styles_theme |
|
1491 |
FOR EACH ROW WHEN ( |
|
1492 |
new.theme_id IS NULL OR new.theme_id = 0 |
|
1493 |
)
|
|
1494 |
BEGIN
|
|
1495 |
SELECT phpbb_styles_theme_seq.nextval |
|
1496 |
INTO :new.theme_id |
|
1497 |
FROM dual; |
|
1498 |
END; |
|
1499 |
/
|
|
1500 |
||
1501 |
||
1502 |
/*
|
|
1503 |
Table: 'phpbb_styles_imageset'
|
|
1504 |
*/
|
|
1505 |
CREATE TABLE phpbb_styles_imageset ( |
|
1506 |
imageset_id number(4) NOT NULL, |
|
1507 |
imageset_name varchar2(765) DEFAULT '' , |
|
1508 |
imageset_copyright varchar2(765) DEFAULT '' , |
|
1509 |
imageset_path varchar2(100) DEFAULT '' , |
|
1510 |
CONSTRAINT pk_phpbb_styles_imageset PRIMARY KEY (imageset_id), |
|
1511 |
CONSTRAINT u_phpbb_imgset_nm UNIQUE (imageset_name) |
|
1512 |
)
|
|
1513 |
/
|
|
1514 |
||
1515 |
||
1516 |
CREATE SEQUENCE phpbb_styles_imageset_seq |
|
1517 |
/
|
|
1518 |
||
1519 |
CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset |
|
1520 |
BEFORE INSERT ON phpbb_styles_imageset |
|
1521 |
FOR EACH ROW WHEN ( |
|
1522 |
new.imageset_id IS NULL OR new.imageset_id = 0 |
|
1523 |
)
|
|
1524 |
BEGIN
|
|
1525 |
SELECT phpbb_styles_imageset_seq.nextval |
|
1526 |
INTO :new.imageset_id |
|
1527 |
FROM dual; |
|
1528 |
END; |
|
1529 |
/
|
|
1530 |
||
1531 |
||
1532 |
/*
|
|
1533 |
Table: 'phpbb_styles_imageset_data'
|
|
1534 |
*/
|
|
1535 |
CREATE TABLE phpbb_styles_imageset_data ( |
|
1536 |
image_id number(4) NOT NULL, |
|
1537 |
image_name varchar2(200) DEFAULT '' , |
|
1538 |
image_filename varchar2(200) DEFAULT '' , |
|
1539 |
image_lang varchar2(30) DEFAULT '' , |
|
1540 |
image_height number(4) DEFAULT '0' NOT NULL, |
|
1541 |
image_width number(4) DEFAULT '0' NOT NULL, |
|
1542 |
imageset_id number(4) DEFAULT '0' NOT NULL, |
|
1543 |
CONSTRAINT pk_phpbb_styles_imageset_data PRIMARY KEY (image_id) |
|
1544 |
)
|
|
1545 |
/
|
|
1546 |
||
1547 |
CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data (imageset_id) |
|
1548 |
/
|
|
1549 |
||
1550 |
CREATE SEQUENCE phpbb_styles_imageset_data_seq |
|
1551 |
/
|
|
1552 |
||
1553 |
CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset_data |
|
1554 |
BEFORE INSERT ON phpbb_styles_imageset_data |
|
1555 |
FOR EACH ROW WHEN ( |
|
1556 |
new.image_id IS NULL OR new.image_id = 0 |
|
1557 |
)
|
|
1558 |
BEGIN
|
|
1559 |
SELECT phpbb_styles_imageset_data_seq.nextval |
|
1560 |
INTO :new.image_id |
|
1561 |
FROM dual; |
|
1562 |
END; |
|
1563 |
/
|
|
1564 |
||
1565 |
||
1566 |
/*
|
|
1567 |
Table: 'phpbb_topics'
|
|
1568 |
*/
|
|
1569 |
CREATE TABLE phpbb_topics ( |
|
1570 |
topic_id number(8) NOT NULL, |
|
1571 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
1572 |
icon_id number(8) DEFAULT '0' NOT NULL, |
|
1573 |
topic_attachment number(1) DEFAULT '0' NOT NULL, |
|
1574 |
topic_approved number(1) DEFAULT '1' NOT NULL, |
|
1575 |
topic_reported number(1) DEFAULT '0' NOT NULL, |
|
1576 |
topic_title varchar2(300) DEFAULT '' , |
|
1577 |
topic_poster number(8) DEFAULT '0' NOT NULL, |
|
1578 |
topic_time number(11) DEFAULT '0' NOT NULL, |
|
1579 |
topic_time_limit number(11) DEFAULT '0' NOT NULL, |
|
1580 |
topic_views number(8) DEFAULT '0' NOT NULL, |
|
1581 |
topic_replies number(8) DEFAULT '0' NOT NULL, |
|
1582 |
topic_replies_real number(8) DEFAULT '0' NOT NULL, |
|
1583 |
topic_status number(3) DEFAULT '0' NOT NULL, |
|
1584 |
topic_type number(3) DEFAULT '0' NOT NULL, |
|
1585 |
topic_first_post_id number(8) DEFAULT '0' NOT NULL, |
|
1586 |
topic_first_poster_name varchar2(765) DEFAULT '' , |
|
1587 |
topic_first_poster_colour varchar2(6) DEFAULT '' , |
|
1588 |
topic_last_post_id number(8) DEFAULT '0' NOT NULL, |
|
1589 |
topic_last_poster_id number(8) DEFAULT '0' NOT NULL, |
|
1590 |
topic_last_poster_name varchar2(765) DEFAULT '' , |
|
1591 |
topic_last_poster_colour varchar2(6) DEFAULT '' , |
|
1592 |
topic_last_post_subject varchar2(300) DEFAULT '' , |
|
1593 |
topic_last_post_time number(11) DEFAULT '0' NOT NULL, |
|
1594 |
topic_last_view_time number(11) DEFAULT '0' NOT NULL, |
|
1595 |
topic_moved_id number(8) DEFAULT '0' NOT NULL, |
|
1596 |
topic_bumped number(1) DEFAULT '0' NOT NULL, |
|
1597 |
topic_bumper number(8) DEFAULT '0' NOT NULL, |
|
1598 |
poll_title varchar2(765) DEFAULT '' , |
|
1599 |
poll_start number(11) DEFAULT '0' NOT NULL, |
|
1600 |
poll_length number(11) DEFAULT '0' NOT NULL, |
|
1601 |
poll_max_options number(4) DEFAULT '1' NOT NULL, |
|
1602 |
poll_last_vote number(11) DEFAULT '0' NOT NULL, |
|
1603 |
poll_vote_change number(1) DEFAULT '0' NOT NULL, |
|
1604 |
CONSTRAINT pk_phpbb_topics PRIMARY KEY (topic_id) |
|
1605 |
)
|
|
1606 |
/
|
|
1607 |
||
1608 |
CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id) |
|
1609 |
/
|
|
1610 |
CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type) |
|
1611 |
/
|
|
1612 |
CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time) |
|
1613 |
/
|
|
1614 |
CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics (topic_approved) |
|
1615 |
/
|
|
1616 |
CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics (forum_id, topic_approved, topic_last_post_id) |
|
1617 |
/
|
|
1618 |
CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id) |
|
1619 |
/
|
|
1620 |
||
1621 |
CREATE SEQUENCE phpbb_topics_seq |
|
1622 |
/
|
|
1623 |
||
1624 |
CREATE OR REPLACE TRIGGER t_phpbb_topics |
|
1625 |
BEFORE INSERT ON phpbb_topics |
|
1626 |
FOR EACH ROW WHEN ( |
|
1627 |
new.topic_id IS NULL OR new.topic_id = 0 |
|
1628 |
)
|
|
1629 |
BEGIN
|
|
1630 |
SELECT phpbb_topics_seq.nextval |
|
1631 |
INTO :new.topic_id |
|
1632 |
FROM dual; |
|
1633 |
END; |
|
1634 |
/
|
|
1635 |
||
1636 |
||
1637 |
/*
|
|
1638 |
Table: 'phpbb_topics_track'
|
|
1639 |
*/
|
|
1640 |
CREATE TABLE phpbb_topics_track ( |
|
1641 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1642 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
1643 |
forum_id number(8) DEFAULT '0' NOT NULL, |
|
1644 |
mark_time number(11) DEFAULT '0' NOT NULL, |
|
1645 |
CONSTRAINT pk_phpbb_topics_track PRIMARY KEY (user_id, topic_id) |
|
1646 |
)
|
|
1647 |
/
|
|
1648 |
||
1649 |
CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id) |
|
1650 |
/
|
|
1651 |
||
1652 |
/*
|
|
1653 |
Table: 'phpbb_topics_posted'
|
|
1654 |
*/
|
|
1655 |
CREATE TABLE phpbb_topics_posted ( |
|
1656 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1657 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
1658 |
topic_posted number(1) DEFAULT '0' NOT NULL, |
|
1659 |
CONSTRAINT pk_phpbb_topics_posted PRIMARY KEY (user_id, topic_id) |
|
1660 |
)
|
|
1661 |
/
|
|
1662 |
||
1663 |
||
1664 |
/*
|
|
1665 |
Table: 'phpbb_topics_watch'
|
|
1666 |
*/
|
|
1667 |
CREATE TABLE phpbb_topics_watch ( |
|
1668 |
topic_id number(8) DEFAULT '0' NOT NULL, |
|
1669 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1670 |
notify_status number(1) DEFAULT '0' NOT NULL |
|
1671 |
)
|
|
1672 |
/
|
|
1673 |
||
1674 |
CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id) |
|
1675 |
/
|
|
1676 |
CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id) |
|
1677 |
/
|
|
1678 |
CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch (notify_status) |
|
1679 |
/
|
|
1680 |
||
1681 |
/*
|
|
1682 |
Table: 'phpbb_user_group'
|
|
1683 |
*/
|
|
1684 |
CREATE TABLE phpbb_user_group ( |
|
1685 |
group_id number(8) DEFAULT '0' NOT NULL, |
|
1686 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1687 |
group_leader number(1) DEFAULT '0' NOT NULL, |
|
1688 |
user_pending number(1) DEFAULT '1' NOT NULL |
|
1689 |
)
|
|
1690 |
/
|
|
1691 |
||
1692 |
CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id) |
|
1693 |
/
|
|
1694 |
CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id) |
|
1695 |
/
|
|
1696 |
CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader) |
|
1697 |
/
|
|
1698 |
||
1699 |
/*
|
|
1700 |
Table: 'phpbb_users'
|
|
1701 |
*/
|
|
1702 |
CREATE TABLE phpbb_users ( |
|
1703 |
user_id number(8) NOT NULL, |
|
1704 |
user_type number(2) DEFAULT '0' NOT NULL, |
|
1705 |
group_id number(8) DEFAULT '3' NOT NULL, |
|
1706 |
user_permissions clob DEFAULT '' , |
|
1707 |
user_perm_from number(8) DEFAULT '0' NOT NULL, |
|
1708 |
user_ip varchar2(40) DEFAULT '' , |
|
1709 |
user_regdate number(11) DEFAULT '0' NOT NULL, |
|
1710 |
username varchar2(255) DEFAULT '' , |
|
1711 |
username_clean varchar2(255) DEFAULT '' , |
|
1712 |
user_password varchar2(120) DEFAULT '' , |
|
1713 |
user_passchg number(11) DEFAULT '0' NOT NULL, |
|
1714 |
user_pass_convert number(1) DEFAULT '0' NOT NULL, |
|
1715 |
user_email varchar2(300) DEFAULT '' , |
|
1716 |
user_email_hash number(20) DEFAULT '0' NOT NULL, |
|
1717 |
user_birthday varchar2(10) DEFAULT '' , |
|
1718 |
user_lastvisit number(11) DEFAULT '0' NOT NULL, |
|
1719 |
user_lastmark number(11) DEFAULT '0' NOT NULL, |
|
1720 |
user_lastpost_time number(11) DEFAULT '0' NOT NULL, |
|
1721 |
user_lastpage varchar2(600) DEFAULT '' , |
|
1722 |
user_last_confirm_key varchar2(10) DEFAULT '' , |
|
1723 |
user_last_search number(11) DEFAULT '0' NOT NULL, |
|
1724 |
user_warnings number(4) DEFAULT '0' NOT NULL, |
|
1725 |
user_last_warning number(11) DEFAULT '0' NOT NULL, |
|
1726 |
user_login_attempts number(4) DEFAULT '0' NOT NULL, |
|
1727 |
user_inactive_reason number(2) DEFAULT '0' NOT NULL, |
|
1728 |
user_inactive_time number(11) DEFAULT '0' NOT NULL, |
|
1729 |
user_posts number(8) DEFAULT '0' NOT NULL, |
|
1730 |
user_lang varchar2(30) DEFAULT '' , |
|
1731 |
user_timezone number(5, 2) DEFAULT '0' NOT NULL, |
|
1732 |
user_dst number(1) DEFAULT '0' NOT NULL, |
|
1733 |
user_dateformat varchar2(90) DEFAULT 'd M Y H:i' NOT NULL, |
|
1734 |
user_style number(4) DEFAULT '0' NOT NULL, |
|
1735 |
user_rank number(8) DEFAULT '0' NOT NULL, |
|
1736 |
user_colour varchar2(6) DEFAULT '' , |
|
1737 |
user_new_privmsg number(4) DEFAULT '0' NOT NULL, |
|
1738 |
user_unread_privmsg number(4) DEFAULT '0' NOT NULL, |
|
1739 |
user_last_privmsg number(11) DEFAULT '0' NOT NULL, |
|
1740 |
user_message_rules number(1) DEFAULT '0' NOT NULL, |
|
1741 |
user_full_folder number(11) DEFAULT '-3' NOT NULL, |
|
1742 |
user_emailtime number(11) DEFAULT '0' NOT NULL, |
|
1743 |
user_topic_show_days number(4) DEFAULT '0' NOT NULL, |
|
1744 |
user_topic_sortby_type varchar2(1) DEFAULT 't' NOT NULL, |
|
1745 |
user_topic_sortby_dir varchar2(1) DEFAULT 'd' NOT NULL, |
|
1746 |
user_post_show_days number(4) DEFAULT '0' NOT NULL, |
|
1747 |
user_post_sortby_type varchar2(1) DEFAULT 't' NOT NULL, |
|
1748 |
user_post_sortby_dir varchar2(1) DEFAULT 'a' NOT NULL, |
|
1749 |
user_notify number(1) DEFAULT '0' NOT NULL, |
|
1750 |
user_notify_pm number(1) DEFAULT '1' NOT NULL, |
|
1751 |
user_notify_type number(4) DEFAULT '0' NOT NULL, |
|
1752 |
user_allow_pm number(1) DEFAULT '1' NOT NULL, |
|
1753 |
user_allow_viewonline number(1) DEFAULT '1' NOT NULL, |
|
1754 |
user_allow_viewemail number(1) DEFAULT '1' NOT NULL, |
|
1755 |
user_allow_massemail number(1) DEFAULT '1' NOT NULL, |
|
1756 |
user_options number(11) DEFAULT '895' NOT NULL, |
|
1757 |
user_avatar varchar2(255) DEFAULT '' , |
|
1758 |
user_avatar_type number(2) DEFAULT '0' NOT NULL, |
|
1759 |
user_avatar_width number(4) DEFAULT '0' NOT NULL, |
|
1760 |
user_avatar_height number(4) DEFAULT '0' NOT NULL, |
|
1761 |
user_sig clob DEFAULT '' , |
|
1762 |
user_sig_bbcode_uid varchar2(8) DEFAULT '' , |
|
1763 |
user_sig_bbcode_bitfield varchar2(255) DEFAULT '' , |
|
1764 |
user_from varchar2(300) DEFAULT '' , |
|
1765 |
user_icq varchar2(15) DEFAULT '' , |
|
1766 |
user_aim varchar2(765) DEFAULT '' , |
|
1767 |
user_yim varchar2(765) DEFAULT '' , |
|
1768 |
user_msnm varchar2(765) DEFAULT '' , |
|
1769 |
user_jabber varchar2(765) DEFAULT '' , |
|
1770 |
user_website varchar2(600) DEFAULT '' , |
|
1771 |
user_occ clob DEFAULT '' , |
|
1772 |
user_interests clob DEFAULT '' , |
|
1773 |
user_actkey varchar2(32) DEFAULT '' , |
|
1774 |
user_newpasswd varchar2(120) DEFAULT '' , |
|
1775 |
user_form_salt varchar2(96) DEFAULT '' , |
|
1776 |
CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id), |
|
1777 |
CONSTRAINT u_phpbb_username_clean UNIQUE (username_clean) |
|
1778 |
)
|
|
1779 |
/
|
|
1780 |
||
1781 |
CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday) |
|
1782 |
/
|
|
1783 |
CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash) |
|
1784 |
/
|
|
1785 |
CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type) |
|
1786 |
/
|
|
1787 |
||
1788 |
CREATE SEQUENCE phpbb_users_seq |
|
1789 |
/
|
|
1790 |
||
1791 |
CREATE OR REPLACE TRIGGER t_phpbb_users |
|
1792 |
BEFORE INSERT ON phpbb_users |
|
1793 |
FOR EACH ROW WHEN ( |
|
1794 |
new.user_id IS NULL OR new.user_id = 0 |
|
1795 |
)
|
|
1796 |
BEGIN
|
|
1797 |
SELECT phpbb_users_seq.nextval |
|
1798 |
INTO :new.user_id |
|
1799 |
FROM dual; |
|
1800 |
END; |
|
1801 |
/
|
|
1802 |
||
1803 |
||
1804 |
/*
|
|
1805 |
Table: 'phpbb_warnings'
|
|
1806 |
*/
|
|
1807 |
CREATE TABLE phpbb_warnings ( |
|
1808 |
warning_id number(8) NOT NULL, |
|
1809 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1810 |
post_id number(8) DEFAULT '0' NOT NULL, |
|
1811 |
log_id number(8) DEFAULT '0' NOT NULL, |
|
1812 |
warning_time number(11) DEFAULT '0' NOT NULL, |
|
1813 |
CONSTRAINT pk_phpbb_warnings PRIMARY KEY (warning_id) |
|
1814 |
)
|
|
1815 |
/
|
|
1816 |
||
1817 |
||
1818 |
CREATE SEQUENCE phpbb_warnings_seq |
|
1819 |
/
|
|
1820 |
||
1821 |
CREATE OR REPLACE TRIGGER t_phpbb_warnings |
|
1822 |
BEFORE INSERT ON phpbb_warnings |
|
1823 |
FOR EACH ROW WHEN ( |
|
1824 |
new.warning_id IS NULL OR new.warning_id = 0 |
|
1825 |
)
|
|
1826 |
BEGIN
|
|
1827 |
SELECT phpbb_warnings_seq.nextval |
|
1828 |
INTO :new.warning_id |
|
1829 |
FROM dual; |
|
1830 |
END; |
|
1831 |
/
|
|
1832 |
||
1833 |
||
1834 |
/*
|
|
1835 |
Table: 'phpbb_words'
|
|
1836 |
*/
|
|
1837 |
CREATE TABLE phpbb_words ( |
|
1838 |
word_id number(8) NOT NULL, |
|
1839 |
word varchar2(765) DEFAULT '' , |
|
1840 |
replacement varchar2(765) DEFAULT '' , |
|
1841 |
CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id) |
|
1842 |
)
|
|
1843 |
/
|
|
1844 |
||
1845 |
||
1846 |
CREATE SEQUENCE phpbb_words_seq |
|
1847 |
/
|
|
1848 |
||
1849 |
CREATE OR REPLACE TRIGGER t_phpbb_words |
|
1850 |
BEFORE INSERT ON phpbb_words |
|
1851 |
FOR EACH ROW WHEN ( |
|
1852 |
new.word_id IS NULL OR new.word_id = 0 |
|
1853 |
)
|
|
1854 |
BEGIN
|
|
1855 |
SELECT phpbb_words_seq.nextval |
|
1856 |
INTO :new.word_id |
|
1857 |
FROM dual; |
|
1858 |
END; |
|
1859 |
/
|
|
1860 |
||
1861 |
||
1862 |
/*
|
|
1863 |
Table: 'phpbb_zebra'
|
|
1864 |
*/
|
|
1865 |
CREATE TABLE phpbb_zebra ( |
|
1866 |
user_id number(8) DEFAULT '0' NOT NULL, |
|
1867 |
zebra_id number(8) DEFAULT '0' NOT NULL, |
|
1868 |
friend number(1) DEFAULT '0' NOT NULL, |
|
1869 |
foe number(1) DEFAULT '0' NOT NULL, |
|
1870 |
CONSTRAINT pk_phpbb_zebra PRIMARY KEY (user_id, zebra_id) |
|
1871 |
)
|
|
1872 |
/
|
|
1873 |
||
1874 |