CREATE TABLE [dbo].[HARPROMOTEPROC]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[STATEOBJID] [int] NOT NULL,
[TOSTATEID] [int] NOT NULL,
[UPDPRIORSTATES] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MERGEDPKGSONLY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CHECKDEPENDENCIES] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARPROMOT__CHECK__3F115E1A] DEFAULT ('N'),
[FROMSTATEID] [int] NOT NULL CONSTRAINT [DF__HARPROMOT__FROMS__40058253] DEFAULT ((0)),
[ENFORCEBIND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARPROMOT__ENFOR__40F9A68C] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPROMOTEPROC] ADD CONSTRAINT [HARPROMOTEPROC_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPROMOTEPROC] ADD CONSTRAINT [HARPROMOTEPROC_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPROMOTEPROC table stores the definition of a promote process. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Check package dependency (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'CHECKDEPENDENCIES'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Enforce bind package group (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'ENFORCEBIND'
GO
EXEC sp_addextendedproperty N'Caption', N'State object ID of fromstate', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'FROMSTATEID'
GO
EXEC sp_addextendedproperty N'Caption', N'Allow unmerged packages (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'MERGEDPKGSONLY'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of destination state', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'TOSTATEID'
GO
EXEC sp_addextendedproperty N'Caption', N'Reserved for future use', 'SCHEMA', N'dbo', 'TABLE', N'HARPROMOTEPROC', 'COLUMN', N'UPDPRIORSTATES'
GO