[dbo].[MssWebPersistedGrant]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count (~)	0
Created	9:07:53 AM Thursday, May 23, 2024
Last Modified	9:08:58 AM Thursday, May 23, 2024

	Name	Data Type	Max Length (Bytes)
	Key	nvarchar(200)	400
$Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\Type$	ClientId	nvarchar(200)	400
	CreationTime	datetime2	8
	Data	nvarchar(max)	max
	Expiration	datetime2	8
$Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\Type$	SubjectId	nvarchar(200)	400
$Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\Type$	Type	nvarchar(50)	100
	SessionId	nvarchar(max)	max
	Description	nvarchar(max)	max
	ConsumedTime	nvarchar(max)	max

	Name	Columns	Unique
	PK_MssWebPersistedGrant	Key
	IX_MssWebPersistedGrant_Expiration	Expiration
	IX_MssWebPersistedGrant_SubjectId_ClientId_Type	SubjectId, ClientId, Type

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

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