diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_41_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 593980ea9b..f907a49fbe 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -224,7 +224,7 @@ CREATE TABLE phpbb_forums ( forum_name text DEFAULT '' NOT NULL, forum_desc text DEFAULT '' NOT NULL, forum_desc_bitfield varchar(252) DEFAULT '' NOT NULL, - forum_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL, + forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, forum_desc_uid varchar(5) DEFAULT '' NOT NULL, forum_link varchar(255) DEFAULT '' NOT NULL, forum_password varchar(40) DEFAULT '' NOT NULL, @@ -233,7 +233,7 @@ CREATE TABLE phpbb_forums ( forum_rules text DEFAULT '' NOT NULL, forum_rules_link varchar(255) DEFAULT '' NOT NULL, forum_rules_bitfield varchar(252) DEFAULT '' NOT NULL, - forum_rules_options int(11) UNSIGNED DEFAULT '0' NOT NULL, + forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL, forum_rules_uid varchar(5) DEFAULT '' NOT NULL, forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL, forum_type tinyint(4) DEFAULT '0' NOT NULL, @@ -298,7 +298,7 @@ CREATE TABLE phpbb_groups ( group_name varchar(252) DEFAULT '' NOT NULL, group_desc text DEFAULT '' NOT NULL, group_desc_bitfield varchar(252) DEFAULT '' NOT NULL, - group_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL, + group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, group_desc_uid varchar(5) DEFAULT '' NOT NULL, group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, group_avatar varchar(255) DEFAULT '' NOT NULL, @@ -979,6 +979,8 @@ CREATE TABLE phpbb_users ( user_warnings tinyint(4) DEFAULT '0' NOT NULL, user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL, user_login_attempts tinyint(4) DEFAULT '0' NOT NULL, + user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL, + user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL, user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_lang varchar(30) DEFAULT '' NOT NULL, user_timezone decimal(5,2) DEFAULT '0' NOT NULL, |