CREATE TABLE [dbo].[ExecutionCache]
(
[ExecutionCacheID] [uniqueidentifier] NOT NULL,
[ReportID] [uniqueidentifier] NOT NULL,
[ExpirationFlags] [int] NOT NULL,
[AbsoluteExpiration] [datetime] NULL,
[RelativeExpiration] [int] NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ExecutionCache] ADD CONSTRAINT [PK_ExecutionCache] PRIMARY KEY NONCLUSTERED ([ExecutionCacheID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_ExecutionCache] ON [dbo].[ExecutionCache] ([AbsoluteExpiration] DESC, [ReportID], [SnapshotDataID]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[ExecutionCache] TO [RSExecRole]
GRANT SELECT ON [dbo].[ExecutionCache] TO [RSExecRole]
GRANT INSERT ON [dbo].[ExecutionCache] TO [RSExecRole]
GRANT DELETE ON [dbo].[ExecutionCache] TO [RSExecRole]
GRANT UPDATE ON [dbo].[ExecutionCache] TO [RSExecRole]
GO
[dbo].[ExecutionCache]
