aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mssql_schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r--phpBB/install/schemas/mssql_schema.sql6
1 files changed, 2 insertions, 4 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 93f80cf5e5..1dd49f53dc 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -131,8 +131,7 @@ CREATE TABLE [phpbb_auth_roles] (
[role_name] [varchar] (255) NOT NULL ,
[role_description] [text] ,
[role_type] [varchar] (10) NOT NULL ,
- [role_order] [int] NOT NULL ,
- [role_group_ids] [varchar] (255) NOT NULL
+ [role_order] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
@@ -144,8 +143,7 @@ ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD
GO
ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD
- CONSTRAINT [DF_auth_p_role_role_order] DEFAULT(0) FOR [role_order],
- CONSTRAINT [DF_auth_p_role_group_ids] DEFAULT ('') FOR [role_group_ids]
+ CONSTRAINT [DF_auth_p_role_role_order] DEFAULT(0) FOR [role_order]
GO
CREATE INDEX [role_type] ON [phpbb_auth_roles]([role_type]) ON [PRIMARY]