diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2004-10-28 13:41:37 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2004-10-28 13:41:37 +0000 |
| commit | f1bcefcaa81e7745db8a9418fb748ef3da23127f (patch) | |
| tree | a888a86ec8f5b52e32ee626ccde818b8a133735c | |
| parent | c5e40db2a07f3e2a432dee409eafc038313302d5 (diff) | |
| download | forums-f1bcefcaa81e7745db8a9418fb748ef3da23127f.tar forums-f1bcefcaa81e7745db8a9418fb748ef3da23127f.tar.gz forums-f1bcefcaa81e7745db8a9418fb748ef3da23127f.tar.bz2 forums-f1bcefcaa81e7745db8a9418fb748ef3da23127f.tar.xz forums-f1bcefcaa81e7745db8a9418fb748ef3da23127f.zip | |
Removed "DEFAULT '0'" for INTs because of problems with installation on Windows. MySQL defaults to 0 anyway for integers.
git-svn-id: file:///svn/phpbb/trunk@5007 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 440 |
1 files changed, 220 insertions, 220 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index ac327fbbbf..edcf43f42e 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -7,19 +7,19 @@ # Table: phpbb_attachments CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, - post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + post_msg_id mediumint(8) UNSIGNED NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + in_message tinyint(1) UNSIGNED NOT NULL, + poster_id mediumint(8) UNSIGNED NOT NULL, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, - download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + download_count mediumint(8) UNSIGNED NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) UNSIGNED NOT NULL, - filetime int(11) UNSIGNED DEFAULT '0' NOT NULL, - thumbnail tinyint(1) DEFAULT '0' NOT NULL, + filetime int(11) UNSIGNED NOT NULL, + thumbnail tinyint(1) NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY post_msg_id (post_msg_id), @@ -31,10 +31,10 @@ CREATE TABLE phpbb_attachments ( # Table: phpbb_auth_groups CREATE TABLE phpbb_auth_groups ( - group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - auth_option_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - auth_setting tinyint(4) DEFAULT '0' NOT NULL, + group_id mediumint(8) UNSIGNED NOT NULL, + forum_id mediumint(8) UNSIGNED NOT NULL, + auth_option_id smallint(5) UNSIGNED NOT NULL, + auth_setting tinyint(4) NOT NULL, KEY group_id (group_id), KEY auth_option_id (auth_option_id) ); @@ -43,9 +43,9 @@ CREATE TABLE phpbb_auth_groups ( CREATE TABLE phpbb_auth_options ( auth_option_id smallint(5) UNSIGNED NOT NULL auto_increment, auth_option char(20) NOT NULL, - is_global tinyint(1) DEFAULT '0' NOT NULL, - is_local tinyint(1) DEFAULT '0' NOT NULL, - founder_only tinyint(1) DEFAULT '0' NOT NULL, + is_global tinyint(1) NOT NULL, + is_local tinyint(1) NOT NULL, + founder_only tinyint(1) NOT NULL, PRIMARY KEY (auth_option_id), KEY auth_option (auth_option) ); @@ -54,7 +54,7 @@ CREATE TABLE phpbb_auth_options ( CREATE TABLE phpbb_auth_presets ( preset_id tinyint(4) NOT NULL auto_increment, preset_name varchar(50) DEFAULT '' NOT NULL, - preset_user_id mediumint(5) UNSIGNED DEFAULT '0' NOT NULL, + preset_user_id mediumint(5) UNSIGNED NOT NULL, preset_type varchar(2) DEFAULT '' NOT NULL, preset_data text DEFAULT '' NOT NULL, PRIMARY KEY (preset_id), @@ -63,10 +63,10 @@ CREATE TABLE phpbb_auth_presets ( # Table: phpbb_auth_users CREATE TABLE phpbb_auth_users ( - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - auth_option_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - auth_setting tinyint(4) DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + forum_id mediumint(8) UNSIGNED NOT NULL, + auth_option_id smallint(5) UNSIGNED NOT NULL, + auth_setting tinyint(4) NOT NULL, KEY user_id (user_id), KEY auth_option_id (auth_option_id) ); @@ -77,9 +77,9 @@ CREATE TABLE phpbb_banlist ( ban_userid mediumint(8) UNSIGNED DEFAULT 0 NOT NULL, ban_ip varchar(40) DEFAULT '' NOT NULL, ban_email varchar(50) DEFAULT '' NOT NULL, - ban_start int(11) DEFAULT '0' NOT NULL, - ban_end int(11) DEFAULT '0' NOT NULL, - ban_exclude tinyint(1) DEFAULT '0' NOT NULL, + ban_start int(11) NOT NULL, + ban_end int(11) NOT NULL, + ban_exclude tinyint(1) NOT NULL, ban_reason varchar(255) DEFAULT '' NOT NULL, ban_give_reason varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (ban_id) @@ -87,7 +87,7 @@ CREATE TABLE phpbb_banlist ( # Table: 'phpbb_bbcodes' CREATE TABLE phpbb_bbcodes ( - bbcode_id tinyint(3) UNSIGNED DEFAULT '0' NOT NULL, + bbcode_id tinyint(3) UNSIGNED NOT NULL, bbcode_tag varchar(16) DEFAULT '' NOT NULL, bbcode_match varchar(255) DEFAULT '' NOT NULL, bbcode_tpl text DEFAULT '' NOT NULL, @@ -100,9 +100,9 @@ CREATE TABLE phpbb_bbcodes ( # Table: 'phpbb_bookmarks' CREATE TABLE phpbb_bookmarks ( - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - order_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + order_id mediumint(8) UNSIGNED NOT NULL, KEY order_id (order_id), KEY topic_user_id (topic_id, user_id) ); @@ -112,7 +112,7 @@ CREATE TABLE phpbb_bots ( bot_id tinyint(3) UNSIGNED NOT NULL auto_increment, bot_active tinyint(1) DEFAULT '1' NOT NULL, bot_name varchar(255) DEFAULT '' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, bot_agent varchar(255) DEFAULT '' NOT NULL, bot_ip varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (bot_id), @@ -122,7 +122,7 @@ CREATE TABLE phpbb_bots ( # Table: 'phpbb_cache' CREATE TABLE phpbb_cache ( var_name varchar(255) DEFAULT '' NOT NULL, - var_expires int(10) UNSIGNED DEFAULT '0' NOT NULL, + var_expires int(10) UNSIGNED NOT NULL, var_data text NOT NULL, PRIMARY KEY (var_name) ); @@ -131,7 +131,7 @@ CREATE TABLE phpbb_cache ( CREATE TABLE phpbb_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, - is_dynamic tinyint(1) DEFAULT '0' NOT NULL, + is_dynamic tinyint(1) NOT NULL, PRIMARY KEY (config_name), KEY is_dynamic (is_dynamic) ); @@ -154,10 +154,10 @@ CREATE TABLE phpbb_disallow ( # Table: 'phpbb_drafts' CREATE TABLE phpbb_drafts ( draft_id mediumint(8) UNSIGNED NOT NULL auto_increment, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - save_time int(11) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + forum_id mediumint(8) UNSIGNED NOT NULL, + save_time int(11) UNSIGNED NOT NULL, draft_subject varchar(60), draft_message text DEFAULT '' NOT NULL, PRIMARY KEY (draft_id), @@ -167,7 +167,7 @@ CREATE TABLE phpbb_drafts ( # Table: 'phpbb_extensions' CREATE TABLE phpbb_extensions ( extension_id mediumint(8) UNSIGNED NOT NULL auto_increment, - group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + group_id mediumint(8) UNSIGNED NOT NULL, extension varchar(100) DEFAULT '' NOT NULL, PRIMARY KEY (extension_id) ); @@ -176,13 +176,13 @@ CREATE TABLE phpbb_extensions ( CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, - cat_id tinyint(2) DEFAULT '0' NOT NULL, - allow_group tinyint(1) DEFAULT '0' NOT NULL, + cat_id tinyint(2) NOT NULL, + allow_group tinyint(1) NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '' NOT NULL, - max_filesize int(20) DEFAULT '0' NOT NULL, + max_filesize int(20) NOT NULL, allowed_forums text NOT NULL, - allow_in_pm tinyint(1) DEFAULT '0' NOT NULL, + allow_in_pm tinyint(1) NOT NULL, PRIMARY KEY (group_id) ); @@ -201,28 +201,28 @@ CREATE TABLE phpbb_forums ( forum_image varchar(50) DEFAULT '' NOT NULL, forum_rules text DEFAULT '' NOT NULL, forum_rules_link varchar(200) DEFAULT '' NOT NULL, - forum_rules_flags tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - forum_rules_bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + forum_rules_flags tinyint(4) UNSIGNED NOT NULL, + forum_rules_bbcode_bitfield int(11) UNSIGNED NOT NULL, forum_rules_bbcode_uid varchar(5) DEFAULT '' NOT NULL, - forum_topics_per_page tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - forum_type tinyint(4) DEFAULT '0' NOT NULL, - forum_status tinyint(4) DEFAULT '0' NOT NULL, - forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_last_poster_id mediumint(8) DEFAULT '0' NOT NULL, - forum_last_post_time int(11) DEFAULT '0' NOT NULL, + forum_topics_per_page tinyint(4) UNSIGNED NOT NULL, + forum_type tinyint(4) NOT NULL, + forum_status tinyint(4) NOT NULL, + forum_posts mediumint(8) UNSIGNED NOT NULL, + forum_topics mediumint(8) UNSIGNED NOT NULL, + forum_topics_real mediumint(8) UNSIGNED NOT NULL, + forum_last_post_id mediumint(8) UNSIGNED NOT NULL, + forum_last_poster_id mediumint(8) NOT NULL, + forum_last_post_time int(11) NOT NULL, forum_last_poster_name varchar(30), - forum_flags tinyint(4) DEFAULT '0' NOT NULL, + forum_flags tinyint(4) NOT NULL, display_on_index tinyint(1) DEFAULT '1' NOT NULL, enable_indexing tinyint(1) DEFAULT '1' NOT NULL, enable_icons tinyint(1) DEFAULT '1' NOT NULL, - enable_prune tinyint(1) DEFAULT '0' NOT NULL, + enable_prune tinyint(1) NOT NULL, prune_next int(11) UNSIGNED, prune_days tinyint(4) UNSIGNED NOT NULL, prune_viewed tinyint(4) UNSIGNED NOT NULL, - prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + prune_freq tinyint(4) UNSIGNED NOT NULL, PRIMARY KEY (forum_id), KEY left_right_id (left_id, right_id), KEY forum_last_post_id (forum_last_post_id) @@ -230,25 +230,25 @@ CREATE TABLE phpbb_forums ( # Table: phpbb_forum_access CREATE TABLE phpbb_forum_access ( - forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + forum_id mediumint(8) UNSIGNED NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, session_id char(32) DEFAULT '' NOT NULL, PRIMARY KEY (forum_id,user_id,session_id) ); # Table: 'phpbb_forums_marking' CREATE TABLE phpbb_forums_marking ( - user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, - forum_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, - mark_time int(11) DEFAULT '0' NOT NULL, + user_id mediumint(9) UNSIGNED NOT NULL, + forum_id mediumint(9) UNSIGNED NOT NULL, + mark_time int(11) NOT NULL, PRIMARY KEY (user_id, forum_id) ); # Table: 'phpbb_forums_watch' CREATE TABLE phpbb_forums_watch ( - forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) DEFAULT '0' NOT NULL, - notify_status tinyint(1) DEFAULT '0' NOT NULL, + forum_id smallint(5) UNSIGNED NOT NULL, + user_id mediumint(8) NOT NULL, + notify_status tinyint(1) NOT NULL, KEY forum_id (forum_id), KEY user_id (user_id), KEY notify_status (notify_status) @@ -259,17 +259,17 @@ CREATE TABLE phpbb_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) DEFAULT '' NOT NULL, - group_display tinyint(1) DEFAULT '0' NOT NULL, + group_display tinyint(1) NOT NULL, group_avatar varchar(100) DEFAULT '' NOT NULL, - group_avatar_type tinyint(4) DEFAULT '0' NOT NULL, - group_avatar_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - group_avatar_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + group_avatar_type tinyint(4) NOT NULL, + group_avatar_width tinyint(4) UNSIGNED NOT NULL, + group_avatar_height tinyint(4) UNSIGNED NOT NULL, group_rank smallint(5) DEFAULT '-1' NOT NULL, group_colour varchar(6) DEFAULT '' NOT NULL, - group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - group_receive_pm tinyint(1) DEFAULT '0' NOT NULL, - group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - group_chgpass smallint(6) DEFAULT '0' NOT NULL, + group_sig_chars mediumint(8) UNSIGNED NOT NULL, + group_receive_pm tinyint(1) NOT NULL, + group_message_limit mediumint(8) UNSIGNED NOT NULL, + group_chgpass smallint(6) NOT NULL, group_description varchar(255) DEFAULT '' NOT NULL, group_legend tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), @@ -300,12 +300,12 @@ CREATE TABLE phpbb_lang ( # Table: 'phpbb_log' CREATE TABLE phpbb_log ( - log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL auto_increment, - log_type tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) DEFAULT '0' NOT NULL, - forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + log_id mediumint(8) UNSIGNED NOT NULL auto_increment, + log_type tinyint(4) UNSIGNED NOT NULL, + user_id mediumint(8) NOT NULL, + forum_id mediumint(8) UNSIGNED NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + reportee_id mediumint(8) UNSIGNED NOT NULL, log_ip varchar(40) NOT NULL, log_time int(11) NOT NULL, log_operation text, @@ -321,9 +321,9 @@ CREATE TABLE phpbb_log ( # Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( forum_id mediumint(8) UNSIGNED NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, username char(30) DEFAULT '' NOT NULL, - group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + group_id mediumint(8) UNSIGNED NOT NULL, groupname char(30) DEFAULT '' NOT NULL, display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, KEY display_on_index (display_on_index), @@ -336,7 +336,7 @@ CREATE TABLE phpbb_modules ( module_type char(3) DEFAULT '' NOT NULL, module_title varchar(50) DEFAULT '' NOT NULL, module_filename varchar(50) DEFAULT '' NOT NULL, - module_order mediumint(4) DEFAULT '0' NOT NULL, + module_order mediumint(4) NOT NULL, module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, module_subs text NOT NULL, module_acl varchar(255) DEFAULT '' NOT NULL, @@ -346,19 +346,19 @@ CREATE TABLE phpbb_modules ( # Table: 'phpbb_poll_results' CREATE TABLE phpbb_poll_results ( - poll_option_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + poll_option_id tinyint(4) UNSIGNED NOT NULL, topic_id mediumint(8) UNSIGNED NOT NULL, poll_option_text varchar(255) NOT NULL, - poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + poll_option_total mediumint(8) UNSIGNED NOT NULL, KEY poll_option_id (poll_option_id), KEY topic_id (topic_id) ); # Table: 'phpbb_poll_voters' CREATE TABLE phpbb_poll_voters ( - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - poll_option_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + poll_option_id tinyint(4) UNSIGNED NOT NULL, + vote_user_id mediumint(8) UNSIGNED NOT NULL, vote_user_ip varchar(40) NOT NULL, KEY topic_id (topic_id), KEY vote_user_id (vote_user_id), @@ -368,16 +368,16 @@ CREATE TABLE phpbb_poll_voters ( # Table: 'phpbb_posts' CREATE TABLE phpbb_posts ( post_id mediumint(8) UNSIGNED NOT NULL auto_increment, - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + forum_id smallint(5) UNSIGNED NOT NULL, + poster_id mediumint(8) UNSIGNED NOT NULL, icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, poster_ip varchar(40) NOT NULL, - post_time int(11) DEFAULT '0' NOT NULL, + post_time int(11) NOT NULL, post_approved tinyint(1) DEFAULT '1' NOT NULL, - post_reported tinyint(1) DEFAULT '0' NOT NULL, + post_reported tinyint(1) NOT NULL, enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, - enable_html tinyint(1) DEFAULT '0' NOT NULL, + enable_html tinyint(1) NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, @@ -386,14 +386,14 @@ CREATE TABLE phpbb_posts ( post_text text, post_checksum varchar(32) NOT NULL, post_encoding varchar(11) DEFAULT 'iso-8859-15' NOT NULL, - post_attachment tinyint(1) DEFAULT '0' NOT NULL, - bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + post_attachment tinyint(1) NOT NULL, + bbcode_bitfield int(11) UNSIGNED NOT NULL, bbcode_uid varchar(5) DEFAULT '' NOT NULL, - post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, + post_edit_time int(11) UNSIGNED NOT NULL, post_edit_reason varchar(100), - post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + post_edit_user mediumint(8) UNSIGNED NOT NULL, + post_edit_count smallint(5) UNSIGNED NOT NULL, + post_edit_locked tinyint(1) UNSIGNED NOT NULL, PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), @@ -406,28 +406,28 @@ CREATE TABLE phpbb_posts ( # Table: 'phpbb_privmsgs' CREATE TABLE phpbb_privmsgs ( msg_id mediumint(8) UNSIGNED NOT NULL auto_increment, - root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + root_level mediumint(8) UNSIGNED NOT NULL, + author_id mediumint(8) UNSIGNED NOT NULL, icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, author_ip varchar(40) DEFAULT '' NOT NULL, - message_time int(11) DEFAULT '0' NOT NULL, - message_reported tinyint(1) DEFAULT '0' NOT NULL, + message_time int(11) NOT NULL, + message_reported tinyint(1) NOT NULL, enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, - enable_html tinyint(1) DEFAULT '0' NOT NULL, + enable_html tinyint(1) NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_magic_url tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, message_subject varchar(60), message_text text, message_edit_reason varchar(100), - message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + message_edit_user mediumint(8) UNSIGNED NOT NULL, message_checksum varchar(32) DEFAULT '' NOT NULL, message_encoding varchar(11) DEFAULT 'iso-8859-15' NOT NULL, - message_attachment tinyint(1) DEFAULT '0' NOT NULL, - bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + message_attachment tinyint(1) NOT NULL, + bbcode_bitfield int(11) UNSIGNED NOT NULL, bbcode_uid varchar(5) DEFAULT '' NOT NULL, - message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, - message_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL, + message_edit_time int(11) UNSIGNED NOT NULL, + message_edit_count smallint(5) UNSIGNED NOT NULL, to_address text, bcc_address text, PRIMARY KEY (msg_id), @@ -440,9 +440,9 @@ CREATE TABLE phpbb_privmsgs ( # Table: 'phpbb_privmsgs_folder' CREATE TABLE phpbb_privmsgs_folder ( folder_id mediumint(8) UNSIGNED NOT NULL auto_increment, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, folder_name varchar(40) DEFAULT '' NOT NULL, - pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + pm_count mediumint(8) UNSIGNED NOT NULL, PRIMARY KEY (folder_id), KEY user_id (user_id) ); @@ -450,29 +450,29 @@ CREATE TABLE phpbb_privmsgs_folder ( # Table: 'phpbb_privmsgs_rules' CREATE TABLE phpbb_privmsgs_rules ( rule_id mediumint(8) UNSIGNED NOT NULL auto_increment, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - rule_check mediumint(4) UNSIGNED DEFAULT '0' NOT NULL, - rule_connection mediumint(4) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + rule_check mediumint(4) UNSIGNED NOT NULL, + rule_connection mediumint(4) UNSIGNED NOT NULL, rule_string varchar(255) DEFAULT '' NOT NULL, - rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - rule_action mediumint(4) UNSIGNED DEFAULT '0' NOT NULL, - rule_folder_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + rule_user_id mediumint(8) UNSIGNED NOT NULL, + rule_group_id mediumint(8) UNSIGNED NOT NULL, + rule_action mediumint(4) UNSIGNED NOT NULL, + rule_folder_id mediumint(8) UNSIGNED NOT NULL, PRIMARY KEY (rule_id) ); # Table: 'phpbb_privmsgs_to' CREATE TABLE phpbb_privmsgs_to ( - msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + msg_id mediumint(8) UNSIGNED NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + author_id mediumint(8) UNSIGNED NOT NULL, + deleted tinyint(1) UNSIGNED NOT NULL, new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, - replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - folder_id int(10) DEFAULT '0' NOT NULL, + replied tinyint(1) UNSIGNED NOT NULL, + marked tinyint(1) UNSIGNED NOT NULL, + forwarded tinyint(1) UNSIGNED NOT NULL, + folder_id int(10) NOT NULL, KEY msg_id (msg_id), KEY user_id (user_id,folder_id) ); @@ -488,13 +488,13 @@ CREATE TABLE phpbb_profile_fields ( field_minlen varchar(255) DEFAULT '' NOT NULL, field_maxlen varchar(255) DEFAULT '' NOT NULL, field_novalue varchar(255) DEFAULT '' NOT NULL, - field_default_value varchar(255) DEFAULT '0' NOT NULL, + field_default_value varchar(255) NOT NULL, field_validation varchar(20) DEFAULT '' NOT NULL, - field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - field_order tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + field_required tinyint(1) UNSIGNED NOT NULL, + field_show_on_reg tinyint(1) UNSIGNED NOT NULL, + field_hide tinyint(1) UNSIGNED NOT NULL, + field_active tinyint(1) UNSIGNED NOT NULL, + field_order tinyint(4) UNSIGNED NOT NULL, PRIMARY KEY (field_id), KEY field_type (field_type), KEY field_order (field_order) @@ -502,24 +502,24 @@ CREATE TABLE phpbb_profile_fields ( # Table: 'phpbb_profile_fields_data' CREATE TABLE phpbb_profile_fields_data ( - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, PRIMARY KEY (user_id) ); # Table: 'phpbb_profile_fields_lang' CREATE TABLE phpbb_profile_fields_lang ( - field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - field_type tinyint(4) DEFAULT '0' NOT NULL, + field_id mediumint(8) UNSIGNED NOT NULL, + lang_id mediumint(8) UNSIGNED NOT NULL, + option_id mediumint(8) UNSIGNED NOT NULL, + field_type tinyint(4) NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (field_id, lang_id, option_id) ); # Table: 'phpbb_profile_lang' CREATE TABLE phpbb_profile_lang ( - field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - lang_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + field_id mediumint(8) UNSIGNED NOT NULL, + lang_id tinyint(4) UNSIGNED NOT NULL, lang_name varchar(255) DEFAULT '' NOT NULL, lang_explain text NOT NULL, lang_default_value varchar(255) DEFAULT '' NOT NULL, @@ -530,7 +530,7 @@ CREATE TABLE phpbb_profile_lang ( CREATE TABLE phpbb_ranks ( rank_id smallint(5) UNSIGNED NOT NULL auto_increment, rank_title varchar(50) NOT NULL, - rank_min mediumint(8) DEFAULT '0' NOT NULL, + rank_min mediumint(8) NOT NULL, rank_special tinyint(1) DEFAULT '0', rank_image varchar(100), PRIMARY KEY (rank_id) @@ -538,9 +538,9 @@ CREATE TABLE phpbb_ranks ( # Table: 'phpbb_ratings' CREATE TABLE phpbb_ratings ( - post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id tinyint(4) UNSIGNED UNSIGNED DEFAULT '0' NOT NULL, - rating tinyint(4) DEFAULT '0' NOT NULL, + post_id mediumint(8) UNSIGNED NOT NULL, + user_id tinyint(4) UNSIGNED UNSIGNED NOT NULL, + rating tinyint(4) NOT NULL, KEY post_id (post_id), KEY user_id (user_id) ); @@ -548,7 +548,7 @@ CREATE TABLE phpbb_ratings ( # Table: 'phpbb_reports_reasons' CREATE TABLE phpbb_reports_reasons ( reason_id smallint(6) NOT NULL auto_increment, - reason_priority tinyint(4) DEFAULT '0' NOT NULL, + reason_priority tinyint(4) NOT NULL, reason_name varchar(255) DEFAULT '' NOT NULL, reason_description text NOT NULL, PRIMARY KEY (reason_id) @@ -557,21 +557,21 @@ CREATE TABLE phpbb_reports_reasons ( # Table: 'phpbb_reports' CREATE TABLE phpbb_reports ( report_id smallint(5) UNSIGNED NOT NULL auto_increment, - reason_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL, - post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_notify tinyint(1) DEFAULT '0' NOT NULL, - report_time int(10) UNSIGNED DEFAULT '0' NOT NULL, + reason_id smallint(5) UNSIGNED NOT NULL, + post_id mediumint(8) UNSIGNED NOT NULL, + msg_id mediumint(8) UNSIGNED NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + user_notify tinyint(1) NOT NULL, + report_time int(10) UNSIGNED NOT NULL, report_text text NOT NULL, PRIMARY KEY (report_id) ); # Table: phpbb_search_results CREATE TABLE phpbb_search_results ( - search_id int(11) UNSIGNED DEFAULT '0' NOT NULL, + search_id int(11) UNSIGNED NOT NULL, session_id varchar(32) DEFAULT '' NOT NULL, - search_time int(11) DEFAULT '0' NOT NULL, + search_time int(11) NOT NULL, search_array text NOT NULL, PRIMARY KEY (search_id), KEY session_id (session_id) @@ -581,31 +581,31 @@ CREATE TABLE phpbb_search_results ( CREATE TABLE phpbb_search_wordlist ( word_text varchar(50) BINARY DEFAULT '' NOT NULL, word_id mediumint(8) UNSIGNED NOT NULL auto_increment, - word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + word_common tinyint(1) UNSIGNED NOT NULL, PRIMARY KEY (word_text), KEY word_id (word_id) ); # Table: phpbb_search_wordmatch CREATE TABLE phpbb_search_wordmatch ( - post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - title_match tinyint(1) DEFAULT '0' NOT NULL, + post_id mediumint(8) UNSIGNED NOT NULL, + word_id mediumint(8) UNSIGNED NOT NULL, + title_match tinyint(1) NOT NULL, KEY word_id (word_id) ); # Table: 'phpbb_sessions' CREATE TABLE phpbb_sessions ( session_id varchar(32) DEFAULT '' NOT NULL, - session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - session_last_visit int(11) DEFAULT '0' NOT NULL, - session_start int(11) DEFAULT '0' NOT NULL, - session_time int(11) DEFAULT '0' NOT NULL, - session_ip varchar(40) DEFAULT '0' NOT NULL, + session_user_id mediumint(8) UNSIGNED NOT NULL, + session_last_visit int(11) NOT NULL, + session_start int(11) NOT NULL, + session_time int(11) NOT NULL, + session_ip varchar(40) NOT NULL, session_browser varchar(100) DEFAULT '' NULL, session_page varchar(100) DEFAULT '' NOT NULL, session_viewonline tinyint(1) DEFAULT '1' NOT NULL, - session_admin tinyint(1) DEFAULT '0' NOT NULL, + session_admin tinyint(1) NOT NULL, PRIMARY KEY (session_id), KEY session_time (session_time), KEY session_user_id (session_user_id) @@ -616,7 +616,7 @@ CREATE TABLE phpbb_sitelist ( site_id mediumint(8) UNSIGNED NOT NULL auto_increment, site_ip varchar(40) DEFAULT '' NOT NULL, site_hostname varchar(255) DEFAULT '' NOT NULL, - ip_exclude tinyint(1) DEFAULT '0' NOT NULL, + ip_exclude tinyint(1) NOT NULL, PRIMARY KEY (site_id) ); @@ -655,8 +655,8 @@ CREATE TABLE phpbb_styles_template ( template_name varchar(30) NOT NULL, template_copyright varchar(50) NOT NULL, template_path varchar(30) NOT NULL, - bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, - template_storedb tinyint(1) DEFAULT '0' NOT NULL, + bbcode_bitfield int(11) UNSIGNED NOT NULL, + template_storedb tinyint(1) NOT NULL, PRIMARY KEY (template_id), UNIQUE template_name (template_name) ); @@ -666,7 +666,7 @@ CREATE TABLE phpbb_styles_template_data ( template_id tinyint(4) UNSIGNED NOT NULL, template_filename varchar(50) DEFAULT '' NOT NULL, template_included text NOT NULL, - template_mtime int(11) DEFAULT '0' NOT NULL, + template_mtime int(11) NOT NULL, template_data text, KEY (template_id), KEY (template_filename) @@ -678,8 +678,8 @@ CREATE TABLE phpbb_styles_theme ( theme_name varchar(30) DEFAULT '' NOT NULL, theme_copyright varchar(50) DEFAULT '' NOT NULL, theme_path varchar(30) DEFAULT '' NOT NULL, - theme_storedb tinyint(1) DEFAULT '0' NOT NULL, - theme_mtime int(11) DEFAULT '0' NOT NULL, + theme_storedb tinyint(1) NOT NULL, + theme_mtime int(11) NOT NULL, theme_data text DEFAULT '' NOT NULL, PRIMARY KEY (theme_id), UNIQUE theme_name (theme_name) @@ -775,36 +775,36 @@ CREATE TABLE phpbb_styles_imageset ( # Table: 'phpbb_topics' CREATE TABLE phpbb_topics ( topic_id mediumint(8) UNSIGNED NOT NULL auto_increment, - forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL, + forum_id smallint(8) UNSIGNED NOT NULL, icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, - topic_attachment tinyint(1) DEFAULT '0' NOT NULL, + topic_attachment tinyint(1) NOT NULL, topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, - topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + topic_reported tinyint(1) UNSIGNED NOT NULL, topic_title varchar(60) NOT NULL, - topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_time int(11) DEFAULT '0' NOT NULL, - topic_time_limit int(11) DEFAULT '0' NOT NULL, - topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_status tinyint(3) DEFAULT '0' NOT NULL, - topic_type tinyint(3) DEFAULT '0' NOT NULL, - topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_poster mediumint(8) UNSIGNED NOT NULL, + topic_time int(11) NOT NULL, + topic_time_limit int(11) NOT NULL, + topic_views mediumint(8) UNSIGNED NOT NULL, + topic_replies mediumint(8) UNSIGNED NOT NULL, + topic_replies_real mediumint(8) UNSIGNED NOT NULL, + topic_status tinyint(3) NOT NULL, + topic_type tinyint(3) NOT NULL, + topic_first_post_id mediumint(8) UNSIGNED NOT NULL, topic_first_poster_name varchar(30), - topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_last_post_id mediumint(8) UNSIGNED NOT NULL, + topic_last_poster_id mediumint(8) UNSIGNED NOT NULL, topic_last_poster_name varchar(30), - topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, - topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL, - topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + topic_last_post_time int(11) UNSIGNED NOT NULL, + topic_last_view_time int(11) UNSIGNED NOT NULL, + topic_moved_id mediumint(8) UNSIGNED NOT NULL, + topic_bumped tinyint(1) UNSIGNED NOT NULL, + topic_bumper mediumint(8) UNSIGNED NOT NULL, poll_title varchar(255) NOT NULL, - poll_start int(11) DEFAULT '0' NOT NULL, - poll_length int(11) DEFAULT '0' NOT NULL, + poll_start int(11) NOT NULL, + poll_length int(11) NOT NULL, poll_max_options tinyint(4) UNSIGNED DEFAULT '1' NOT NULL, poll_last_vote int(11) UNSIGNED DEFAULT '0', - poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + poll_vote_change tinyint(1) UNSIGNED NOT NULL, PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY forum_id_type (forum_id, topic_type), @@ -813,18 +813,18 @@ CREATE TABLE phpbb_topics ( # Table: 'phpbb_topic_marking' CREATE TABLE phpbb_topics_marking ( - user_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, - topic_id mediumint(9) UNSIGNED DEFAULT '0' NOT NULL, - mark_type tinyint(4) DEFAULT '0' NOT NULL, - mark_time int(11) DEFAULT '0' NOT NULL, + user_id mediumint(9) UNSIGNED NOT NULL, + topic_id mediumint(9) UNSIGNED NOT NULL, + mark_type tinyint(4) NOT NULL, + mark_time int(11) NOT NULL, PRIMARY KEY (user_id, topic_id) ); # Table: 'phpbb_topics_watch' CREATE TABLE phpbb_topics_watch ( - topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - notify_status tinyint(1) DEFAULT '0' NOT NULL, + topic_id mediumint(8) UNSIGNED NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + notify_status tinyint(1) NOT NULL, KEY topic_id (topic_id), KEY user_id (user_id), KEY notify_status (notify_status) @@ -832,9 +832,9 @@ CREATE TABLE phpbb_topics_watch ( # Table: 'phpbb_user_group' CREATE TABLE phpbb_user_group ( - group_id mediumint(8) DEFAULT '0' NOT NULL, - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - group_leader tinyint(1) DEFAULT '0' NOT NULL, + group_id mediumint(8) NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + group_leader tinyint(1) NOT NULL, user_pending tinyint(1), KEY group_id (group_id), KEY user_id (user_id), @@ -844,42 +844,42 @@ CREATE TABLE phpbb_user_group ( # Table: 'phpbb_users' CREATE TABLE phpbb_users ( user_id mediumint(8) UNSIGNED NOT NULL auto_increment, - user_type tinyint(1) DEFAULT '0' NOT NULL, + user_type tinyint(1) NOT NULL, group_id mediumint(8) DEFAULT '3' NOT NULL, user_permissions text DEFAULT '' NOT NULL, user_ip varchar(40) DEFAULT '' NOT NULL, - user_regdate int(11) DEFAULT '0' NOT NULL, + user_regdate int(11) NOT NULL, username varchar(30) DEFAULT '' NOT NULL, user_password varchar(32) DEFAULT '' NOT NULL, - user_passchg int(11) DEFAULT '0' NOT NULL, + user_passchg int(11) NOT NULL, user_email varchar(60) DEFAULT '' NOT NULL, - user_email_hash bigint(20) DEFAULT '0' NOT NULL, + user_email_hash bigint(20) NOT NULL, user_birthday varchar(10) DEFAULT '' NOT NULL, - user_lastvisit int(11) DEFAULT '0' NOT NULL, - user_lastpost_time int(11) DEFAULT '0' NOT NULL, + user_lastvisit int(11) NOT NULL, + user_lastpost_time int(11) NOT NULL, user_lastpage varchar(100) DEFAULT '' NOT NULL, user_last_confirm_key varchar(10) DEFAULT '' NOT NULL, - user_warnings tinyint(4) DEFAULT '0' NOT NULL, - user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, + user_warnings tinyint(4) NOT NULL, + user_posts mediumint(8) UNSIGNED NOT NULL, user_lang varchar(30) DEFAULT '' NOT NULL, user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL, - user_dst tinyint(1) DEFAULT '0' NOT NULL, + user_dst tinyint(1) NOT NULL, user_dateformat varchar(15) DEFAULT 'd M Y H:i' NOT NULL, - user_style tinyint(4) DEFAULT '0' NOT NULL, + user_style tinyint(4) NOT NULL, user_rank int(11) DEFAULT '0', user_colour varchar(6) DEFAULT '' NOT NULL, - user_new_privmsg tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_unread_privmsg tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_last_privmsg int(11) DEFAULT '0' NOT NULL, - user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, + user_new_privmsg tinyint(4) UNSIGNED NOT NULL, + user_unread_privmsg tinyint(4) UNSIGNED NOT NULL, + user_last_privmsg int(11) NOT NULL, + user_message_rules tinyint(1) UNSIGNED NOT NULL, user_full_folder int(11) DEFAULT '-3' NOT NULL, - user_emailtime int(11) DEFAULT '0' NOT NULL, + user_emailtime int(11) NOT NULL, user_sortby_type varchar(1) DEFAULT '' NOT NULL, user_sortby_dir varchar(1) DEFAULT '' NOT NULL, user_show_days tinyint(1) DEFAULT '' NOT NULL, - user_notify tinyint(1) DEFAULT '0' NOT NULL, + user_notify tinyint(1) NOT NULL, user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, - user_notify_type tinyint(4) DEFAULT '0' NOT NULL, + user_notify_type tinyint(4) NOT NULL, user_allow_pm tinyint(1) DEFAULT '1' NOT NULL, user_allow_email tinyint(1) DEFAULT '1' NOT NULL, user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL, @@ -887,12 +887,12 @@ CREATE TABLE phpbb_users ( user_allow_massemail tinyint(1) DEFAULT '1' NOT NULL, user_options int(11) DEFAULT '893' NOT NULL, user_avatar varchar(100) DEFAULT '' NOT NULL, - user_avatar_type tinyint(2) DEFAULT '0' NOT NULL, - user_avatar_width tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_avatar_height tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + user_avatar_type tinyint(2) NOT NULL, + user_avatar_width tinyint(4) UNSIGNED NOT NULL, + user_avatar_height tinyint(4) UNSIGNED NOT NULL, user_sig text DEFAULT '' NOT NULL, user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield int(11) DEFAULT '0' NOT NULL, + user_sig_bbcode_bitfield int(11) NOT NULL, user_from varchar(100) DEFAULT '' NOT NULL, user_icq varchar(15) DEFAULT '' NOT NULL, user_aim varchar(255) DEFAULT '' NOT NULL, @@ -920,10 +920,10 @@ CREATE TABLE phpbb_words ( # Table: 'phpbb_zebra' CREATE TABLE phpbb_zebra ( - user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - friend tinyint(1) DEFAULT '0' NOT NULL, - foe tinyint(1) DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED NOT NULL, + zebra_id mediumint(8) UNSIGNED NOT NULL, + friend tinyint(1) NOT NULL, + foe tinyint(1) NOT NULL, KEY user_id (user_id), KEY zebra_id (zebra_id) ); |