CREATE TABLE [dbo].[HARPATHFULLNAME]
(
[ITEMOBJID] [int] NOT NULL,
[PATHFULLNAME] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[PATHFULLNAMEUPPER] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VERSIONOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPATHFULLNAME] ADD CONSTRAINT [HARPATHFULLNAME_PK] PRIMARY KEY CLUSTERED ([VERSIONOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPATHFULLNAME_PATH] ON [dbo].[HARPATHFULLNAME] ([PATHFULLNAME], [VERSIONOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPATHFULLNAME_PUPPER] ON [dbo].[HARPATHFULLNAME] ([PATHFULLNAMEUPPER], [VERSIONOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPATHFULLNAME] ADD CONSTRAINT [HARPATHFULLNAME_VERID_FK] FOREIGN KEY ([VERSIONOBJID]) REFERENCES [dbo].[HARVERSIONS] ([VERSIONOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPATHFULLNAME table stores the full repository path to every version of an item path. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPATHFULLNAME', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of item', 'SCHEMA', N'dbo', 'TABLE', N'HARPATHFULLNAME', 'COLUMN', N'ITEMOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Full repository path to item path version', 'SCHEMA', N'dbo', 'TABLE', N'HARPATHFULLNAME', 'COLUMN', N'PATHFULLNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Full repository path to item path version in uppercase characters', 'SCHEMA', N'dbo', 'TABLE', N'HARPATHFULLNAME', 'COLUMN', N'PATHFULLNAMEUPPER'
GO
EXEC sp_addextendedproperty N'Caption', N'Version object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARPATHFULLNAME', 'COLUMN', N'VERSIONOBJID'
GO