diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 2168 |
1 files changed, 1034 insertions, 1134 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 6ffd59cd45..2ac992ed0c 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -2,6 +2,7 @@ Oracle Schema for phpBB 3.x - (c) phpBB Group, 2005 $Id$ + */ /* @@ -16,7 +17,7 @@ /* CREATE TABLESPACE "PHPBB" LOGGING - DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora' + DATAFILE \'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora\' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 100M; @@ -41,462 +42,432 @@ 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, - physical_filename varchar2(255) NOT NULL, - real_filename varchar2(255) NOT NULL, - download_count number(8) DEFAULT '0' NOT NULL, - "COMMENT" clob, - extension varchar2(100), - mimetype varchar2(100), - 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) + 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, + pysical_filename varchar2(255) DEFAULT '' NOT NULL, + real_filename varchar2(255) DEFAULT '' NOT NULL, + download_count number(8) DEFAULT '0' NOT NULL, + attach_comment clob DEFAULT '' NOT NULL, + extension varchar2(100) DEFAULT '' NOT NULL, + mimetype varchar2(100) DEFAULT '' NOT NULL, + 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_filesize ON phpbb_attachments (filesize) +/ + CREATE SEQUENCE phpbb_attachments_seq / CREATE OR REPLACE TRIGGER ai_phpbb_attachments_seq BEFORE INSERT ON phpbb_attachments FOR EACH ROW WHEN ( - new.attach_id IS NULL OR new.attach_id = 0 + new.attach_id IS NULL OR new.attach_id = 0 ) BEGIN - SELECT phpbb_attachments_seq.nextval - INTO :new.attach_id - FROM dual; + SELECT phpbb_attachments_seq.nextval + INTO :new.attach_id + FROM dual; END; / -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_phys_fname on phpbb_attachments (physical_filename) -/ -CREATE INDEX phpbb_attachments_filesize on phpbb_attachments (filesize) -/ - -/* - Table: phpbb_acl_groups -*/ +/* 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 + 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_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_option_id ON phpbb_acl_groups (auth_option_id) / - -/* - Table: phpbb_acl_options -*/ +/* Table: 'phpbb_acl_options' */ CREATE TABLE phpbb_acl_options ( - auth_option_id number(8) NOT NULL, - auth_option varchar2(50) NOT NULL, - 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) + auth_option_id number(8) NOT NULL, + auth_option varchar2(50) DEFAULT '' NOT NULL, + 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) ) / +CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options (auth_option) +/ + CREATE SEQUENCE phpbb_acl_options_seq / CREATE OR REPLACE TRIGGER ai_phpbb_acl_options_seq BEFORE INSERT ON phpbb_acl_options FOR EACH ROW WHEN ( - new.auth_option_id IS NULL OR new.auth_option_id = 0 + 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; + SELECT phpbb_acl_options_seq.nextval + INTO :new.auth_option_id + FROM dual; END; / -CREATE INDEX phpbb_acl_options_auth_option on phpbb_acl_options (auth_option) -/ - -/* - Table: phpbb_acl_roles -*/ +/* Table: 'phpbb_acl_roles' */ CREATE TABLE phpbb_acl_roles ( - role_id number(8) NOT NULL, - role_name varchar2(255) DEFAULT '', - role_description clob, - role_type varchar2(10) DEFAULT '', - role_order number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_acl_roles PRIMARY KEY (role_id) + role_id number(8) NOT NULL, + role_name varchar2(255) DEFAULT '' NOT NULL, + role_description clob DEFAULT '' NOT NULL, + role_type varchar2(10) DEFAULT '' NOT NULL, + 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 ai_phpbb_acl_roles_seq BEFORE INSERT ON phpbb_acl_roles FOR EACH ROW WHEN ( - new.role_id IS NULL OR new.role_id = 0 + new.role_id IS NULL OR new.role_id = 0 ) BEGIN - SELECT phpbb_acl_roles_seq.nextval - INTO :new.role_id - FROM dual; + SELECT phpbb_acl_roles_seq.nextval + INTO :new.role_id + FROM dual; END; / -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) -/ -/* - Table: phpbb_acl_roles_data -*/ +/* 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) + 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) ) / -/* - Table: phpbb_acl_users -*/ +/* 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 + 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_user_id ON phpbb_acl_users (user_id) / -CREATE INDEX phpbb_acl_users_auth_opt_id on phpbb_acl_users (auth_option_id) +CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id) / - -/* - Table: phpbb_banlist -*/ +/* 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(100) 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(3000), - ban_give_reason varchar2(3000), - CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id) + ban_id number(8) NOT NULL, + ban_userid number(8) DEFAULT '0' NOT NULL, + ban_ip varchar2(40) DEFAULT '' NOT NULL, + ban_email varchar2(100) DEFAULT '' NOT NULL, + 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(3000) DEFAULT '' NOT NULL, + ban_give_reason varchar2(3000) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id) ) / + CREATE SEQUENCE phpbb_banlist_seq / CREATE OR REPLACE TRIGGER ai_phpbb_banlist_seq BEFORE INSERT ON phpbb_banlist FOR EACH ROW WHEN ( - new.ban_id IS NULL OR new.ban_id = 0 + new.ban_id IS NULL OR new.ban_id = 0 ) BEGIN - SELECT phpbb_banlist_seq.nextval - INTO :new.ban_id - FROM dual; + SELECT phpbb_banlist_seq.nextval + INTO :new.ban_id + FROM dual; END; / -/* - Table: phpbb_bbcodes -*/ +/* Table: 'phpbb_bbcodes' */ CREATE TABLE phpbb_bbcodes ( - bbcode_id number(3) DEFAULT '0' NOT NULL, - bbcode_tag varchar2(16) DEFAULT '', - display_on_posting number(1) DEFAULT '0' NOT NULL, - bbcode_match varchar2(255) DEFAULT '', - bbcode_tpl clob, - first_pass_match varchar2(255) DEFAULT '', - first_pass_replace varchar2(255) DEFAULT '', - second_pass_match varchar2(255) DEFAULT '', - second_pass_replace clob, - CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id) + bbcode_id number(3) DEFAULT '0' NOT NULL, + bbcode_tag varchar2(16) DEFAULT '' NOT NULL, + display_on_posting number(1) DEFAULT '0' NOT NULL, + bbcode_match varchar2(255) DEFAULT '' NOT NULL, + bbcode_tpl clob DEFAULT '' NOT NULL, + first_pass_match varchar2(255) DEFAULT '' NOT NULL, + first_pass_replace varchar2(255) DEFAULT '' NOT NULL, + second_pass_match varchar2(255) DEFAULT '' NOT NULL, + second_pass_replace clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id) ) / -CREATE INDEX phpbb_bbcodes_disp_on_posting on phpbb_bbcodes (display_on_posting) +CREATE INDEX phpbb_bbcodes_display_in_posting ON phpbb_bbcodes (display_on_posting) / - -/* - Table: phpbb_bookmarks -*/ +/* Table: 'phpbb_bookmarks' */ CREATE TABLE phpbb_bookmarks ( - topic_id number(8) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - order_id number(8) DEFAULT '0' NOT NULL + topic_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + order_id number(8) DEFAULT '0' NOT NULL ) / -CREATE INDEX phpbb_bookmarks_order_id on phpbb_bookmarks (order_id) +CREATE INDEX phpbb_bookmarks_order_id ON phpbb_bookmarks (order_id) / -CREATE INDEX phpbb_bookmarks_topic_user_id on phpbb_bookmarks (topic_id, user_id) +CREATE INDEX phpbb_bookmarks_topic_user_id ON phpbb_bookmarks (topic_id, user_id) / - -/* - Table: phpbb_bots -*/ +/* Table: 'phpbb_bots' */ CREATE TABLE phpbb_bots ( - bot_id number(3) NOT NULL, - bot_active number(1) DEFAULT '1' NOT NULL, - bot_name varchar2(1000), - 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) + bot_id number(8) NOT NULL, + bot_active number(1) DEFAULT '1' NOT NULL, + bot_name varchar2(3000) DEFAULT '' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + bot_agent varchar2(255) DEFAULT '' NOT NULL, + bot_ip varchar2(255) DEFAULT '' NOT NULL, + 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 ai_phpbb_bots_seq BEFORE INSERT ON phpbb_bots FOR EACH ROW WHEN ( - new.bot_id IS NULL OR new.bot_id = 0 + new.bot_id IS NULL OR new.bot_id = 0 ) BEGIN - SELECT phpbb_bots_seq.nextval - INTO :new.bot_id - FROM dual; + SELECT phpbb_bots_seq.nextval + INTO :new.bot_id + FROM dual; END; / -CREATE INDEX phpbb_bots_bot_active on phpbb_bots (bot_active) -/ - -/* - Table: phpbb_config -*/ +/* Table: 'phpbb_config' */ CREATE TABLE phpbb_config ( - config_name varchar2(255) NOT NULL, - config_value varchar2(255) DEFAULT '', - is_dynamic number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name) + config_name varchar2(255) DEFAULT '' NOT NULL, + config_value varchar2(255) DEFAULT '' NOT NULL, + 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) +CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic) / - -/* - Table: phpbb_confirm -*/ +/* 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 '', - CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id) + confirm_id char(32) DEFAULT '' NOT NULL, + session_id char(32) DEFAULT '' NOT NULL, + confirm_type number(3) DEFAULT '0' NOT NULL, + code varchar2(8) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id) ) / -/* - Table: phpbb_disallow -*/ +/* Table: 'phpbb_disallow' */ CREATE TABLE phpbb_disallow ( - disallow_id number(8) NOT NULL, - disallow_username varchar2(255) DEFAULT '', - CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id) + disallow_id number(8) NOT NULL, + disallow_username varchar2(255) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id) ) / + CREATE SEQUENCE phpbb_disallow_seq / CREATE OR REPLACE TRIGGER ai_phpbb_disallow_seq BEFORE INSERT ON phpbb_disallow FOR EACH ROW WHEN ( - new.disallow_id IS NULL OR new.disallow_id = 0 + new.disallow_id IS NULL OR new.disallow_id = 0 ) BEGIN - SELECT phpbb_disallow_seq.nextval - INTO :new.disallow_id - FROM dual; + SELECT phpbb_disallow_seq.nextval + INTO :new.disallow_id + FROM dual; END; / -/* - Table: phpbb_drafts -*/ +/* 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(1000), - draft_message clob, - CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id) + 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(1000) DEFAULT '' NOT NULL, + draft_message clob DEFAULT '' NOT NULL, + 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 ai_phpbb_drafts_seq BEFORE INSERT ON phpbb_drafts FOR EACH ROW WHEN ( - new.draft_id IS NULL OR new.draft_id = 0 + new.draft_id IS NULL OR new.draft_id = 0 ) BEGIN - SELECT phpbb_drafts_seq.nextval - INTO :new.draft_id - FROM dual; + SELECT phpbb_drafts_seq.nextval + INTO :new.draft_id + FROM dual; END; / -CREATE INDEX phpbb_drafts_save_time on phpbb_drafts (save_time) -/ - -/* - Table: phpbb_extensions -*/ +/* 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) + extension_id number(8) NOT NULL, + group_id number(8) DEFAULT '0' NOT NULL, + extension varchar2(100) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id) ) / + CREATE SEQUENCE phpbb_extensions_seq / CREATE OR REPLACE TRIGGER ai_phpbb_extensions_seq BEFORE INSERT ON phpbb_extensions FOR EACH ROW WHEN ( - new.extension_id IS NULL OR new.extension_id = 0 + new.extension_id IS NULL OR new.extension_id = 0 ) BEGIN - SELECT phpbb_extensions_seq.nextval - INTO :new.extension_id - FROM dual; + SELECT phpbb_extensions_seq.nextval + INTO :new.extension_id + FROM dual; END; / -/* - Table: phpbb_extension_groups -*/ +/* Table: 'phpbb_extension_groups' */ CREATE TABLE phpbb_extension_groups ( - group_id number(8) NOT NULL, - group_name varchar2(255) NOT NULL, - 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, - allow_in_pm number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_extension_groups PRIMARY KEY (group_id) + group_id number(8) NOT NULL, + group_name varchar2(255) DEFAULT '' NOT NULL, + 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 '' NOT NULL, + max_filesize number(20) DEFAULT '0' NOT NULL, + allowed_forums clob DEFAULT '' NOT NULL, + 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 ai_phpbb_extension_groups_seq BEFORE INSERT ON phpbb_extension_groups FOR EACH ROW WHEN ( - new.group_id IS NULL OR new.group_id = 0 + new.group_id IS NULL OR new.group_id = 0 ) BEGIN - SELECT phpbb_extension_groups_seq.nextval - INTO :new.group_id - FROM dual; + SELECT phpbb_extension_groups_seq.nextval + INTO :new.group_id + FROM dual; END; / -/* - Table: phpbb_forums -*/ +/* Table: 'phpbb_forums' */ CREATE TABLE phpbb_forums ( - forum_id number(5) NOT NULL, - parent_id number(5) DEFAULT '0' NOT NULL, - left_id number(5) DEFAULT '0' NOT NULL, - right_id number(5) DEFAULT '0' NOT NULL, - forum_parents clob, - forum_name varchar2(3000), - forum_desc clob, - forum_desc_bitfield number(11) DEFAULT '0' NOT NULL, - forum_desc_uid varchar2(5) DEFAULT '', - forum_link varchar2(255) DEFAULT '', - forum_password varchar2(40) DEFAULT '', - forum_style number(4), - forum_image varchar2(255) DEFAULT '', - forum_rules clob, - forum_rules_link varchar2(255) DEFAULT '', - forum_rules_bitfield number(11) DEFAULT '0' NOT NULL, - forum_rules_uid varchar2(5) 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 number(8) DEFAULT '0' NOT NULL, - forum_topics number(8) DEFAULT '0' NOT NULL, - forum_topics_real 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_time number(11) DEFAULT '0' NOT NULL, - forum_last_poster_name varchar2(255), - forum_flags number(4) DEFAULT '32' 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), - prune_days number(4) DEFAULT '0' NOT NULL, - prune_viewed number(4) DEFAULT '0' NOT NULL, - prune_freq number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_forums PRIMARY KEY (forum_id) -) + 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 '' NOT NULL, + forum_name varchar2(3000) DEFAULT '' NOT NULL, + forum_desc clob DEFAULT '' NOT NULL, + forum_desc_bitfield number(11) DEFAULT '0' NOT NULL, + forum_desc_uid varchar2(5) DEFAULT '' NOT NULL, + forum_link varchar2(255) DEFAULT '' NOT NULL, + forum_password varchar2(40) DEFAULT '' NOT NULL, + forum_style number(4) DEFAULT '0' NOT NULL, + forum_image varchar2(255) DEFAULT '' NOT NULL, + forum_rules clob DEFAULT '' NOT NULL, + forum_rules_link varchar2(255) DEFAULT '' NOT NULL, + forum_rules_bitfield number(11) DEFAULT '0' NOT NULL, + forum_rules_uid varchar2(5) DEFAULT '' NOT NULL, + 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 number(8) DEFAULT '0' NOT NULL, + forum_topics number(8) DEFAULT '0' NOT NULL, + forum_topics_real 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_time number(11) DEFAULT '0' NOT NULL, + forum_last_poster_name varchar2(255) DEFAULT '' NOT NULL, + forum_flags number(4) DEFAULT '32' 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(4) DEFAULT '0' NOT NULL, + prune_viewed number(4) DEFAULT '0' NOT NULL, + prune_freq number(4) 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_last_post_id ON phpbb_forums (forum_last_post_id) / CREATE SEQUENCE phpbb_forums_seq @@ -505,87 +476,75 @@ CREATE SEQUENCE phpbb_forums_seq CREATE OR REPLACE TRIGGER ai_phpbb_forums_seq BEFORE INSERT ON phpbb_forums FOR EACH ROW WHEN ( - new.forum_id IS NULL OR new.forum_id = 0 + new.forum_id IS NULL OR new.forum_id = 0 ) BEGIN - SELECT phpbb_forums_seq.nextval - INTO :new.forum_id - FROM dual; + SELECT phpbb_forums_seq.nextval + INTO :new.forum_id + FROM dual; END; / -CREATE INDEX phpbb_forums_left_right_id on phpbb_forums (left_id, right_id) -/ -CREATE INDEX phpbb_forums_forum_last_pst_id on phpbb_forums (forum_last_post_id) -/ - -/* - Table: phpbb_forums_access -*/ +/* 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 varchar2(32) DEFAULT '', - CONSTRAINT pk_phpbb_forums_access PRIMARY KEY (forum_id, user_id, session_id) + forum_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + session_id char(32) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_forums_access PRIMARY KEY (forum_id, user_id, session_id) ) / -/* - Table: phpbb_forums_track -*/ +/* Table: 'phpbb_forums_track' */ CREATE TABLE phpbb_forums_track ( - user_id number(9) DEFAULT '0' NOT NULL, - forum_id number(9) DEFAULT '0' NOT NULL, - mark_time number(11) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_forums_track PRIMARY KEY (user_id, forum_id) + 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 -*/ +/* Table: 'phpbb_forums_watch' */ CREATE TABLE phpbb_forums_watch ( - forum_id number(5) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - notify_status number(1) DEFAULT '0' NOT NULL + 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_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_user_id ON phpbb_forums_watch (user_id) / -CREATE INDEX phpbb_forums_watch_notify_stat on phpbb_forums_watch (notify_status) +CREATE INDEX phpbb_forums_watch_notify_status ON phpbb_forums_watch (notify_status) / - -/* - Table: phpbb_groups -*/ +/* Table: 'phpbb_groups' */ CREATE TABLE phpbb_groups ( - group_id number(8) NOT NULL, - group_type number(4) DEFAULT '1' NOT NULL, - group_name varchar2(255) DEFAULT '', - group_desc clob, - group_desc_bitfield number(11) DEFAULT '0' NOT NULL, - group_desc_uid varchar2(5) DEFAULT '', - group_display number(1) DEFAULT '0' NOT NULL, - group_avatar varchar2(255) DEFAULT '', - group_avatar_type number(4) DEFAULT '0' NOT NULL, - group_avatar_width number(4) DEFAULT '0' NOT NULL, - group_avatar_height number(4) DEFAULT '0' NOT NULL, - group_rank number(5) DEFAULT '-1' 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_chgpass number(6) DEFAULT '0' NOT NULL, - group_legend number(1) DEFAULT '1' NOT NULL, - CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id) -) + group_id number(8) NOT NULL, + group_type number(4) DEFAULT '1' NOT NULL, + group_name varchar2(255) DEFAULT '' NOT NULL, + group_desc clob DEFAULT '' NOT NULL, + group_desc_bitfield number(11) DEFAULT '0' NOT NULL, + group_desc_uid varchar2(5) DEFAULT '' NOT NULL, + group_display number(1) DEFAULT '0' NOT NULL, + group_avatar varchar2(255) DEFAULT '' NOT NULL, + group_avatar_type number(4) DEFAULT '0' NOT NULL, + 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 '' NOT NULL, + 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_legend number(1) DEFAULT '1' NOT NULL, + CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id) +) +/ + +CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend) / CREATE SEQUENCE phpbb_groups_seq @@ -594,312 +553,301 @@ CREATE SEQUENCE phpbb_groups_seq CREATE OR REPLACE TRIGGER ai_phpbb_groups_seq BEFORE INSERT ON phpbb_groups FOR EACH ROW WHEN ( - new.group_id IS NULL OR new.group_id = 0 + new.group_id IS NULL OR new.group_id = 0 ) BEGIN - SELECT phpbb_groups_seq.nextval - INTO :new.group_id - FROM dual; + SELECT phpbb_groups_seq.nextval + INTO :new.group_id + FROM dual; END; / -CREATE INDEX phpbb_groups_group_legend on phpbb_groups (group_legend) -/ - -/* - Table: phpbb_icons -*/ +/* Table: 'phpbb_icons' */ CREATE TABLE phpbb_icons ( - icons_id number(4) NOT NULL, - icons_url varchar2(255), - 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) + icons_id number(8) NOT NULL, + icons_url varchar2(255) DEFAULT '' NOT NULL, + 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 SEQUENCE phpbb_icons_seq / CREATE OR REPLACE TRIGGER ai_phpbb_icons_seq BEFORE INSERT ON phpbb_icons FOR EACH ROW WHEN ( - new.icons_id IS NULL OR new.icons_id = 0 + new.icons_id IS NULL OR new.icons_id = 0 ) BEGIN - SELECT phpbb_icons_seq.nextval - INTO :new.icons_id - FROM dual; + SELECT phpbb_icons_seq.nextval + INTO :new.icons_id + FROM dual; END; / -/* - Table: phpbb_lang -*/ +/* Table: 'phpbb_lang' */ CREATE TABLE phpbb_lang ( - lang_id number(4) NOT NULL, - lang_iso varchar2(5) NOT NULL, - lang_dir varchar2(30) NOT NULL, - lang_english_name varchar2(100), - lang_local_name varchar2(255), - lang_author varchar2(255), - CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id) + lang_id number(4) NOT NULL, + lang_iso varchar2(5) DEFAULT '' NOT NULL, + lang_dir varchar2(30) DEFAULT '' NOT NULL, + lang_english_name varchar2(100) DEFAULT '' NOT NULL, + lang_local_name varchar2(255) DEFAULT '' NOT NULL, + lang_author varchar2(255) DEFAULT '' NOT NULL, + 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 ai_phpbb_lang_seq BEFORE INSERT ON phpbb_lang FOR EACH ROW WHEN ( - new.lang_id IS NULL OR new.lang_id = 0 + new.lang_id IS NULL OR new.lang_id = 0 ) BEGIN - SELECT phpbb_lang_seq.nextval - INTO :new.lang_id - FROM dual; + SELECT phpbb_lang_seq.nextval + INTO :new.lang_id + FROM dual; END; / -/* - Table: phpbb_log -*/ +/* 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) NOT NULL, - log_time number(11) DEFAULT '0' NOT NULL, - log_operation clob, - log_data clob, - CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id) + 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 '' NOT NULL, + log_time number(11) DEFAULT '0' NOT NULL, + log_operation clob DEFAULT '' NOT NULL, + log_data clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id) ) / +CREATE INDEX phpbb_log_log_type ON phpbb_log (log_type) +/ +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 ai_phpbb_log_seq BEFORE INSERT ON phpbb_log FOR EACH ROW WHEN ( - new.log_id IS NULL OR new.log_id = 0 + new.log_id IS NULL OR new.log_id = 0 ) BEGIN - SELECT phpbb_log_seq.nextval - INTO :new.log_id - FROM dual; + SELECT phpbb_log_seq.nextval + INTO :new.log_id + FROM dual; END; / -CREATE INDEX phpbb_log_log_type on phpbb_log (log_type) -/ -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) -/ - -/* - Table: phpbb_moderator_cache -*/ +/* 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(255) DEFAULT '', - group_id number(8) DEFAULT '0' NOT NULL, - group_name varchar2(255) DEFAULT '', - display_on_index number(1) DEFAULT '1' NOT NULL + forum_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + username varchar2(255) DEFAULT '' NOT NULL, + group_id number(8) DEFAULT '0' NOT NULL, + group_name varchar2(255) DEFAULT '' NOT NULL, + 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_display_on_index ON phpbb_moderator_cache (display_on_index) / -CREATE INDEX phpbb_moderator_cache_forum_id on phpbb_moderator_cache (forum_id) +CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id) / - -/* - Table: phpbb_modules -*/ +/* 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_name 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) + 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 '' NOT NULL, + module_class varchar2(10) DEFAULT '' 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, + module_langname varchar2(255) DEFAULT '' NOT NULL, + module_mode varchar2(255) DEFAULT '' NOT NULL, + module_auth varchar2(255) DEFAULT '' NOT NULL, + 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 ai_phpbb_modules_seq BEFORE INSERT ON phpbb_modules FOR EACH ROW WHEN ( - new.module_id IS NULL OR new.module_id = 0 + new.module_id IS NULL OR new.module_id = 0 ) BEGIN - SELECT phpbb_modules_seq.nextval - INTO :new.module_id - FROM dual; + SELECT phpbb_modules_seq.nextval + INTO :new.module_id + FROM dual; END; / -CREATE INDEX phpbb_modules_module_enabled on phpbb_modules (module_enabled) -/ -CREATE INDEX phpbb_modules_left_right_id on phpbb_modules (left_id, right_id) -/ -CREATE INDEX phpbb_modules_class_left_id on phpbb_modules (module_class, left_id) -/ - -/* - Table: phpbb_poll_options -*/ +/* 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 varchar2(3000), - poll_option_total number(8) DEFAULT '0' NOT NULL + poll_option_id number(4) DEFAULT '0' NOT NULL, + topic_id number(8) DEFAULT '0' NOT NULL, + poll_option_text clob DEFAULT '' NOT NULL, + 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_poll_option_id ON phpbb_poll_options (poll_option_id) / -CREATE INDEX phpbb_poll_options_topic_id on phpbb_poll_options (topic_id) +CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id) / - -/* - Table: phpbb_poll_votes -*/ +/* 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) NOT NULL + 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 '' NOT NULL ) / -CREATE INDEX phpbb_poll_votes_topic_id on phpbb_poll_votes (topic_id) +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) +CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes (vote_user_id) / -CREATE INDEX phpbb_poll_votes_vote_user_ip on phpbb_poll_votes (vote_user_ip) +CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes (vote_user_ip) / - -/* - Table: phpbb_posts -*/ +/* Table: 'phpbb_posts' */ CREATE TABLE phpbb_posts ( - post_id number(8) NOT NULL, - topic_id number(8) DEFAULT '0' NOT NULL, - forum_id number(5) DEFAULT '0' NOT NULL, - poster_id number(8) DEFAULT '0' NOT NULL, - icon_id number(4) DEFAULT '0' NOT NULL, - poster_ip varchar2(40) NOT NULL, - post_time number(11) DEFAULT '0' NOT NULL, - post_approved number(1) DEFAULT '1' NOT NULL, - post_reported number(1) DEFAULT '0' NOT NULL, - enable_bbcode number(1) DEFAULT '1' NOT NULL, - enable_smilies number(1) DEFAULT '1' NOT NULL, - enable_magic_url number(1) DEFAULT '1' NOT NULL, - enable_sig number(1) DEFAULT '1' NOT NULL, - post_username varchar2(255) NULL, - post_subject varchar2(1000) NOT NULL, - post_text clob NOT NULL, - post_checksum varchar2(32) NOT NULL, - post_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, - post_attachment number(1) DEFAULT '0' NOT NULL, - bbcode_bitfield number(11) DEFAULT '0' NOT NULL, - bbcode_uid varchar2(5) DEFAULT '', - post_edit_time number(11) DEFAULT '0' NULL, - post_edit_reason varchar2(1000) NULL, - post_edit_user number(8) DEFAULT '0' NULL, - post_edit_count number(5) DEFAULT '0' NULL, - post_edit_locked number(1) DEFAULT '0' NULL, - CONSTRAINT pk_phpbb_posts PRIMARY KEY (post_id) + post_id number(8) NOT NULL, + topic_id number(8) DEFAULT '0' NOT NULL, + forum_id number(8) DEFAULT '0' NOT NULL, + poster_id number(8) DEFAULT '0' NOT NULL, + icon_id number(8) DEFAULT '0' NOT NULL, + poster_ip varchar2(40) DEFAULT '' NOT NULL, + post_time number(11) DEFAULT '0' NOT NULL, + post_approved number(1) DEFAULT '1' NOT NULL, + post_reported number(1) DEFAULT '0' NOT NULL, + enable_bbcode number(1) DEFAULT '1' NOT NULL, + enable_smilies number(1) DEFAULT '1' NOT NULL, + enable_magic_url number(1) DEFAULT '1' NOT NULL, + enable_sig number(1) DEFAULT '1' NOT NULL, + post_username varchar2(255) DEFAULT '' NOT NULL, + post_subject varchar2(1000) DEFAULT '' NOT NULL, + post_text clob DEFAULT '' NOT NULL, + post_checksum varchar2(32) DEFAULT '' NOT NULL, + post_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, + post_attachment number(1) DEFAULT '0' NOT NULL, + bbcode_bitfield number(11) DEFAULT '0' NOT NULL, + bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + post_edit_time number(11) DEFAULT '0' NOT NULL, + post_edit_reason varchar2(3000) DEFAULT '' NOT NULL, + post_edit_user number(8) DEFAULT '0' NOT NULL, + post_edit_count number(4) DEFAULT '0' NOT NULL, + post_edit_locked number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_posts PRIMARY KEY (post_id) ) / +CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id) +/ +CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id) +/ +CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip) +/ +CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id) +/ +CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved) +/ +CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time) +/ + CREATE SEQUENCE phpbb_posts_seq / CREATE OR REPLACE TRIGGER ai_phpbb_posts_seq BEFORE INSERT ON phpbb_posts FOR EACH ROW WHEN ( - new.post_id IS NULL OR new.post_id = 0 + new.post_id IS NULL OR new.post_id = 0 ) BEGIN - SELECT phpbb_posts_seq.nextval - INTO :new.post_id - FROM dual; + SELECT phpbb_posts_seq.nextval + INTO :new.post_id + FROM dual; END; / -CREATE INDEX phpbb_posts_forum_id on phpbb_posts (forum_id) -/ -CREATE INDEX phpbb_posts_topic_id on phpbb_posts (topic_id) -/ -CREATE INDEX phpbb_posts_poster_ip on phpbb_posts (poster_ip) + +/* Table: 'phpbb_privmsgs' */ +CREATE TABLE phpbb_privmsgs ( + msg_id number(8) NOT NULL, + root_level number(8) DEFAULT '0' NOT NULL, + author_id number(8) DEFAULT '0' NOT NULL, + icon_id number(8) DEFAULT '0' NOT NULL, + author_ip varchar2(40) DEFAULT '' NOT NULL, + message_time number(11) DEFAULT '0' NOT NULL, + enable_bbcode number(1) DEFAULT '1' NOT NULL, + enable_smilies number(1) DEFAULT '1' NOT NULL, + enable_magic_url number(1) DEFAULT '1' NOT NULL, + enable_sig number(1) DEFAULT '1' NOT NULL, + message_subject varchar2(1000) DEFAULT '' NOT NULL, + message_text clob DEFAULT '' NOT NULL, + message_edit_reason varchar2(3000) DEFAULT '' NOT NULL, + message_edit_user number(8) DEFAULT '0' NOT NULL, + message_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, + message_attachment number(1) DEFAULT '0' NOT NULL, + bbcode_bitfield number(11) DEFAULT '0' NOT NULL, + bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + message_edit_time number(11) DEFAULT '0' NOT NULL, + message_edit_count number(4) DEFAULT '0' NOT NULL, + to_address clob DEFAULT '' NOT NULL, + bcc_address clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id) +) / -CREATE INDEX phpbb_posts_poster_id on phpbb_posts (poster_id) + +CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs (author_ip) / -CREATE INDEX phpbb_posts_post_approved on phpbb_posts (post_approved) +CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs (message_time) / -CREATE INDEX phpbb_posts_post_time on phpbb_posts (post_time) +CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs (author_id) / - - -/* - Table: phpbb_privmsgs -*/ -CREATE TABLE phpbb_privmsgs ( - msg_id number(8) NOT NULL, - root_level number(8) DEFAULT '0' NOT NULL, - author_id number(8) DEFAULT '0' NOT NULL, - icon_id number(4) DEFAULT '0' NOT NULL, - author_ip varchar2(40) DEFAULT '', - message_time number(11) DEFAULT '0' NOT NULL, - enable_bbcode number(1) DEFAULT '1' NOT NULL, - enable_smilies number(1) DEFAULT '1' NOT NULL, - enable_magic_url number(1) DEFAULT '1' NOT NULL, - enable_sig number(1) DEFAULT '1' NOT NULL, - message_subject varchar2(3000) NOT NULL, - message_text clob NOT NULL, - message_edit_reason varchar2(3000) NULL, - message_edit_user number(8) DEFAULT '0' NULL, - message_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, - message_attachment number(1) DEFAULT '0' NOT NULL, - bbcode_bitfield number(11) DEFAULT '0' NOT NULL, - bbcode_uid varchar2(5) DEFAULT '', - message_edit_time number(11) DEFAULT '0' NULL, - message_edit_count number(5) DEFAULT '0' NULL, - to_address clob NOT NULL, - bcc_address clob NOT NULL, - CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id) -) +CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level) / CREATE SEQUENCE phpbb_privmsgs_seq @@ -908,717 +856,691 @@ CREATE SEQUENCE phpbb_privmsgs_seq CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_seq BEFORE INSERT ON phpbb_privmsgs FOR EACH ROW WHEN ( - new.msg_id IS NULL OR new.msg_id = 0 + new.msg_id IS NULL OR new.msg_id = 0 ) BEGIN - SELECT phpbb_privmsgs_seq.nextval - INTO :new.msg_id - FROM dual; + SELECT phpbb_privmsgs_seq.nextval + INTO :new.msg_id + FROM dual; END; / -CREATE INDEX phpbb_privmsgs_author_ip on phpbb_privmsgs (author_ip) -/ -CREATE INDEX phpbb_privmsgs_message_time on phpbb_privmsgs (message_time) -/ -CREATE INDEX phpbb_privmsgs_author_id on phpbb_privmsgs (author_id) -/ -CREATE INDEX phpbb_privmsgs_root_level on phpbb_privmsgs (root_level) -/ - -/* - Table: phpbb_privmsgs_folder -*/ +/* Table: 'phpbb_privmsgs_folder' */ CREATE TABLE phpbb_privmsgs_folder ( - folder_id number(8) NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - folder_name varchar2(255) DEFAULT '', - pm_count number(8) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id) + folder_id number(8) NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + folder_name varchar2(255) DEFAULT '' NOT NULL, + pm_count number(8) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id) ) / +CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder (user_id) +/ + CREATE SEQUENCE phpbb_privmsgs_folder_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_fldr_seq +CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_folder_seq BEFORE INSERT ON phpbb_privmsgs_folder FOR EACH ROW WHEN ( - new.folder_id IS NULL OR new.folder_id = 0 + new.folder_id IS NULL OR new.folder_id = 0 ) BEGIN - SELECT phpbb_privmsgs_folder_seq.nextval - INTO :new.folder_id - FROM dual; + SELECT phpbb_privmsgs_folder_seq.nextval + INTO :new.folder_id + FROM dual; END; / -CREATE INDEX phpbb_privmsgs_folder_user_id on phpbb_privmsgs_folder (user_id) -/ - -/* - Table: phpbb_privmsgs_rules -*/ +/* Table: 'phpbb_privmsgs_rules' */ CREATE TABLE phpbb_privmsgs_rules ( - rule_id number(8) NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - rule_check number(4) DEFAULT '0' NOT NULL, - rule_connection number(4) DEFAULT '0' NOT NULL, - rule_string varchar2(255) DEFAULT '', - rule_user_id number(8) DEFAULT '0' NOT NULL, - rule_group_id number(8) DEFAULT '0' NOT NULL, - rule_action number(4) DEFAULT '0' NOT NULL, - rule_folder_id number(8) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_privmsgs_rules PRIMARY KEY (rule_id) + rule_id number(8) NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + rule_check number(8) DEFAULT '0' NOT NULL, + rule_connection number(8) DEFAULT '0' NOT NULL, + rule_string varchar2(255) DEFAULT '' NOT NULL, + rule_user_id number(8) DEFAULT '0' NOT NULL, + rule_group_id number(8) DEFAULT '0' NOT NULL, + rule_action number(8) DEFAULT '0' NOT NULL, + rule_folder_id number(8) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_privmsgs_rules PRIMARY KEY (rule_id) ) / + CREATE SEQUENCE phpbb_privmsgs_rules_seq / CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_rules_seq BEFORE INSERT ON phpbb_privmsgs_rules FOR EACH ROW WHEN ( - new.rule_id IS NULL OR new.rule_id = 0 + new.rule_id IS NULL OR new.rule_id = 0 ) BEGIN - SELECT phpbb_privmsgs_rules_seq.nextval - INTO :new.rule_id - FROM dual; + SELECT phpbb_privmsgs_rules_seq.nextval + INTO :new.rule_id + FROM dual; END; / -/* - Table: phpbb_privmsgs_to -*/ +/* Table: 'phpbb_privmsgs_to' */ CREATE TABLE phpbb_privmsgs_to ( - msg_id number(8) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - author_id number(8) DEFAULT '0' NOT NULL, - deleted number(1) DEFAULT '0' NOT NULL, - new number(1) DEFAULT '1' NOT NULL, - unread number(1) DEFAULT '1' NOT NULL, - replied number(1) DEFAULT '0' NOT NULL, - marked number(1) DEFAULT '0' NOT NULL, - forwarded number(1) DEFAULT '0' NOT NULL, - folder_id number(10) DEFAULT '0' NOT NULL + msg_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + author_id number(8) DEFAULT '0' NOT NULL, + pm_deleted number(1) DEFAULT '0' NOT NULL, + pm_new number(1) DEFAULT '1' NOT NULL, + pm_unread number(1) DEFAULT '1' NOT NULL, + pm_replied number(1) DEFAULT '0' NOT NULL, + pm_marked number(1) DEFAULT '0' NOT NULL, + pm_forwarded number(1) DEFAULT '0' NOT NULL, + folder_id number(8) DEFAULT '0' NOT NULL ) / -CREATE INDEX phpbb_privmsgs_to_msg_id on phpbb_privmsgs_to (msg_id) +CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id) / -CREATE INDEX phpbb_privmsgs_to_user_id on phpbb_privmsgs_to (user_id, folder_id) +CREATE INDEX phpbb_privmsgs_to_user_folder_id ON phpbb_privmsgs_to (user_id, folder_id) / - -/* - Table: phpbb_profile_fields -*/ +/* Table: 'phpbb_profile_fields' */ CREATE TABLE phpbb_profile_fields ( - field_id number(8) NOT NULL, - field_name varchar2(255) DEFAULT '', - field_type number(8) DEFAULT '0' NOT NULL, - field_ident varchar2(20) DEFAULT '', - field_length varchar2(20) DEFAULT '', - field_minlen varchar2(255) DEFAULT '', - field_maxlen varchar2(255) DEFAULT '', - field_novalue varchar2(255) DEFAULT '', - field_default_value varchar2(255) DEFAULT '0' NOT NULL, - field_validation varchar2(20) DEFAULT '', - field_required number(1) DEFAULT '0' NOT NULL, - field_show_on_reg number(1) DEFAULT '0' NOT NULL, - field_hide number(1) DEFAULT '0' NOT NULL, - field_no_view number(1) DEFAULT '0' NOT NULL, - field_active number(1) DEFAULT '0' NOT NULL, - field_order number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_profile_fields PRIMARY KEY (field_id) + field_id number(8) NOT NULL, + field_name varchar2(255) DEFAULT '' NOT NULL, + field_type number(4) DEFAULT '0' NOT NULL, + field_ident varchar2(20) DEFAULT '' NOT NULL, + field_length varchar2(20) DEFAULT '' NOT NULL, + field_minlen varchar2(255) DEFAULT '' NOT NULL, + field_maxlen varchar2(255) DEFAULT '' NOT NULL, + field_novalue varchar2(255) DEFAULT '' NOT NULL, + field_default_value varchar2(255) DEFAULT '' NOT NULL, + field_validation varchar2(20) DEFAULT '' NOT NULL, + field_required number(1) DEFAULT '0' NOT NULL, + field_show_on_reg number(1) DEFAULT '0' NOT NULL, + field_hide number(1) DEFAULT '0' NOT NULL, + field_no_view number(1) DEFAULT '0' NOT NULL, + field_active number(1) DEFAULT '0' NOT NULL, + field_order number(8) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_profile_fields PRIMARY KEY (field_id) ) / +CREATE INDEX phpbb_profile_fields_field_type ON phpbb_profile_fields (field_type) +/ +CREATE INDEX phpbb_profile_fields_field_order ON phpbb_profile_fields (field_order) +/ + CREATE SEQUENCE phpbb_profile_fields_seq / CREATE OR REPLACE TRIGGER ai_phpbb_profile_fields_seq BEFORE INSERT ON phpbb_profile_fields FOR EACH ROW WHEN ( - new.field_id IS NULL OR new.field_id = 0 + new.field_id IS NULL OR new.field_id = 0 ) BEGIN - SELECT phpbb_profile_fields_seq.nextval - INTO :new.field_id - FROM dual; + SELECT phpbb_profile_fields_seq.nextval + INTO :new.field_id + FROM dual; END; / -CREATE INDEX phpbb_profile_fields_field_typ on phpbb_profile_fields (field_type) -/ -CREATE INDEX phpbb_profile_fields_fld_order on phpbb_profile_fields (field_order) -/ - -/* - Table: phpbb_profile_fields_data -*/ +/* Table: 'phpbb_profile_fields_data' */ CREATE TABLE phpbb_profile_fields_data ( - user_id number(8) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id) + user_id number(8) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_profile_fields_data PRIMARY KEY (user_id) ) / -/* - Table: phpbb_profile_fields_lang -*/ +/* Table: 'phpbb_profile_fields_lang' */ CREATE TABLE phpbb_profile_fields_lang ( - field_id number(8) DEFAULT '0' NOT NULL, - lang_id number(8) DEFAULT '0' NOT NULL, - option_id number(8) DEFAULT '0' NOT NULL, - field_type number(4) DEFAULT '0' NOT NULL, - value varchar2(255) DEFAULT '', - CONSTRAINT pk_phpbb_profile_fields_lang PRIMARY KEY (field_id, lang_id, option_id) + field_id number(8) DEFAULT '0' NOT NULL, + lang_id number(8) DEFAULT '0' NOT NULL, + option_id number(8) DEFAULT '0' NOT NULL, + field_type number(4) DEFAULT '0' NOT NULL, + lang_value varchar2(255) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_profile_fields_lang PRIMARY KEY (field_id, lang_id, option_id) ) / -/* - Table: phpbb_profile_lang -*/ +/* Table: 'phpbb_profile_lang' */ CREATE TABLE phpbb_profile_lang ( - field_id number(8) DEFAULT '0' NOT NULL, - lang_id number(4) DEFAULT '0' NOT NULL, - lang_name varchar2(255) DEFAULT '', - lang_explain clob, - lang_default_value varchar2(255) DEFAULT '', - CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id) + field_id number(8) DEFAULT '0' NOT NULL, + lang_id number(8) DEFAULT '0' NOT NULL, + lang_name varchar2(255) DEFAULT '' NOT NULL, + lang_explain clob DEFAULT '' NOT NULL, + lang_default_value varchar2(255) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id) ) / -/* - Table: phpbb_ranks -*/ +/* Table: 'phpbb_ranks' */ CREATE TABLE phpbb_ranks ( - rank_id number(5) NOT NULL, - rank_title varchar2(255) NOT NULL, - rank_min number(8) DEFAULT '0' NOT NULL, - rank_special number(1) DEFAULT '0', - rank_image varchar2(255), - CONSTRAINT pk_phpbb_ranks PRIMARY KEY (rank_id) + rank_id number(8) NOT NULL, + rank_title varchar2(255) DEFAULT '' NOT NULL, + rank_min number(8) DEFAULT '0' NOT NULL, + rank_special number(1) DEFAULT '0' NOT NULL, + rank_image varchar2(255) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_ranks PRIMARY KEY (rank_id) ) / + CREATE SEQUENCE phpbb_ranks_seq / CREATE OR REPLACE TRIGGER ai_phpbb_ranks_seq BEFORE INSERT ON phpbb_ranks FOR EACH ROW WHEN ( - new.rank_id IS NULL OR new.rank_id = 0 + new.rank_id IS NULL OR new.rank_id = 0 ) BEGIN - SELECT phpbb_ranks_seq.nextval - INTO :new.rank_id - FROM dual; + SELECT phpbb_ranks_seq.nextval + INTO :new.rank_id + FROM dual; END; / -/* - Table: phpbb_reports -*/ +/* Table: 'phpbb_reports' */ CREATE TABLE phpbb_reports ( - report_id number(5) NOT NULL, - reason_id number(5) DEFAULT '0' NOT NULL, - post_id number(8) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - user_notify number(1) DEFAULT '0' NOT NULL, - report_closed number(1) DEFAULT '0' NOT NULL, - report_time number(11) DEFAULT '0' NOT NULL, - report_text clob, - CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) + report_id number(8) NOT NULL, + reason_id number(4) DEFAULT '0' NOT NULL, + post_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + user_notify number(1) DEFAULT '0' NOT NULL, + report_closed number(1) DEFAULT '0' NOT NULL, + report_time number(11) DEFAULT '0' NOT NULL, + report_text clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) ) / + CREATE SEQUENCE phpbb_reports_seq / CREATE OR REPLACE TRIGGER ai_phpbb_reports_seq BEFORE INSERT ON phpbb_reports FOR EACH ROW WHEN ( - new.report_id IS NULL OR new.report_id = 0 + new.report_id IS NULL OR new.report_id = 0 ) BEGIN - SELECT phpbb_reports_seq.nextval - INTO :new.report_id - FROM dual; + SELECT phpbb_reports_seq.nextval + INTO :new.report_id + FROM dual; END; / -/* - Table: phpbb_reports_reasons -*/ +/* Table: 'phpbb_reports_reasons' */ CREATE TABLE phpbb_reports_reasons ( - reason_id number(6) NOT NULL, - reason_title varchar2(255) DEFAULT '', - reason_description clob, - reason_order number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id) + reason_id number(4) NOT NULL, + reason_title varchar2(255) DEFAULT '' NOT NULL, + reason_description clob DEFAULT '' NOT NULL, + reason_order number(4) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id) ) / + CREATE SEQUENCE phpbb_reports_reasons_seq / CREATE OR REPLACE TRIGGER ai_phpbb_reports_reasons_seq BEFORE INSERT ON phpbb_reports_reasons FOR EACH ROW WHEN ( - new.reason_id IS NULL OR new.reason_id = 0 + new.reason_id IS NULL OR new.reason_id = 0 ) BEGIN - SELECT phpbb_reports_reasons_seq.nextval - INTO :new.reason_id - FROM dual; + SELECT phpbb_reports_reasons_seq.nextval + INTO :new.reason_id + FROM dual; END; / -/* - Table: phpbb_search_results -*/ +/* Table: 'phpbb_search_results' */ CREATE TABLE phpbb_search_results ( - search_key varchar2(32) DEFAULT '', - search_time number(11) DEFAULT '0' NOT NULL, - search_keywords clob, - search_authors clob, - CONSTRAINT pk_phpbb_search_results PRIMARY KEY (search_key) + search_key varchar2(32) DEFAULT '' NOT NULL, + search_time number(11) DEFAULT '0' NOT NULL, + search_keywords clob DEFAULT '' NOT NULL, + search_authors clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_search_results PRIMARY KEY (search_key) ) / -/* - Table: phpbb_search_wordlist -*/ +/* Table: 'phpbb_search_wordlist' */ CREATE TABLE phpbb_search_wordlist ( - word_text varchar2(252) DEFAULT '', - word_id number(8) NOT NULL, - word_common number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_text) + word_text varchar2(252) DEFAULT '' NOT NULL, + word_id number(8) NOT NULL, + word_common number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_text) ) / +CREATE INDEX phpbb_search_wordlist_word_id ON phpbb_search_wordlist (word_id) +/ + CREATE SEQUENCE phpbb_search_wordlist_seq / CREATE OR REPLACE TRIGGER ai_phpbb_search_wordlist_seq BEFORE INSERT ON phpbb_search_wordlist FOR EACH ROW WHEN ( - new.word_id IS NULL OR new.word_id = 0 + new.word_id IS NULL OR new.word_id = 0 ) BEGIN - SELECT phpbb_search_wordlist_seq.nextval - INTO :new.word_id - FROM dual; + SELECT phpbb_search_wordlist_seq.nextval + INTO :new.word_id + FROM dual; END; / -CREATE INDEX phpbb_search_wordlist_word_id on phpbb_search_wordlist (word_id) -/ - -/* - Table: phpbb_search_wordmatch -*/ +/* Table: 'phpbb_search_wordmatch' */ CREATE TABLE phpbb_search_wordmatch ( - post_id number(8) DEFAULT '0' NOT NULL, - word_id number(8) DEFAULT '0' NOT NULL, - title_match number(1) DEFAULT '0' NOT NULL + post_id number(8) DEFAULT '0' NOT NULL, + word_id number(8) DEFAULT '0' NOT NULL, + title_match number(1) DEFAULT '0' NOT NULL ) / -CREATE INDEX phpbb_search_wordmatch_word_id on phpbb_search_wordmatch (word_id) +CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id) / - -/* - Table: phpbb_sessions -*/ +/* Table: 'phpbb_sessions' */ CREATE TABLE phpbb_sessions ( - session_id varchar2(32) DEFAULT '', - session_user_id number(8) DEFAULT '0' NOT NULL, - session_last_visit number(11) DEFAULT '0' NOT NULL, - session_start number(11) DEFAULT '0' NOT NULL, - session_time number(11) DEFAULT '0' NOT NULL, - session_ip varchar2(40) DEFAULT '0' NOT NULL, - session_browser varchar2(150) DEFAULT '', - session_page varchar2(200) DEFAULT '', - session_viewonline number(1) DEFAULT '1' NOT NULL, - session_autologin number(1) DEFAULT '0' NOT NULL, - session_admin number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_sessions PRIMARY KEY (session_id) + session_id char(32) DEFAULT '' NOT NULL, + session_user_id number(8) DEFAULT '0' NOT NULL, + session_last_visit number(11) DEFAULT '0' NOT NULL, + session_start number(11) DEFAULT '0' NOT NULL, + session_time number(11) DEFAULT '0' NOT NULL, + session_ip varchar2(40) DEFAULT '' NOT NULL, + session_browser varchar2(150) DEFAULT '' NOT NULL, + session_page varchar2(255) DEFAULT '' NOT NULL, + session_viewonline number(1) DEFAULT '1' NOT NULL, + session_autologin number(1) DEFAULT '0' NOT NULL, + session_admin number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_sessions PRIMARY KEY (session_id) ) / -CREATE INDEX phpbb_sessions_session_time on phpbb_sessions (session_time) +CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time) / -CREATE INDEX phpbb_sessions_session_user_id on phpbb_sessions (session_user_id) +CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id) / - -/* - Table: phpbb_sessions_keys -*/ +/* Table: 'phpbb_sessions_keys' */ CREATE TABLE phpbb_sessions_keys ( - key_id varchar2(32) DEFAULT '', - user_id number(8) DEFAULT '0' NOT NULL, - last_ip varchar2(40) DEFAULT '', - last_login number(11) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_sessions_keys PRIMARY KEY (key_id,user_id) + key_id char(32) DEFAULT '' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + last_ip varchar2(40) DEFAULT '' NOT NULL, + last_login number(11) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_sessions_keys PRIMARY KEY (key_id, user_id) ) / -CREATE INDEX phpbb_sessions_keys_last_login on phpbb_sessions_keys (last_login) +CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys (last_login) / - -/* - Table: phpbb_sitelist -*/ +/* Table: 'phpbb_sitelist' */ CREATE TABLE phpbb_sitelist ( - site_id number(8) NOT NULL, - site_ip varchar2(40) DEFAULT '', - site_hostname varchar2(255) DEFAULT '', - ip_exclude number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_sitelist PRIMARY KEY (site_id) + site_id number(8) NOT NULL, + site_ip varchar2(40) DEFAULT '' NOT NULL, + site_hostname varchar2(255) DEFAULT '' NOT NULL, + ip_exclude number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_sitelist PRIMARY KEY (site_id) ) / + CREATE SEQUENCE phpbb_sitelist_seq / CREATE OR REPLACE TRIGGER ai_phpbb_sitelist_seq BEFORE INSERT ON phpbb_sitelist FOR EACH ROW WHEN ( - new.site_id IS NULL OR new.site_id = 0 + new.site_id IS NULL OR new.site_id = 0 ) BEGIN - SELECT phpbb_sitelist_seq.nextval - INTO :new.site_id - FROM dual; + SELECT phpbb_sitelist_seq.nextval + INTO :new.site_id + FROM dual; END; / -/* - Table: phpbb_smilies -*/ +/* Table: 'phpbb_smilies' */ CREATE TABLE phpbb_smilies ( - smiley_id number(4) NOT NULL, - code varchar2(50), - emotion varchar2(50), - smiley_url varchar2(50), - smiley_width number(4) DEFAULT '0' NOT NULL, - smiley_height number(4) DEFAULT '0' NOT NULL, - smiley_order number(8) DEFAULT '0' NOT NULL, - display_on_posting number(1) DEFAULT '1' NOT NULL, - CONSTRAINT pk_phpbb_smilies PRIMARY KEY (smiley_id) + smiley_id number(8) NOT NULL, + code varchar2(50) DEFAULT '' NOT NULL, + emotion varchar2(50) DEFAULT '' NOT NULL, + smiley_url varchar2(50) DEFAULT '' NOT NULL, + smiley_width number(4) DEFAULT '0' NOT NULL, + smiley_height number(4) DEFAULT '0' NOT NULL, + smiley_order number(8) DEFAULT '0' NOT NULL, + display_on_posting number(1) DEFAULT '1' NOT NULL, + CONSTRAINT pk_phpbb_smilies PRIMARY KEY (smiley_id) ) / +CREATE INDEX phpbb_smilies_display_on_posting ON phpbb_smilies (display_on_posting) +/ + CREATE SEQUENCE phpbb_smilies_seq / CREATE OR REPLACE TRIGGER ai_phpbb_smilies_seq BEFORE INSERT ON phpbb_smilies FOR EACH ROW WHEN ( - new.smiley_id IS NULL OR new.smiley_id = 0 + new.smiley_id IS NULL OR new.smiley_id = 0 ) BEGIN - SELECT phpbb_smilies_seq.nextval - INTO :new.smiley_id - FROM dual; + SELECT phpbb_smilies_seq.nextval + INTO :new.smiley_id + FROM dual; END; / -/* - Table: phpbb_styles -*/ +/* Table: 'phpbb_styles' */ CREATE TABLE phpbb_styles ( - style_id number(4) NOT NULL, - style_name varchar2(255) DEFAULT '', - style_copyright varchar2(255) DEFAULT '', - style_active number(1) DEFAULT '1' NOT NULL, - template_id number(4) DEFAULT '0' NOT NULL, - theme_id number(4) DEFAULT '0' NOT NULL, - imageset_id number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id), - CONSTRAINT u_phpbb_style_name UNIQUE (style_name) + style_id number(4) NOT NULL, + style_name varchar2(255) DEFAULT '' NOT NULL, + style_copyright varchar2(255) DEFAULT '' NOT NULL, + style_active number(1) DEFAULT '1' NOT NULL, + template_id number(4) DEFAULT '0' NOT NULL, + theme_id number(4) DEFAULT '0' NOT NULL, + imageset_id number(4) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id), + CONSTRAINT u_phpbb_style_name UNIQUE (style_name) ) / +CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id) +/ +CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id) +/ +CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id) +/ + CREATE SEQUENCE phpbb_styles_seq / CREATE OR REPLACE TRIGGER ai_phpbb_styles_seq BEFORE INSERT ON phpbb_styles FOR EACH ROW WHEN ( - new.style_id IS NULL OR new.style_id = 0 + new.style_id IS NULL OR new.style_id = 0 ) BEGIN - SELECT phpbb_styles_seq.nextval - INTO :new.style_id - FROM dual; + SELECT phpbb_styles_seq.nextval + INTO :new.style_id + FROM dual; END; / -CREATE INDEX phpbb_styles_template_id on phpbb_styles (template_id) -/ -CREATE INDEX phpbb_styles_theme_id on phpbb_styles (theme_id) -/ -CREATE INDEX phpbb_styles_imageset_id on phpbb_styles (imageset_id) -/ - -/* - Table: phpbb_styles_template -*/ +/* Table: 'phpbb_styles_template' */ CREATE TABLE phpbb_styles_template ( - template_id number(4) NOT NULL, - template_name varchar2(255) NOT NULL, - template_copyright varchar2(255) NOT NULL, - template_path varchar2(100) NOT NULL, - bbcode_bitfield number(11) DEFAULT '6921' NOT NULL, - template_storedb number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id), - CONSTRAINT u_phpbb_template_name UNIQUE (template_name) + template_id number(4) NOT NULL, + template_name varchar2(255) DEFAULT '' NOT NULL, + template_copyright varchar2(255) DEFAULT '' NOT NULL, + template_path varchar2(100) DEFAULT '' NOT NULL, + bbcode_bitfield number(11) DEFAULT '6921' NOT NULL, + template_storedb number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_styles_template PRIMARY KEY (template_id), + CONSTRAINT u_phpbb_template_name UNIQUE (template_name) ) / + CREATE SEQUENCE phpbb_styles_template_seq / CREATE OR REPLACE TRIGGER ai_phpbb_styles_template_seq BEFORE INSERT ON phpbb_styles_template FOR EACH ROW WHEN ( - new.template_id IS NULL OR new.template_id = 0 + new.template_id IS NULL OR new.template_id = 0 ) BEGIN - SELECT phpbb_styles_template_seq.nextval - INTO :new.template_id - FROM dual; + SELECT phpbb_styles_template_seq.nextval + INTO :new.template_id + FROM dual; END; / -/* - Table: phpbb_styles_template_data -*/ +/* Table: 'phpbb_styles_template_data' */ CREATE TABLE phpbb_styles_template_data ( - template_id number(4) NOT NULL DEFAULT '0', - template_filename varchar2(100) DEFAULT '', - template_included clob, - template_mtime number(11) DEFAULT '0' NOT NULL, - template_data clob + template_id number(4) NOT NULL, + template_filename varchar2(100) DEFAULT '' NOT NULL, + template_included clob DEFAULT '' NOT NULL, + template_mtime number(11) DEFAULT '0' NOT NULL, + template_data clob DEFAULT '' NOT NULL ) / -CREATE INDEX phpbb_sty_tmplt_dt_tmplate_id on phpbb_styles_template_data (template_id) +CREATE INDEX phpbb_styles_template_data_template_id ON phpbb_styles_template_data (template_id) / -CREATE INDEX phpbb_sty_tmplt_dt_tmplt_fname on phpbb_styles_template_data (template_filename) +CREATE INDEX phpbb_styles_template_data_template_filename ON phpbb_styles_template_data (template_filename) / +CREATE SEQUENCE phpbb_styles_template_data_seq +/ -/* - Table: phpbb_styles_theme -*/ +CREATE OR REPLACE TRIGGER ai_phpbb_styles_template_data_seq +BEFORE INSERT ON phpbb_styles_template_data +FOR EACH ROW WHEN ( + new.template_id IS NULL OR new.template_id = 0 +) +BEGIN + SELECT phpbb_styles_template_data_seq.nextval + INTO :new.template_id + FROM dual; +END; +/ + + +/* Table: 'phpbb_styles_theme' */ CREATE TABLE phpbb_styles_theme ( - theme_id number(4) NOT NULL, - theme_name varchar2(255) DEFAULT '', - theme_copyright varchar2(255) DEFAULT '', - theme_path varchar2(100) DEFAULT '', - theme_storedb number(1) DEFAULT '0' NOT NULL, - theme_mtime number(11) DEFAULT '0' NOT NULL, - theme_data clob, - CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id), - CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name) + theme_id number(4) NOT NULL, + theme_name varchar2(255) DEFAULT '' NOT NULL, + theme_copyright varchar2(255) DEFAULT '' NOT NULL, + theme_path varchar2(100) DEFAULT '' NOT NULL, + theme_storedb number(1) DEFAULT '0' NOT NULL, + theme_mtime number(11) DEFAULT '0' NOT NULL, + theme_data clob DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id), + CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name) ) / + CREATE SEQUENCE phpbb_styles_theme_seq / CREATE OR REPLACE TRIGGER ai_phpbb_styles_theme_seq BEFORE INSERT ON phpbb_styles_theme FOR EACH ROW WHEN ( - new.theme_id IS NULL OR new.theme_id = 0 + new.theme_id IS NULL OR new.theme_id = 0 ) BEGIN - SELECT phpbb_styles_theme_seq.nextval - INTO :new.theme_id - FROM dual; + SELECT phpbb_styles_theme_seq.nextval + INTO :new.theme_id + FROM dual; END; / -/* - Table: phpbb_styles_imageset -*/ +/* Table: 'phpbb_styles_imageset' */ CREATE TABLE phpbb_styles_imageset ( - imageset_id number(4) NOT NULL, - imageset_name varchar2(255) DEFAULT '', - imageset_copyright varchar2(255) DEFAULT '', - imageset_path varchar2(100) DEFAULT '', - site_logo varchar2(200) DEFAULT '', - btn_post varchar2(200) DEFAULT '', - btn_post_pm varchar2(200) DEFAULT '', - btn_reply varchar2(200) DEFAULT '', - btn_reply_pm varchar2(200) DEFAULT '', - btn_locked varchar2(200) DEFAULT '', - btn_profile varchar2(200) DEFAULT '', - btn_pm varchar2(200) DEFAULT '', - btn_delete varchar2(200) DEFAULT '', - btn_info varchar2(200) DEFAULT '', - btn_quote varchar2(200) DEFAULT '', - btn_search varchar2(200) DEFAULT '', - btn_edit varchar2(200) DEFAULT '', - btn_report varchar2(200) DEFAULT '', - btn_email varchar2(200) DEFAULT '', - btn_www varchar2(200) DEFAULT '', - btn_icq varchar2(200) DEFAULT '', - btn_aim varchar2(200) DEFAULT '', - btn_yim varchar2(200) DEFAULT '', - btn_msnm varchar2(200) DEFAULT '', - btn_jabber varchar2(200) DEFAULT '', - btn_online varchar2(200) DEFAULT '', - btn_offline varchar2(200) DEFAULT '', - btn_friend varchar2(200) DEFAULT '', - btn_foe varchar2(200) DEFAULT '', - icon_unapproved varchar2(200) DEFAULT '', - icon_reported varchar2(200) DEFAULT '', - icon_attach varchar2(200) DEFAULT '', - icon_post varchar2(200) DEFAULT '', - icon_post_new varchar2(200) DEFAULT '', - icon_post_latest varchar2(200) DEFAULT '', - icon_post_newest varchar2(200) DEFAULT '', - forum varchar2(200) DEFAULT '', - forum_new varchar2(200) DEFAULT '', - forum_locked varchar2(200) DEFAULT '', - forum_link varchar2(200) DEFAULT '', - sub_forum varchar2(200) DEFAULT '', - sub_forum_new varchar2(200) DEFAULT '', - folder varchar2(200) DEFAULT '', - folder_moved varchar2(200) DEFAULT '', - folder_posted varchar2(200) DEFAULT '', - folder_new varchar2(200) DEFAULT '', - folder_new_posted varchar2(200) DEFAULT '', - folder_hot varchar2(200) DEFAULT '', - folder_hot_posted varchar2(200) DEFAULT '', - folder_hot_new varchar2(200) DEFAULT '', - folder_hot_new_posted varchar2(200) DEFAULT '', - folder_locked varchar2(200) DEFAULT '', - folder_locked_posted varchar2(200) DEFAULT '', - folder_locked_new varchar2(200) DEFAULT '', - folder_locked_new_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_announce varchar2(200) DEFAULT '' NOT NULL, - folder_locked_announce_new varchar2(200) DEFAULT '' NOT NULL, - folder_locked_announce_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_announce_new_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_global varchar2(200) DEFAULT '' NOT NULL, - folder_locked_global_new varchar2(200) DEFAULT '' NOT NULL, - folder_locked_global_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_global_new_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_sticky varchar2(200) DEFAULT '' NOT NULL, - folder_locked_sticky_new varchar2(200) DEFAULT '' NOT NULL, - folder_locked_sticky_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL, - folder_sticky varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_posted varchar2(200) DEFAULT '', - folder_sticky_new varchar2(200) DEFAULT '', - folder_sticky_new_posted varchar2(200) DEFAULT '', - folder_announce varchar2(200) DEFAULT '', - folder_announce_posted varchar2(200) DEFAULT '', - folder_announce_new varchar2(200) DEFAULT '', - folder_announce_new_posted varchar2(200) DEFAULT '', - folder_global varchar2(200) DEFAULT '', - folder_global_posted varchar2(200) DEFAULT '', - folder_global_new varchar2(200) DEFAULT '', - folder_global_new_posted varchar2(200) DEFAULT '', - poll_left varchar2(200) DEFAULT '', - poll_center varchar2(200) DEFAULT '', - poll_right varchar2(200) DEFAULT '', - attach_progress_bar varchar2(200) DEFAULT '', - user_icon1 varchar2(200) DEFAULT '', - user_icon2 varchar2(200) DEFAULT '', - user_icon3 varchar2(200) DEFAULT '', - user_icon4 varchar2(200) DEFAULT '', - user_icon5 varchar2(200) DEFAULT '', - user_icon6 varchar2(200) DEFAULT '', - user_icon7 varchar2(200) DEFAULT '', - user_icon8 varchar2(200) DEFAULT '', - user_icon9 varchar2(200) DEFAULT '', - user_icon10 varchar2(200) DEFAULT '', - CONSTRAINT pk_phpbb_styles_imageset PRIMARY KEY (imageset_id), - CONSTRAINT u_phpbb_imageset_name UNIQUE (imageset_name) + imageset_id number(4) NOT NULL, + imageset_name varchar2(255) DEFAULT '' NOT NULL, + imageset_copyright varchar2(255) DEFAULT '' NOT NULL, + imageset_path varchar2(100) DEFAULT '' NOT NULL, + site_logo varchar2(200) DEFAULT '' NOT NULL, + btn_post varchar2(200) DEFAULT '' NOT NULL, + btn_post_pm varchar2(200) DEFAULT '' NOT NULL, + btn_reply varchar2(200) DEFAULT '' NOT NULL, + btn_reply_pm varchar2(200) DEFAULT '' NOT NULL, + btn_locked varchar2(200) DEFAULT '' NOT NULL, + btn_profile varchar2(200) DEFAULT '' NOT NULL, + btn_pm varchar2(200) DEFAULT '' NOT NULL, + btn_delete varchar2(200) DEFAULT '' NOT NULL, + btn_info varchar2(200) DEFAULT '' NOT NULL, + btn_quote varchar2(200) DEFAULT '' NOT NULL, + btn_search varchar2(200) DEFAULT '' NOT NULL, + btn_edit varchar2(200) DEFAULT '' NOT NULL, + btn_report varchar2(200) DEFAULT '' NOT NULL, + btn_email varchar2(200) DEFAULT '' NOT NULL, + btn_www varchar2(200) DEFAULT '' NOT NULL, + btn_icq varchar2(200) DEFAULT '' NOT NULL, + btn_aim varchar2(200) DEFAULT '' NOT NULL, + btn_yim varchar2(200) DEFAULT '' NOT NULL, + btn_msnm varchar2(200) DEFAULT '' NOT NULL, + btn_jabber varchar2(200) DEFAULT '' NOT NULL, + btn_online varchar2(200) DEFAULT '' NOT NULL, + btn_offline varchar2(200) DEFAULT '' NOT NULL, + btn_friend varchar2(200) DEFAULT '' NOT NULL, + btn_foe varchar2(200) DEFAULT '' NOT NULL, + icon_unapproved varchar2(200) DEFAULT '' NOT NULL, + icon_reported varchar2(200) DEFAULT '' NOT NULL, + icon_attach varchar2(200) DEFAULT '' NOT NULL, + icon_post varchar2(200) DEFAULT '' NOT NULL, + icon_post_new varchar2(200) DEFAULT '' NOT NULL, + icon_post_latest varchar2(200) DEFAULT '' NOT NULL, + icon_post_newest varchar2(200) DEFAULT '' NOT NULL, + forum varchar2(200) DEFAULT '' NOT NULL, + forum_new varchar2(200) DEFAULT '' NOT NULL, + forum_locked varchar2(200) DEFAULT '' NOT NULL, + forum_link varchar2(200) DEFAULT '' NOT NULL, + sub_forum varchar2(200) DEFAULT '' NOT NULL, + sub_forum_new varchar2(200) DEFAULT '' NOT NULL, + folder varchar2(200) DEFAULT '' NOT NULL, + folder_moved varchar2(200) DEFAULT '' NOT NULL, + folder_posted varchar2(200) DEFAULT '' NOT NULL, + folder_new varchar2(200) DEFAULT '' NOT NULL, + folder_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_hot varchar2(200) DEFAULT '' NOT NULL, + folder_hot_posted varchar2(200) DEFAULT '' NOT NULL, + folder_hot_new varchar2(200) DEFAULT '' NOT NULL, + folder_hot_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked varchar2(200) DEFAULT '' NOT NULL, + folder_locked_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_sticky varchar2(200) DEFAULT '' NOT NULL, + folder_sticky_posted varchar2(200) DEFAULT '' NOT NULL, + folder_sticky_new varchar2(200) DEFAULT '' NOT NULL, + folder_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_announce varchar2(200) DEFAULT '' NOT NULL, + folder_announce_posted varchar2(200) DEFAULT '' NOT NULL, + folder_announce_new varchar2(200) DEFAULT '' NOT NULL, + folder_announce_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_global varchar2(200) DEFAULT '' NOT NULL, + folder_global_posted varchar2(200) DEFAULT '' NOT NULL, + folder_global_new varchar2(200) DEFAULT '' NOT NULL, + folder_global_new_posted varchar2(200) DEFAULT '' NOT NULL, + poll_left varchar2(200) DEFAULT '' NOT NULL, + poll_center varchar2(200) DEFAULT '' NOT NULL, + poll_right varchar2(200) DEFAULT '' NOT NULL, + attach_progress_bar varchar2(200) DEFAULT '' NOT NULL, + user_icon1 varchar2(200) DEFAULT '' NOT NULL, + user_icon2 varchar2(200) DEFAULT '' NOT NULL, + user_icon3 varchar2(200) DEFAULT '' NOT NULL, + user_icon4 varchar2(200) DEFAULT '' NOT NULL, + user_icon5 varchar2(200) DEFAULT '' NOT NULL, + user_icon6 varchar2(200) DEFAULT '' NOT NULL, + user_icon7 varchar2(200) DEFAULT '' NOT NULL, + user_icon8 varchar2(200) DEFAULT '' NOT NULL, + user_icon9 varchar2(200) DEFAULT '' NOT NULL, + user_icon10 varchar2(200) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_styles_imageset PRIMARY KEY (imageset_id), + CONSTRAINT u_phpbb_imageset_name UNIQUE (imageset_name) ) / + CREATE SEQUENCE phpbb_styles_imageset_seq / CREATE OR REPLACE TRIGGER ai_phpbb_styles_imageset_seq BEFORE INSERT ON phpbb_styles_imageset FOR EACH ROW WHEN ( - new.imageset_id IS NULL OR new.imageset_id = 0 + new.imageset_id IS NULL OR new.imageset_id = 0 ) BEGIN - SELECT phpbb_styles_imageset_seq.nextval - INTO :new.imageset_id - FROM dual; + SELECT phpbb_styles_imageset_seq.nextval + INTO :new.imageset_id + FROM dual; END; / -/* - Table: phpbb_topics -*/ +/* Table: 'phpbb_topics' */ CREATE TABLE phpbb_topics ( - topic_id number(8) NOT NULL, - forum_id number(5) DEFAULT '0' NOT NULL, - icon_id number(4) DEFAULT '1' NOT NULL, - topic_attachment number(1) DEFAULT '0' NOT NULL, - topic_approved number(1) DEFAULT '1' NOT NULL, - topic_reported number(1) DEFAULT '0' NOT NULL, - topic_title varchar2(1000), - topic_poster number(8) DEFAULT '0' NOT NULL, - topic_time number(11) DEFAULT '0' NOT NULL, - topic_time_limit number(11) DEFAULT '0' NOT NULL, - topic_views number(8) DEFAULT '0' NOT NULL, - topic_replies number(8) DEFAULT '0' NOT NULL, - topic_replies_real number(8) DEFAULT '0' NOT NULL, - topic_status number(3) DEFAULT '0' NOT NULL, - topic_type number(3) DEFAULT '0' NOT NULL, - topic_first_post_id number(8) DEFAULT '0' NOT NULL, - topic_first_poster_name varchar2(255), - topic_last_post_id number(8) DEFAULT '0' NOT NULL, - topic_last_poster_id number(8) DEFAULT '0' NOT NULL, - topic_last_poster_name varchar2(255), - topic_last_post_time number(11) DEFAULT '0' NOT NULL, - topic_last_view_time number(11) DEFAULT '0' NOT NULL, - topic_moved_id number(8) DEFAULT '0' NOT NULL, - topic_bumped number(1) DEFAULT '0' NOT NULL, - topic_bumper number(8) DEFAULT '0' NOT NULL, - poll_title varchar2(3000) NULL, - poll_start number(11) DEFAULT '0' NULL, - poll_length number(11) DEFAULT '0' NULL, - poll_max_options number(4) DEFAULT '1' NOT NULL, - poll_last_vote number(11) DEFAULT '0', - poll_vote_change number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_topics PRIMARY KEY (topic_id) -) + topic_id number(8) NOT NULL, + forum_id number(8) DEFAULT '0' NOT NULL, + icon_id number(8) DEFAULT '0' NOT NULL, + topic_attachment number(1) DEFAULT '0' NOT NULL, + topic_approved number(1) DEFAULT '1' NOT NULL, + topic_reported number(1) DEFAULT '0' NOT NULL, + topic_title varchar2(1000) DEFAULT '' NOT NULL, + topic_poster number(8) DEFAULT '0' NOT NULL, + topic_time number(11) DEFAULT '0' NOT NULL, + topic_time_limit number(11) DEFAULT '0' NOT NULL, + topic_views number(8) DEFAULT '0' NOT NULL, + topic_replies number(8) DEFAULT '0' NOT NULL, + topic_replies_real number(8) DEFAULT '0' NOT NULL, + topic_status number(3) DEFAULT '0' NOT NULL, + topic_type number(3) DEFAULT '0' NOT NULL, + topic_first_post_id number(8) DEFAULT '0' NOT NULL, + topic_first_poster_name varchar2(255) DEFAULT '' NOT NULL, + topic_last_post_id number(8) DEFAULT '0' NOT NULL, + topic_last_poster_id number(8) DEFAULT '0' NOT NULL, + topic_last_poster_name varchar2(255) DEFAULT '' NOT NULL, + topic_last_post_time number(11) DEFAULT '0' NOT NULL, + topic_last_view_time number(11) DEFAULT '0' NOT NULL, + topic_moved_id number(8) DEFAULT '0' NOT NULL, + topic_bumped number(1) DEFAULT '0' NOT NULL, + topic_bumper number(8) DEFAULT '0' NOT NULL, + poll_title varchar2(1000) DEFAULT '' NOT NULL, + poll_start number(11) DEFAULT '0' NOT NULL, + poll_length number(11) DEFAULT '0' NOT NULL, + poll_max_options number(4) DEFAULT '1' NOT NULL, + poll_last_vote number(11) DEFAULT '0' NOT NULL, + poll_vote_change number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_topics PRIMARY KEY (topic_id) +) +/ + +CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id) +/ +CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type) +/ +CREATE INDEX phpbb_topics_topic_last_post_time ON phpbb_topics (topic_last_post_time) / CREATE SEQUENCE phpbb_topics_seq @@ -1627,163 +1549,152 @@ CREATE SEQUENCE phpbb_topics_seq CREATE OR REPLACE TRIGGER ai_phpbb_topics_seq BEFORE INSERT ON phpbb_topics FOR EACH ROW WHEN ( - new.topic_id IS NULL OR new.topic_id = 0 + new.topic_id IS NULL OR new.topic_id = 0 ) BEGIN - SELECT phpbb_topics_seq.nextval - INTO :new.topic_id - FROM dual; + SELECT phpbb_topics_seq.nextval + INTO :new.topic_id + FROM dual; END; / -CREATE INDEX phpbb_topics_forum_id on phpbb_topics (forum_id) -/ -CREATE INDEX phpbb_topics_forum_id_type on phpbb_topics (forum_id, topic_type) -/ -CREATE INDEX phpbb_topics_last_post_time on phpbb_topics (topic_last_post_time) -/ - -/* - Table: phpbb_topics_track -*/ +/* Table: 'phpbb_topics_track' */ CREATE TABLE phpbb_topics_track ( - user_id number(8) DEFAULT '0' NOT NULL, - topic_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_topics_track PRIMARY KEY (user_id, topic_id) + user_id number(8) DEFAULT '0' NOT NULL, + topic_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_topics_track PRIMARY KEY (user_id, topic_id) ) / -CREATE INDEX phpbb_topics_track_forum_id on phpbb_topics_track (forum_id) +CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id) / - -/* - Table: phpbb_topics_posted -*/ +/* Table: 'phpbb_topics_posted' */ CREATE TABLE phpbb_topics_posted ( - user_id number(8) DEFAULT '0' NOT NULL, - topic_id number(8) DEFAULT '0' NOT NULL, - topic_posted number(4) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_topics_posted PRIMARY KEY (user_id, topic_id) + user_id number(8) DEFAULT '0' NOT NULL, + topic_id number(8) DEFAULT '0' NOT NULL, + topic_posted number(1) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_topics_posted PRIMARY KEY (user_id, topic_id) ) / -/* - Table: phpbb_topics_watch -*/ +/* Table: 'phpbb_topics_watch' */ CREATE TABLE phpbb_topics_watch ( - topic_id number(8) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - notify_status number(1) DEFAULT '0' NOT NULL + topic_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_topics_watch_topic_id on phpbb_topics_watch (topic_id) +CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch (topic_id) / -CREATE INDEX phpbb_topics_watch_user_id on phpbb_topics_watch (user_id) +CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch (user_id) / -CREATE INDEX phpbb_topics_watch_notify_stat on phpbb_topics_watch (notify_status) +CREATE INDEX phpbb_topics_watch_notify_status ON phpbb_topics_watch (notify_status) / - -/* - Table: phpbb_user_group -*/ +/* Table: 'phpbb_user_group' */ CREATE TABLE phpbb_user_group ( - group_id number(8) DEFAULT '0' NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - group_leader number(1) DEFAULT '0' NOT NULL, - user_pending number(1) + group_id number(8) DEFAULT '0' NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + group_leader number(1) DEFAULT '0' NOT NULL, + user_pending number(1) DEFAULT '1' NOT NULL ) / -CREATE INDEX phpbb_user_group_group_id on phpbb_user_group (group_id) +CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id) / -CREATE INDEX phpbb_user_group_user_id on phpbb_user_group (user_id) +CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id) / -CREATE INDEX phpbb_user_group_group_leader on phpbb_user_group (group_leader) +CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group (group_leader) / - -/* - Table: phpbb_users -*/ +/* Table: 'phpbb_users' */ CREATE TABLE phpbb_users ( - user_id number(8) NOT NULL, - user_type number(1) DEFAULT '0' NOT NULL, - group_id number(8) DEFAULT '3' NOT NULL, - user_permissions clob NULL, - user_perm_from number(8) DEFAULT '0' NOT NULL, - user_ip varchar2(40) DEFAULT '', - user_regdate number(11) DEFAULT '0' NOT NULL, - username varchar2(255) DEFAULT '', - user_password varchar2(40) DEFAULT '', - user_passchg number(11) DEFAULT '0' NULL, - user_email varchar2(100) DEFAULT '', - user_email_hash number(20) DEFAULT '0' NOT NULL, - user_birthday varchar2(10) DEFAULT '' NULL, - user_lastvisit number(11) DEFAULT '0' NOT NULL, - user_lastmark number(11) DEFAULT '0' NOT NULL, - user_lastpost_time number(11) DEFAULT '0' NOT NULL, - user_lastpage varchar2(200) DEFAULT '', - user_last_confirm_key varchar2(10) DEFAULT '' NULL, - user_last_search number(11) DEFAULT '0' NULL, - user_warnings number(4) DEFAULT '0' NULL, - user_last_warning number(11) DEFAULT '0' NULL, - user_login_attempts number(4) DEFAULT '0' NULL, - user_posts number(8) DEFAULT '0' NOT NULL, - user_lang varchar2(30) DEFAULT '', - user_timezone number(5, 2) DEFAULT '0' NOT NULL, - user_dst number(1) DEFAULT '0' NOT NULL, - user_dateformat varchar2(30) DEFAULT 'd M Y H:i' NOT NULL, - user_style number(4) DEFAULT '0' NOT NULL, - user_rank number(11) DEFAULT '0' NULL, - user_colour varchar2(6) DEFAULT '', - user_new_privmsg number(4) DEFAULT '0' NOT NULL, - user_unread_privmsg number(4) DEFAULT '0' NOT NULL, - user_last_privmsg number(11) DEFAULT '0' NOT NULL, - user_message_rules number(1) DEFAULT '0' NOT NULL, - user_full_folder number(11) DEFAULT '-3' NOT NULL, - user_emailtime number(11) DEFAULT '0' NOT NULL, - user_topic_show_days number(4) DEFAULT '0' NOT NULL, - user_topic_sortby_type varchar2(1) DEFAULT 't', - user_topic_sortby_dir varchar2(1) DEFAULT 'd', - user_post_show_days number(4) DEFAULT '0' NOT NULL, - user_post_sortby_type varchar2(1) DEFAULT 't', - user_post_sortby_dir varchar2(1) DEFAULT 'a', - user_notify number(1) DEFAULT '0' NOT NULL, - user_notify_pm number(1) DEFAULT '1' NOT NULL, - user_notify_type number(4) DEFAULT '0' NOT NULL, - user_allow_pm number(1) DEFAULT '1' NOT NULL, - user_allow_email number(1) DEFAULT '1' NOT NULL, - user_allow_viewonline number(1) DEFAULT '1' NOT NULL, - user_allow_viewemail number(1) DEFAULT '1' NOT NULL, - user_allow_massemail number(1) DEFAULT '1' NOT NULL, - user_options number(11) DEFAULT '893' NOT NULL, - user_avatar varchar2(255) DEFAULT '', - user_avatar_type number(2) DEFAULT '0' NOT NULL, - user_avatar_width number(4) DEFAULT '0' NOT NULL, - user_avatar_height number(4) DEFAULT '0' NOT NULL, - user_sig clob NULL, - user_sig_bbcode_uid varchar2(5) DEFAULT '' NULL, - user_sig_bbcode_bitfield number(11) DEFAULT '0' NULL, - user_from varchar2(100) DEFAULT '' NULL, - user_icq varchar2(15) DEFAULT '' NULL, - user_aim varchar2(255) DEFAULT '' NULL, - user_yim varchar2(255) DEFAULT '' NULL, - user_msnm varchar2(255) DEFAULT '' NULL, - user_jabber varchar2(255) DEFAULT '' NULL, - user_website varchar2(200) DEFAULT '' NULL, - user_occ varchar2(255) DEFAULT '' NULL, - user_interests varchar2(255) DEFAULT '' NULL, - user_actkey varchar2(32) DEFAULT '', - user_newpasswd varchar2(32) DEFAULT '' NULL, - CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id) -) + user_id number(8) NOT NULL, + user_type number(2) DEFAULT '0' NOT NULL, + group_id number(8) DEFAULT '3' NOT NULL, + user_permissions clob DEFAULT '' NOT NULL, + user_perm_from number(8) DEFAULT '0' NOT NULL, + user_ip varchar2(40) DEFAULT '' NOT NULL, + user_regdate number(11) DEFAULT '0' NOT NULL, + username varchar2(255) DEFAULT '' NOT NULL, + user_password varchar2(40) DEFAULT '' NOT NULL, + user_passchg number(11) DEFAULT '0' NOT NULL, + user_email varchar2(100) DEFAULT '' NOT NULL, + user_email_hash number(20) DEFAULT '0' NOT NULL, + user_birthday varchar2(10) DEFAULT '' NOT NULL, + user_lastvisit number(11) DEFAULT '0' NOT NULL, + user_lastmark number(11) DEFAULT '0' NOT NULL, + user_lastpost_time number(11) DEFAULT '0' NOT NULL, + user_lastpage varchar2(200) DEFAULT '' NOT NULL, + user_last_confirm_key varchar2(10) DEFAULT '' NOT NULL, + user_last_search number(11) DEFAULT '0' NOT NULL, + user_warnings number(4) DEFAULT '0' NOT NULL, + user_last_warning number(11) DEFAULT '0' NOT NULL, + user_login_attempts number(4) DEFAULT '0' NOT NULL, + user_posts number(8) DEFAULT '0' NOT NULL, + user_lang varchar2(30) DEFAULT '' NOT NULL, + user_timezone number(5, 2) DEFAULT '0' NOT NULL, + user_dst number(1) DEFAULT '0' NOT NULL, + user_dateformat varchar2(30) DEFAULT 'd M Y H:i' NOT NULL, + user_style number(4) DEFAULT '0' NOT NULL, + user_rank number(8) DEFAULT '0' NOT NULL, + user_colour varchar2(6) DEFAULT '' NOT NULL, + user_new_privmsg number(4) DEFAULT '0' NOT NULL, + user_unread_privmsg number(4) DEFAULT '0' NOT NULL, + user_last_privmsg number(11) DEFAULT '0' NOT NULL, + user_message_rules number(1) DEFAULT '0' NOT NULL, + user_full_folder number(11) DEFAULT '-3' NOT NULL, + user_emailtime number(11) DEFAULT '0' NOT NULL, + user_topic_show_days number(4) DEFAULT '0' NOT NULL, + user_topic_sortby_type varchar2(1) DEFAULT 't' NOT NULL, + user_topic_sortby_dir varchar2(1) DEFAULT 'd' NOT NULL, + user_post_show_days number(4) DEFAULT '0' NOT NULL, + user_post_sortby_type varchar2(1) DEFAULT 't' NOT NULL, + user_post_sortby_dir varchar2(1) DEFAULT 'a' NOT NULL, + user_notify number(1) DEFAULT '0' NOT NULL, + user_notify_pm number(1) DEFAULT '1' NOT NULL, + user_notify_type number(4) DEFAULT '0' NOT NULL, + user_allow_pm number(1) DEFAULT '1' NOT NULL, + user_allow_email number(1) DEFAULT '1' NOT NULL, + user_allow_viewonline number(1) DEFAULT '1' NOT NULL, + user_allow_viewemail number(1) DEFAULT '1' NOT NULL, + user_allow_massemail number(1) DEFAULT '1' NOT NULL, + user_options number(11) DEFAULT '893' NOT NULL, + user_avatar varchar2(255) DEFAULT '' NOT NULL, + user_avatar_type number(2) DEFAULT '0' NOT NULL, + user_avatar_width number(4) DEFAULT '0' NOT NULL, + user_avatar_height number(4) DEFAULT '0' NOT NULL, + user_sig clob DEFAULT '' NOT NULL, + user_sig_bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + user_sig_bbcode_bitfield number(11) DEFAULT '0' NOT NULL, + user_from varchar2(100) DEFAULT '' NOT NULL, + user_icq varchar2(15) DEFAULT '' NOT NULL, + user_aim varchar2(255) DEFAULT '' NOT NULL, + user_yim varchar2(255) DEFAULT '' NOT NULL, + user_msnm varchar2(255) DEFAULT '' NOT NULL, + user_jabber varchar2(255) DEFAULT '' NOT NULL, + user_website varchar2(200) DEFAULT '' NOT NULL, + user_occ varchar2(255) DEFAULT '' NOT NULL, + user_interests clob DEFAULT '' NOT NULL, + user_actkey varchar2(32) DEFAULT '' NOT NULL, + user_newpasswd varchar2(32) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id) +) +/ + +CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday) +/ +CREATE INDEX phpbb_users_user_email_hash ON phpbb_users (user_email_hash) +/ +CREATE INDEX phpbb_users_user_type ON phpbb_users (user_type) +/ +CREATE INDEX phpbb_users_username ON phpbb_users (username) / CREATE SEQUENCE phpbb_users_seq @@ -1792,92 +1703,81 @@ CREATE SEQUENCE phpbb_users_seq CREATE OR REPLACE TRIGGER ai_phpbb_users_seq BEFORE INSERT ON phpbb_users FOR EACH ROW WHEN ( - new.user_id IS NULL OR new.user_id = 0 + new.user_id IS NULL OR new.user_id = 0 ) BEGIN - SELECT phpbb_users_seq.nextval - INTO :new.user_id - FROM dual; + SELECT phpbb_users_seq.nextval + INTO :new.user_id + FROM dual; END; / -CREATE INDEX phpbb_users_user_birthday on phpbb_users (user_birthday) -/ -CREATE INDEX phpbb_users_user_email_hash on phpbb_users (user_email_hash) -/ -CREATE INDEX phpbb_users_username on phpbb_users (username) -/ - -/* - Table: phpbb_warnings -*/ +/* Table: 'phpbb_warnings' */ CREATE TABLE phpbb_warnings ( - warning_id number(8) NOT NULL, - user_id number(8) DEFAULT '0' NOT NULL, - post_id number(8) DEFAULT '0' NOT NULL, - log_id number(8) DEFAULT '0' NOT NULL, - warning_time number(11) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_warnings PRIMARY KEY (warning_id) + warning_id number(8) NOT NULL, + user_id number(8) DEFAULT '0' NOT NULL, + post_id number(8) DEFAULT '0' NOT NULL, + log_id number(8) DEFAULT '0' NOT NULL, + warning_time number(11) DEFAULT '0' NOT NULL, + CONSTRAINT pk_phpbb_warnings PRIMARY KEY (warning_id) ) / -CREATE SEQUENCE sq_phpbb_warnings_warning_id + +CREATE SEQUENCE phpbb_warnings_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_warnings_warning_id +CREATE OR REPLACE TRIGGER ai_phpbb_warnings_seq BEFORE INSERT ON phpbb_warnings FOR EACH ROW WHEN ( - new.warning_id IS NULL OR new.warning_id = 0 + new.warning_id IS NULL OR new.warning_id = 0 ) BEGIN - SELECT sq_phpbb_warnings_warning_id.nextval - INTO :new.warning_id - FROM dual; + SELECT phpbb_warnings_seq.nextval + INTO :new.warning_id + FROM dual; END; / -/* - Table: phpbb_words -*/ +/* Table: 'phpbb_words' */ CREATE TABLE phpbb_words ( - word_id number(8) NOT NULL, - word varchar2(255) NOT NULL, - replacement varchar2(255) NOT NULL, - CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id) + word_id number(8) NOT NULL, + word varchar2(255) DEFAULT '' NOT NULL, + replacement varchar2(255) DEFAULT '' NOT NULL, + CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id) ) / -CREATE SEQUENCE sq_phpbb_words_word_id + +CREATE SEQUENCE phpbb_words_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_words_word_id +CREATE OR REPLACE TRIGGER ai_phpbb_words_seq BEFORE INSERT ON phpbb_words FOR EACH ROW WHEN ( - new.word_id IS NULL OR new.word_id = 0 + new.word_id IS NULL OR new.word_id = 0 ) BEGIN - SELECT sq_phpbb_words_word_id.nextval - INTO :new.word_id - FROM dual; + SELECT phpbb_words_seq.nextval + INTO :new.word_id + FROM dual; END; / -/* - Table: phpbb_zebra -*/ +/* Table: 'phpbb_zebra' */ CREATE TABLE phpbb_zebra ( - user_id number(8) DEFAULT '0' NOT NULL, - zebra_id number(8) DEFAULT '0' NOT NULL, - friend number(1) DEFAULT '0' NOT NULL, - foe number(1) DEFAULT '0' NOT NULL + user_id number(8) DEFAULT '0' NOT NULL, + zebra_id number(8) DEFAULT '0' NOT NULL, + friend number(1) DEFAULT '0' NOT NULL, + foe number(1) DEFAULT '0' NOT NULL ) / -CREATE INDEX phpbb_zebra_user_id on phpbb_zebra (user_id) +CREATE INDEX phpbb_zebra_user_id ON phpbb_zebra (user_id) / -CREATE INDEX phpbb_zebra_zebra_id on phpbb_zebra (zebra_id) +CREATE INDEX phpbb_zebra_zebra_id ON phpbb_zebra (zebra_id) / |