CREATE TABLE [dbo].[SnapshotData]
(
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[ParamsHash] [int] NULL,
[QueryParams] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[EffectiveParams] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Description] [nvarchar] (512) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[DependsOnUser] [bit] NULL,
[PermanentRefcount] [int] NOT NULL,
[TransientRefcount] [int] NOT NULL,
[ExpirationDate] [datetime] NOT NULL,
[PageCount] [int] NULL,
[HasDocMap] [bit] NULL,
[Machine] [nvarchar] (512) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[SnapshotData] ADD CONSTRAINT [PK_SnapshotData] PRIMARY KEY CLUSTERED ([SnapshotDataID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IS_SnapshotExpiration] ON [dbo].[SnapshotData] ([PermanentRefcount], [ExpirationDate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SnapshotCleaning] ON [dbo].[SnapshotData] ([PermanentRefcount], [TransientRefcount]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[SnapshotData] TO [RSExecRole]
GRANT SELECT ON  [dbo].[SnapshotData] TO [RSExecRole]
GRANT INSERT ON  [dbo].[SnapshotData] TO [RSExecRole]
GRANT DELETE ON  [dbo].[SnapshotData] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[SnapshotData] TO [RSExecRole]
GO