CREATE TABLE [dbo].[harenvironment]
(
[envobjid] [int] NOT NULL,
[environmentname] [char] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[envisactive] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[baselineviewid] [int] NOT NULL CONSTRAINT [DF__harenviro__basel__24BD5A91] DEFAULT ((0)),
[creationtime] [datetime] NOT NULL,
[creatorid] [int] NOT NULL,
[modifiedtime] [datetime] NOT NULL,
[modifierid] [int] NOT NULL,
[note] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[isarchive] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harenviro__isarc__25B17ECA] DEFAULT ('N'),
[archiveby] [int] NOT NULL CONSTRAINT [DF__harenviro__archi__26A5A303] DEFAULT ((1)),
[archivemachine] [char] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[archivefile] [char] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[archivetime] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harenvironment] ADD CONSTRAINT [XPKharenvironment] PRIMARY KEY CLUSTERED ([envobjid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [harenvironment_ind] ON [dbo].[harenvironment] ([environmentname]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[harenvironment] TO [harvest_group]
GRANT INSERT ON  [dbo].[harenvironment] TO [harvest_group]
GRANT DELETE ON  [dbo].[harenvironment] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harenvironment] TO [harvest_group]
GRANT SELECT ON  [dbo].[harenvironment] TO [harvest_rep]
GO