CREATE TABLE [dbo].[HARPACKAGESTATUS]
(
[PACKAGEOBJID] [int] NOT NULL,
[CLIENTNAME] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SERVERNAME] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STATUSINFO] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPACKAGESTATUS] ADD CONSTRAINT [HARPACKAGESTATUS_PK] PRIMARY KEY CLUSTERED ([PACKAGEOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPACKAGESTATUS_C_IDX] ON [dbo].[HARPACKAGESTATUS] ([CLIENTNAME], [STATUSINFO]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPACKAGESTATUS_S_IDX] ON [dbo].[HARPACKAGESTATUS] ([SERVERNAME]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPACKAGESTATUS] ADD CONSTRAINT [HARPACKAGESTATUS_FK] FOREIGN KEY ([PACKAGEOBJID]) REFERENCES [dbo].[HARPACKAGE] ([PACKAGEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'Stores package status attributes used for resetting package status.', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGESTATUS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'When package status is not idle, this is the name of the client process that is operating on the package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGESTATUS', 'COLUMN', N'CLIENTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGESTATUS', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'When package status is not idle, this is the name of the server process that is operating on the package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGESTATUS', 'COLUMN', N'SERVERNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'STATUSINFO is set to P by Part 1 of a 2-part process (promote,demote,and interactive merge). Part 2 resets STATUSINFO to null.', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGESTATUS', 'COLUMN', N'STATUSINFO'
GO