CREATE TABLE [dbo].[REG_RESOURCE]
(
[REG_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_PATH] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_MEDIA_TYPE] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_COLLECTION] [int] NOT NULL,
[REG_CREATOR] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_CREATED_TIME] [datetime] NULL,
[REG_LAST_UPDATOR] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_LAST_UPDATED_TIME] [datetime] NULL,
[REG_DESCRIPTION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_CONTENT_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REG_EQUIVALENT_VERSION] [int] NOT NULL,
[REG_ASSOCIATED_SNAPSHOT_ID] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TRIGGER REG_RESOURCE_DEPENDENCY_CHILD_RID ON  REG_RESOURCE INSTEAD OF DELETE AS BEGIN SET NOCOUNT ON; DELETE FROM REG_DEPENDENCY where REG_CHILD_RID in ( SELECT REG_RID FROM DELETED); DELETE FROM REG_DEPENDENCY WHERE REG_PARENT_RID in ( SELECT REG_RID FROM DELETED); DELETE FROM REG_RESOURCE WHERE REG_RID in ( SELECT REG_RID FROM DELETED); END;
GO
ALTER TABLE [dbo].[REG_RESOURCE] ADD CONSTRAINT [PK__REG_RESOURCE__2D27B809] PRIMARY KEY CLUSTERED ([REG_RID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [REG_INDEX_RESOURCE_PATH] ON [dbo].[REG_RESOURCE] ([REG_PATH]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_RESOURCE] ADD CONSTRAINT [FK__REG_RESOU__REG_C__2E1BDC42] FOREIGN KEY ([REG_CONTENT_ID]) REFERENCES [dbo].[REG_CONTENT] ([REG_CONTENT_ID])
GO