CREATE TABLE [dbo].[HARVERSIONDATA]
(
[VERSIONDATAOBJID] [int] NOT NULL,
[REFCOUNTER] [int] NOT NULL CONSTRAINT [DF__HARVERSIO__REFCO__2334397B] DEFAULT ((0)),
[DATASIZE] [int] NOT NULL,
[COMPRESSED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[COMPDATASIZE] [int] NOT NULL CONSTRAINT [DF__HARVERSIO__COMPD__24285DB4] DEFAULT ((0)),
[FILEACCESS] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MODIFYTIME] [datetime] NULL,
[CREATETIME] [datetime] NULL,
[DCB] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TEXTFILE] [int] NOT NULL,
[ITEMOBJID] [int] NOT NULL CONSTRAINT [DF__HARVERSIO__ITEMO__251C81ED] DEFAULT ((0)),
[VERSIONDATA] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO

   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 [HARVERSIONDATA_PK] 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
EXEC sp_addextendedproperty N'Caption', N'The HARVERSIONDATA table stores the BLOB data of each version. ', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Compressed data size', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'COMPDATASIZE'
GO
EXEC sp_addextendedproperty N'Caption', N'Compressed or not (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'COMPRESSED'
GO
EXEC sp_addextendedproperty N'Caption', N'File creation time in file system', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'CREATETIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Data size', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'DATASIZE'
GO
EXEC sp_addextendedproperty N'Caption', N'For MVS system', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'DCB'
GO
EXEC sp_addextendedproperty N'Caption', N'File access record in file system', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'FILEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of item', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'ITEMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'File modification time in file system', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'MODIFYTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Reference counter', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'REFCOUNTER'
GO
EXEC sp_addextendedproperty N'Caption', N'Text or binary file (0/1)', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'TEXTFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Version data', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'VERSIONDATA'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of version data', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDATA', 'COLUMN', N'VERSIONDATAOBJID'
GO