Verzeichnisstruktur phpBB-3.0.0
- Veröffentlicht
- 12.12.2007
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
oracle_schema.sql
0001 /*
0002
0003 $Id$
0004
0005 */
0006
0007 /*
0008 This first section is optional, however its probably the best method
0009 of running phpBB on Oracle. If you already have a tablespace and user created
0010 for phpBB you can leave this section commented out!
0011
0012 The first set of statements create a phpBB tablespace and a phpBB user,
0013 make sure you change the password of the phpBB user before you run this script!!
0014 */
0015
0016 /*
0017 CREATE TABLESPACE "PHPBB"
0018 LOGGING
0019 DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora'
0020 SIZE 10M
0021 AUTOEXTEND ON NEXT 10M
0022 MAXSIZE 100M;
0023
0024 CREATE USER "PHPBB"
0025 PROFILE "DEFAULT"
0026 IDENTIFIED BY "phpbb_password"
0027 DEFAULT TABLESPACE "PHPBB"
0028 QUOTA UNLIMITED ON "PHPBB"
0029 ACCOUNT UNLOCK;
0030
0031 GRANT ANALYZE ANY TO "PHPBB";
0032 GRANT CREATE SEQUENCE TO "PHPBB";
0033 GRANT CREATE SESSION TO "PHPBB";
0034 GRANT CREATE TABLE TO "PHPBB";
0035 GRANT CREATE TRIGGER TO "PHPBB";
0036 GRANT CREATE VIEW TO "PHPBB";
0037 GRANT "CONNECT" TO "PHPBB";
0038
0039 COMMIT;
0040 DISCONNECT;
0041
0042 CONNECT phpbb/phpbb_password;
0043 */
0044 /*
0045 Table: 'phpbb_attachments'
0046 */
0047 CREATE TABLE phpbb_attachments (
0048 attach_id number(8) NOT NULL,
0049 post_msg_id number(8) DEFAULT '0' NOT NULL,
0050 topic_id number(8) DEFAULT '0' NOT NULL,
0051 in_message number(1) DEFAULT '0' NOT NULL,
0052 poster_id number(8) DEFAULT '0' NOT NULL,
0053 is_orphan number(1) DEFAULT '1' NOT NULL,
0054 physical_filename varchar2(255) DEFAULT '' ,
0055 real_filename varchar2(255) DEFAULT '' ,
0056 download_count number(8) DEFAULT '0' NOT NULL,
0057 attach_comment clob DEFAULT '' ,
0058 extension varchar2(100) DEFAULT '' ,
0059 mimetype varchar2(100) DEFAULT '' ,
0060 filesize number(20) DEFAULT '0' NOT NULL,
0061 filetime number(11) DEFAULT '0' NOT NULL,
0062 thumbnail number(1) DEFAULT '0' NOT NULL,
0063 CONSTRAINT pk_phpbb_attachments PRIMARY KEY (attach_id)
0064 )
0065 /
0066
0067 CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments (filetime)
0068 /
0069 CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments (post_msg_id)
0070 /
0071 CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments (topic_id)
0072 /
0073 CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments (poster_id)
0074 /
0075 CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments (is_orphan)
0076 /
0077
0078 CREATE SEQUENCE phpbb_attachments_seq
0079 /
0080
0081 CREATE OR REPLACE TRIGGER t_phpbb_attachments
0082 BEFORE INSERT ON phpbb_attachments
0083 FOR EACH ROW WHEN (
0084 new.attach_id IS NULL OR new.attach_id = 0
0085 )
0086 BEGIN
0087 SELECT phpbb_attachments_seq.nextval
0088 INTO :new.attach_id
0089 FROM dual;
0090 END;
0091 /
0092
0093
0094 /*
0095 Table: 'phpbb_acl_groups'
0096 */
0097 CREATE TABLE phpbb_acl_groups (
0098 group_id number(8) DEFAULT '0' NOT NULL,
0099 forum_id number(8) DEFAULT '0' NOT NULL,
0100 auth_option_id number(8) DEFAULT '0' NOT NULL,
0101 auth_role_id number(8) DEFAULT '0' NOT NULL,
0102 auth_setting number(2) DEFAULT '0' NOT NULL
0103 )
0104 /
0105
0106 CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id)
0107 /
0108 CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups (auth_option_id)
0109 /
0110 CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups (auth_role_id)
0111 /
0112
0113 /*
0114 Table: 'phpbb_acl_options'
0115 */
0116 CREATE TABLE phpbb_acl_options (
0117 auth_option_id number(8) NOT NULL,
0118 auth_option varchar2(50) DEFAULT '' ,
0119 is_global number(1) DEFAULT '0' NOT NULL,
0120 is_local number(1) DEFAULT '0' NOT NULL,
0121 founder_only number(1) DEFAULT '0' NOT NULL,
0122 CONSTRAINT pk_phpbb_acl_options PRIMARY KEY (auth_option_id)
0123 )
0124 /
0125
0126 CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option)
0127 /
0128
0129 CREATE SEQUENCE phpbb_acl_options_seq
0130 /
0131
0132 CREATE OR REPLACE TRIGGER t_phpbb_acl_options
0133 BEFORE INSERT ON phpbb_acl_options
0134 FOR EACH ROW WHEN (
0135 new.auth_option_id IS NULL OR new.auth_option_id = 0
0136 )
0137 BEGIN
0138 SELECT phpbb_acl_options_seq.nextval
0139 INTO :new.auth_option_id
0140 FROM dual;
0141 END;
0142 /
0143
0144
0145 /*
0146 Table: 'phpbb_acl_roles'
0147 */
0148 CREATE TABLE phpbb_acl_roles (
0149 role_id number(8) NOT NULL,
0150 role_name varchar2(765) DEFAULT '' ,
0151 role_description clob DEFAULT '' ,
0152 role_type varchar2(10) DEFAULT '' ,
0153 role_order number(4) DEFAULT '0' NOT NULL,
0154 CONSTRAINT pk_phpbb_acl_roles PRIMARY KEY (role_id)
0155 )
0156 /
0157
0158 CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles (role_type)
0159 /
0160 CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles (role_order)
0161 /
0162
0163 CREATE SEQUENCE phpbb_acl_roles_seq
0164 /
0165
0166 CREATE OR REPLACE TRIGGER t_phpbb_acl_roles
0167 BEFORE INSERT ON phpbb_acl_roles
0168 FOR EACH ROW WHEN (
0169 new.role_id IS NULL OR new.role_id = 0
0170 )
0171 BEGIN
0172 SELECT phpbb_acl_roles_seq.nextval
0173 INTO :new.role_id
0174 FROM dual;
0175 END;
0176 /
0177
0178
0179 /*
0180 Table: 'phpbb_acl_roles_data'
0181 */
0182 CREATE TABLE phpbb_acl_roles_data (
0183 role_id number(8) DEFAULT '0' NOT NULL,
0184 auth_option_id number(8) DEFAULT '0' NOT NULL,
0185 auth_setting number(2) DEFAULT '0' NOT NULL,
0186 CONSTRAINT pk_phpbb_acl_roles_data PRIMARY KEY (role_id, auth_option_id)
0187 )
0188 /
0189
0190 CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data (auth_option_id)
0191 /
0192
0193 /*
0194 Table: 'phpbb_acl_users'
0195 */
0196 CREATE TABLE phpbb_acl_users (
0197 user_id number(8) DEFAULT '0' NOT NULL,
0198 forum_id number(8) DEFAULT '0' NOT NULL,
0199 auth_option_id number(8) DEFAULT '0' NOT NULL,
0200 auth_role_id number(8) DEFAULT '0' NOT NULL,
0201 auth_setting number(2) DEFAULT '0' NOT NULL
0202 )
0203 /
0204
0205 CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id)
0206 /
0207 CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id)
0208 /
0209 CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users (auth_role_id)
0210 /
0211
0212 /*
0213 Table: 'phpbb_banlist'
0214 */
0215 CREATE TABLE phpbb_banlist (
0216 ban_id number(8) NOT NULL,
0217 ban_userid number(8) DEFAULT '0' NOT NULL,
0218 ban_ip varchar2(40) DEFAULT '' ,
0219 ban_email varchar2(300) DEFAULT '' ,
0220 ban_start number(11) DEFAULT '0' NOT NULL,
0221 ban_end number(11) DEFAULT '0' NOT NULL,
0222 ban_exclude number(1) DEFAULT '0' NOT NULL,
0223 ban_reason varchar2(765) DEFAULT '' ,
0224 ban_give_reason varchar2(765) DEFAULT '' ,
0225 CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id)
0226 )
0227 /
0228
0229 CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end)
0230 /
0231 CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude)
0232 /
0233 CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude)
0234 /
0235 CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude)
0236 /
0237
0238 CREATE SEQUENCE phpbb_banlist_seq
0239 /
0240
0241 CREATE OR REPLACE TRIGGER t_phpbb_banlist
0242 BEFORE INSERT ON phpbb_banlist
0243 FOR EACH ROW WHEN (
0244 new.ban_id IS NULL OR new.ban_id = 0
0245 )
0246 BEGIN
0247 SELECT phpbb_banlist_seq.nextval
0248 INTO :new.ban_id
0249 FROM dual;
0250 END;
0251 /
0252
0253
0254 /*
0255 Table: 'phpbb_bbcodes'
0256 */
0257 CREATE TABLE phpbb_bbcodes (
0258 bbcode_id number(3) DEFAULT '0' NOT NULL,
0259 bbcode_tag varchar2(16) DEFAULT '' ,
0260 bbcode_helpline varchar2(765) DEFAULT '' ,
0261 display_on_posting number(1) DEFAULT '0' NOT NULL,
0262 bbcode_match clob DEFAULT '' ,
0263 bbcode_tpl clob DEFAULT '' ,
0264 first_pass_match clob DEFAULT '' ,
0265 first_pass_replace clob DEFAULT '' ,
0266 second_pass_match clob DEFAULT '' ,
0267 second_pass_replace clob DEFAULT '' ,
0268 CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id)
0269 )
0270 /
0271
0272 CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes (display_on_posting)
0273 /
0274
0275 /*
0276 Table: 'phpbb_bookmarks'
0277 */
0278 CREATE TABLE phpbb_bookmarks (
0279 topic_id number(8) DEFAULT '0' NOT NULL,
0280 user_id number(8) DEFAULT '0' NOT NULL,
0281 CONSTRAINT pk_phpbb_bookmarks PRIMARY KEY (topic_id, user_id)
0282 )
0283 /
0284
0285
0286 /*
0287 Table: 'phpbb_bots'
0288 */
0289 CREATE TABLE phpbb_bots (
0290 bot_id number(8) NOT NULL,
0291 bot_active number(1) DEFAULT '1' NOT NULL,
0292 bot_name varchar2(765) DEFAULT '' ,
0293 user_id number(8) DEFAULT '0' NOT NULL,
0294 bot_agent varchar2(255) DEFAULT '' ,
0295 bot_ip varchar2(255) DEFAULT '' ,
0296 CONSTRAINT pk_phpbb_bots PRIMARY KEY (bot_id)
0297 )
0298 /
0299
0300 CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active)
0301 /
0302
0303 CREATE SEQUENCE phpbb_bots_seq
0304 /
0305
0306 CREATE OR REPLACE TRIGGER t_phpbb_bots
0307 BEFORE INSERT ON phpbb_bots
0308 FOR EACH ROW WHEN (
0309 new.bot_id IS NULL OR new.bot_id = 0
0310 )
0311 BEGIN
0312 SELECT phpbb_bots_seq.nextval
0313 INTO :new.bot_id
0314 FROM dual;
0315 END;
0316 /
0317
0318
0319 /*
0320 Table: 'phpbb_config'
0321 */
0322 CREATE TABLE phpbb_config (
0323 config_name varchar2(255) DEFAULT '' ,
0324 config_value varchar2(765) DEFAULT '' ,
0325 is_dynamic number(1) DEFAULT '0' NOT NULL,
0326 CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name)
0327 )
0328 /
0329
0330 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic)
0331 /
0332
0333 /*
0334 Table: 'phpbb_confirm'
0335 */
0336 CREATE TABLE phpbb_confirm (
0337 confirm_id char(32) DEFAULT '' ,
0338 session_id char(32) DEFAULT '' ,
0339 confirm_type number(3) DEFAULT '0' NOT NULL,
0340 code varchar2(8) DEFAULT '' ,
0341 seed number(10) DEFAULT '0' NOT NULL,
0342 CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id)
0343 )
0344 /
0345
0346 CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type)
0347 /
0348
0349 /*
0350 Table: 'phpbb_disallow'
0351 */
0352 CREATE TABLE phpbb_disallow (
0353 disallow_id number(8) NOT NULL,
0354 disallow_username varchar2(765) DEFAULT '' ,
0355 CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id)
0356 )
0357 /
0358
0359
0360 CREATE SEQUENCE phpbb_disallow_seq
0361 /
0362
0363 CREATE OR REPLACE TRIGGER t_phpbb_disallow
0364 BEFORE INSERT ON phpbb_disallow
0365 FOR EACH ROW WHEN (
0366 new.disallow_id IS NULL OR new.disallow_id = 0
0367 )
0368 BEGIN
0369 SELECT phpbb_disallow_seq.nextval
0370 INTO :new.disallow_id
0371 FROM dual;
0372 END;
0373 /
0374
0375
0376 /*
0377 Table: 'phpbb_drafts'
0378 */
0379 CREATE TABLE phpbb_drafts (
0380 draft_id number(8) NOT NULL,
0381 user_id number(8) DEFAULT '0' NOT NULL,
0382 topic_id number(8) DEFAULT '0' NOT NULL,
0383 forum_id number(8) DEFAULT '0' NOT NULL,
0384 save_time number(11) DEFAULT '0' NOT NULL,
0385 draft_subject varchar2(300) DEFAULT '' ,
0386 draft_message clob DEFAULT '' ,
0387 CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id)
0388 )
0389 /
0390
0391 CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time)
0392 /
0393
0394 CREATE SEQUENCE phpbb_drafts_seq
0395 /
0396
0397 CREATE OR REPLACE TRIGGER t_phpbb_drafts
0398 BEFORE INSERT ON phpbb_drafts
0399 FOR EACH ROW WHEN (
0400 new.draft_id IS NULL OR new.draft_id = 0
0401 )
0402 BEGIN
0403 SELECT phpbb_drafts_seq.nextval
0404 INTO :new.draft_id
0405 FROM dual;
0406 END;
0407 /
0408
0409
0410 /*
0411 Table: 'phpbb_extensions'
0412 */
0413 CREATE TABLE phpbb_extensions (
0414 extension_id number(8) NOT NULL,
0415 group_id number(8) DEFAULT '0' NOT NULL,
0416 extension varchar2(100) DEFAULT '' ,
0417 CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id)
0418 )
0419 /
0420
0421
0422 CREATE SEQUENCE phpbb_extensions_seq
0423 /
0424
0425 CREATE OR REPLACE TRIGGER t_phpbb_extensions
0426 BEFORE INSERT ON phpbb_extensions
0427 FOR EACH ROW WHEN (
0428 new.extension_id IS NULL OR new.extension_id = 0
0429 )
0430 BEGIN
0431 SELECT phpbb_extensions_seq.nextval
0432 INTO :new.extension_id
0433 FROM dual;
0434 END;
0435 /
0436
0437
0438 /*
0439 Table: 'phpbb_extension_groups'
0440 */
0441 CREATE TABLE phpbb_extension_groups (
0442 group_id number(8) NOT NULL,
0443 group_name varchar2(765) DEFAULT '' ,
0444 cat_id number(2) DEFAULT '0' NOT NULL,
0445 allow_group number(1) DEFAULT '0' NOT NULL,
0446 download_mode number(1) DEFAULT '1' NOT NULL,
0447 upload_icon varchar2(255) DEFAULT '' ,
0448 max_filesize number(20) DEFAULT '0' NOT NULL,
0449 allowed_forums clob DEFAULT '' ,
0450 allow_in_pm number(1) DEFAULT '0' NOT NULL,
0451 CONSTRAINT pk_phpbb_extension_groups PRIMARY KEY (group_id)
0452 )
0453 /
0454
0455
0456 CREATE SEQUENCE phpbb_extension_groups_seq
0457 /
0458
0459 CREATE OR REPLACE TRIGGER t_phpbb_extension_groups
0460 BEFORE INSERT ON phpbb_extension_groups
0461 FOR EACH ROW WHEN (
0462 new.group_id IS NULL OR new.group_id = 0
0463 )
0464 BEGIN
0465 SELECT phpbb_extension_groups_seq.nextval
0466 INTO :new.group_id
0467 FROM dual;
0468 END;
0469 /
0470
0471
0472 /*
0473 Table: 'phpbb_forums'
0474 */
0475 CREATE TABLE phpbb_forums (
0476 forum_id number(8) NOT NULL,
0477 parent_id number(8) DEFAULT '0' NOT NULL,
0478 left_id number(8) DEFAULT '0' NOT NULL,
0479 right_id number(8) DEFAULT '0' NOT NULL,
0480 forum_parents clob DEFAULT '' ,
0481 forum_name varchar2(765) DEFAULT '' ,
0482 forum_desc clob DEFAULT '' ,
0483 forum_desc_bitfield varchar2(255) DEFAULT '' ,
0484 forum_desc_options number(11) DEFAULT '7' NOT NULL,
0485 forum_desc_uid varchar2(8) DEFAULT '' ,
0486 forum_link varchar2(765) DEFAULT '' ,
0487 forum_password varchar2(120) DEFAULT '' ,
0488 forum_style number(4) DEFAULT '0' NOT NULL,
0489 forum_image varchar2(255) DEFAULT '' ,
0490 forum_rules clob DEFAULT '' ,
0491 forum_rules_link varchar2(765) DEFAULT '' ,
0492 forum_rules_bitfield varchar2(255) DEFAULT '' ,
0493 forum_rules_options number(11) DEFAULT '7' NOT NULL,
0494 forum_rules_uid varchar2(8) DEFAULT '' ,
0495 forum_topics_per_page number(4) DEFAULT '0' NOT NULL,
0496 forum_type number(4) DEFAULT '0' NOT NULL,
0497 forum_status number(4) DEFAULT '0' NOT NULL,
0498 forum_posts number(8) DEFAULT '0' NOT NULL,
0499 forum_topics number(8) DEFAULT '0' NOT NULL,
0500 forum_topics_real number(8) DEFAULT '0' NOT NULL,
0501 forum_last_post_id number(8) DEFAULT '0' NOT NULL,
0502 forum_last_poster_id number(8) DEFAULT '0' NOT NULL,
0503 forum_last_post_subject varchar2(300) DEFAULT '' ,
0504 forum_last_post_time number(11) DEFAULT '0' NOT NULL,
0505 forum_last_poster_name varchar2(765) DEFAULT '' ,
0506 forum_last_poster_colour varchar2(6) DEFAULT '' ,
0507 forum_flags number(4) DEFAULT '32' NOT NULL,
0508 display_on_index number(1) DEFAULT '1' NOT NULL,
0509 enable_indexing number(1) DEFAULT '1' NOT NULL,
0510 enable_icons number(1) DEFAULT '1' NOT NULL,
0511 enable_prune number(1) DEFAULT '0' NOT NULL,
0512 prune_next number(11) DEFAULT '0' NOT NULL,
0513 prune_days number(8) DEFAULT '0' NOT NULL,
0514 prune_viewed number(8) DEFAULT '0' NOT NULL,
0515 prune_freq number(8) DEFAULT '0' NOT NULL,
0516 CONSTRAINT pk_phpbb_forums PRIMARY KEY (forum_id)
0517 )
0518 /
0519
0520 CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums (left_id, right_id)
0521 /
0522 CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id)
0523 /
0524
0525 CREATE SEQUENCE phpbb_forums_seq
0526 /
0527
0528 CREATE OR REPLACE TRIGGER t_phpbb_forums
0529 BEFORE INSERT ON phpbb_forums
0530 FOR EACH ROW WHEN (
0531 new.forum_id IS NULL OR new.forum_id = 0
0532 )
0533 BEGIN
0534 SELECT phpbb_forums_seq.nextval
0535 INTO :new.forum_id
0536 FROM dual;
0537 END;
0538 /
0539
0540
0541 /*
0542 Table: 'phpbb_forums_access'
0543 */
0544 CREATE TABLE phpbb_forums_access (
0545 forum_id number(8) DEFAULT '0' NOT NULL,
0546 user_id number(8) DEFAULT '0' NOT NULL,
0547 session_id char(32) DEFAULT '' ,
0548 CONSTRAINT pk_phpbb_forums_access PRIMARY KEY (forum_id, user_id, session_id)
0549 )
0550 /
0551
0552
0553 /*
0554 Table: 'phpbb_forums_track'
0555 */
0556 CREATE TABLE phpbb_forums_track (
0557 user_id number(8) DEFAULT '0' NOT NULL,
0558 forum_id number(8) DEFAULT '0' NOT NULL,
0559 mark_time number(11) DEFAULT '0' NOT NULL,
0560 CONSTRAINT pk_phpbb_forums_track PRIMARY KEY (user_id, forum_id)
0561 )
0562 /
0563
0564
0565 /*
0566 Table: 'phpbb_forums_watch'
0567 */
0568 CREATE TABLE phpbb_forums_watch (
0569 forum_id number(8) DEFAULT '0' NOT NULL,
0570 user_id number(8) DEFAULT '0' NOT NULL,
0571 notify_status number(1) DEFAULT '0' NOT NULL
0572 )
0573 /
0574
0575 CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id)
0576 /
0577 CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id)
0578 /
0579 CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch (notify_status)
0580 /
0581
0582 /*
0583 Table: 'phpbb_groups'
0584 */
0585 CREATE TABLE phpbb_groups (
0586 group_id number(8) NOT NULL,
0587 group_type number(4) DEFAULT '1' NOT NULL,
0588 group_founder_manage number(1) DEFAULT '0' NOT NULL,
0589 group_name varchar2(255) DEFAULT '' ,
0590 group_desc clob DEFAULT '' ,
0591 group_desc_bitfield varchar2(255) DEFAULT '' ,
0592 group_desc_options number(11) DEFAULT '7' NOT NULL,
0593 group_desc_uid varchar2(8) DEFAULT '' ,
0594 group_display number(1) DEFAULT '0' NOT NULL,
0595 group_avatar varchar2(255) DEFAULT '' ,
0596 group_avatar_type number(2) DEFAULT '0' NOT NULL,
0597 group_avatar_width number(4) DEFAULT '0' NOT NULL,
0598 group_avatar_height number(4) DEFAULT '0' NOT NULL,
0599 group_rank number(8) DEFAULT '0' NOT NULL,
0600 group_colour varchar2(6) DEFAULT '' ,
0601 group_sig_chars number(8) DEFAULT '0' NOT NULL,
0602 group_receive_pm number(1) DEFAULT '0' NOT NULL,
0603 group_message_limit number(8) DEFAULT '0' NOT NULL,
0604 group_legend number(1) DEFAULT '1' NOT NULL,
0605 CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id)
0606 )
0607 /
0608
0609 CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend)
0610 /
0611
0612 CREATE SEQUENCE phpbb_groups_seq
0613 /
0614
0615 CREATE OR REPLACE TRIGGER t_phpbb_groups
0616 BEFORE INSERT ON phpbb_groups
0617 FOR EACH ROW WHEN (
0618 new.group_id IS NULL OR new.group_id = 0
0619 )
0620 BEGIN
0621 SELECT phpbb_groups_seq.nextval
0622 INTO :new.group_id
0623 FROM dual;
0624 END;
0625 /
0626
0627
0628 /*
0629 Table: 'phpbb_icons'
0630 */
0631 CREATE TABLE phpbb_icons (
0632 icons_id number(8) NOT NULL,
0633 icons_url varchar2(255) DEFAULT '' ,
0634 icons_width number(4) DEFAULT '0' NOT NULL,
0635 icons_height number(4) DEFAULT '0' NOT NULL,
0636 icons_order number(8) DEFAULT '0' NOT NULL,
0637 display_on_posting number(1) DEFAULT '1' NOT NULL,
0638 CONSTRAINT pk_phpbb_icons PRIMARY KEY (icons_id)
0639 )
0640 /
0641
0642 CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting)
0643 /
0644
0645 CREATE SEQUENCE phpbb_icons_seq
0646 /
0647
0648 CREATE OR REPLACE TRIGGER t_phpbb_icons
0649 BEFORE INSERT ON phpbb_icons
0650 FOR EACH ROW WHEN (
0651 new.icons_id IS NULL OR new.icons_id = 0
0652 )
0653 BEGIN
0654 SELECT phpbb_icons_seq.nextval
0655 INTO :new.icons_id
0656 FROM dual;
0657 END;
0658 /
0659
0660
0661 /*
0662 Table: 'phpbb_lang'
0663 */
0664 CREATE TABLE phpbb_lang (
0665 lang_id number(4) NOT NULL,
0666 lang_iso varchar2(30) DEFAULT '' ,
0667 lang_dir varchar2(30) DEFAULT '' ,
0668 lang_english_name varchar2(300) DEFAULT '' ,
0669 lang_local_name varchar2(765) DEFAULT '' ,
0670 lang_author varchar2(765) DEFAULT '' ,
0671 CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id)
0672 )
0673 /
0674
0675 CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso)
0676 /
0677
0678 CREATE SEQUENCE phpbb_lang_seq
0679 /
0680
0681 CREATE OR REPLACE TRIGGER t_phpbb_lang
0682 BEFORE INSERT ON phpbb_lang
0683 FOR EACH ROW WHEN (
0684 new.lang_id IS NULL OR new.lang_id = 0
0685 )
0686 BEGIN
0687 SELECT phpbb_lang_seq.nextval
0688 INTO :new.lang_id
0689 FROM dual;
0690 END;
0691 /
0692
0693
0694 /*
0695 Table: 'phpbb_log'
0696 */
0697 CREATE TABLE phpbb_log (
0698 log_id number(8) NOT NULL,
0699 log_type number(4) DEFAULT '0' NOT NULL,
0700 user_id number(8) DEFAULT '0' NOT NULL,
0701 forum_id number(8) DEFAULT '0' NOT NULL,
0702 topic_id number(8) DEFAULT '0' NOT NULL,
0703 reportee_id number(8) DEFAULT '0' NOT NULL,
0704 log_ip varchar2(40) DEFAULT '' ,
0705 log_time number(11) DEFAULT '0' NOT NULL,
0706 log_operation clob DEFAULT '' ,
0707 log_data clob DEFAULT '' ,
0708 CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id)
0709 )
0710 /
0711
0712 CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type)
0713 /
0714 CREATE INDEX phpbb_log_forum_id ON phpbb_log (forum_id)
0715 /
0716 CREATE INDEX phpbb_log_topic_id ON phpbb_log (topic_id)
0717 /
0718 CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id)
0719 /
0720 CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id)
0721 /
0722
0723 CREATE SEQUENCE phpbb_log_seq
0724 /
0725
0726 CREATE OR REPLACE TRIGGER t_phpbb_log
0727 BEFORE INSERT ON phpbb_log
0728 FOR EACH ROW WHEN (
0729 new.log_id IS NULL OR new.log_id = 0
0730 )
0731 BEGIN
0732 SELECT phpbb_log_seq.nextval
0733 INTO :new.log_id
0734 FROM dual;
0735 END;
0736 /
0737
0738
0739 /*
0740 Table: 'phpbb_moderator_cache'
0741 */
0742 CREATE TABLE phpbb_moderator_cache (
0743 forum_id number(8) DEFAULT '0' NOT NULL,
0744 user_id number(8) DEFAULT '0' NOT NULL,
0745 username varchar2(765) DEFAULT '' ,
0746 group_id number(8) DEFAULT '0' NOT NULL,
0747 group_name varchar2(765) DEFAULT '' ,
0748 display_on_index number(1) DEFAULT '1' NOT NULL
0749 )
0750 /
0751
0752 CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index)
0753 /
0754 CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id)
0755 /
0756
0757 /*
0758 Table: 'phpbb_modules'
0759 */
0760 CREATE TABLE phpbb_modules (
0761 module_id number(8) NOT NULL,
0762 module_enabled number(1) DEFAULT '1' NOT NULL,
0763 module_display number(1) DEFAULT '1' NOT NULL,
0764 module_basename varchar2(255) DEFAULT '' ,
0765 module_class varchar2(10) DEFAULT '' ,
0766 parent_id number(8) DEFAULT '0' NOT NULL,
0767 left_id number(8) DEFAULT '0' NOT NULL,
0768 right_id number(8) DEFAULT '0' NOT NULL,
0769 module_langname varchar2(255) DEFAULT '' ,
0770 module_mode varchar2(255) DEFAULT '' ,
0771 module_auth varchar2(255) DEFAULT '' ,
0772 CONSTRAINT pk_phpbb_modules PRIMARY KEY (module_id)
0773 )
0774 /
0775
0776 CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id)
0777 /
0778 CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled)
0779 /
0780 CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id)
0781 /
0782
0783 CREATE SEQUENCE phpbb_modules_seq
0784 /
0785
0786 CREATE OR REPLACE TRIGGER t_phpbb_modules
0787 BEFORE INSERT ON phpbb_modules
0788 FOR EACH ROW WHEN (
0789 new.module_id IS NULL OR new.module_id = 0
0790 )
0791 BEGIN
0792 SELECT phpbb_modules_seq.nextval
0793 INTO :new.module_id
0794 FROM dual;
0795 END;
0796 /
0797
0798
0799 /*
0800 Table: 'phpbb_poll_options'
0801 */
0802 CREATE TABLE phpbb_poll_options (
0803 poll_option_id number(4) DEFAULT '0' NOT NULL,
0804 topic_id number(8) DEFAULT '0' NOT NULL,
0805 poll_option_text clob DEFAULT '' ,
0806 poll_option_total number(8) DEFAULT '0' NOT NULL
0807 )
0808 /
0809
0810 CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id)
0811 /
0812 CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id)
0813 /
0814
0815 /*
0816 Table: 'phpbb_poll_votes'
0817 */
0818 CREATE TABLE phpbb_poll_votes (
0819 topic_id number(8) DEFAULT '0' NOT NULL,
0820 poll_option_id number(4) DEFAULT '0' NOT NULL,
0821 vote_user_id number(8) DEFAULT '0' NOT NULL,
0822 vote_user_ip varchar2(40) DEFAULT ''
0823 )
0824 /
0825
0826 CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes (topic_id)
0827 /
0828 CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id)
0829 /
0830 CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip)
0831 /
0832
0833 /*
0834 Table: 'phpbb_posts'
0835 */
0836 CREATE TABLE phpbb_posts (
0837 post_id number(8) NOT NULL,
0838 topic_id number(8) DEFAULT '0' NOT NULL,
0839 forum_id number(8) DEFAULT '0' NOT NULL,
0840 poster_id number(8) DEFAULT '0' NOT NULL,
0841 icon_id number(8) DEFAULT '0' NOT NULL,
0842 poster_ip varchar2(40) DEFAULT '' ,
0843 post_time number(11) DEFAULT '0' NOT NULL,
0844 post_approved number(1) DEFAULT '1' NOT NULL,
0845 post_reported number(1) DEFAULT '0' NOT NULL,
0846 enable_bbcode number(1) DEFAULT '1' NOT NULL,
0847 enable_smilies number(1) DEFAULT '1' NOT NULL,
0848 enable_magic_url number(1) DEFAULT '1' NOT NULL,
0849 enable_sig number(1) DEFAULT '1' NOT NULL,
0850 post_username varchar2(765) DEFAULT '' ,
0851 post_subject varchar2(300) DEFAULT '' ,
0852 post_text clob DEFAULT '' ,
0853 post_checksum varchar2(32) DEFAULT '' ,
0854 post_attachment number(1) DEFAULT '0' NOT NULL,
0855 bbcode_bitfield varchar2(255) DEFAULT '' ,
0856 bbcode_uid varchar2(8) DEFAULT '' ,
0857 post_postcount number(1) DEFAULT '1' NOT NULL,
0858 post_edit_time number(11) DEFAULT '0' NOT NULL,
0859 post_edit_reason varchar2(765) DEFAULT '' ,
0860 post_edit_user number(8) DEFAULT '0' NOT NULL,
0861 post_edit_count number(4) DEFAULT '0' NOT NULL,
0862 post_edit_locked number(1) DEFAULT '0' NOT NULL,
0863 CONSTRAINT pk_phpbb_posts PRIMARY KEY (post_id)
0864 )
0865 /
0866
0867 CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id)
0868 /
0869 CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id)
0870 /
0871 CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip)
0872 /
0873 CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id)
0874 /
0875 CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved)
0876 /
0877 CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts (topic_id, post_time)
0878 /
0879
0880 CREATE SEQUENCE phpbb_posts_seq
0881 /
0882
0883 CREATE OR REPLACE TRIGGER t_phpbb_posts
0884 BEFORE INSERT ON phpbb_posts
0885 FOR EACH ROW WHEN (
0886 new.post_id IS NULL OR new.post_id = 0
0887 )
0888 BEGIN
0889 SELECT phpbb_posts_seq.nextval
0890 INTO :new.post_id
0891 FROM dual;
0892 END;
0893 /
0894
0895
0896 /*
0897 Table: 'phpbb_privmsgs'
0898 */
0899 CREATE TABLE phpbb_privmsgs (
0900 msg_id number(8) NOT NULL,
0901 root_level number(8) DEFAULT '0' NOT NULL,
0902 author_id number(8) DEFAULT '0' NOT NULL,
0903 icon_id number(8) DEFAULT '0' NOT NULL,
0904 author_ip varchar2(40) DEFAULT '' ,
0905 message_time number(11) DEFAULT '0' NOT NULL,
0906 enable_bbcode number(1) DEFAULT '1' NOT NULL,
0907 enable_smilies number(1) DEFAULT '1' NOT NULL,
0908 enable_magic_url number(1) DEFAULT '1' NOT NULL,
0909 enable_sig number(1) DEFAULT '1' NOT NULL,
0910 message_subject varchar2(300) DEFAULT '' ,
0911 message_text clob DEFAULT '' ,
0912 message_edit_reason varchar2(765) DEFAULT '' ,
0913 message_edit_user number(8) DEFAULT '0' NOT NULL,
0914 message_attachment number(1) DEFAULT '0' NOT NULL,
0915 bbcode_bitfield varchar2(255) DEFAULT '' ,
0916 bbcode_uid varchar2(8) DEFAULT '' ,
0917 message_edit_time number(11) DEFAULT '0' NOT NULL,
0918 message_edit_count number(4) DEFAULT '0' NOT NULL,
0919 to_address clob DEFAULT '' ,
0920 bcc_address clob DEFAULT '' ,
0921 CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id)
0922 )
0923 /
0924
0925 CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip)
0926 /
0927 CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time)
0928 /
0929 CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id)
0930 /
0931 CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level)
0932 /
0933
0934 CREATE SEQUENCE phpbb_privmsgs_seq
0935 /
0936
0937 CREATE OR REPLACE TRIGGER t_phpbb_privmsgs
0938 BEFORE INSERT ON phpbb_privmsgs
0939 FOR EACH ROW WHEN (
0940 new.msg_id IS NULL OR new.msg_id = 0
0941 )
0942 BEGIN
0943 SELECT phpbb_privmsgs_seq.nextval
0944 INTO :new.msg_id
0945 FROM dual;
0946 END;
0947 /
0948
0949
0950 /*
0951 Table: 'phpbb_privmsgs_folder'
0952 */
0953 CREATE TABLE phpbb_privmsgs_folder (
0954 folder_id number(8) NOT NULL,
0955 user_id number(8) DEFAULT '0' NOT NULL,
0956 folder_name varchar2(765) DEFAULT '' ,
0957 pm_count number(8) DEFAULT '0' NOT NULL,
0958 CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id)
0959 )
0960 /
0961
0962 CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id)
0963 /
0964
0965 CREATE SEQUENCE phpbb_privmsgs_folder_seq
0966 /
0967
0968 CREATE OR REPLACE TRIGGER t_phpbb_privmsgs_folder
0969 BEFORE INSERT ON phpbb_privmsgs_folder
0970 FOR EACH ROW WHEN (
0971 new.folder_id IS NULL OR new.folder_id = 0
0972 )
0973 BEGIN
0974 SELECT phpbb_privmsgs_folder_seq.nextval
0975 INTO :new.folder_id
0976 FROM dual;
0977 END;
0978 /
0979
0980
0981 /*
0982 Table: 'phpbb_privmsgs_rules'
0983 */
0984 CREATE TABLE phpbb_privmsgs_rules (
0985 rule_id number(8) NOT NULL,
0986 user_id number(8) DEFAULT '0' NOT NULL,
0987 rule_check number(8) DEFAULT '0' NOT NULL,
0988 rule_connection number(8) DEFAULT '0' NOT NULL,
0989 rule_string varchar2(765) DEFAULT '' ,
0990 rule_user_id number(8) DEFAULT '0' NOT NULL,
0991 rule_group_id number(8) DEFAULT '0' NOT NULL,
0992 rule_action number(8) DEFAULT '0' NOT NULL,
0993 rule_folder_id number(11) DEFAULT '0' NOT NULL,
0994 CONSTRAINT pk_phpbb_privmsgs_rules PRIMARY KEY (rule_id)
0995 )
0996 /
0997
0998 CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id)
0999 /
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
1875