CREATE TABLE [dbo].[harmr]
(
[formobjid] [int] NOT NULL,
[mrdatereported] [datetime] NULL,
[mrreportedby] [char] (44) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrcategory] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrothercategory] [char] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrapplication] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrreleasenum] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrhardware] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mroperatingsys] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrdocument] [varchar] (130) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrrevisionnum] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrdescript] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrkeyword] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrseverity] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrinvestnotes] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrinvestigator] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrrecommend] [varchar] (76) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrresolution] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrunittest] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrdeveloper] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrtestresults] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mrtester] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harmr] ADD CONSTRAINT [XPKharmr] PRIMARY KEY CLUSTERED ([formobjid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harmr] ADD CONSTRAINT [HARMR_FORMID_FK] FOREIGN KEY ([formobjid]) REFERENCES [dbo].[harform] ([formobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harmr] TO [harvest_group]
GRANT INSERT ON  [dbo].[harmr] TO [harvest_group]
GRANT DELETE ON  [dbo].[harmr] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harmr] TO [harvest_group]
GRANT SELECT ON  [dbo].[harmr] TO [harvest_rep]
GO