From 698a2236a5e26bdae9359939f6e6be9cfa988b9a Mon Sep 17 00:00:00 2001
From: Joas Schilling <nickvergessen@gmx.de>
Date: Fri, 11 Oct 2013 11:59:28 +0200
Subject: [ticket/11867] Schema files are not created by
create_schema_files.php
PHPBB3-11867
---
phpBB/install/schemas/mssql_schema.sql | 74 +++++++++++++++++-----------------
1 file changed, 37 insertions(+), 37 deletions(-)
(limited to 'phpBB/install/schemas/mssql_schema.sql')
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 922313236e..49804bdcc0 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -166,43 +166,6 @@ CREATE INDEX [auth_role_id] ON [phpbb_acl_users]([auth_role_id]) ON [PRIMARY]
GO
-/*
- Table: 'phpbb_oauth_tokens'
-*/
-CREATE TABLE [phpbb_oauth_tokens] (
- [user_id] [int] DEFAULT (0) NOT NULL ,
- [session_id] [char] (32) DEFAULT ('') NOT NULL ,
- [provider] [varchar] (255) DEFAULT ('') NOT NULL ,
- [oauth_token] [text] DEFAULT ('') NOT NULL
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-CREATE INDEX [user_id] ON [phpbb_oauth_tokens]([user_id]) ON [PRIMARY]
-GO
-
-CREATE INDEX [provider] ON [phpbb_oauth_tokens]([provider]) ON [PRIMARY]
-GO
-
-
-/*
- Table: 'phpbb_oauth_accounts'
-*/
-CREATE TABLE [phpbb_oauth_accounts] (
- [user_id] [int] DEFAULT (0) NOT NULL ,
- [provider] [varchar] (255) DEFAULT ('') NOT NULL ,
- [oauth_provider_id] [varchar] (4000) DEFAULT ('') NOT NULL
-) ON [PRIMARY]
-GO
-
-ALTER TABLE [phpbb_oauth_accounts] WITH NOCHECK ADD
- CONSTRAINT [PK_phpbb_oauth_accounts] PRIMARY KEY CLUSTERED
- (
- [user_id],
- [provider]
- ) ON [PRIMARY]
-GO
-
-
/*
Table: 'phpbb_banlist'
*/
@@ -879,6 +842,43 @@ CREATE INDEX [user] ON [phpbb_notifications]([user_id], [notification_read]) ON
GO
+/*
+ Table: 'phpbb_oauth_accounts'
+*/
+CREATE TABLE [phpbb_oauth_accounts] (
+ [user_id] [int] DEFAULT (0) NOT NULL ,
+ [provider] [varchar] (255) DEFAULT ('') NOT NULL ,
+ [oauth_provider_id] [varchar] (4000) DEFAULT ('') NOT NULL
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [phpbb_oauth_accounts] WITH NOCHECK ADD
+ CONSTRAINT [PK_phpbb_oauth_accounts] PRIMARY KEY CLUSTERED
+ (
+ [user_id],
+ [provider]
+ ) ON [PRIMARY]
+GO
+
+
+/*
+ Table: 'phpbb_oauth_tokens'
+*/
+CREATE TABLE [phpbb_oauth_tokens] (
+ [user_id] [int] DEFAULT (0) NOT NULL ,
+ [session_id] [char] (32) DEFAULT ('') NOT NULL ,
+ [provider] [varchar] (255) DEFAULT ('') NOT NULL ,
+ [oauth_token] [text] DEFAULT ('') NOT NULL
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+GO
+
+CREATE INDEX [user_id] ON [phpbb_oauth_tokens]([user_id]) ON [PRIMARY]
+GO
+
+CREATE INDEX [provider] ON [phpbb_oauth_tokens]([provider]) ON [PRIMARY]
+GO
+
+
/*
Table: 'phpbb_poll_options'
*/
--
cgit v1.2.1