diff options
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 6 |
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] |