CREATE TABLE [dbo].[HARUSDDEPLOYINFO]
(
[PACKAGEOBJID] [int] NOT NULL,
[FORMOBJID] [int] NULL,
[TARGETOPERATINGSYSTEM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEVERSION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPLOYSEQUENCE] [int] NULL,
[BASEDONPACKAGE] [varchar] (172) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGECOMMENT] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLFILE] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLTYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLPARMS] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLFILE] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLTYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLPARMS] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOADPATH] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAYLOAD] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETSTATE1] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETGROUP1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETSTATE2] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETGROUP2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETSTATE3] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETGROUP3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETSTATE4] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETGROUP4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETSTATE5] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETGROUP5] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER5] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPLOYSTATE] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEFOREBOOTFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEFORELOGOFFFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AFTERBOOTFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AFTERLOGOFFFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OFFLINEFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PROMPTFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EXECPROMPTTIMEOUTFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USERCANCELFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RESOLVEQUERYGROUPSFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ATTACHMENTOBJID] [int] NULL,
[USDDEPLOYJOBUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DEPLOYSTATUS] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDJOBCONTAINERUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGEUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDVOLUMEUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDINSTALLPROCEDUREUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDUNINSTALLPROCEDUREUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDINSTALLJOBUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDBASEDONPACKAGEUUID] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDDEPLOYINFO_ATTACH_IND] ON [dbo].[HARUSDDEPLOYINFO] ([ATTACHMENTOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDDEPLOYINFO_FRM_IND] ON [dbo].[HARUSDDEPLOYINFO] ([FORMOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDDEPLOYINFO_PKG_IND] ON [dbo].[HARUSDDEPLOYINFO] ([PACKAGEOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSDDEPLOYINFO] ADD CONSTRAINT [HARUSDDEPLOYINFO_FRMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARUSDDEPLOYINFO] ADD CONSTRAINT [HARUSDDEPLOYINFO_PKGID_FK] FOREIGN KEY ([PACKAGEOBJID]) REFERENCES [dbo].[HARPACKAGE] ([PACKAGEOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDDEPLOYINFO table maintains USD software deployment information on a platform by platform basis.', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'After install restart flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'AFTERBOOTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'After install logoff flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'AFTERLOGOFFFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'The attachment ID if record created from a file attachment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'ATTACHMENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'The name and version of the USD package that the deployment is based on', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'BASEDONPACKAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Before install restart flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'BEFOREBOOTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Before install logoff flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'BEFORELOGOFFFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'The sequence used for generating USD package names', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'DEPLOYSEQUENCE'
GO
EXEC sp_addextendedproperty N'Caption', N'The life cycle state of the current deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'DEPLOYSTATE'
GO
EXEC sp_addextendedproperty N'Caption', N'The current status of the package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'DEPLOYSTATUS'
GO
EXEC sp_addextendedproperty N'Caption', N'Execution prompt timeout flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'EXECPROMPTTIMEOUTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Install filename', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'INSTALLFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Install file parameters', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'INSTALLPARMS'
GO
EXEC sp_addextendedproperty N'Caption', N'Install program type', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'INSTALLTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Staging path', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'LOADPATH'
GO
EXEC sp_addextendedproperty N'Caption', N'Offline flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'OFFLINEFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'The list of install parts', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'PAYLOAD'
GO
EXEC sp_addextendedproperty N'Caption', N'Prompt flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'PROMPTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Resolve query groups flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'RESOLVEQUERYGROUPSFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the first state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETCOMPUTER1'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the second state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETCOMPUTER2'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the third state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETCOMPUTER3'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the fourth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETCOMPUTER4'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the fifth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETCOMPUTER5'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the first state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETGROUP1'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the second state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETGROUP2'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the third state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETGROUP3'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the fourth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETGROUP4'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the fifth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETGROUP5'
GO
EXEC sp_addextendedproperty N'Caption', N'The platform operating system', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETOPERATINGSYSTEM'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the first or only deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETSTATE1'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the second deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETSTATE2'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the third state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETSTATE3'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the fourth deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETSTATE4'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the fifth deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'TARGETSTATE5'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall filename', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'UNINSTALLFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall file parameters', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'UNINSTALLPARMS'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall program type', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'UNINSTALLTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the USD package the deployment is based on', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDBASEDONPACKAGEUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the deploy job', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDDEPLOYJOBUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the Install Job', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDINSTALLJOBUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the USD uninstall procedure', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDINSTALLPROCEDUREUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the deploy job container', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDJOBCONTAINERUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'A comment associated with the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDPACKAGECOMMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'The name of the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDPACKAGEUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The version of the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDPACKAGEVERSION'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the USD uninstall procedure', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDUNINSTALLPROCEDUREUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'The UUID of the USD package volume', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USDVOLUMEUUID'
GO
EXEC sp_addextendedproperty N'Caption', N'Allow user cancel flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDDEPLOYINFO', 'COLUMN', N'USERCANCELFLAG'
GO