[dbo].[harpathfullname]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	1
Created	11:08:00 AM Wednesday, March 07, 2007
Last Modified	11:12:23 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)	Default
$Indexes HARPATHFULLNAME_P: pathfullname\itemobjid$ $Indexes harpathfullname_path: pathfullname\itemobjid$ $Indexes HARPATHFULLNAME_PU: pathfullnameupper\itemobjid$	itemobjid	int	4
$Indexes HARPATHFULLNAME_P: pathfullname\itemobjid$ $Indexes harpathfullname_path: pathfullname\itemobjid$	pathfullname	varchar(1024)	1024	(' ')
$Indexes HARPATHFULLNAME_PU: pathfullnameupper\itemobjid$	pathfullnameupper	varchar(1024)	1024	(' ')

	Name	Columns	Unique
	XPKharpathfullname	itemobjid
	HARPATHFULLNAME_P	pathfullname, itemobjid
	harpathfullname_path	pathfullname, itemobjid
	HARPATHFULLNAME_PU	pathfullnameupper, itemobjid
	harpathfullname_pupper	pathfullnameupper

Name	Delete	Columns
HARPATHFULLNAME_ITEMID_FK	Cascade	itemobjid->[dbo].[haritems].[itemobjid]

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].[harpathfullname]
(
[itemobjid] [int] NOT NULL,
[pathfullname] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harpathfu__pathf__0603C947] DEFAULT (' '),
[pathfullnameupper] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harpathfu__pathf__06F7ED80] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpathfullname] ADD CONSTRAINT [XPKharpathfullname] PRIMARY KEY CLUSTERED ([itemobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPATHFULLNAME_P] ON [dbo].[harpathfullname] ([pathfullname], [itemobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harpathfullname_path] ON [dbo].[harpathfullname] ([pathfullname], [itemobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harpathfullname_pupper] ON [dbo].[harpathfullname] ([pathfullnameupper]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPATHFULLNAME_PU] ON [dbo].[harpathfullname] ([pathfullnameupper], [itemobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpathfullname] ADD CONSTRAINT [HARPATHFULLNAME_ITEMID_FK] FOREIGN KEY ([itemobjid]) REFERENCES [dbo].[haritems] ([itemobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harpathfullname] TO [harvest_group]
GRANT INSERT ON  [dbo].[harpathfullname] TO [harvest_group]
GRANT DELETE ON  [dbo].[harpathfullname] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harpathfullname] TO [harvest_group]
GRANT SELECT ON  [dbo].[harpathfullname] TO [harvest_rep]
GO