From 03b9af1f28c0d537d8459c9820e0f49464046e33 Mon Sep 17 00:00:00 2001 From: David M Date: Tue, 18 Apr 2006 02:41:59 +0000 Subject: - Olympus now properly works with MS SQL - DB backup system handles MS SQL - A few bug fixes to the backup system ;) git-svn-id: file:///svn/phpbb/trunk@5793 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/mssql_schema.sql | 2 ++ phpBB/install/schemas/schema_data.sql | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'phpBB/install') diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 2cd34cfd4e..93f80cf5e5 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -83,6 +83,7 @@ ALTER TABLE [phpbb_auth_groups] WITH NOCHECK ADD CONSTRAINT [DF_auth_g_group_id] DEFAULT (0) FOR [group_id], CONSTRAINT [DF_auth_g_forum_id] DEFAULT (0) FOR [forum_id], CONSTRAINT [DF_auth_g_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_g_auth_role_id] DEFAULT (0) FOR [auth_role_id], CONSTRAINT [DF_auth_g_auth_setting] DEFAULT (0) FOR [auth_setting] GO @@ -195,6 +196,7 @@ ALTER TABLE [phpbb_auth_users] WITH NOCHECK ADD CONSTRAINT [DF_auth_u_user_id] DEFAULT (0) FOR [user_id], CONSTRAINT [DF_auth_u_forum_id] DEFAULT (0) FOR [forum_id], CONSTRAINT [DF_auth_u_auth_option_id] DEFAULT (0) FOR [auth_option_id], + CONSTRAINT [DF_auth_u_auth_role_id] DEFAULT (0) FOR [auth_role_id], CONSTRAINT [DF_auth_u_auth_setting] DEFAULT (0) FOR [auth_setting] GO diff --git a/phpBB/install/schemas/schema_data.sql b/phpBB/install/schemas/schema_data.sql index 4174c287f3..9375dd15cc 100644 --- a/phpBB/install/schemas/schema_data.sql +++ b/phpBB/install/schemas/schema_data.sql @@ -445,7 +445,7 @@ INSERT INTO phpbb_bots (bot_id, bot_active, bot_name, user_id, bot_agent, bot_ip # MSSQL IDENTITY phpbb_bots OFF # -# MSSQL IDENTITY phpbb_modules OFF # +# MSSQL IDENTITY phpbb_modules ON # # -- Modules -- cgit v1.2.1