CREATE TABLE [dbo].[Catalog]
(
[ItemID] [uniqueidentifier] NOT NULL,
[Path] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[Name] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[ParentID] [uniqueidentifier] NULL,
[Type] [int] NOT NULL,
[Content] [image] NULL,
[Intermediate] [uniqueidentifier] NULL,
[SnapshotDataID] [uniqueidentifier] NULL,
[LinkSourceID] [uniqueidentifier] NULL,
[Property] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Description] [nvarchar] (512) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Hidden] [bit] NULL,
[CreatedByID] [uniqueidentifier] NOT NULL,
[CreationDate] [datetime] NOT NULL,
[ModifiedByID] [uniqueidentifier] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
[MimeType] [nvarchar] (260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[SnapshotLimit] [int] NULL,
[Parameter] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[PolicyID] [uniqueidentifier] NOT NULL,
[PolicyRoot] [bit] NOT NULL,
[ExecutionFlag] [int] NOT NULL,
[ExecutionTime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Catalog] ADD CONSTRAINT [PK_Catalog] PRIMARY KEY NONCLUSTERED ([ItemID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Link] ON [dbo].[Catalog] ([LinkSourceID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Parent] ON [dbo].[Catalog] ([ParentID]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_Catalog] ON [dbo].[Catalog] ([Path]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Catalog] WITH NOCHECK ADD CONSTRAINT [FK_Catalog_CreatedByID] FOREIGN KEY ([CreatedByID]) REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Catalog] WITH NOCHECK ADD CONSTRAINT [FK_Catalog_LinkSourceID] FOREIGN KEY ([LinkSourceID]) REFERENCES [dbo].[Catalog] ([ItemID])
GO
ALTER TABLE [dbo].[Catalog] WITH NOCHECK ADD CONSTRAINT [FK_Catalog_ModifiedByID] FOREIGN KEY ([ModifiedByID]) REFERENCES [dbo].[Users] ([UserID])
GO
ALTER TABLE [dbo].[Catalog] WITH NOCHECK ADD CONSTRAINT [FK_Catalog_ParentID] FOREIGN KEY ([ParentID]) REFERENCES [dbo].[Catalog] ([ItemID])
GO
ALTER TABLE [dbo].[Catalog] WITH NOCHECK ADD CONSTRAINT [FK_Catalog_Policy] FOREIGN KEY ([PolicyID]) REFERENCES [dbo].[Policies] ([PolicyID])
GO
GRANT REFERENCES ON  [dbo].[Catalog] TO [RSExecRole]
GRANT SELECT ON  [dbo].[Catalog] TO [RSExecRole]
GRANT INSERT ON  [dbo].[Catalog] TO [RSExecRole]
GRANT DELETE ON  [dbo].[Catalog] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[Catalog] TO [RSExecRole]
GO