CREATE TABLE [dbo].[HARCHECKINPROC]
(
[PROCESSOBJID] [int] NOT NULL,
[PROCESSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[STATEOBJID] [int] NOT NULL,
[ITEMOPTION] [int] NOT NULL,
[PATHOPTION] [int] NOT NULL,
[ITEMNEWER] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MODEOPTION] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL,
[MODIFIERID] [int] NOT NULL,
[NEWOREXISTINGITEM] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NEWITEMONLY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EXISTINGITEMONLY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DELETEAFTERCI] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OWNERONLY] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FORCECOMMENT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARCHECKI__FORCE__1920BF5C] DEFAULT ('N'),
[ONTRUNK] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARCHECKI__ONTRU__1A14E395] DEFAULT ('Y'),
[ONBRANCH] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARCHECKI__ONBRA__1B0907CE] DEFAULT ('N'),
[VIEWPATH] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CLIENTDIR] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARCHECKINPROC] ADD CONSTRAINT [HARCHECKINPROC_PK] PRIMARY KEY CLUSTERED ([PROCESSOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARCHECKINPROC] ADD CONSTRAINT [HARCHECKINPROC_SPID_FK] FOREIGN KEY ([STATEOBJID], [PROCESSOBJID]) REFERENCES [dbo].[HARSTATEPROCESS] ([STATEOBJID], [PROCESSOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARCHECKINPROC table stores the definition of a check-in process.', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Client directory path name', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'CLIENTDIR'
GO
EXEC sp_addextendedproperty N'Caption', N'Time process was created', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user to create', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in option (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'DELETEAFTERCI'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined description', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'DESCRIPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in option (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'EXISTINGITEMONLY'
GO
EXEC sp_addextendedproperty N'Caption', N'Force comment (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'FORCECOMMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'New item (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'ITEMNEWER'
GO
EXEC sp_addextendedproperty N'Caption', N'New/existing item option', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'ITEMOPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in mode', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'MODEOPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Time process was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user to modify', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in option (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'NEWITEMONLY'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in option (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'NEWOREXISTINGITEM'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Can new items be checked in to a branch (Y/N).  Defaults to N.', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'ONBRANCH'
GO
EXEC sp_addextendedproperty N'Caption', N'Can new items be checked in to the trunk (Y/N).  Defaults to Y.', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'ONTRUNK'
GO
EXEC sp_addextendedproperty N'Caption', N'Exclusive check-in flag (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'OWNERONLY'
GO
EXEC sp_addextendedproperty N'Caption', N'Check-in path option setting', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'PATHOPTION'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of the process', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'PROCESSNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of process', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'PROCESSOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'View path name', 'SCHEMA', N'dbo', 'TABLE', N'HARCHECKINPROC', 'COLUMN', N'VIEWPATH'
GO