CREATE TABLE [dbo].[HARVERSIONDELTA]
(
[CHILDVERSIONDATAID] [int] NOT NULL,
[PARENTVERSIONDATAID] [int] NOT NULL,
[DELTASIZE] [int] NOT NULL,
[VERSIONDELTA] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVERSIONDELTA] ADD CONSTRAINT [HARVERSIONDELTA_PK] PRIMARY KEY CLUSTERED ([CHILDVERSIONDATAID], [PARENTVERSIONDATAID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONDELTA_PARENT] ON [dbo].[HARVERSIONDELTA] ([PARENTVERSIONDATAID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVERSIONDELTA] ADD CONSTRAINT [HARVERSIONDELTA_CHIDID_FK] FOREIGN KEY ([CHILDVERSIONDATAID]) REFERENCES [dbo].[HARVERSIONDATA] ([VERSIONDATAOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARVERSIONDELTA table stores the result data of a list differences process.', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDELTA', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Child version data object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDELTA', 'COLUMN', N'CHILDVERSIONDATAID'
GO
EXEC sp_addextendedproperty N'Caption', N'Difference data size of two versions', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDELTA', 'COLUMN', N'DELTASIZE'
GO
EXEC sp_addextendedproperty N'Caption', N'Parent version data object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDELTA', 'COLUMN', N'PARENTVERSIONDATAID'
GO
EXEC sp_addextendedproperty N'Caption', N'Difference of two versions', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONDELTA', 'COLUMN', N'VERSIONDELTA'
GO