CREATE TABLE [dbo].[HARPKGHISTORY]
(
[PACKAGEOBJID] [int] NOT NULL,
[STATENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[STATEOBJID] [int] NULL,
[ENVIRONMENTNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[ENVOBJID] [int] NULL,
[EXECDTIME] [datetime] NOT NULL,
[USROBJID] [int] NOT NULL,
[ACTION] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPKGHISTORY_ACTION_IND] ON [dbo].[HARPKGHISTORY] ([ACTION]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPKGHIST_IND] ON [dbo].[HARPKGHISTORY] ([PACKAGEOBJID]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPKGHISTORY table stores information used for reporting and for providing history information on a package. HARPKGHISTORY records associated with a particular package are not deleted when the package is deleted from its associated state. This means that the size of this table will always increase and will not decrease when packages are deleted.', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Action performed on package', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'ACTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of project', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'ENVIRONMENTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time of package operation', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'EXECDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of state', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'STATENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user', 'SCHEMA', N'dbo', 'TABLE', N'HARPKGHISTORY', 'COLUMN', N'USROBJID'
GO