forked from phpbb/phpbb
-
Notifications
You must be signed in to change notification settings - Fork 1
/
oracle_schema.sql
1969 lines (1726 loc) · 50.1 KB
/
oracle_schema.sql
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
* DO NOT EDIT THIS FILE, IT IS GENERATED
*
* To change the contents of this file, edit
* phpBB/develop/create_schema_files.php and
* run it.
*/
/*
This first section is optional, however its probably the best method
of running phpBB on Oracle. If you already have a tablespace and user created
for phpBB you can leave this section commented out!
The first set of statements create a phpBB tablespace and a phpBB user,
make sure you change the password of the phpBB user before you run this script!!
*/
/*
CREATE TABLESPACE "PHPBB"
LOGGING
DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora'
SIZE 10M
AUTOEXTEND ON NEXT 10M
MAXSIZE 100M;
CREATE USER "PHPBB"
PROFILE "DEFAULT"
IDENTIFIED BY "phpbb_password"
DEFAULT TABLESPACE "PHPBB"
QUOTA UNLIMITED ON "PHPBB"
ACCOUNT UNLOCK;
GRANT ANALYZE ANY TO "PHPBB";
GRANT CREATE SEQUENCE TO "PHPBB";
GRANT CREATE SESSION TO "PHPBB";
GRANT CREATE TABLE TO "PHPBB";
GRANT CREATE TRIGGER TO "PHPBB";
GRANT CREATE VIEW TO "PHPBB";
GRANT "CONNECT" TO "PHPBB";
COMMIT;
DISCONNECT;
CONNECT phpbb/phpbb_password;
*/
/*
Table: 'phpbb_attachments'
*/
CREATE TABLE phpbb_attachments (
attach_id number(8) NOT NULL,
post_msg_id number(8) DEFAULT '0' NOT NULL,
topic_id number(8) DEFAULT '0' NOT NULL,
in_message number(1) DEFAULT '0' NOT NULL,
poster_id number(8) DEFAULT '0' NOT NULL,
is_orphan number(1) DEFAULT '1' NOT NULL,
physical_filename varchar2(255) DEFAULT '' ,
real_filename varchar2(255) DEFAULT '' ,
download_count number(8) DEFAULT '0' NOT NULL,
attach_comment clob DEFAULT '' ,
extension varchar2(100) DEFAULT '' ,
mimetype varchar2(100) DEFAULT '' ,
filesize number(20) DEFAULT '0' NOT NULL,
filetime number(11) DEFAULT '0' NOT NULL,
thumbnail number(1) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_attachments PRIMARY KEY (attach_id)
)
/
CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime)
/
CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id)
/
CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id)
/
CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id)
/
CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan)
/
CREATE SEQUENCE phpbb_attachments_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_attachments
BEFORE INSERT ON phpbb_attachments
FOR EACH ROW WHEN (
new.attach_id IS NULL OR new.attach_id = 0
)
BEGIN
SELECT phpbb_attachments_seq.nextval
INTO :new.attach_id
FROM dual;
END;
/
/*
Table: 'phpbb_acl_groups'
*/
CREATE TABLE phpbb_acl_groups (
group_id number(8) DEFAULT '0' NOT NULL,
forum_id number(8) DEFAULT '0' NOT NULL,
auth_option_id number(8) DEFAULT '0' NOT NULL,
auth_role_id number(8) DEFAULT '0' NOT NULL,
auth_setting number(2) DEFAULT '0' NOT NULL
)
/
CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id)
/
CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id)
/
CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id)
/
/*
Table: 'phpbb_acl_options'
*/
CREATE TABLE phpbb_acl_options (
auth_option_id number(8) NOT NULL,
auth_option varchar2(50) DEFAULT '' ,
is_global number(1) DEFAULT '0' NOT NULL,
is_local number(1) DEFAULT '0' NOT NULL,
founder_only number(1) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_acl_options PRIMARY KEY (auth_option_id),
CONSTRAINT u_phpbb_auth_option UNIQUE (auth_option)
)
/
CREATE SEQUENCE phpbb_acl_options_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_acl_options
BEFORE INSERT ON phpbb_acl_options
FOR EACH ROW WHEN (
new.auth_option_id IS NULL OR new.auth_option_id = 0
)
BEGIN
SELECT phpbb_acl_options_seq.nextval
INTO :new.auth_option_id
FROM dual;
END;
/
/*
Table: 'phpbb_acl_roles'
*/
CREATE TABLE phpbb_acl_roles (
role_id number(8) NOT NULL,
role_name varchar2(765) DEFAULT '' ,
role_description clob DEFAULT '' ,
role_type varchar2(10) DEFAULT '' ,
role_order number(4) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_acl_roles PRIMARY KEY (role_id)
)
/
CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type)
/
CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order)
/
CREATE SEQUENCE phpbb_acl_roles_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_acl_roles
BEFORE INSERT ON phpbb_acl_roles
FOR EACH ROW WHEN (
new.role_id IS NULL OR new.role_id = 0
)
BEGIN
SELECT phpbb_acl_roles_seq.nextval
INTO :new.role_id
FROM dual;
END;
/
/*
Table: 'phpbb_acl_roles_data'
*/
CREATE TABLE phpbb_acl_roles_data (
role_id number(8) DEFAULT '0' NOT NULL,
auth_option_id number(8) DEFAULT '0' NOT NULL,
auth_setting number(2) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_acl_roles_data PRIMARY KEY (role_id, auth_option_id)
)
/
CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data (auth_option_id)
/
/*
Table: 'phpbb_acl_users'
*/
CREATE TABLE phpbb_acl_users (
user_id number(8) DEFAULT '0' NOT NULL,
forum_id number(8) DEFAULT '0' NOT NULL,
auth_option_id number(8) DEFAULT '0' NOT NULL,
auth_role_id number(8) DEFAULT '0' NOT NULL,
auth_setting number(2) DEFAULT '0' NOT NULL
)
/
CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id)
/
CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id)
/
CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id)
/
/*
Table: 'phpbb_banlist'
*/
CREATE TABLE phpbb_banlist (
ban_id number(8) NOT NULL,
ban_userid number(8) DEFAULT '0' NOT NULL,
ban_ip varchar2(40) DEFAULT '' ,
ban_email varchar2(300) DEFAULT '' ,
ban_start number(11) DEFAULT '0' NOT NULL,
ban_end number(11) DEFAULT '0' NOT NULL,
ban_exclude number(1) DEFAULT '0' NOT NULL,
ban_reason varchar2(765) DEFAULT '' ,
ban_give_reason varchar2(765) DEFAULT '' ,
CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id)
)
/
CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end)
/
CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude)
/
CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude)
/
CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude)
/
CREATE SEQUENCE phpbb_banlist_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_banlist
BEFORE INSERT ON phpbb_banlist
FOR EACH ROW WHEN (
new.ban_id IS NULL OR new.ban_id = 0
)
BEGIN
SELECT phpbb_banlist_seq.nextval
INTO :new.ban_id
FROM dual;
END;
/
/*
Table: 'phpbb_bbcodes'
*/
CREATE TABLE phpbb_bbcodes (
bbcode_id number(4) DEFAULT '0' NOT NULL,
bbcode_tag varchar2(16) DEFAULT '' ,
bbcode_helpline varchar2(765) DEFAULT '' ,
display_on_posting number(1) DEFAULT '0' NOT NULL,
bbcode_match clob DEFAULT '' ,
bbcode_tpl clob DEFAULT '' ,
first_pass_match clob DEFAULT '' ,
first_pass_replace clob DEFAULT '' ,
second_pass_match clob DEFAULT '' ,
second_pass_replace clob DEFAULT '' ,
CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id)
)
/
CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting)
/
/*
Table: 'phpbb_bookmarks'
*/
CREATE TABLE phpbb_bookmarks (
topic_id number(8) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_bookmarks PRIMARY KEY (topic_id, user_id)
)
/
/*
Table: 'phpbb_bots'
*/
CREATE TABLE phpbb_bots (
bot_id number(8) NOT NULL,
bot_active number(1) DEFAULT '1' NOT NULL,
bot_name varchar2(765) DEFAULT '' ,
user_id number(8) DEFAULT '0' NOT NULL,
bot_agent varchar2(255) DEFAULT '' ,
bot_ip varchar2(255) DEFAULT '' ,
CONSTRAINT pk_phpbb_bots PRIMARY KEY (bot_id)
)
/
CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active)
/
CREATE SEQUENCE phpbb_bots_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_bots
BEFORE INSERT ON phpbb_bots
FOR EACH ROW WHEN (
new.bot_id IS NULL OR new.bot_id = 0
)
BEGIN
SELECT phpbb_bots_seq.nextval
INTO :new.bot_id
FROM dual;
END;
/
/*
Table: 'phpbb_config'
*/
CREATE TABLE phpbb_config (
config_name varchar2(255) DEFAULT '' ,
config_value varchar2(765) DEFAULT '' ,
is_dynamic number(1) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name)
)
/
CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic)
/
/*
Table: 'phpbb_config_text'
*/
CREATE TABLE phpbb_config_text (
config_name varchar2(255) DEFAULT '' ,
config_value clob DEFAULT '' ,
CONSTRAINT pk_phpbb_config_text PRIMARY KEY (config_name)
)
/
/*
Table: 'phpbb_confirm'
*/
CREATE TABLE phpbb_confirm (
confirm_id char(32) DEFAULT '' ,
session_id char(32) DEFAULT '' ,
confirm_type number(3) DEFAULT '0' NOT NULL,
code varchar2(8) DEFAULT '' ,
seed number(10) DEFAULT '0' NOT NULL,
attempts number(8) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id)
)
/
CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type)
/
/*
Table: 'phpbb_disallow'
*/
CREATE TABLE phpbb_disallow (
disallow_id number(8) NOT NULL,
disallow_username varchar2(765) DEFAULT '' ,
CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id)
)
/
CREATE SEQUENCE phpbb_disallow_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_disallow
BEFORE INSERT ON phpbb_disallow
FOR EACH ROW WHEN (
new.disallow_id IS NULL OR new.disallow_id = 0
)
BEGIN
SELECT phpbb_disallow_seq.nextval
INTO :new.disallow_id
FROM dual;
END;
/
/*
Table: 'phpbb_drafts'
*/
CREATE TABLE phpbb_drafts (
draft_id number(8) NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
topic_id number(8) DEFAULT '0' NOT NULL,
forum_id number(8) DEFAULT '0' NOT NULL,
save_time number(11) DEFAULT '0' NOT NULL,
draft_subject varchar2(765) DEFAULT '' ,
draft_message clob DEFAULT '' ,
CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id)
)
/
CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time)
/
CREATE SEQUENCE phpbb_drafts_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_drafts
BEFORE INSERT ON phpbb_drafts
FOR EACH ROW WHEN (
new.draft_id IS NULL OR new.draft_id = 0
)
BEGIN
SELECT phpbb_drafts_seq.nextval
INTO :new.draft_id
FROM dual;
END;
/
/*
Table: 'phpbb_ext'
*/
CREATE TABLE phpbb_ext (
ext_name varchar2(255) DEFAULT '' ,
ext_active number(1) DEFAULT '0' NOT NULL,
ext_state clob DEFAULT '' ,
CONSTRAINT u_phpbb_ext_name UNIQUE (ext_name)
)
/
/*
Table: 'phpbb_extensions'
*/
CREATE TABLE phpbb_extensions (
extension_id number(8) NOT NULL,
group_id number(8) DEFAULT '0' NOT NULL,
extension varchar2(100) DEFAULT '' ,
CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id)
)
/
CREATE SEQUENCE phpbb_extensions_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_extensions
BEFORE INSERT ON phpbb_extensions
FOR EACH ROW WHEN (
new.extension_id IS NULL OR new.extension_id = 0
)
BEGIN
SELECT phpbb_extensions_seq.nextval
INTO :new.extension_id
FROM dual;
END;
/
/*
Table: 'phpbb_extension_groups'
*/
CREATE TABLE phpbb_extension_groups (
group_id number(8) NOT NULL,
group_name varchar2(765) DEFAULT '' ,
cat_id number(2) DEFAULT '0' NOT NULL,
allow_group number(1) DEFAULT '0' NOT NULL,
download_mode number(1) DEFAULT '1' NOT NULL,
upload_icon varchar2(255) DEFAULT '' ,
max_filesize number(20) DEFAULT '0' NOT NULL,
allowed_forums clob DEFAULT '' ,
allow_in_pm number(1) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_extension_groups PRIMARY KEY (group_id)
)
/
CREATE SEQUENCE phpbb_extension_groups_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_extension_groups
BEFORE INSERT ON phpbb_extension_groups
FOR EACH ROW WHEN (
new.group_id IS NULL OR new.group_id = 0
)
BEGIN
SELECT phpbb_extension_groups_seq.nextval
INTO :new.group_id
FROM dual;
END;
/
/*
Table: 'phpbb_forums'
*/
CREATE TABLE phpbb_forums (
forum_id number(8) NOT NULL,
parent_id number(8) DEFAULT '0' NOT NULL,
left_id number(8) DEFAULT '0' NOT NULL,
right_id number(8) DEFAULT '0' NOT NULL,
forum_parents clob DEFAULT '' ,
forum_name varchar2(765) DEFAULT '' ,
forum_desc clob DEFAULT '' ,
forum_desc_bitfield varchar2(255) DEFAULT '' ,
forum_desc_options number(11) DEFAULT '7' NOT NULL,
forum_desc_uid varchar2(8) DEFAULT '' ,
forum_link varchar2(765) DEFAULT '' ,
forum_password varchar2(255) DEFAULT '' ,
forum_style number(8) DEFAULT '0' NOT NULL,
forum_image varchar2(255) DEFAULT '' ,
forum_rules clob DEFAULT '' ,
forum_rules_link varchar2(765) DEFAULT '' ,
forum_rules_bitfield varchar2(255) DEFAULT '' ,
forum_rules_options number(11) DEFAULT '7' NOT NULL,
forum_rules_uid varchar2(8) DEFAULT '' ,
forum_topics_per_page number(4) DEFAULT '0' NOT NULL,
forum_type number(4) DEFAULT '0' NOT NULL,
forum_status number(4) DEFAULT '0' NOT NULL,
forum_posts_approved number(8) DEFAULT '0' NOT NULL,
forum_posts_unapproved number(8) DEFAULT '0' NOT NULL,
forum_posts_softdeleted number(8) DEFAULT '0' NOT NULL,
forum_topics_approved number(8) DEFAULT '0' NOT NULL,
forum_topics_unapproved number(8) DEFAULT '0' NOT NULL,
forum_topics_softdeleted number(8) DEFAULT '0' NOT NULL,
forum_last_post_id number(8) DEFAULT '0' NOT NULL,
forum_last_poster_id number(8) DEFAULT '0' NOT NULL,
forum_last_post_subject varchar2(765) DEFAULT '' ,
forum_last_post_time number(11) DEFAULT '0' NOT NULL,
forum_last_poster_name varchar2(765) DEFAULT '' ,
forum_last_poster_colour varchar2(6) DEFAULT '' ,
forum_flags number(4) DEFAULT '32' NOT NULL,
forum_options number(20) DEFAULT '0' NOT NULL,
display_subforum_list number(1) DEFAULT '1' NOT NULL,
display_on_index number(1) DEFAULT '1' NOT NULL,
enable_indexing number(1) DEFAULT '1' NOT NULL,
enable_icons number(1) DEFAULT '1' NOT NULL,
enable_prune number(1) DEFAULT '0' NOT NULL,
prune_next number(11) DEFAULT '0' NOT NULL,
prune_days number(8) DEFAULT '0' NOT NULL,
prune_viewed number(8) DEFAULT '0' NOT NULL,
prune_freq number(8) DEFAULT '0' NOT NULL,
enable_shadow_prune number(1) DEFAULT '0' NOT NULL,
prune_shadow_next number(11) DEFAULT '0' NOT NULL,
prune_shadow_days number(8) DEFAULT '0' NOT NULL,
prune_shadow_freq number(8) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_forums PRIMARY KEY (forum_id)
)
/
CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id)
/
CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id)
/
CREATE SEQUENCE phpbb_forums_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_forums
BEFORE INSERT ON phpbb_forums
FOR EACH ROW WHEN (
new.forum_id IS NULL OR new.forum_id = 0
)
BEGIN
SELECT phpbb_forums_seq.nextval
INTO :new.forum_id
FROM dual;
END;
/
/*
Table: 'phpbb_forums_access'
*/
CREATE TABLE phpbb_forums_access (
forum_id number(8) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
session_id char(32) DEFAULT '' ,
CONSTRAINT pk_phpbb_forums_access PRIMARY KEY (forum_id, user_id, session_id)
)
/
/*
Table: 'phpbb_forums_track'
*/
CREATE TABLE phpbb_forums_track (
user_id number(8) DEFAULT '0' NOT NULL,
forum_id number(8) DEFAULT '0' NOT NULL,
mark_time number(11) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_forums_track PRIMARY KEY (user_id, forum_id)
)
/
/*
Table: 'phpbb_forums_watch'
*/
CREATE TABLE phpbb_forums_watch (
forum_id number(8) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
notify_status number(1) DEFAULT '0' NOT NULL
)
/
CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id)
/
CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id)
/
CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status)
/
/*
Table: 'phpbb_groups'
*/
CREATE TABLE phpbb_groups (
group_id number(8) NOT NULL,
group_type number(4) DEFAULT '1' NOT NULL,
group_founder_manage number(1) DEFAULT '0' NOT NULL,
group_skip_auth number(1) DEFAULT '0' NOT NULL,
group_name varchar2(255) DEFAULT '' ,
group_desc clob DEFAULT '' ,
group_desc_bitfield varchar2(255) DEFAULT '' ,
group_desc_options number(11) DEFAULT '7' NOT NULL,
group_desc_uid varchar2(8) DEFAULT '' ,
group_display number(1) DEFAULT '0' NOT NULL,
group_avatar varchar2(255) DEFAULT '' ,
group_avatar_type varchar2(255) DEFAULT '' ,
group_avatar_width number(4) DEFAULT '0' NOT NULL,
group_avatar_height number(4) DEFAULT '0' NOT NULL,
group_rank number(8) DEFAULT '0' NOT NULL,
group_colour varchar2(6) DEFAULT '' ,
group_sig_chars number(8) DEFAULT '0' NOT NULL,
group_receive_pm number(1) DEFAULT '0' NOT NULL,
group_message_limit number(8) DEFAULT '0' NOT NULL,
group_max_recipients number(8) DEFAULT '0' NOT NULL,
group_legend number(8) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)
)
/
CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups (group_legend, group_name)
/
CREATE SEQUENCE phpbb_groups_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_groups
BEFORE INSERT ON phpbb_groups
FOR EACH ROW WHEN (
new.group_id IS NULL OR new.group_id = 0
)
BEGIN
SELECT phpbb_groups_seq.nextval
INTO :new.group_id
FROM dual;
END;
/
/*
Table: 'phpbb_icons'
*/
CREATE TABLE phpbb_icons (
icons_id number(8) NOT NULL,
icons_url varchar2(255) DEFAULT '' ,
icons_width number(4) DEFAULT '0' NOT NULL,
icons_height number(4) DEFAULT '0' NOT NULL,
icons_order number(8) DEFAULT '0' NOT NULL,
display_on_posting number(1) DEFAULT '1' NOT NULL,
CONSTRAINT pk_phpbb_icons PRIMARY KEY (icons_id)
)
/
CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting)
/
CREATE SEQUENCE phpbb_icons_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_icons
BEFORE INSERT ON phpbb_icons
FOR EACH ROW WHEN (
new.icons_id IS NULL OR new.icons_id = 0
)
BEGIN
SELECT phpbb_icons_seq.nextval
INTO :new.icons_id
FROM dual;
END;
/
/*
Table: 'phpbb_lang'
*/
CREATE TABLE phpbb_lang (
lang_id number(4) NOT NULL,
lang_iso varchar2(30) DEFAULT '' ,
lang_dir varchar2(30) DEFAULT '' ,
lang_english_name varchar2(300) DEFAULT '' ,
lang_local_name varchar2(765) DEFAULT '' ,
lang_author varchar2(765) DEFAULT '' ,
CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id)
)
/
CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso)
/
CREATE SEQUENCE phpbb_lang_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_lang
BEFORE INSERT ON phpbb_lang
FOR EACH ROW WHEN (
new.lang_id IS NULL OR new.lang_id = 0
)
BEGIN
SELECT phpbb_lang_seq.nextval
INTO :new.lang_id
FROM dual;
END;
/
/*
Table: 'phpbb_log'
*/
CREATE TABLE phpbb_log (
log_id number(8) NOT NULL,
log_type number(4) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
forum_id number(8) DEFAULT '0' NOT NULL,
topic_id number(8) DEFAULT '0' NOT NULL,
reportee_id number(8) DEFAULT '0' NOT NULL,
log_ip varchar2(40) DEFAULT '' ,
log_time number(11) DEFAULT '0' NOT NULL,
log_operation clob DEFAULT '' ,
log_data clob DEFAULT '' ,
CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id)
)
/
CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type)
/
CREATE INDEX phpbb_log_log_time ON phpbb_log (log_time)
/
CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id)
/
CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id)
/
CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id)
/
CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id)
/
CREATE SEQUENCE phpbb_log_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_log
BEFORE INSERT ON phpbb_log
FOR EACH ROW WHEN (
new.log_id IS NULL OR new.log_id = 0
)
BEGIN
SELECT phpbb_log_seq.nextval
INTO :new.log_id
FROM dual;
END;
/
/*
Table: 'phpbb_login_attempts'
*/
CREATE TABLE phpbb_login_attempts (
attempt_ip varchar2(40) DEFAULT '' ,
attempt_browser varchar2(150) DEFAULT '' ,
attempt_forwarded_for varchar2(255) DEFAULT '' ,
attempt_time number(11) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
username varchar2(765) DEFAULT '0' NOT NULL,
username_clean varchar2(255) DEFAULT '0' NOT NULL
)
/
CREATE INDEX phpbb_login_attempts_att_ip ON phpbb_login_attempts (attempt_ip, attempt_time)
/
CREATE INDEX phpbb_login_attempts_att_for ON phpbb_login_attempts (attempt_forwarded_for, attempt_time)
/
CREATE INDEX phpbb_login_attempts_att_time ON phpbb_login_attempts (attempt_time)
/
CREATE INDEX phpbb_login_attempts_user_id ON phpbb_login_attempts (user_id)
/
/*
Table: 'phpbb_moderator_cache'
*/
CREATE TABLE phpbb_moderator_cache (
forum_id number(8) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
username varchar2(765) DEFAULT '' ,
group_id number(8) DEFAULT '0' NOT NULL,
group_name varchar2(765) DEFAULT '' ,
display_on_index number(1) DEFAULT '1' NOT NULL
)
/
CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index)
/
CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id)
/
/*
Table: 'phpbb_migrations'
*/
CREATE TABLE phpbb_migrations (
migration_name varchar2(255) DEFAULT '' ,
migration_depends_on clob DEFAULT '' ,
migration_schema_done number(1) DEFAULT '0' NOT NULL,
migration_data_done number(1) DEFAULT '0' NOT NULL,
migration_data_state clob DEFAULT '' ,
migration_start_time number(11) DEFAULT '0' NOT NULL,
migration_end_time number(11) DEFAULT '0' NOT NULL,
CONSTRAINT pk_phpbb_migrations PRIMARY KEY (migration_name)
)
/
/*
Table: 'phpbb_modules'
*/
CREATE TABLE phpbb_modules (
module_id number(8) NOT NULL,
module_enabled number(1) DEFAULT '1' NOT NULL,
module_display number(1) DEFAULT '1' NOT NULL,
module_basename varchar2(255) DEFAULT '' ,
module_class varchar2(10) DEFAULT '' ,
parent_id number(8) DEFAULT '0' NOT NULL,
left_id number(8) DEFAULT '0' NOT NULL,
right_id number(8) DEFAULT '0' NOT NULL,
module_langname varchar2(255) DEFAULT '' ,
module_mode varchar2(255) DEFAULT '' ,
module_auth varchar2(255) DEFAULT '' ,
CONSTRAINT pk_phpbb_modules PRIMARY KEY (module_id)
)
/
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id)
/
CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled)
/
CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id)
/
CREATE SEQUENCE phpbb_modules_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_modules
BEFORE INSERT ON phpbb_modules
FOR EACH ROW WHEN (
new.module_id IS NULL OR new.module_id = 0
)
BEGIN
SELECT phpbb_modules_seq.nextval
INTO :new.module_id
FROM dual;
END;
/
/*
Table: 'phpbb_notification_types'
*/
CREATE TABLE phpbb_notification_types (
notification_type_id number(4) NOT NULL,
notification_type_name varchar2(255) DEFAULT '' ,
notification_type_enabled number(1) DEFAULT '1' NOT NULL,
CONSTRAINT pk_phpbb_notification_types PRIMARY KEY (notification_type_id),
CONSTRAINT u_phpbb_type UNIQUE (notification_type_name)
)
/
CREATE SEQUENCE phpbb_notification_types_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_notification_types
BEFORE INSERT ON phpbb_notification_types
FOR EACH ROW WHEN (
new.notification_type_id IS NULL OR new.notification_type_id = 0
)
BEGIN
SELECT phpbb_notification_types_seq.nextval
INTO :new.notification_type_id
FROM dual;
END;
/
/*
Table: 'phpbb_notifications'
*/
CREATE TABLE phpbb_notifications (
notification_id number(10) NOT NULL,
notification_type_id number(4) DEFAULT '0' NOT NULL,
item_id number(8) DEFAULT '0' NOT NULL,
item_parent_id number(8) DEFAULT '0' NOT NULL,
user_id number(8) DEFAULT '0' NOT NULL,
notification_read number(1) DEFAULT '0' NOT NULL,
notification_time number(11) DEFAULT '1' NOT NULL,
notification_data clob DEFAULT '' ,
CONSTRAINT pk_phpbb_notifications PRIMARY KEY (notification_id)
)
/
CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (notification_type_id, item_id)
/
CREATE INDEX phpbb_notifications_user ON phpbb_notifications (user_id, notification_read)
/
CREATE SEQUENCE phpbb_notifications_seq
/
CREATE OR REPLACE TRIGGER t_phpbb_notifications
BEFORE INSERT ON phpbb_notifications
FOR EACH ROW WHEN (
new.notification_id IS NULL OR new.notification_id = 0
)
BEGIN
SELECT phpbb_notifications_seq.nextval
INTO :new.notification_id
FROM dual;
END;
/
/*
Table: 'phpbb_oauth_accounts'
*/
CREATE TABLE phpbb_oauth_accounts (
user_id number(8) DEFAULT '0' NOT NULL,
provider varchar2(255) DEFAULT '' ,
oauth_provider_id clob DEFAULT '' ,
CONSTRAINT pk_phpbb_oauth_accounts PRIMARY KEY (user_id, provider)
)
/
/*
Table: 'phpbb_oauth_tokens'
*/
CREATE TABLE phpbb_oauth_tokens (
user_id number(8) DEFAULT '0' NOT NULL,
session_id char(32) DEFAULT '' ,
provider varchar2(255) DEFAULT '' ,
oauth_token clob DEFAULT ''
)
/
CREATE INDEX phpbb_oauth_tokens_user_id ON phpbb_oauth_tokens (user_id)
/
CREATE INDEX phpbb_oauth_tokens_provider ON phpbb_oauth_tokens (provider)
/
/*
Table: 'phpbb_poll_options'
*/
CREATE TABLE phpbb_poll_options (
poll_option_id number(4) DEFAULT '0' NOT NULL,
topic_id number(8) DEFAULT '0' NOT NULL,
poll_option_text clob DEFAULT '' ,
poll_option_total number(8) DEFAULT '0' NOT NULL
)
/
CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id)
/
CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id)
/
/*
Table: 'phpbb_poll_votes'
*/
CREATE TABLE phpbb_poll_votes (
topic_id number(8) DEFAULT '0' NOT NULL,
poll_option_id number(4) DEFAULT '0' NOT NULL,
vote_user_id number(8) DEFAULT '0' NOT NULL,
vote_user_ip varchar2(40) DEFAULT ''
)
/
CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id)
/
CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id)
/