CREATE TABLE [dbo].[MssWebPersistedGrant]
(
[Key] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClientId] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreationTime] [datetime2] NOT NULL,
[Data] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Expiration] [datetime2] NULL,
[SubjectId] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SessionId] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConsumedTime] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebPersistedGrant] ADD CONSTRAINT [PK_MssWebPersistedGrant] PRIMARY KEY CLUSTERED  ([Key]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MssWebPersistedGrant_Expiration] ON [dbo].[MssWebPersistedGrant] ([Expiration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MssWebPersistedGrant_SubjectId_ClientId_Type] ON [dbo].[MssWebPersistedGrant] ([SubjectId], [ClientId], [Type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT INSERT ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT DELETE ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT UPDATE ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GO