CREATE TABLE [dbo].[HARVERSIONTRACKING]
(
[VERSIONOBJID] [int] NOT NULL,
[ACTION] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VIEWOBJID] [int] NOT NULL,
[STATEOBJID] [int] NOT NULL,
[FROMPKGOBJID] [int] NOT NULL,
[TOPKGOBJID] [int] NOT NULL,
[INBRANCH] [int] NOT NULL,
[VERSIONSTATUS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MAPPEDVERSION] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EXECDTIME] [datetime] NOT NULL,
[USROBJID] [int] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONTRACKING_FK_IND] ON [dbo].[HARVERSIONTRACKING] ([VERSIONOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVERSIONTRACKING] ADD CONSTRAINT [HARVERSIONTRACKING_VERID_FK] FOREIGN KEY ([VERSIONOBJID]) REFERENCES [dbo].[HARVERSIONS] ([VERSIONOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'This table stores historic values that exist for the version at the time of the switch package operation (that is, at EXECDTIME). The columns in this table are not synchronized with the current values for the version in the HARVERSIONS table.', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Action or process performed on the package, for example, switch package', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'ACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of package operation', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'EXECDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of source package', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'FROMPKGOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Version is a trunk (0) or branch (1)', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'INBRANCH'
GO
EXEC sp_addextendedproperty N'Caption', N'Version string', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'MAPPEDVERSION'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of target package', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'TOPKGOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'USROBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Version object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'VERSIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Status tag: Normal (N), Deleted (D), Reserve (R), Merge (M)', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'VERSIONSTATUS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of view', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONTRACKING', 'COLUMN', N'VIEWOBJID'
GO