Tables [dbo].[harusddeployinfo]
(local) > mdb > Tables > dbo.harusddeployinfo
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:08:04 AM Wednesday, March 07, 2007
Last Modified11:09:57 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys harusddeployinfo_fk: [dbo].[harpackage].packageobjidIndexes HARUSDDEPLOYINFO_PKG_IND: packageobjidpackageobjidint4
No
Foreign Keys HARUSDDEPLOYINFO_FRMID_FK: [dbo].[harform].formobjidIndexes HARUSDDEPLOYINFO_FRM_IND: formobjidformobjidint4
Yes
targetoperatingsystemvarchar(32)32
Yes
usdpackagenamevarchar(128)128
Yes
usdpackageversionvarchar(40)40
Yes
deploysequenceint4
Yes
basedonpackagevarchar(172)172
Yes
installfilevarchar(260)260
Yes
installtypevarchar(10)10
Yes
installparmsvarchar(256)256
Yes
uninstallfilevarchar(260)260
Yes
uninstalltypevarchar(10)10
Yes
uninstallparmsvarchar(256)256
Yes
loadpathvarchar(1024)1024
Yes
payloadvarchar(2000)2000
Yes
targetstate1varchar(128)128
Yes
targetgroup1varchar(40)40
Yes
targetcomputer1varchar(40)40
Yes
targetstate2varchar(128)128
Yes
targetgroup2varchar(40)40
Yes
targetcomputer2varchar(40)40
Yes
targetstate3varchar(128)128
Yes
targetgroup3varchar(40)40
Yes
targetcomputer3varchar(40)40
Yes
targetstate4varchar(128)128
Yes
targetcomputer4varchar(40)40
Yes
targetgroup4varchar(40)40
Yes
targetstate5varchar(128)128
Yes
targetgroup5varchar(40)40
Yes
targetcomputer5varchar(40)40
Yes
deploystatechar(128)128
Yes
beforebootflagchar(5)5
Yes
beforelogoffflagchar(5)5
Yes
afterbootflagchar(5)5
Yes
afterlogoffflagchar(5)5
Yes
offlineflagchar(5)5
Yes
promptflagchar(5)5
Yes
execprompttimeoutflagchar(5)5
Yes
usercancelflagchar(5)5
Yes
resolvequerygroupsflagchar(5)5
Yes
Foreign Keys HARUSDDEPLOYINFO_ATTID_FK: [dbo].[harformattachment].attachmentobjidIndexes HARUSDDEPLOYINFO_ATTACH_IND: attachmentobjidattachmentobjidint4
Yes
usddeployjobuuidchar(32)32
Yes
deploystatuschar(12)12
Yes
usdjobcontaineruuidchar(32)32
Yes
usdpackageuuidchar(32)32
Yes
usdvolumeuuidchar(32)32
Yes
usdinstallprocedureuuidchar(32)32
Yes
usduninstallprocedureuuidchar(32)32
Yes
usdinstalljobuuidchar(32)32
Yes
usdbasedonpackageuuidchar(32)32
Yes
usdpackagecommentvarchar(500)500
Yes
Indexes Indexes
NameColumns
HARUSDDEPLOYINFO_ATTACH_INDattachmentobjid
HARUSDDEPLOYINFO_FRM_INDformobjid
HARUSDDEPLOYINFO_PKG_INDpackageobjid
Foreign Keys Foreign Keys
NameDeleteColumns
HARUSDDEPLOYINFO_ATTID_FKCascadeattachmentobjid->[dbo].[harformattachment].[attachmentobjid]
harusddeployinfo_fkCascadepackageobjid->[dbo].[harpackage].[packageobjid]
HARUSDDEPLOYINFO_FRMID_FKCascadeformobjid->[dbo].[harform].[formobjid]
Permissions
TypeActionOwning Principal
GrantDeleteharvest_group
GrantInsertharvest_group
GrantSelectharvest_group
GrantUpdateharvest_group
GrantSelectharvest_rep
SQL Script
CREATE TABLE [dbo].[harusddeployinfo]
(
[packageobjid] [int] NOT NULL,
[formobjid] [int] NULL,
[targetoperatingsystem] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackagename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackageversion] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[deploysequence] [int] NULL,
[basedonpackage] [varchar] (172) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installfile] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installtype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[installparms] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstallfile] [varchar] (260) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstalltype] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uninstallparms] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[loadpath] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[payload] [varchar] (2000) 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,
[targetcomputer4] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[targetgroup4] [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,
[deploystate] [char] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[beforebootflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[beforelogoffflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[afterbootflag] [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,
[usercancelflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resolvequerygroupsflag] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[attachmentobjid] [int] NULL,
[usddeployjobuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[deploystatus] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdjobcontaineruuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackageuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdvolumeuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdinstallprocedureuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usduninstallprocedureuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdinstalljobuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdbasedonpackageuuid] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[usdpackagecomment] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CS_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_ATTID_FK] FOREIGN KEY ([attachmentobjid]) REFERENCES [dbo].[harformattachment] ([attachmentobjid]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[harusddeployinfo] ADD CONSTRAINT [harusddeployinfo_fk] FOREIGN KEY ([packageobjid]) REFERENCES [dbo].[harpackage] ([packageobjid]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[harusddeployinfo] ADD CONSTRAINT [HARUSDDEPLOYINFO_FRMID_FK] FOREIGN KEY ([formobjid]) REFERENCES [dbo].[harform] ([formobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harusddeployinfo] TO [harvest_group]
GRANT INSERT ON  [dbo].[harusddeployinfo] TO [harvest_group]
GRANT DELETE ON  [dbo].[harusddeployinfo] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harusddeployinfo] TO [harvest_group]
GRANT SELECT ON  [dbo].[harusddeployinfo] TO [harvest_rep]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved