summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAndrew Arnott <andrewarnott@gmail.com>2009-12-09 11:24:53 -0800
committerAndrew Arnott <andrewarnott@gmail.com>2009-12-12 09:16:36 -0800
commit3a79bf93105e966a7b76baa2da8c864ba3f9d4c3 (patch)
treef34baa0b366dcb683ae103081cfa0b120909cb29
parent9eda89ad1ff263dd51af0468ab5dca6ace3b898e (diff)
downloadDotNetOpenAuth-3a79bf93105e966a7b76baa2da8c864ba3f9d4c3.zip
DotNetOpenAuth-3a79bf93105e966a7b76baa2da8c864ba3f9d4c3.tar.gz
DotNetOpenAuth-3a79bf93105e966a7b76baa2da8c864ba3f9d4c3.tar.bz2
Fixed db proj schema for project template as well.
-rw-r--r--projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Consumer.table.sql2
-rw-r--r--projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql2
-rw-r--r--projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql2
3 files changed, 3 insertions, 3 deletions
diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Consumer.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Consumer.table.sql
index a02948d..8549a78 100644
--- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Consumer.table.sql
+++ b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Consumer.table.sql
@@ -1,7 +1,7 @@
CREATE TABLE [dbo].[Consumer] (
[ConsumerId] INT IDENTITY (1, 1) NOT NULL,
[ConsumerKey] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
- [ConsumerSecret] NVARCHAR (255) NULL,
+ [ConsumerSecret] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[X509Certificate] IMAGE NULL,
[Callback] NVARCHAR (2048) NULL,
[VerificationCodeFormat] INT NOT NULL,
diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql
index c42523f..8882e93 100644
--- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql
+++ b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql
@@ -6,7 +6,7 @@
[TokenSecret] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[CreatedOn] DATETIME NOT NULL,
[Callback] NVARCHAR (2048) NULL,
- [VerificationCode] NVARCHAR (255) NULL,
+ [VerificationCode] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ConsumerVersion] VARCHAR (10) NULL,
[ExpirationDate] DATETIME NULL,
[IsAccessToken] BIT NOT NULL,
diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql
index 128d21a..bd52d69 100644
--- a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql
+++ b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Nonce.table.sql
@@ -1,7 +1,7 @@
CREATE TABLE [dbo].[Nonce] (
[NonceId] INT IDENTITY (1, 1) NOT NULL,
[Context] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
- [Code] VARCHAR (255) NOT NULL,
+ [Code] VARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[Issued] DATETIME NOT NULL,
[Expires] DATETIME NOT NULL
);