[dbo].[harusdplatforminfo]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:04 AM Wednesday, March 07, 2007
Last Modified	11:12:22 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
formobjid	int	4
usdpackagename	varchar(128)	128
basedonpackage	varchar(172)	172
loadpath	varchar(1024)	1024
installfile	varchar(260)	260
installparms	varchar(256)	256
installtype	varchar(10)	10
uninstallfile	varchar(260)	260
uninstallparms	varchar(256)	256
uninstalltype	varchar(10)	10
beforelogoffflag	char(5)	5
afterlogoffflag	char(5)	5
offlineflag	char(5)	5
promptflag	char(5)	5
execprompttimeoutflag	char(5)	5
resolvequerygroupsflag	char(5)	5
payload	varchar(2000)	2000
targetoperatingsystem	varchar(32)	32
usercancelflag	char(5)	5
beforebootflag	char(5)	5
afterbootflag	char(5)	5
targetstate1	varchar(128)	128
targetgroup1	varchar(40)	40
targetcomputer1	varchar(40)	40
targetstate2	varchar(128)	128
targetgroup2	varchar(40)	40
targetcomputer2	varchar(40)	40
targetstate3	varchar(128)	128
targetgroup3	varchar(40)	40
targetcomputer3	varchar(40)	40
targetstate4	varchar(128)	128
targetgroup4	varchar(40)	40
targetcomputer4	varchar(40)	40
targetstate5	varchar(128)	128
targetgroup5	varchar(40)	40
targetcomputer5	varchar(40)	40
usdpackagecomment	varchar(500)	500

	Name	Columns	Unique
	$harus_u00003d6300000000	formobjid
	HARUSDPLATFORMINFO_FRM_IND	formobjid

Name	Delete	Columns
HARUSDPLATFORMINFO_FRMID_FK	Cascade	formobjid->[dbo].[harform].[formobjid]

Type	Action	Owning Principal
Grant	Delete	harvest_group
Grant	Insert	harvest_group
Grant	Select	harvest_group
Grant	Update	harvest_group
Grant	Select	harvest_rep

SQL Script

CREATE TABLE [dbo].[harusdplatforminfo]
(
[formobjid] [int] NOT NULL,
[usdpackagename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[basedonpackage] [varchar] (172) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[loadpath] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installfile] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installparms] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installtype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstallfile] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstallparms] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstalltype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[beforelogoffflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[afterlogoffflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[offlineflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[promptflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[execprompttimeoutflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resolvequerygroupsflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[payload] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetoperatingsystem] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usercancelflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[beforebootflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[afterbootflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetstate1] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetcomputer1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetstate2] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetcomputer2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetstate3] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetcomputer3] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetstate4] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetcomputer4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetstate5] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup5] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetcomputer5] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackagecomment] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harusdplatforminfo] ADD CONSTRAINT [$harus_u00003d6300000000] PRIMARY KEY CLUSTERED ([formobjid]) 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
GRANT SELECT ON  [dbo].[harusdplatforminfo] TO [harvest_group]
GRANT INSERT ON  [dbo].[harusdplatforminfo] TO [harvest_group]
GRANT DELETE ON  [dbo].[harusdplatforminfo] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harusdplatforminfo] TO [harvest_group]
GRANT SELECT ON  [dbo].[harusdplatforminfo] TO [harvest_rep]
GO