diff options
| author | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-12 09:26:21 -0800 |
|---|---|---|
| committer | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-12 09:26:21 -0800 |
| commit | 764a5c47d2d5042ee0e2cec54f9cee7011b949a1 (patch) | |
| tree | 6fe8912555b67597a93ecf36f31707a592755bdd /projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql | |
| parent | 077d53305f2e3ba2247e0ad7a396727e21a9cfff (diff) | |
| parent | c578ed605653e848253ad6940c9d522846812a53 (diff) | |
| download | DotNetOpenAuth-764a5c47d2d5042ee0e2cec54f9cee7011b949a1.zip DotNetOpenAuth-764a5c47d2d5042ee0e2cec54f9cee7011b949a1.tar.gz DotNetOpenAuth-764a5c47d2d5042ee0e2cec54f9cee7011b949a1.tar.bz2 | |
Project template's database schema now derives from a database project.
Merge branch 'projtemplateDBproject' into v3.3
Diffstat (limited to 'projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql')
| -rw-r--r-- | projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql new file mode 100644 index 0000000..8882e93 --- /dev/null +++ b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/IssuedToken.table.sql @@ -0,0 +1,15 @@ +CREATE TABLE [dbo].[IssuedToken] ( + [IssuedTokenId] INT IDENTITY (1, 1) NOT NULL, + [ConsumerId] INT NOT NULL, + [UserId] INT NULL, + [Token] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, + [TokenSecret] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, + [CreatedOn] DATETIME NOT NULL, + [Callback] NVARCHAR (2048) NULL, + [VerificationCode] NVARCHAR (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL, + [ConsumerVersion] VARCHAR (10) NULL, + [ExpirationDate] DATETIME NULL, + [IsAccessToken] BIT NOT NULL, + [Scope] NVARCHAR (255) NULL +); + |