CREATE TABLE [dbo].[HARUSDPLATFORMINFO]
(
[FORMOBJID] [int] NOT NULL,
[USDPACKAGENAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BASEDONPACKAGE] [varchar] (172) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LOADPATH] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLFILE] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLPARMS] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[INSTALLTYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLFILE] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLPARMS] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UNINSTALLTYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEFORELOGOFFFLAG] [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,
[RESOLVEQUERYGROUPSFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PAYLOAD] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USDPACKAGECOMMENT] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETOPERATINGSYSTEM] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[USERCANCELFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BEFOREBOOTFLAG] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AFTERBOOTFLAG] [char] (1) 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,
[TARGETGROUP4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TARGETCOMPUTER4] [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
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARUSDPLATFORMINFO_FRM_IND] ON [dbo].[HARUSDPLATFORMINFO] ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARUSDPLATFORMINFO] ADD CONSTRAINT [HARUSDPLATFORMINFO_FRMID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARUSDPLATFORMINFO table maintains USD package information on a platform basis. ', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'After install restart flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'AFTERBOOTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'After install logoff flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'AFTERLOGOFFFLAG'
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'HARUSDPLATFORMINFO', 'COLUMN', N'BASEDONPACKAGE'
GO
EXEC sp_addextendedproperty N'Caption', N'Before install restart flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'BEFOREBOOTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Before install logoff flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'BEFORELOGOFFFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Execution prompt timeout flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'EXECPROMPTTIMEOUTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'FORMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Install filename', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'INSTALLFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Install file parameters', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'INSTALLPARMS'
GO
EXEC sp_addextendedproperty N'Caption', N'Install program type', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'INSTALLTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Staging path', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'LOADPATH'
GO
EXEC sp_addextendedproperty N'Caption', N'Offline flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'OFFLINEFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'The list of install parts', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'PAYLOAD'
GO
EXEC sp_addextendedproperty N'Caption', N'Prompt flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'PROMPTFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'Resolve query groups flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'RESOLVEQUERYGROUPSFLAG'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the first state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETCOMPUTER1'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the second state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETCOMPUTER2'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the third state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETCOMPUTER3'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the fourth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETCOMPUTER4'
GO
EXEC sp_addextendedproperty N'Caption', N'The target computer associated with the fifth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETCOMPUTER5'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the first state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETGROUP1'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the second state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETGROUP2'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the third state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETGROUP3'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the fourth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETGROUP4'
GO
EXEC sp_addextendedproperty N'Caption', N'The target group associated with the fifth state', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETGROUP5'
GO
EXEC sp_addextendedproperty N'Caption', N'The platform operating system', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETOPERATINGSYSTEM'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the first or only deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETSTATE1'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the second deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETSTATE2'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the third deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETSTATE3'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the fourth deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETSTATE4'
GO
EXEC sp_addextendedproperty N'Caption', N'The state associated with the fifth deployment', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'TARGETSTATE5'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall filename', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'UNINSTALLFILE'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall file parameters', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'UNINSTALLPARMS'
GO
EXEC sp_addextendedproperty N'Caption', N'Uninstall program type', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'UNINSTALLTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'A comment associated with the USD package', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'USDPACKAGECOMMENT'
GO
EXEC sp_addextendedproperty N'Caption', N'USD Package Name', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'USDPACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Allow User cancel flag', 'SCHEMA', N'dbo', 'TABLE', N'HARUSDPLATFORMINFO', 'COLUMN', N'USERCANCELFLAG'
GO