diff options
author | Graham Eames <grahamje@users.sourceforge.net> | 2006-09-23 12:39:48 +0000 |
---|---|---|
committer | Graham Eames <grahamje@users.sourceforge.net> | 2006-09-23 12:39:48 +0000 |
commit | a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583 (patch) | |
tree | 0fd0166ce4ef0f04db1090fd1bae9b4b103504a5 /phpBB/install/schemas/mssql_schema.sql | |
parent | cbece78f7b180253af95071ab859c468ed061ff5 (diff) | |
download | forums-a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583.tar forums-a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583.tar.gz forums-a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583.tar.bz2 forums-a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583.tar.xz forums-a5a9f16c0decb0a6d828f5ee46a7e6a1fb28c583.zip |
And the schema changes for the inactive user changes
git-svn-id: file:///svn/phpbb/trunk@6395 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 0b9b55824d..3e78b80161 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -404,7 +404,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] DEFAULT (0) NOT NULL , + [forum_desc_options] [int] 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 , @@ -413,7 +413,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] DEFAULT (0) NOT NULL , + [forum_rules_options] [int] DEFAULT (7) NOT NULL , [forum_rules_uid] [varchar] (5) DEFAULT ('') NOT NULL , [forum_topics_per_page] [int] DEFAULT (0) NOT NULL , [forum_type] [int] DEFAULT (0) NOT NULL , @@ -521,7 +521,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] DEFAULT (0) NOT NULL , + [group_desc_options] [int] DEFAULT (7) NOT NULL , [group_desc_uid] [varchar] (5) DEFAULT ('') NOT NULL , [group_display] [int] DEFAULT (0) NOT NULL , [group_avatar] [varchar] (255) DEFAULT ('') NOT NULL , @@ -1619,6 +1619,8 @@ CREATE TABLE [phpbb_users] ( [user_warnings] [int] DEFAULT (0) NOT NULL , [user_last_warning] [int] DEFAULT (0) NOT NULL , [user_login_attempts] [int] DEFAULT (0) NOT NULL , + [user_inactive_reason] [int] DEFAULT (0) NOT NULL , + [user_inactive_time] [int] DEFAULT (0) NOT NULL , [user_posts] [int] DEFAULT (0) NOT NULL , [user_lang] [varchar] (30) DEFAULT ('') NOT NULL , [user_timezone] [float] DEFAULT (0) NOT NULL , |