CREATE TABLE [dbo].[CachePolicy]
(
[CachePolicyID] [uniqueidentifier] NOT NULL,
[ReportID] [uniqueidentifier] NOT NULL,
[ExpirationFlags] [int] NOT NULL,
[CacheExpiration] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CachePolicy] ADD CONSTRAINT [PK_CachePolicy] PRIMARY KEY NONCLUSTERED ([CachePolicyID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_CachePolicyReportID] ON [dbo].[CachePolicy] ([ReportID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CachePolicy] WITH NOCHECK ADD CONSTRAINT [FK_CachePolicyReportID] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[Catalog] ([ItemID]) ON DELETE CASCADE
GO
GRANT REFERENCES ON [dbo].[CachePolicy] TO [RSExecRole]
GRANT SELECT ON [dbo].[CachePolicy] TO [RSExecRole]
GRANT INSERT ON [dbo].[CachePolicy] TO [RSExecRole]
GRANT DELETE ON [dbo].[CachePolicy] TO [RSExecRole]
GRANT UPDATE ON [dbo].[CachePolicy] TO [RSExecRole]
GO
[dbo].[CachePolicy]
![Foreign Keys FK_CachePolicyReportID: [dbo].[Catalog].ReportID](../../Images/fk.gif)
