diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index f89f468085..fad2c457e3 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -195,9 +195,9 @@ CREATE TABLE phpbb_extension_groups ( # Table: 'phpbb_forums' CREATE TABLE phpbb_forums ( forum_id smallint(5) UNSIGNED NOT NULL auto_increment, - parent_id smallint(5) UNSIGNED NOT NULL, - left_id smallint(5) UNSIGNED NOT NULL, - right_id smallint(5) UNSIGNED NOT NULL, + parent_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, + left_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, + right_id smallint(5) DEFAULT '0' UNSIGNED NOT NULL, forum_parents text, forum_name text, forum_desc text, @@ -227,8 +227,8 @@ CREATE TABLE phpbb_forums ( enable_icons tinyint(1) DEFAULT '1' NOT NULL, enable_prune tinyint(1) DEFAULT '0' NOT NULL, prune_next int(11) UNSIGNED, - prune_days tinyint(4) UNSIGNED NOT NULL, - prune_viewed tinyint(4) UNSIGNED NOT NULL, + prune_days tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + prune_viewed tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, prune_freq tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (forum_id), KEY left_right_id (left_id, right_id), @@ -289,9 +289,9 @@ CREATE TABLE phpbb_groups ( CREATE TABLE phpbb_icons ( icons_id tinyint(4) UNSIGNED NOT NULL auto_increment, icons_url varchar(255), - icons_width tinyint(4) UNSIGNED NOT NULL, - icons_height tinyint(4) UNSIGNED NOT NULL, - icons_order tinyint(4) UNSIGNED NOT NULL, + icons_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + icons_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + icons_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, PRIMARY KEY (icons_id) ); @@ -311,12 +311,12 @@ CREATE TABLE phpbb_lang ( CREATE TABLE phpbb_log ( log_id mediumint(8) UNSIGNED NOT NULL auto_increment, log_type tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - user_id mediumint(8) DEFAULT '0' NOT NULL, + user_id mediumint(8) UNSIGNED 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_ip varchar(40) NOT NULL, - log_time int(11) NOT NULL, + log_time int(11) DEFAULT '0' NOT NULL, log_operation text, log_data text, PRIMARY KEY (log_id), @@ -329,7 +329,7 @@ CREATE TABLE phpbb_log ( # Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( - forum_id mediumint(8) UNSIGNED NOT NULL, + forum_id mediumint(8) DEFAULT '0' UNSIGNED NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -361,7 +361,7 @@ CREATE TABLE phpbb_modules ( # Table: 'phpbb_poll_options' CREATE TABLE phpbb_poll_options ( poll_option_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - topic_id mediumint(8) UNSIGNED NOT NULL, + topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, poll_option_text text, poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, KEY poll_option_id (poll_option_id), @@ -491,7 +491,7 @@ CREATE TABLE phpbb_privmsgs_to ( CREATE TABLE phpbb_profile_fields ( field_id mediumint(8) UNSIGNED NOT NULL auto_increment, field_name varchar(255) DEFAULT '' NOT NULL, - field_type mediumint(8) UNSIGNED NOT NULL, + field_type mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, field_ident varchar(20) DEFAULT '' NOT NULL, field_length varchar(20) DEFAULT '' NOT NULL, field_minlen varchar(255) DEFAULT '' NOT NULL, @@ -637,9 +637,9 @@ CREATE TABLE phpbb_smilies ( code varchar(50), emotion varchar(50), smiley_url varchar(50), - smiley_width tinyint(4) UNSIGNED NOT NULL, - smiley_height tinyint(4) UNSIGNED NOT NULL, - smiley_order tinyint(4) UNSIGNED NOT NULL, + smiley_width tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + smiley_height tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, + smiley_order tinyint(4) DEFAULT '0' UNSIGNED NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, PRIMARY KEY (smiley_id) ); @@ -650,9 +650,9 @@ CREATE TABLE phpbb_styles ( style_name varchar(255) DEFAULT '' NOT NULL, style_copyright varchar(255) DEFAULT '' NOT NULL, style_active tinyint(1) DEFAULT '1' NOT NULL, - template_id tinyint(4) UNSIGNED NOT NULL, - theme_id tinyint(4) UNSIGNED NOT NULL, - imageset_id tinyint(4) UNSIGNED NOT NULL, + template_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + theme_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, + imageset_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (style_id), UNIQUE style_name (style_name), KEY (template_id), @@ -674,7 +674,7 @@ CREATE TABLE phpbb_styles_template ( # Table: 'phpbb_styles_template_data' CREATE TABLE phpbb_styles_template_data ( - template_id tinyint(4) UNSIGNED NOT NULL, + template_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, template_filename varchar(100) DEFAULT '' NOT NULL, template_included text, template_mtime int(11) DEFAULT '0' NOT NULL, |