CREATE TABLE [dbo].[audithis]
(
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[exename] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[sttotal] [int] NOT NULL,
[vernr] [int] NOT NULL,
[exepath] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[acid] [int] NULL,
[stdate] [int] NULL,
[sttime] [int] NULL,
[enddate] [int] NULL,
[endtime] [int] NULL,
[endtotal] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[audithis] ADD CONSTRAINT [XPKaudithis] PRIMARY KEY CLUSTERED ([object_uuid], [exename], [sttotal], [vernr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [audithis_sk1] ON [dbo].[audithis] ([acid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [audithis_sk2] ON [dbo].[audithis] ([object_uuid], [object_domain_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[audithis] TO [ams_group]
GRANT SELECT ON  [dbo].[audithis] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[audithis] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[audithis] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[audithis] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[audithis] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[audithis] TO [upmuser_group]
GO