aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/firebird_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
1 files changed, 5 insertions, 3 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 25dd4dcf33..0237ea838f 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -352,7 +352,7 @@ CREATE TABLE phpbb_forums (
forum_name BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_desc_bitfield VARCHAR(252) DEFAULT '' NOT NULL,
- forum_desc_options INTEGER DEFAULT 0 NOT NULL,
+ forum_desc_options INTEGER DEFAULT 7 NOT NULL,
forum_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
forum_link VARCHAR(84) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,
forum_password VARCHAR(14) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,
@@ -361,7 +361,7 @@ CREATE TABLE phpbb_forums (
forum_rules BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
forum_rules_link VARCHAR(84) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,
forum_rules_bitfield VARCHAR(252) DEFAULT '' NOT NULL,
- forum_rules_options INTEGER DEFAULT 0 NOT NULL,
+ forum_rules_options INTEGER DEFAULT 7 NOT NULL,
forum_rules_uid VARCHAR(5) DEFAULT '' NOT NULL,
forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
forum_type INTEGER DEFAULT 0 NOT NULL,
@@ -440,7 +440,7 @@ CREATE TABLE phpbb_groups (
group_name VARCHAR(84) CHARACTER SET UNICODE_FSS DEFAULT '' NOT NULL,
group_desc BLOB SUB_TYPE TEXT DEFAULT '' NOT NULL,
group_desc_bitfield VARCHAR(252) DEFAULT '' NOT NULL,
- group_desc_options INTEGER DEFAULT 0 NOT NULL,
+ group_desc_options INTEGER DEFAULT 7 NOT NULL,
group_desc_uid VARCHAR(5) DEFAULT '' NOT NULL,
group_display INTEGER DEFAULT 0 NOT NULL,
group_avatar VARCHAR(255) DEFAULT '' NOT NULL,
@@ -1392,6 +1392,8 @@ CREATE TABLE phpbb_users (
user_warnings INTEGER DEFAULT 0 NOT NULL,
user_last_warning INTEGER DEFAULT 0 NOT NULL,
user_login_attempts INTEGER DEFAULT 0 NOT NULL,
+ user_inactive_reason INTEGER DEFAULT 0 NOT NULL,
+ user_inactive_time INTEGER DEFAULT 0 NOT NULL,
user_posts INTEGER DEFAULT 0 NOT NULL,
user_lang VARCHAR(30) DEFAULT '' NOT NULL,
user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,