CREATE TABLE [dbo].[harversions]
(
[versionobjid] [int] NOT NULL,
[itemobjid] [int] NOT NULL,
[packageobjid] [int] NOT NULL,
[parentversionid] [int] NOT NULL,
[mergedversionid] [int] NOT NULL,
[inbranch] [int] NOT NULL,
[mappedversion] [char] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[versionstatus] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creationtime] [datetime] NOT NULL,
[creatorid] [int] NOT NULL,
[modifiedtime] [datetime] NOT NULL,
[modifierid] [int] NOT NULL,
[description] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[versiondataobjid] [int] NOT NULL,
[clientmachine] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[clientpath] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ancestorversionid] [int] NOT NULL CONSTRAINT [DF__harversio__ances__73B00EE2] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harversions] ADD CONSTRAINT [XPKharversions] PRIMARY KEY CLUSTERED ([versionobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_ITEMMAPPED] ON [dbo].[harversions] ([itemobjid], [mappedversion], [versionobjid], [packageobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_ITEM_IND] ON [dbo].[harversions] ([itemobjid], [versionobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harversions_vc] ON [dbo].[harversions] ([itemobjid], [versionobjid], [versionstatus], [inbranch]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_VSTATUS] ON [dbo].[harversions] ([itemobjid], [versionstatus]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harversions_merged_ind] ON [dbo].[harversions] ([mergedversionid], [packageobjid], [parentversionid], [versionobjid], [mappedversion]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_MERGED_IDX] ON [dbo].[harversions] ([mergedversionid], [parentversionid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_PKG_IND] ON [dbo].[harversions] ([packageobjid], [modifierid], [creatorid], [versionstatus]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harversions_par_ind] ON [dbo].[harversions] ([parentversionid], [packageobjid], [mergedversionid], [versionobjid], [mappedversion]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_VERITEM] ON [dbo].[harversions] ([versionobjid], [itemobjid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVERSIONS_STATUS] ON [dbo].[harversions] ([versionstatus], [itemobjid], [versionobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harversions] ADD CONSTRAINT [harversions_pkgid_fk] FOREIGN KEY ([packageobjid]) REFERENCES [dbo].[harpackage] ([packageobjid])
GO
GRANT SELECT ON  [dbo].[harversions] TO [harvest_group]
GRANT INSERT ON  [dbo].[harversions] TO [harvest_group]
GRANT DELETE ON  [dbo].[harversions] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harversions] TO [harvest_group]
GRANT SELECT ON  [dbo].[harversions] TO [harvest_rep]
GO