IdentityServer4 SQL scripts for SqlServer: PersistedGrants and DeviceCodes tables

PersistedGrantDb.sql

CREATE TABLE "PersistedGrants"
(
    "Key" varchar(200) NOT NULL,
    "Type" varchar(50) NOT NULL,
    "SubjectId" varchar(200),
    "SessionId" varchar(100),
    "ClientId" varchar(200) NOT NULL,
    "Description" varchar(200),
    "CreationTime" datetime NOT NULL,
    "Expiration" datetime,
    "ConsumedTime" datetime,
    "Data" varchar(max) NOT NULL,
    CONSTRAINT "PK_PersistedGrants" PRIMARY KEY ("Key")
)
GO
CREATE INDEX "IX_PersistedGrants_Expiration" ON "PersistedGrants" ("Expiration");
CREATE INDEX "IX_PersistedGrants_SubjectId_ClientId_Type" ON "PersistedGrants" ("SubjectId", "ClientId", "Type");
CREATE INDEX "IX_PersistedGrants_SubjectId_SessionId_Type" ON "PersistedGrants" ("SubjectId", "SessionId", "Type");
GO
CREATE TABLE "DeviceCodes"
(
    "UserCode" varchar(200) NOT NULL,
    "DeviceCode" varchar(200) NOT NULL,
    "SubjectId" varchar(200),
    "SessionId" varchar(100),
    "ClientId" varchar(200) NOT NULL,
    "Description" varchar(200),
    "CreationTime" datetime NOT NULL,
    "Expiration" datetime NOT NULL,
    "Data" varchar(max) NOT NULL,
    CONSTRAINT "PK_DeviceCodes" PRIMARY KEY ("UserCode")
)
GO
CREATE UNIQUE INDEX "IX_DeviceCodes_DeviceCode" ON "DeviceCodes" ("DeviceCode");
CREATE INDEX "IX_DeviceCodes_Expiration" ON "DeviceCodes" ("Expiration");