diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 394 |
1 files changed, 197 insertions, 197 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index d143128ed7..2264bc8bbf 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -48,8 +48,8 @@ CREATE TABLE phpbb_attachments ( 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), - real_filename varchar2(255), + 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), @@ -98,7 +98,7 @@ CREATE TABLE phpbb_auth_groups ( 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(4) DEFAULT '0' NOT NULL + auth_setting number(2) DEFAULT '0' NOT NULL ) / @@ -113,7 +113,7 @@ CREATE INDEX phpbb_auth_groups_auth_opt_id on phpbb_auth_groups (auth_option_id) */ CREATE TABLE phpbb_auth_options ( auth_option_id number(8) NOT NULL, - auth_option varchar2(20), + auth_option varchar2(20) 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, @@ -145,9 +145,9 @@ CREATE INDEX phpbb_auth_options_auth_option on phpbb_auth_options (auth_option) */ CREATE TABLE phpbb_auth_roles ( role_id number(8) NOT NULL, - role_name varchar2(255) DEFAULT '', + role_name varchar2(255) DEFAULT '' NOT NULL, role_description clob, - role_type varchar2(10) DEFAULT '', + role_type varchar2(10) DEFAULT '' NOT NULL, role_order number(4) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_auth_roles PRIMARY KEY (role_id) ) @@ -180,7 +180,7 @@ CREATE INDEX phpbb_auth_roles_role_order on phpbb_auth_roles (role_order) CREATE TABLE phpbb_auth_roles_data ( role_id number(8) DEFAULT '0' NOT NULL, auth_option_id number(8) DEFAULT '0' NOT NULL, - auth_setting number(4) DEFAULT '0' NOT NULL, + auth_setting number(2) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_auth_roles_data PRIMARY KEY (role_id, auth_option_id) ) / @@ -194,7 +194,7 @@ CREATE TABLE phpbb_auth_users ( 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(4) DEFAULT '0' NOT NULL + auth_setting number(2) DEFAULT '0' NOT NULL ) / @@ -210,8 +210,8 @@ CREATE INDEX phpbb_auth_users_auth_opt_id on phpbb_auth_users (auth_option_id) 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_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, @@ -242,13 +242,13 @@ END; */ CREATE TABLE phpbb_bbcodes ( bbcode_id number(3) DEFAULT '0' NOT NULL, - bbcode_tag varchar2(16) DEFAULT '', + bbcode_tag varchar2(16) DEFAULT '' NOT NULL, display_on_posting number(1) DEFAULT '0' NOT NULL, - bbcode_match varchar2(255) DEFAULT '', + bbcode_match varchar2(255) DEFAULT '' NOT NULL, bbcode_tpl clob, - first_pass_match varchar2(255) DEFAULT '', - first_pass_replace varchar2(255) DEFAULT '', - second_pass_match varchar2(255) DEFAULT '', + 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, CONSTRAINT pk_phpbb_bbcodes PRIMARY KEY (bbcode_id) ) @@ -282,8 +282,8 @@ CREATE TABLE phpbb_bots ( 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 '', + bot_agent varchar2(255) DEFAULT '' NOT NULL, + bot_ip varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_bots PRIMARY KEY (bot_id) ) / @@ -311,7 +311,7 @@ CREATE INDEX phpbb_bots_bot_active on phpbb_bots (bot_active) Table: phpbb_cache */ CREATE TABLE phpbb_cache ( - var_name varchar2(255) DEFAULT '', + var_name varchar2(255) DEFAULT '' NOT NULL, var_expires number(10) DEFAULT '0' NOT NULL, var_data clob, CONSTRAINT pk_phpbb_cache PRIMARY KEY (var_name) @@ -323,8 +323,8 @@ CREATE TABLE phpbb_cache ( Table: phpbb_config */ CREATE TABLE phpbb_config ( - config_name varchar2(255), - config_value varchar2(255), + config_name varchar2(255) NOT NULL, + config_value varchar2(255) NOT NULL, is_dynamic number(1) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name) ) @@ -338,10 +338,10 @@ CREATE INDEX phpbb_config_is_dynamic on phpbb_config (is_dynamic) Table: phpbb_confirm */ CREATE TABLE phpbb_confirm ( - confirm_id varchar2(32) DEFAULT '', - session_id varchar2(32) DEFAULT '', + 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 '', + code varchar2(8) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id) ) / @@ -352,7 +352,7 @@ CREATE TABLE phpbb_confirm ( */ CREATE TABLE phpbb_disallow ( disallow_id number(8) NOT NULL, - disallow_username varchar2(255) DEFAULT '', + disallow_username varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_disallow PRIMARY KEY (disallow_id) ) / @@ -413,7 +413,7 @@ CREATE INDEX phpbb_drafts_save_time on phpbb_drafts (save_time) CREATE TABLE phpbb_extensions ( extension_id number(8) NOT NULL, group_id number(8) DEFAULT '0' NOT NULL, - extension varchar2(100) DEFAULT '', + extension varchar2(100) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_extensions PRIMARY KEY (extension_id) ) / @@ -439,11 +439,11 @@ END; */ CREATE TABLE phpbb_extension_groups ( group_id number(8) NOT NULL, - group_name varchar2(255), + 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 '', + upload_icon varchar2(255) DEFAULT '' NOT NULL, max_filesize number(20) DEFAULT '0' NOT NULL, allowed_forums clob, allow_in_pm number(1) DEFAULT '0' NOT NULL, @@ -479,15 +479,15 @@ CREATE TABLE phpbb_forums ( forum_name varchar2(1000), 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_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), - forum_image varchar2(255) DEFAULT '', + forum_image varchar2(255) DEFAULT '' NOT NULL, forum_rules clob, - forum_rules_link varchar2(255) DEFAULT '', + forum_rules_link varchar2(255) DEFAULT '' NOT NULL, forum_rules_bitfield number(11) DEFAULT '0' NOT NULL, - forum_rules_uid varchar2(5) DEFAULT '', + 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, @@ -538,7 +538,7 @@ CREATE INDEX phpbb_forums_forum_last_pst_id on phpbb_forums (forum_last_post_id) CREATE TABLE phpbb_forum_access ( forum_id number(8) DEFAULT '0' NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, - session_id varchar2(32) DEFAULT '', + session_id varchar2(32) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_forum_access PRIMARY KEY (forum_id, user_id, session_id) ) / @@ -583,14 +583,14 @@ CREATE TABLE phpbb_groups ( group_name varchar2(255) DEFAULT '' NOT NULL, group_desc clob, group_desc_bitfield number(11) DEFAULT '0' NOT NULL, - group_desc_uid varchar2(5) DEFAULT '', + group_desc_uid varchar2(5) DEFAULT '' NOT NULL, group_display number(1) DEFAULT '0' NOT NULL, - group_avatar varchar2(255) DEFAULT '', + 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(5) DEFAULT '1' NOT NULL, - group_colour varchar2(6) DEFAULT '', + group_rank number(5) DEFAULT '-1' 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, @@ -654,8 +654,8 @@ END; */ CREATE TABLE phpbb_lang ( lang_id number(4) NOT NULL, - lang_iso varchar2(5), - lang_dir varchar2(30), + 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), @@ -689,7 +689,7 @@ 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), + log_ip varchar2(40) NOT NULL, log_time number(11) NOT NULL, log_operation clob, log_data clob, @@ -730,9 +730,9 @@ CREATE INDEX phpbb_log_user_id on phpbb_log (user_id) CREATE TABLE phpbb_moderator_cache ( forum_id number(8) NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, - username varchar2(255) DEFAULT '', + username varchar2(255) DEFAULT '' NOT NULL, group_id number(8) DEFAULT '0' NOT NULL, - group_name varchar2(255) DEFAULT '', + group_name varchar2(255) DEFAULT '' NOT NULL, display_on_index number(1) DEFAULT '1' NOT NULL ) / @@ -750,14 +750,14 @@ 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 '', + module_name 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 '', - module_mode varchar2(255) DEFAULT '', - module_auth varchar2(255) DEFAULT '', + 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) ) / @@ -807,7 +807,7 @@ CREATE TABLE phpbb_poll_voters ( 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) + vote_user_ip varchar2(40) NOT NULL ) / @@ -943,7 +943,7 @@ CREATE INDEX phpbb_privmsgs_root_level on phpbb_privmsgs (root_level) CREATE TABLE phpbb_privmsgs_folder ( folder_id number(8) NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, - folder_name varchar2(255) DEFAULT '', + folder_name varchar2(255) DEFAULT '' NOT NULL, pm_count number(8) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_privmsgs_folder PRIMARY KEY (folder_id) ) @@ -976,7 +976,7 @@ CREATE TABLE phpbb_privmsgs_rules ( 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_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(4) DEFAULT '0' NOT NULL, @@ -1029,16 +1029,16 @@ CREATE INDEX phpbb_privmsgs_to_user_id on phpbb_privmsgs_to (user_id, folder_id) */ CREATE TABLE phpbb_profile_fields ( field_id number(8) NOT NULL, - field_name varchar2(255) DEFAULT '', + field_name varchar2(255) DEFAULT '' NOT NULL, field_desc clob, field_type number(8) 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', - field_validation varchar2(20) DEFAULT '', + 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 '0' 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, @@ -1088,7 +1088,7 @@ CREATE TABLE phpbb_profile_fields_lang ( 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 '', + value varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_profile_fields_lang PRIMARY KEY (field_id, lang_id, option_id) ) / @@ -1100,9 +1100,9 @@ CREATE TABLE phpbb_profile_fields_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_name varchar2(255) DEFAULT '' NOT NULL, lang_explain clob, - lang_default_value varchar2(255) DEFAULT '', + lang_default_value varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_profile_lang PRIMARY KEY (field_id, lang_id) ) / @@ -1113,7 +1113,7 @@ CREATE TABLE phpbb_profile_lang ( */ CREATE TABLE phpbb_ranks ( rank_id number(5) NOT NULL, - rank_title varchar2(255), + rank_title varchar2(255) NOT NULL, rank_min number(8) DEFAULT '0' NOT NULL, rank_special number(1) DEFAULT '0', rank_image varchar2(255), @@ -1138,34 +1138,6 @@ END; /* - 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) -) -/ - -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 -) -BEGIN - SELECT phpbb_reports_reasons_seq.nextval - INTO :new.reason_id - FROM dual; -END; -/ - - -/* Table: phpbb_reports */ CREATE TABLE phpbb_reports ( @@ -1175,7 +1147,7 @@ CREATE TABLE phpbb_reports ( 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(10) DEFAULT '0' NOT NULL, + report_time number(11) DEFAULT '0' NOT NULL, report_text clob, CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) ) @@ -1198,6 +1170,34 @@ END; /* + Table: phpbb_reports_reasons +*/ +CREATE TABLE phpbb_reports_reasons ( + reason_id number(6) NOT NULL, + reason_title varchar2(255) DEFAULT '' NOT NULL, + reason_description clob, + 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 +) +BEGIN + SELECT phpbb_reports_reasons_seq.nextval + INTO :new.reason_id + FROM dual; +END; +/ + + +/* Table: phpbb_search_results */ CREATE TABLE phpbb_search_results ( @@ -1214,7 +1214,7 @@ CREATE TABLE phpbb_search_results ( Table: phpbb_search_wordlist */ CREATE TABLE phpbb_search_wordlist ( - word_text varchar2(50) DEFAULT '', + word_text varchar2(50) 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) @@ -1258,14 +1258,14 @@ CREATE INDEX phpbb_search_wordmatch_word_id on phpbb_search_wordmatch (word_id) Table: phpbb_sessions */ CREATE TABLE phpbb_sessions ( - session_id varchar2(32) DEFAULT '', + session_id varchar2(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 '0', - session_browser varchar2(150) DEFAULT '', - session_page varchar2(200) DEFAULT '', + session_ip varchar2(40) DEFAULT '0' NOT NULL, + session_browser varchar2(150) DEFAULT '' NOT NULL, + session_page varchar2(200) 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, @@ -1283,9 +1283,9 @@ CREATE INDEX phpbb_sessions_session_user_id on phpbb_sessions (session_user_id) Table: phpbb_sessions_keys */ CREATE TABLE phpbb_sessions_keys ( - key_id varchar2(32) DEFAULT '', + key_id varchar2(32) DEFAULT '' NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, - last_ip varchar2(40) DEFAULT '0', + 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) ) @@ -1300,8 +1300,8 @@ CREATE INDEX phpbb_sessions_keys_last_login on phpbb_sessions_keys (last_login) */ CREATE TABLE phpbb_sitelist ( site_id number(8) NOT NULL, - site_ip varchar2(40) DEFAULT '', - site_hostname varchar2(255) DEFAULT '', + 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) ) @@ -1360,8 +1360,8 @@ END; */ CREATE TABLE phpbb_styles ( style_id number(4) NOT NULL, - style_name varchar2(255) DEFAULT '', - style_copyright varchar2(255) DEFAULT '', + 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) NOT NULL, theme_id number(4) NOT NULL, @@ -1399,9 +1399,9 @@ CREATE INDEX phpbb_styles_imageset_id on phpbb_styles (imageset_id) */ CREATE TABLE phpbb_styles_template ( template_id number(4) NOT NULL, - template_name varchar2(255), - template_copyright varchar2(255), - template_path varchar2(100), + 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), @@ -1430,7 +1430,7 @@ END; */ CREATE TABLE phpbb_styles_template_data ( template_id number(4) NOT NULL, - template_filename varchar2(100) DEFAULT '', + template_filename varchar2(100) DEFAULT '' NOT NULL, template_included clob, template_mtime number(11) DEFAULT '0' NOT NULL, template_data clob @@ -1448,9 +1448,9 @@ CREATE INDEX phpbb_sty_tmplt_dt_tmplt_fname on phpbb_styles_template_data (templ */ 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_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, @@ -1480,86 +1480,86 @@ END; */ 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 '', - folder_sticky varchar2(200) DEFAULT '', - 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 '', + 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_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_imageset_name UNIQUE (imageset_name) ) @@ -1586,7 +1586,7 @@ END; */ CREATE TABLE phpbb_topics ( topic_id number(8) NOT NULL, - forum_id number(8) DEFAULT '0' 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, @@ -1716,7 +1716,7 @@ CREATE TABLE phpbb_users ( 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' 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, @@ -1728,14 +1728,14 @@ CREATE TABLE phpbb_users ( 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_lastpage varchar2(200) DEFAULT '' NOT NULL, user_last_confirm_key varchar2(10) DEFAULT '' 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 '' NOT NULL, - user_timezone number(5, 2) DEFAULT '1' 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, @@ -1767,7 +1767,7 @@ CREATE TABLE phpbb_users ( 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 '' NULLL, + 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, @@ -1841,8 +1841,8 @@ END; */ CREATE TABLE phpbb_words ( word_id number(8) NOT NULL, - word varchar2(100), - replacement varchar2(100), + word varchar2(255) NOT NULL, + replacement varchar2(255) NOT NULL, CONSTRAINT pk_phpbb_words PRIMARY KEY (word_id) ) / |