From 2483efe9a34df48a82bcceff5f966881fea2a37e Mon Sep 17 00:00:00 2001
From: Joseph Warner <hardolaf@hardolaf.com>
Date: Tue, 23 Jul 2013 22:18:41 -0400
Subject: [feature/oauth] Actual final schema changes

PHPBB3-11673
---
 phpBB/install/schemas/mssql_schema.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 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 36e3910bc8..b2fe8d1710 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -172,8 +172,8 @@ GO
 CREATE TABLE [phpbb_oauth_tokens] (
 	[user_id] [int] DEFAULT (0) NOT NULL ,
 	[session_id] [char] (32) DEFAULT ('') NOT NULL ,
-	[provider] [varchar] (255) NOT NULL ,
-	[oauth_token] [varchar] (4000) NOT NULL 
+	[provider] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[oauth_token] [varchar] (4000) DEFAULT ('') NOT NULL 
 ) ON [PRIMARY]
 GO
 
@@ -189,8 +189,8 @@ GO
 */
 CREATE TABLE [phpbb_oauth_accounts] (
 	[user_id] [int] DEFAULT (0) NOT NULL ,
-	[provider] [varchar] (255) NOT NULL ,
-	[oauth_provider_id] [varchar] (4000) NOT NULL 
+	[provider] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[oauth_provider_id] [varchar] (4000) DEFAULT ('') NOT NULL 
 ) ON [PRIMARY]
 GO
 
-- 
cgit v1.2.1

