diff options
| author | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-09 11:20:10 -0800 |
|---|---|---|
| committer | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-09 11:20:10 -0800 |
| commit | 68e04701a8882268f8041d9d73b9a97d8390748c (patch) | |
| tree | 058537f7172369550ce5d38177d5a4ef9f504b6f /projecttemplates/RelyingPartyLogic/CreateDatabase.sql | |
| parent | 92a3935bf24efe40a12f6eb9e35421f8677efa75 (diff) | |
| download | DotNetOpenAuth-68e04701a8882268f8041d9d73b9a97d8390748c.zip DotNetOpenAuth-68e04701a8882268f8041d9d73b9a97d8390748c.tar.gz DotNetOpenAuth-68e04701a8882268f8041d9d73b9a97d8390748c.tar.bz2 | |
Fixed case sensitivity on security-critical columns in the database of the project template.
Diffstat (limited to 'projecttemplates/RelyingPartyLogic/CreateDatabase.sql')
| -rw-r--r-- | projecttemplates/RelyingPartyLogic/CreateDatabase.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql index dd42724..0470448 100644 --- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql +++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql @@ -27,7 +27,7 @@ GO 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) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, + [Code] [varchar](255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, [Issued] [datetime] NOT NULL, [Expires] [datetime] NOT NULL, CONSTRAINT [PK_Nonce] PRIMARY KEY CLUSTERED @@ -84,7 +84,7 @@ GO 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) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, + [ConsumerSecret] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL, [X509Certificate] [image] NULL, [Callback] [nvarchar](2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [VerificationCodeFormat] [int] NOT NULL, @@ -145,7 +145,7 @@ CREATE TABLE [dbo].[IssuedToken]( [TokenSecret] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, [CreatedOn] [datetime] NOT NULL, [Callback] [nvarchar](2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, - [VerificationCode] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, + [VerificationCode] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL, [ConsumerVersion] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ExpirationDate] [datetime] NULL, [IsAccessToken] [bit] NOT NULL, |