diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-08-05 15:49:28 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-08-05 15:49:28 +0000 |
| commit | b4b901b82552e639cae00c4dc38542cf6fe2d873 (patch) | |
| tree | 27a02a9b1861ef07cd22dd19e6b970a82945e490 /phpBB/install/schemas/oracle_schema.sql | |
| parent | 0a007bd5d746892459201306363c38cbdec36bc2 (diff) | |
| download | forums-b4b901b82552e639cae00c4dc38542cf6fe2d873.tar forums-b4b901b82552e639cae00c4dc38542cf6fe2d873.tar.gz forums-b4b901b82552e639cae00c4dc38542cf6fe2d873.tar.bz2 forums-b4b901b82552e639cae00c4dc38542cf6fe2d873.tar.xz forums-b4b901b82552e639cae00c4dc38542cf6fe2d873.zip | |
- fixed some bugs
- made imageset naming more consistent
- updated every schema to be consistent and also fixed it (every db should install fine now)
-
git-svn-id: file:///svn/phpbb/trunk@6237 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 889 |
1 files changed, 508 insertions, 381 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index f6a1038d2d..98450307d4 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -17,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; @@ -42,19 +42,21 @@ DISCONNECT; CONNECT phpbb/phpbb_password; */ -/* Table: 'phpbb_attachments' */ +/* + 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) DEFAULT '' NOT NULL, - real_filename varchar2(255) DEFAULT '' NOT NULL, + physical_filename varchar2(255) DEFAULT '' , + real_filename varchar2(255) DEFAULT '' , 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, + attach_comment clob DEFAULT '' , + extension varchar2(100) DEFAULT '' , + mimetype varchar2(100) DEFAULT '' , filesize number(20) DEFAULT '0' NOT NULL, filetime number(11) DEFAULT '0' NOT NULL, thumbnail number(1) DEFAULT '0' NOT NULL, @@ -76,7 +78,7 @@ CREATE INDEX phpbb_attachments_filesize ON phpbb_attachments (filesize) CREATE SEQUENCE phpbb_attachments_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_attachments_seq +CREATE OR REPLACE TRIGGER t_phpbb_attachments BEFORE INSERT ON phpbb_attachments FOR EACH ROW WHEN ( new.attach_id IS NULL OR new.attach_id = 0 @@ -89,7 +91,9 @@ END; / -/* 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, @@ -101,13 +105,15 @@ CREATE TABLE phpbb_acl_groups ( CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups (group_id) / -CREATE INDEX phpbb_acl_groups_auth_option_id ON phpbb_acl_groups (auth_option_id) +CREATE INDEX phpbb_acl_groups_auth_opt_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) DEFAULT '' NOT NULL, + auth_option varchar2(50) DEFAULT '' , is_global number(1) DEFAULT '0' NOT NULL, is_local number(1) DEFAULT '0' NOT NULL, founder_only number(1) DEFAULT '0' NOT NULL, @@ -121,7 +127,7 @@ 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 +CREATE OR REPLACE TRIGGER t_phpbb_acl_options BEFORE INSERT ON phpbb_acl_options FOR EACH ROW WHEN ( new.auth_option_id IS NULL OR new.auth_option_id = 0 @@ -134,12 +140,14 @@ END; / -/* Table: 'phpbb_acl_roles' */ +/* + Table: 'phpbb_acl_roles' +*/ CREATE TABLE phpbb_acl_roles ( 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_name varchar2(255) DEFAULT '' , + role_description clob DEFAULT '' , + role_type varchar2(10) DEFAULT '' , role_order number(4) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_acl_roles PRIMARY KEY (role_id) ) @@ -153,7 +161,7 @@ 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 +CREATE OR REPLACE TRIGGER t_phpbb_acl_roles BEFORE INSERT ON phpbb_acl_roles FOR EACH ROW WHEN ( new.role_id IS NULL OR new.role_id = 0 @@ -166,7 +174,9 @@ END; / -/* 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, @@ -176,7 +186,9 @@ CREATE TABLE phpbb_acl_roles_data ( / -/* 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, @@ -191,17 +203,19 @@ CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users (user_id) CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users (auth_option_id) / -/* 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 '' NOT NULL, - ban_email varchar2(100) DEFAULT '' 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) DEFAULT '' NOT NULL, - ban_give_reason varchar2(3000) DEFAULT '' NOT NULL, + ban_reason varchar2(3000) DEFAULT '' , + ban_give_reason varchar2(3000) DEFAULT '' , CONSTRAINT pk_phpbb_banlist PRIMARY KEY (ban_id) ) / @@ -210,7 +224,7 @@ CREATE TABLE phpbb_banlist ( CREATE SEQUENCE phpbb_banlist_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_banlist_seq +CREATE OR REPLACE TRIGGER t_phpbb_banlist BEFORE INSERT ON phpbb_banlist FOR EACH ROW WHEN ( new.ban_id IS NULL OR new.ban_id = 0 @@ -223,26 +237,30 @@ END; / -/* Table: 'phpbb_bbcodes' */ +/* + Table: 'phpbb_bbcodes' +*/ CREATE TABLE phpbb_bbcodes ( bbcode_id number(3) DEFAULT '0' NOT NULL, - bbcode_tag varchar2(16) DEFAULT '' NOT NULL, - bbcode_helpline varchar2(255) DEFAULT '' NOT NULL, + bbcode_tag varchar2(16) DEFAULT '' , + bbcode_helpline varchar2(255) DEFAULT '' , 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, + bbcode_match varchar2(255) DEFAULT '' , + bbcode_tpl clob DEFAULT '' , + first_pass_match varchar2(255) DEFAULT '' , + first_pass_replace varchar2(255) DEFAULT '' , + second_pass_match varchar2(255) DEFAULT '' , + second_pass_replace clob DEFAULT '' , CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id) ) / -CREATE INDEX phpbb_bbcodes_display_in_posting ON phpbb_bbcodes (display_on_posting) +CREATE INDEX phpbb_bbcodes_display_on_post 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, @@ -255,14 +273,16 @@ 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) / -/* Table: 'phpbb_bots' */ +/* + Table: 'phpbb_bots' +*/ CREATE TABLE phpbb_bots ( bot_id number(8) NOT NULL, bot_active number(1) DEFAULT '1' NOT NULL, - bot_name varchar2(3000) DEFAULT '' NOT NULL, + bot_name varchar2(3000) DEFAULT '' , user_id number(8) DEFAULT '0' NOT NULL, - bot_agent varchar2(255) DEFAULT '' NOT NULL, - bot_ip varchar2(255) DEFAULT '' NOT NULL, + bot_agent varchar2(255) DEFAULT '' , + bot_ip varchar2(255) DEFAULT '' , CONSTRAINT pk_phpbb_bots PRIMARY KEY (bot_id) ) / @@ -273,7 +293,7 @@ CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active) CREATE SEQUENCE phpbb_bots_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_bots_seq +CREATE OR REPLACE TRIGGER t_phpbb_bots BEFORE INSERT ON phpbb_bots FOR EACH ROW WHEN ( new.bot_id IS NULL OR new.bot_id = 0 @@ -286,10 +306,12 @@ END; / -/* Table: 'phpbb_config' */ +/* + Table: 'phpbb_config' +*/ CREATE TABLE phpbb_config ( - config_name varchar2(255) DEFAULT '' NOT NULL, - config_value varchar2(255) DEFAULT '' NOT NULL, + config_name varchar2(252) DEFAULT '' , + config_value varchar2(255) DEFAULT '' , is_dynamic number(1) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name) ) @@ -298,21 +320,25 @@ CREATE TABLE phpbb_config ( 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 '' NOT NULL, - session_id char(32) DEFAULT '' NOT NULL, + confirm_id char(32) DEFAULT '' , + session_id char(32) DEFAULT '' , confirm_type number(3) DEFAULT '0' NOT NULL, - code varchar2(8) DEFAULT '' NOT NULL, + code varchar2(8) DEFAULT '' , 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 '' NOT NULL, + disallow_username varchar2(252) DEFAULT '' , CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id) ) / @@ -321,7 +347,7 @@ CREATE TABLE phpbb_disallow ( CREATE SEQUENCE phpbb_disallow_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_disallow_seq +CREATE OR REPLACE TRIGGER t_phpbb_disallow BEFORE INSERT ON phpbb_disallow FOR EACH ROW WHEN ( new.disallow_id IS NULL OR new.disallow_id = 0 @@ -334,15 +360,17 @@ 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) DEFAULT '' NOT NULL, - draft_message clob DEFAULT '' NOT NULL, + draft_subject varchar2(1000) DEFAULT '' , + draft_message clob DEFAULT '' , CONSTRAINT pk_phpbb_drafts PRIMARY KEY (draft_id) ) / @@ -353,7 +381,7 @@ CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts (save_time) CREATE SEQUENCE phpbb_drafts_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_drafts_seq +CREATE OR REPLACE TRIGGER t_phpbb_drafts BEFORE INSERT ON phpbb_drafts FOR EACH ROW WHEN ( new.draft_id IS NULL OR new.draft_id = 0 @@ -366,11 +394,13 @@ END; / -/* 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 '' NOT NULL, + extension varchar2(100) DEFAULT '' , CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id) ) / @@ -379,7 +409,7 @@ CREATE TABLE phpbb_extensions ( CREATE SEQUENCE phpbb_extensions_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_extensions_seq +CREATE OR REPLACE TRIGGER t_phpbb_extensions BEFORE INSERT ON phpbb_extensions FOR EACH ROW WHEN ( new.extension_id IS NULL OR new.extension_id = 0 @@ -392,16 +422,18 @@ END; / -/* Table: 'phpbb_extension_groups' */ +/* + Table: 'phpbb_extension_groups' +*/ CREATE TABLE phpbb_extension_groups ( group_id number(8) NOT NULL, - group_name varchar2(255) DEFAULT '' NOT NULL, + group_name varchar2(255) DEFAULT '' , cat_id number(2) DEFAULT '0' NOT NULL, allow_group number(1) DEFAULT '0' NOT NULL, download_mode number(1) DEFAULT '1' NOT NULL, - upload_icon varchar2(255) DEFAULT '' NOT NULL, + upload_icon varchar2(255) DEFAULT '' , max_filesize number(20) DEFAULT '0' NOT NULL, - allowed_forums clob DEFAULT '' NOT NULL, + allowed_forums clob DEFAULT '' , allow_in_pm number(1) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_extension_groups PRIMARY KEY (group_id) ) @@ -411,7 +443,7 @@ CREATE TABLE phpbb_extension_groups ( CREATE SEQUENCE phpbb_extension_groups_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_extension_groups_seq +CREATE OR REPLACE TRIGGER t_phpbb_extension_groups BEFORE INSERT ON phpbb_extension_groups FOR EACH ROW WHEN ( new.group_id IS NULL OR new.group_id = 0 @@ -424,27 +456,29 @@ END; / -/* Table: 'phpbb_forums' */ +/* + Table: 'phpbb_forums' +*/ CREATE TABLE phpbb_forums ( forum_id number(8) NOT NULL, parent_id number(8) DEFAULT '0' NOT NULL, left_id number(8) DEFAULT '0' NOT NULL, right_id number(8) DEFAULT '0' NOT NULL, - forum_parents clob DEFAULT '' NOT NULL, - forum_name varchar2(3000) DEFAULT '' NOT NULL, - forum_desc clob DEFAULT '' NOT NULL, - forum_desc_bitfield raw(255) DEFAULT '' NOT NULL, - forum_desc_options number(1) 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_parents clob DEFAULT '' , + forum_name varchar2(3000) DEFAULT '' , + forum_desc clob DEFAULT '' , + forum_desc_bitfield raw(255) DEFAULT '' , + forum_desc_options 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) 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 raw(255) DEFAULT '' NOT NULL, - forum_rules_options number(1) DEFAULT '0' NOT NULL, - forum_rules_uid varchar2(5) DEFAULT '' NOT NULL, + forum_image varchar2(255) DEFAULT '' , + forum_rules clob DEFAULT '' , + forum_rules_link varchar2(255) DEFAULT '' , + forum_rules_bitfield raw(255) DEFAULT '' , + forum_rules_options 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, @@ -454,7 +488,7 @@ CREATE TABLE phpbb_forums ( 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_last_poster_name varchar2(255) DEFAULT '' , 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, @@ -470,13 +504,13 @@ CREATE TABLE phpbb_forums ( 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 INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums (forum_last_post_id) / CREATE SEQUENCE phpbb_forums_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_forums_seq +CREATE OR REPLACE TRIGGER t_phpbb_forums BEFORE INSERT ON phpbb_forums FOR EACH ROW WHEN ( new.forum_id IS NULL OR new.forum_id = 0 @@ -489,17 +523,21 @@ END; / -/* 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 char(32) DEFAULT '' NOT NULL, + session_id char(32) DEFAULT '' , 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(8) DEFAULT '0' NOT NULL, forum_id number(8) DEFAULT '0' NOT NULL, @@ -509,7 +547,9 @@ CREATE TABLE phpbb_forums_track ( / -/* Table: 'phpbb_forums_watch' */ +/* + Table: 'phpbb_forums_watch' +*/ CREATE TABLE phpbb_forums_watch ( forum_id number(8) DEFAULT '0' NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, @@ -521,25 +561,27 @@ CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch (forum_id) / CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch (user_id) / -CREATE INDEX phpbb_forums_watch_notify_status ON phpbb_forums_watch (notify_status) +CREATE INDEX phpbb_forums_watch_notify_stat 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 '' NOT NULL, - group_desc clob DEFAULT '' NOT NULL, - group_desc_bitfield raw(255) DEFAULT '' NOT NULL, - group_desc_options number(1) DEFAULT '0' NOT NULL, - group_desc_uid varchar2(5) DEFAULT '' NOT NULL, + group_name varchar2(252) DEFAULT '' , + group_desc clob DEFAULT '' , + group_desc_bitfield raw(255) DEFAULT '' , + group_desc_options 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 '' 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(8) DEFAULT '0' NOT NULL, - group_colour varchar2(6) DEFAULT '' 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, @@ -554,7 +596,7 @@ CREATE INDEX phpbb_groups_group_legend ON phpbb_groups (group_legend) CREATE SEQUENCE phpbb_groups_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_groups_seq +CREATE OR REPLACE TRIGGER t_phpbb_groups BEFORE INSERT ON phpbb_groups FOR EACH ROW WHEN ( new.group_id IS NULL OR new.group_id = 0 @@ -567,10 +609,12 @@ END; / -/* Table: 'phpbb_icons' */ +/* + Table: 'phpbb_icons' +*/ CREATE TABLE phpbb_icons ( icons_id number(8) NOT NULL, - icons_url varchar2(255) DEFAULT '' NOT NULL, + icons_url varchar2(255) DEFAULT '' , icons_width number(4) DEFAULT '0' NOT NULL, icons_height number(4) DEFAULT '0' NOT NULL, icons_order number(8) DEFAULT '0' NOT NULL, @@ -579,11 +623,13 @@ CREATE TABLE phpbb_icons ( ) / +CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons (display_on_posting) +/ CREATE SEQUENCE phpbb_icons_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_icons_seq +CREATE OR REPLACE TRIGGER t_phpbb_icons BEFORE INSERT ON phpbb_icons FOR EACH ROW WHEN ( new.icons_id IS NULL OR new.icons_id = 0 @@ -596,14 +642,16 @@ END; / -/* Table: 'phpbb_lang' */ +/* + Table: 'phpbb_lang' +*/ CREATE TABLE phpbb_lang ( lang_id number(4) NOT NULL, - lang_iso varchar2(30) 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, + lang_iso varchar2(30) DEFAULT '' , + lang_dir varchar2(30) DEFAULT '' , + lang_english_name varchar2(100) DEFAULT '' , + lang_local_name varchar2(255) DEFAULT '' , + lang_author varchar2(255) DEFAULT '' , CONSTRAINT pk_phpbb_lang PRIMARY KEY (lang_id) ) / @@ -614,7 +662,7 @@ CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang (lang_iso) CREATE SEQUENCE phpbb_lang_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_lang_seq +CREATE OR REPLACE TRIGGER t_phpbb_lang BEFORE INSERT ON phpbb_lang FOR EACH ROW WHEN ( new.lang_id IS NULL OR new.lang_id = 0 @@ -627,7 +675,9 @@ 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, @@ -635,10 +685,10 @@ CREATE TABLE phpbb_log ( 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_ip varchar2(40) DEFAULT '' , log_time number(11) DEFAULT '0' NOT NULL, - log_operation clob DEFAULT '' NOT NULL, - log_data clob DEFAULT '' NOT NULL, + log_operation clob DEFAULT '' , + log_data clob DEFAULT '' , CONSTRAINT pk_phpbb_log PRIMARY KEY (log_id) ) / @@ -657,7 +707,7 @@ CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id) CREATE SEQUENCE phpbb_log_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_log_seq +CREATE OR REPLACE TRIGGER t_phpbb_log BEFORE INSERT ON phpbb_log FOR EACH ROW WHEN ( new.log_id IS NULL OR new.log_id = 0 @@ -670,35 +720,39 @@ END; / -/* 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 '' NOT NULL, + username varchar2(252) DEFAULT '' , group_id number(8) DEFAULT '0' NOT NULL, - group_name varchar2(255) DEFAULT '' NOT NULL, + group_name varchar2(255) DEFAULT '' , display_on_index number(1) DEFAULT '1' NOT NULL ) / -CREATE INDEX phpbb_moderator_cache_display_on_index ON phpbb_moderator_cache (display_on_index) +CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache (display_on_index) / CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache (forum_id) / -/* Table: 'phpbb_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_basename varchar2(255) DEFAULT '' NOT NULL, - module_class varchar2(10) DEFAULT '' NOT NULL, + module_basename varchar2(255) DEFAULT '' , + module_class varchar2(10) DEFAULT '' , parent_id number(8) DEFAULT '0' NOT NULL, left_id number(8) DEFAULT '0' NOT NULL, right_id number(8) DEFAULT '0' NOT NULL, - module_langname varchar2(255) DEFAULT '' NOT NULL, - module_mode varchar2(255) DEFAULT '' NOT NULL, - module_auth varchar2(255) DEFAULT '' 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) ) / @@ -713,7 +767,7 @@ 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 +CREATE OR REPLACE TRIGGER t_phpbb_modules BEFORE INSERT ON phpbb_modules FOR EACH ROW WHEN ( new.module_id IS NULL OR new.module_id = 0 @@ -726,26 +780,30 @@ END; / -/* 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 clob DEFAULT '' NOT NULL, + poll_option_text clob DEFAULT '' , poll_option_total number(8) DEFAULT '0' NOT NULL ) / -CREATE INDEX phpbb_poll_options_poll_option_id ON phpbb_poll_options (poll_option_id) +CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options (poll_option_id) / CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options (topic_id) / -/* Table: 'phpbb_poll_votes' */ +/* + Table: 'phpbb_poll_votes' +*/ CREATE TABLE phpbb_poll_votes ( topic_id number(8) DEFAULT '0' NOT NULL, poll_option_id number(4) DEFAULT '0' NOT NULL, vote_user_id number(8) DEFAULT '0' NOT NULL, - vote_user_ip varchar2(40) DEFAULT '' NOT NULL + vote_user_ip varchar2(40) DEFAULT '' ) / @@ -756,14 +814,16 @@ 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) / -/* 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(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, + poster_ip varchar2(40) DEFAULT '' , post_time number(11) DEFAULT '0' NOT NULL, post_approved number(1) DEFAULT '1' NOT NULL, post_reported number(1) DEFAULT '0' NOT NULL, @@ -771,17 +831,17 @@ CREATE TABLE phpbb_posts ( 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_username varchar2(252) DEFAULT '' , + post_subject varchar2(1000) DEFAULT '' , + post_text clob DEFAULT '' , + post_checksum varchar2(32) DEFAULT '' , post_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, post_attachment number(1) DEFAULT '0' NOT NULL, - bbcode_bitfield raw(255) DEFAULT '' NOT NULL, - bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + bbcode_bitfield raw(255) DEFAULT '' , + bbcode_uid varchar2(5) DEFAULT '' , post_postcount number(1) DEFAULT '1' NOT NULL, post_edit_time number(11) DEFAULT '0' NOT NULL, - post_edit_reason varchar2(3000) DEFAULT '' NOT NULL, + post_edit_reason varchar2(3000) DEFAULT '' , 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, @@ -807,7 +867,7 @@ CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time) CREATE SEQUENCE phpbb_posts_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_posts_seq +CREATE OR REPLACE TRIGGER t_phpbb_posts BEFORE INSERT ON phpbb_posts FOR EACH ROW WHEN ( new.post_id IS NULL OR new.post_id = 0 @@ -820,30 +880,32 @@ END; / -/* Table: 'phpbb_privmsgs' */ +/* + 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, + 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(1000) DEFAULT '' NOT NULL, - message_text clob DEFAULT '' NOT NULL, - message_edit_reason varchar2(3000) DEFAULT '' NOT NULL, + message_subject varchar2(1000) DEFAULT '' , + message_text clob DEFAULT '' , + message_edit_reason varchar2(3000) DEFAULT '' , 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 raw(255) DEFAULT '' NOT NULL, - bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + bbcode_bitfield raw(255) DEFAULT '' , + bbcode_uid varchar2(5) DEFAULT '' , 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, + to_address clob DEFAULT '' , + bcc_address clob DEFAULT '' , CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id) ) / @@ -860,7 +922,7 @@ CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs (root_level) CREATE SEQUENCE phpbb_privmsgs_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_seq +CREATE OR REPLACE TRIGGER t_phpbb_privmsgs BEFORE INSERT ON phpbb_privmsgs FOR EACH ROW WHEN ( new.msg_id IS NULL OR new.msg_id = 0 @@ -873,11 +935,13 @@ END; / -/* 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 '' NOT NULL, + folder_name varchar2(255) DEFAULT '' , pm_count number(8) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id) ) @@ -889,7 +953,7 @@ 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_folder_seq +CREATE OR REPLACE TRIGGER t_phpbb_privmsgs_folder BEFORE INSERT ON phpbb_privmsgs_folder FOR EACH ROW WHEN ( new.folder_id IS NULL OR new.folder_id = 0 @@ -902,17 +966,19 @@ END; / -/* 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(8) DEFAULT '0' NOT NULL, rule_connection number(8) DEFAULT '0' NOT NULL, - rule_string varchar2(255) DEFAULT '' 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(8) DEFAULT '0' NOT NULL, - rule_folder_id number(8) DEFAULT '0' NOT NULL, + rule_folder_id number(4) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_privmsgs_rules PRIMARY KEY (rule_id) ) / @@ -921,7 +987,7 @@ CREATE TABLE phpbb_privmsgs_rules ( CREATE SEQUENCE phpbb_privmsgs_rules_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_privmsgs_rules_seq +CREATE OR REPLACE TRIGGER t_phpbb_privmsgs_rules BEFORE INSERT ON phpbb_privmsgs_rules FOR EACH ROW WHEN ( new.rule_id IS NULL OR new.rule_id = 0 @@ -934,7 +1000,9 @@ 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, @@ -945,27 +1013,29 @@ CREATE TABLE phpbb_privmsgs_to ( 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 + folder_id number(4) DEFAULT '0' NOT NULL ) / CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id) / -CREATE INDEX phpbb_privmsgs_to_user_folder_id ON phpbb_privmsgs_to (user_id, folder_id) +CREATE INDEX phpbb_privmsgs_to_usr_flder_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 '' NOT NULL, + field_name varchar2(255) DEFAULT '' , 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_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 '' , + 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, @@ -976,15 +1046,15 @@ CREATE TABLE phpbb_profile_fields ( ) / -CREATE INDEX phpbb_profile_fields_field_type ON phpbb_profile_fields (field_type) +CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields (field_type) / -CREATE INDEX phpbb_profile_fields_field_order ON phpbb_profile_fields (field_order) +CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields (field_order) / CREATE SEQUENCE phpbb_profile_fields_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_profile_fields_seq +CREATE OR REPLACE TRIGGER t_phpbb_profile_fields BEFORE INSERT ON phpbb_profile_fields FOR EACH ROW WHEN ( new.field_id IS NULL OR new.field_id = 0 @@ -997,7 +1067,9 @@ END; / -/* 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) @@ -1005,37 +1077,43 @@ CREATE TABLE phpbb_profile_fields_data ( / -/* 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, - lang_value varchar2(255) DEFAULT '' NOT NULL, + lang_value varchar2(255) DEFAULT '' , 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(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, + lang_name varchar2(255) DEFAULT '' , + lang_explain clob DEFAULT '' , + lang_default_value varchar2(255) DEFAULT '' , CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id) ) / -/* Table: 'phpbb_ranks' */ +/* + Table: 'phpbb_ranks' +*/ CREATE TABLE phpbb_ranks ( rank_id number(8) NOT NULL, - rank_title varchar2(255) DEFAULT '' NOT NULL, + rank_title varchar2(255) DEFAULT '' , rank_min number(8) DEFAULT '0' NOT NULL, rank_special number(1) DEFAULT '0' NOT NULL, - rank_image varchar2(255) DEFAULT '' NOT NULL, + rank_image varchar2(255) DEFAULT '' , CONSTRAINT pk_phpbb_ranks PRIMARY KEY (rank_id) ) / @@ -1044,7 +1122,7 @@ CREATE TABLE phpbb_ranks ( CREATE SEQUENCE phpbb_ranks_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_ranks_seq +CREATE OR REPLACE TRIGGER t_phpbb_ranks BEFORE INSERT ON phpbb_ranks FOR EACH ROW WHEN ( new.rank_id IS NULL OR new.rank_id = 0 @@ -1057,7 +1135,9 @@ END; / -/* Table: 'phpbb_reports' */ +/* + Table: 'phpbb_reports' +*/ CREATE TABLE phpbb_reports ( report_id number(8) NOT NULL, reason_id number(4) DEFAULT '0' NOT NULL, @@ -1066,7 +1146,7 @@ CREATE TABLE phpbb_reports ( 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, + report_text clob DEFAULT '' , CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) ) / @@ -1075,7 +1155,7 @@ CREATE TABLE phpbb_reports ( CREATE SEQUENCE phpbb_reports_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_reports_seq +CREATE OR REPLACE TRIGGER t_phpbb_reports BEFORE INSERT ON phpbb_reports FOR EACH ROW WHEN ( new.report_id IS NULL OR new.report_id = 0 @@ -1088,11 +1168,13 @@ END; / -/* Table: 'phpbb_reports_reasons' */ +/* + Table: 'phpbb_reports_reasons' +*/ CREATE TABLE phpbb_reports_reasons ( reason_id number(4) NOT NULL, - reason_title varchar2(255) DEFAULT '' NOT NULL, - reason_description clob DEFAULT '' NOT NULL, + reason_title varchar2(255) DEFAULT '' , + reason_description clob DEFAULT '' , reason_order number(4) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id) ) @@ -1102,7 +1184,7 @@ CREATE TABLE phpbb_reports_reasons ( CREATE SEQUENCE phpbb_reports_reasons_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_reports_reasons_seq +CREATE OR REPLACE TRIGGER t_phpbb_reports_reasons BEFORE INSERT ON phpbb_reports_reasons FOR EACH ROW WHEN ( new.reason_id IS NULL OR new.reason_id = 0 @@ -1115,33 +1197,36 @@ END; / -/* Table: 'phpbb_search_results' */ +/* + Table: 'phpbb_search_results' +*/ CREATE TABLE phpbb_search_results ( - search_key varchar2(32) DEFAULT '' NOT NULL, + search_key varchar2(32) DEFAULT '' , search_time number(11) DEFAULT '0' NOT NULL, - search_keywords clob DEFAULT '' NOT NULL, - search_authors clob DEFAULT '' NOT NULL, + search_keywords clob DEFAULT '' , + search_authors clob DEFAULT '' , 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 '' NOT NULL, word_id number(8) NOT NULL, + word_text varchar2(252) DEFAULT '' , word_common number(1) DEFAULT '0' NOT NULL, - CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_text) + CONSTRAINT pk_phpbb_search_wordlist PRIMARY KEY (word_id), + CONSTRAINT u_phpbb_wrd_txt UNIQUE (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 +CREATE OR REPLACE TRIGGER t_phpbb_search_wordlist BEFORE INSERT ON phpbb_search_wordlist FOR EACH ROW WHEN ( new.word_id IS NULL OR new.word_id = 0 @@ -1154,7 +1239,9 @@ END; / -/* 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, @@ -1165,16 +1252,18 @@ CREATE TABLE phpbb_search_wordmatch ( 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 char(32) DEFAULT '' NOT NULL, + session_id char(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 '' NOT NULL, - session_browser varchar2(150) DEFAULT '' NOT NULL, - session_page varchar2(255) DEFAULT '' NOT NULL, + session_ip varchar2(40) DEFAULT '' , + session_browser varchar2(150) DEFAULT '' , + session_page varchar2(255) 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, @@ -1187,11 +1276,13 @@ CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time) 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 char(32) DEFAULT '' NOT NULL, + key_id char(32) DEFAULT '' , user_id number(8) DEFAULT '0' NOT NULL, - last_ip varchar2(40) DEFAULT '' 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) ) @@ -1200,11 +1291,13 @@ CREATE TABLE phpbb_sessions_keys ( 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 '' NOT NULL, - site_hostname varchar2(255) DEFAULT '' 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) ) @@ -1214,7 +1307,7 @@ CREATE TABLE phpbb_sitelist ( CREATE SEQUENCE phpbb_sitelist_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_sitelist_seq +CREATE OR REPLACE TRIGGER t_phpbb_sitelist BEFORE INSERT ON phpbb_sitelist FOR EACH ROW WHEN ( new.site_id IS NULL OR new.site_id = 0 @@ -1227,12 +1320,14 @@ END; / -/* Table: 'phpbb_smilies' */ +/* + Table: 'phpbb_smilies' +*/ CREATE TABLE phpbb_smilies ( 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, + code varchar2(50) DEFAULT '' , + emotion varchar2(50) DEFAULT '' , + smiley_url varchar2(50) DEFAULT '' , smiley_width number(4) DEFAULT '0' NOT NULL, smiley_height number(4) DEFAULT '0' NOT NULL, smiley_order number(8) DEFAULT '0' NOT NULL, @@ -1241,13 +1336,13 @@ CREATE TABLE phpbb_smilies ( ) / -CREATE INDEX phpbb_smilies_display_on_posting ON phpbb_smilies (display_on_posting) +CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies (display_on_posting) / CREATE SEQUENCE phpbb_smilies_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_smilies_seq +CREATE OR REPLACE TRIGGER t_phpbb_smilies BEFORE INSERT ON phpbb_smilies FOR EACH ROW WHEN ( new.smiley_id IS NULL OR new.smiley_id = 0 @@ -1260,11 +1355,13 @@ END; / -/* Table: 'phpbb_styles' */ +/* + Table: 'phpbb_styles' +*/ CREATE TABLE phpbb_styles ( style_id number(4) NOT NULL, - style_name varchar2(255) DEFAULT '' NOT NULL, - style_copyright varchar2(255) DEFAULT '' NOT NULL, + style_name varchar2(252) 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, @@ -1284,7 +1381,7 @@ CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id) CREATE SEQUENCE phpbb_styles_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_styles_seq +CREATE OR REPLACE TRIGGER t_phpbb_styles BEFORE INSERT ON phpbb_styles FOR EACH ROW WHEN ( new.style_id IS NULL OR new.style_id = 0 @@ -1297,16 +1394,18 @@ END; / -/* Table: 'phpbb_styles_template' */ +/* + Table: 'phpbb_styles_template' +*/ CREATE TABLE phpbb_styles_template ( 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, + template_name varchar2(252) DEFAULT '' , + template_copyright varchar2(255) DEFAULT '' , + template_path varchar2(100) DEFAULT '' , bbcode_bitfield raw(255) DEFAULT '90D8' 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) + CONSTRAINT u_phpbb_tmplte_nm UNIQUE (template_name) ) / @@ -1314,7 +1413,7 @@ CREATE TABLE phpbb_styles_template ( CREATE SEQUENCE phpbb_styles_template_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_styles_template_seq +CREATE OR REPLACE TRIGGER t_phpbb_styles_template BEFORE INSERT ON phpbb_styles_template FOR EACH ROW WHEN ( new.template_id IS NULL OR new.template_id = 0 @@ -1327,25 +1426,27 @@ END; / -/* Table: 'phpbb_styles_template_data' */ +/* + Table: 'phpbb_styles_template_data' +*/ CREATE TABLE phpbb_styles_template_data ( template_id number(4) NOT NULL, - template_filename varchar2(100) DEFAULT '' NOT NULL, - template_included clob DEFAULT '' NOT NULL, + template_filename varchar2(100) DEFAULT '' , + template_included clob DEFAULT '' , template_mtime number(11) DEFAULT '0' NOT NULL, - template_data clob DEFAULT '' NOT NULL + template_data clob DEFAULT '' ) / -CREATE INDEX phpbb_styles_template_data_template_id ON phpbb_styles_template_data (template_id) +CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data (template_id) / -CREATE INDEX phpbb_styles_template_data_template_filename ON phpbb_styles_template_data (template_filename) +CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data (template_filename) / CREATE SEQUENCE phpbb_styles_template_data_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_styles_template_data_seq +CREATE OR REPLACE TRIGGER t_phpbb_styles_template_data BEFORE INSERT ON phpbb_styles_template_data FOR EACH ROW WHEN ( new.template_id IS NULL OR new.template_id = 0 @@ -1358,15 +1459,17 @@ END; / -/* Table: 'phpbb_styles_theme' */ +/* + Table: 'phpbb_styles_theme' +*/ CREATE TABLE phpbb_styles_theme ( 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_name varchar2(252) 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 DEFAULT '' NOT NULL, + theme_data clob DEFAULT '' , CONSTRAINT pk_phpbb_styles_theme PRIMARY KEY (theme_id), CONSTRAINT u_phpbb_theme_name UNIQUE (theme_name) ) @@ -1376,7 +1479,7 @@ CREATE TABLE phpbb_styles_theme ( CREATE SEQUENCE phpbb_styles_theme_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_styles_theme_seq +CREATE OR REPLACE TRIGGER t_phpbb_styles_theme BEFORE INSERT ON phpbb_styles_theme FOR EACH ROW WHEN ( new.theme_id IS NULL OR new.theme_id = 0 @@ -1389,104 +1492,110 @@ 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 '' 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_warn 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_post varchar2(200) DEFAULT '' NOT NULL, - folder_new varchar2(200) DEFAULT '' NOT NULL, - folder_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_hot varchar2(200) DEFAULT '' NOT NULL, - folder_hot_post varchar2(200) DEFAULT '' NOT NULL, - folder_hot_new varchar2(200) DEFAULT '' NOT NULL, - folder_hot_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock varchar2(200) DEFAULT '' NOT NULL, - folder_lock_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_new varchar2(200) DEFAULT '' NOT NULL, - folder_lock_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_announce varchar2(200) DEFAULT '' NOT NULL, - folder_lock_announce_new varchar2(200) DEFAULT '' NOT NULL, - folder_lock_announce_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_announce_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_global varchar2(200) DEFAULT '' NOT NULL, - folder_lock_global_new varchar2(200) DEFAULT '' NOT NULL, - folder_lock_global_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_global_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_sticky varchar2(200) DEFAULT '' NOT NULL, - folder_lock_sticky_new varchar2(200) DEFAULT '' NOT NULL, - folder_lock_sticky_post varchar2(200) DEFAULT '' NOT NULL, - folder_lock_sticky_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_sticky varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_post varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_new varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_announce varchar2(200) DEFAULT '' NOT NULL, - folder_announce_post varchar2(200) DEFAULT '' NOT NULL, - folder_announce_new varchar2(200) DEFAULT '' NOT NULL, - folder_announce_new_post varchar2(200) DEFAULT '' NOT NULL, - folder_global varchar2(200) DEFAULT '' NOT NULL, - folder_global_post varchar2(200) DEFAULT '' NOT NULL, - folder_global_new varchar2(200) DEFAULT '' NOT NULL, - folder_global_new_post 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, + imageset_name varchar2(252) DEFAULT '' , + imageset_copyright varchar2(255) DEFAULT '' , + imageset_path varchar2(100) DEFAULT '' , + site_logo varchar2(200) DEFAULT '' , + upload_bar varchar2(200) DEFAULT '' , + poll_left varchar2(200) DEFAULT '' , + poll_center varchar2(200) DEFAULT '' , + poll_right varchar2(200) DEFAULT '' , + icon_friend varchar2(200) DEFAULT '' , + icon_foe varchar2(200) DEFAULT '' , + forum_link varchar2(200) DEFAULT '' , + forum_read varchar2(200) DEFAULT '' , + forum_read_locked varchar2(200) DEFAULT '' , + forum_read_subforum varchar2(200) DEFAULT '' , + forum_unread varchar2(200) DEFAULT '' , + forum_unread_locked varchar2(200) DEFAULT '' , + forum_unread_subforum varchar2(200) DEFAULT '' , + topic_moved varchar2(200) DEFAULT '' , + topic_read varchar2(200) DEFAULT '' , + topic_read_mine varchar2(200) DEFAULT '' , + topic_read_hot varchar2(200) DEFAULT '' , + topic_read_hot_mine varchar2(200) DEFAULT '' , + topic_read_locked varchar2(200) DEFAULT '' , + topic_read_locked_mine varchar2(200) DEFAULT '' , + topic_unread varchar2(200) DEFAULT '' , + topic_unread_mine varchar2(200) DEFAULT '' , + topic_unread_hot varchar2(200) DEFAULT '' , + topic_unread_hot_mine varchar2(200) DEFAULT '' , + topic_unread_locked varchar2(200) DEFAULT '' , + topic_unread_locked_mine varchar2(200) DEFAULT '' , + sticky_read varchar2(200) DEFAULT '' , + sticky_read_mine varchar2(200) DEFAULT '' , + sticky_read_locked varchar2(200) DEFAULT '' , + sticky_read_locked_mine varchar2(200) DEFAULT '' , + sticky_unread varchar2(200) DEFAULT '' , + sticky_unread_mine varchar2(200) DEFAULT '' , + sticky_unread_locked varchar2(200) DEFAULT '' , + sticky_unread_locked_mine varchar2(200) DEFAULT '' , + announce_read varchar2(200) DEFAULT '' , + announce_read_mine varchar2(200) DEFAULT '' , + announce_read_locked varchar2(200) DEFAULT '' , + announce_read_locked_mine varchar2(200) DEFAULT '' , + announce_unread varchar2(200) DEFAULT '' , + announce_unread_mine varchar2(200) DEFAULT '' , + announce_unread_locked varchar2(200) DEFAULT '' , + announce_unread_locked_mine varchar2(200) DEFAULT '' , + global_read varchar2(200) DEFAULT '' , + global_read_mine varchar2(200) DEFAULT '' , + global_read_locked varchar2(200) DEFAULT '' , + global_read_locked_mine varchar2(200) DEFAULT '' , + global_unread varchar2(200) DEFAULT '' , + global_unread_mine varchar2(200) DEFAULT '' , + global_unread_locked varchar2(200) DEFAULT '' , + global_unread_locked_mine varchar2(200) DEFAULT '' , + pm_read varchar2(200) DEFAULT '' , + pm_unread varchar2(200) DEFAULT '' , + icon_contact_aim varchar2(200) DEFAULT '' , + icon_contact_email varchar2(200) DEFAULT '' , + icon_contact_icq varchar2(200) DEFAULT '' , + icon_contact_jabber varchar2(200) DEFAULT '' , + icon_contact_msnm varchar2(200) DEFAULT '' , + icon_contact_pm varchar2(200) DEFAULT '' , + icon_contact_yahoo varchar2(200) DEFAULT '' , + icon_contact_www varchar2(200) DEFAULT '' , + icon_post_delete varchar2(200) DEFAULT '' , + icon_post_edit varchar2(200) DEFAULT '' , + icon_post_info varchar2(200) DEFAULT '' , + icon_post_quote varchar2(200) DEFAULT '' , + icon_post_report varchar2(200) DEFAULT '' , + icon_post_target varchar2(200) DEFAULT '' , + icon_post_target_unread varchar2(200) DEFAULT '' , + icon_topic_attach varchar2(200) DEFAULT '' , + icon_topic_latest varchar2(200) DEFAULT '' , + icon_topic_newest varchar2(200) DEFAULT '' , + icon_topic_reported varchar2(200) DEFAULT '' , + icon_topic_unapproved varchar2(200) DEFAULT '' , + icon_user_online varchar2(200) DEFAULT '' , + icon_user_offline varchar2(200) DEFAULT '' , + icon_user_profile varchar2(200) DEFAULT '' , + icon_user_search varchar2(200) DEFAULT '' , + icon_user_warn varchar2(200) DEFAULT '' , + button_pm_forward varchar2(200) DEFAULT '' , + button_pm_new varchar2(200) DEFAULT '' , + button_pm_reply varchar2(200) DEFAULT '' , + button_topic_locked varchar2(200) DEFAULT '' , + button_topic_new varchar2(200) DEFAULT '' , + button_topic_reply 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) + CONSTRAINT u_phpbb_imgset_nm UNIQUE (imageset_name) ) / @@ -1494,7 +1603,7 @@ CREATE TABLE phpbb_styles_imageset ( CREATE SEQUENCE phpbb_styles_imageset_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_styles_imageset_seq +CREATE OR REPLACE TRIGGER t_phpbb_styles_imageset BEFORE INSERT ON phpbb_styles_imageset FOR EACH ROW WHEN ( new.imageset_id IS NULL OR new.imageset_id = 0 @@ -1507,7 +1616,9 @@ END; / -/* Table: 'phpbb_topics' */ +/* + Table: 'phpbb_topics' +*/ CREATE TABLE phpbb_topics ( topic_id number(8) NOT NULL, forum_id number(8) DEFAULT '0' NOT NULL, @@ -1515,7 +1626,7 @@ CREATE TABLE phpbb_topics ( 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_title varchar2(1000) DEFAULT '' , 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, @@ -1525,16 +1636,16 @@ CREATE TABLE phpbb_topics ( 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_first_poster_name varchar2(255) DEFAULT '' , 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_poster_name varchar2(255) DEFAULT '' , 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_title varchar2(1000) DEFAULT '' , 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, @@ -1548,13 +1659,13 @@ 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 INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time) / CREATE SEQUENCE phpbb_topics_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_topics_seq +CREATE OR REPLACE TRIGGER t_phpbb_topics BEFORE INSERT ON phpbb_topics FOR EACH ROW WHEN ( new.topic_id IS NULL OR new.topic_id = 0 @@ -1567,7 +1678,9 @@ END; / -/* 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, @@ -1580,7 +1693,9 @@ CREATE TABLE phpbb_topics_track ( 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, @@ -1590,7 +1705,9 @@ CREATE TABLE phpbb_topics_posted ( / -/* 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, @@ -1602,10 +1719,12 @@ 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_notify_status ON phpbb_topics_watch (notify_status) +CREATE INDEX phpbb_topics_watch_notify_stat 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, @@ -1621,38 +1740,40 @@ 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) / -/* Table: 'phpbb_users' */ +/* + Table: 'phpbb_users' +*/ CREATE TABLE phpbb_users ( 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_permissions clob DEFAULT '' , user_perm_from number(8) DEFAULT '0' NOT NULL, - user_ip varchar2(40) DEFAULT '' NOT NULL, + user_ip varchar2(40) DEFAULT '' , user_regdate number(11) DEFAULT '0' NOT NULL, - username varchar2(255) DEFAULT '' NOT NULL, - user_password varchar2(40) DEFAULT '' NOT NULL, + username varchar2(252) DEFAULT '' , + user_password varchar2(40) DEFAULT '' , user_passchg number(11) DEFAULT '0' NOT NULL, - user_email varchar2(100) DEFAULT '' NOT NULL, + user_email varchar2(100) DEFAULT '' , user_email_hash number(20) DEFAULT '0' NOT NULL, - user_birthday varchar2(10) DEFAULT '' NOT NULL, + user_birthday varchar2(10) DEFAULT '' , 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_lastpage varchar2(200) DEFAULT '' , + user_last_confirm_key varchar2(10) DEFAULT '' , 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_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(8) DEFAULT '0' NOT NULL, - user_colour varchar2(6) DEFAULT '' NOT 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, @@ -1674,24 +1795,24 @@ CREATE TABLE phpbb_users ( 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 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 DEFAULT '' NOT NULL, - user_sig_bbcode_uid varchar2(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield raw(255) DEFAULT '' 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, + user_sig clob DEFAULT '' , + user_sig_bbcode_uid varchar2(5) DEFAULT '' , + user_sig_bbcode_bitfield raw(255) DEFAULT '' , + user_from varchar2(100) DEFAULT '' , + user_icq varchar2(15) DEFAULT '' , + user_aim varchar2(255) DEFAULT '' , + user_yim varchar2(255) DEFAULT '' , + user_msnm varchar2(255) DEFAULT '' , + user_jabber varchar2(255) DEFAULT '' , + user_website varchar2(200) DEFAULT '' , + user_occ varchar2(255) DEFAULT '' , + user_interests clob DEFAULT '' , + user_actkey varchar2(32) DEFAULT '' , + user_newpasswd varchar2(32) DEFAULT '' , CONSTRAINT pk_phpbb_users PRIMARY KEY (user_id) ) / @@ -1708,7 +1829,7 @@ CREATE INDEX phpbb_users_username ON phpbb_users (username) CREATE SEQUENCE phpbb_users_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_users_seq +CREATE OR REPLACE TRIGGER t_phpbb_users BEFORE INSERT ON phpbb_users FOR EACH ROW WHEN ( new.user_id IS NULL OR new.user_id = 0 @@ -1721,7 +1842,9 @@ END; / -/* Table: 'phpbb_warnings' */ +/* + Table: 'phpbb_warnings' +*/ CREATE TABLE phpbb_warnings ( warning_id number(8) NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, @@ -1736,7 +1859,7 @@ CREATE TABLE phpbb_warnings ( CREATE SEQUENCE phpbb_warnings_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_warnings_seq +CREATE OR REPLACE TRIGGER t_phpbb_warnings BEFORE INSERT ON phpbb_warnings FOR EACH ROW WHEN ( new.warning_id IS NULL OR new.warning_id = 0 @@ -1749,11 +1872,13 @@ END; / -/* Table: 'phpbb_words' */ +/* + Table: 'phpbb_words' +*/ CREATE TABLE phpbb_words ( word_id number(8) NOT NULL, - word varchar2(255) DEFAULT '' NOT NULL, - replacement varchar2(255) DEFAULT '' NOT NULL, + word varchar2(255) DEFAULT '' , + replacement varchar2(255) DEFAULT '' , CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id) ) / @@ -1762,7 +1887,7 @@ CREATE TABLE phpbb_words ( CREATE SEQUENCE phpbb_words_seq / -CREATE OR REPLACE TRIGGER ai_phpbb_words_seq +CREATE OR REPLACE TRIGGER t_phpbb_words BEFORE INSERT ON phpbb_words FOR EACH ROW WHEN ( new.word_id IS NULL OR new.word_id = 0 @@ -1775,7 +1900,9 @@ 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, |