diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-04-18 02:41:59 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-04-18 02:41:59 +0000 |
| commit | 03b9af1f28c0d537d8459c9820e0f49464046e33 (patch) | |
| tree | abca94200c0c3855acda96f197363940a4835b2e /phpBB/install | |
| parent | 5b3d732456c281e4beaeb2f4aeb819a535e6d1be (diff) | |
| download | forums-03b9af1f28c0d537d8459c9820e0f49464046e33.tar forums-03b9af1f28c0d537d8459c9820e0f49464046e33.tar.gz forums-03b9af1f28c0d537d8459c9820e0f49464046e33.tar.bz2 forums-03b9af1f28c0d537d8459c9820e0f49464046e33.tar.xz forums-03b9af1f28c0d537d8459c9820e0f49464046e33.zip | |
- 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
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/schema_data.sql | 2 |
2 files changed, 3 insertions, 1 deletions
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 |