CREATE TABLE [dbo].[harversiondata]
(
[versiondataobjid] [int] NOT NULL,
[refcounter] [int] NOT NULL CONSTRAINT [DF__harversio__refco__6B1AC8E1] DEFAULT ((0)),
[datasize] [int] NOT NULL,
[compressed] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[compdatasize] [int] NOT NULL CONSTRAINT [DF__harversio__compd__6C0EED1A] DEFAULT ((0)),
[fileaccess] [char] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[modifytime] [datetime] NULL,
[createtime] [datetime] NULL,
[dcb] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textfile] [int] NOT NULL,
[itemobjid] [int] NOT NULL CONSTRAINT [DF__harversio__itemo__6D031153] DEFAULT ((0)),
[versiondata] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Trigger dbo.HARVERSIONDELTA_PARENTID_TRIGGER    Script Date: 12/1/2005 11:51:04 PM ******/



/* HARVERSIONDELTA - HARVERSIONDATA  TRIGGER */

CREATE TRIGGER HARVERSIONDELTA_PARENTID_TRIGGER ON dbo.HARVERSIONDATA FOR DELETE
AS

IF (@@ROWCOUNT = 0) RETURN

IF EXISTS(SELECT *
          FROM
              HARVERSIONDELTA AS E
            JOIN
              DELETED   AS D ON E.PARENTVERSIONDATAID = D.VERSIONDATAOBJID)
  DELETE FROM HARVERSIONDELTA
  FROM
      HARVERSIONDELTA AS E
    JOIN
      DELETED   AS D ON E.PARENTVERSIONDATAID = D.VERSIONDATAOBJID


GO
ALTER TABLE [dbo].[harversiondata] ADD CONSTRAINT [XPKharversiondata] PRIMARY KEY CLUSTERED ([versiondataobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONDATA_ITMID_FK] ON [dbo].[harversiondata] ([itemobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harversiondata] ADD CONSTRAINT [HARVERSIONDATA_ITMID_FK] FOREIGN KEY ([itemobjid]) REFERENCES [dbo].[haritems] ([itemobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harversiondata] TO [harvest_group]
GRANT INSERT ON  [dbo].[harversiondata] TO [harvest_group]
GRANT DELETE ON  [dbo].[harversiondata] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harversiondata] TO [harvest_group]
GRANT SELECT ON  [dbo].[harversiondata] TO [harvest_rep]
GO