CREATE TABLE [dbo].[AUDITHIS]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[EXENAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STTOTAL] [int] NOT NULL,
[VERNR] [int] NOT NULL,
[EXEPATH] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_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 [AUDITHIS_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [EXENAME], [STTOTAL], [VERNR], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [AUDITHIS_SK1] ON [dbo].[AUDITHIS] ([ACID]) ON [PRIMARY]
GO
[dbo].[AUDITHIS]
