CREATE TABLE [cohesion].[cc_audit_log]
(
[audit_log_id] [int] NOT NULL,
[session_id] [int] NOT NULL,
[application_id] [int] NULL,
[module_id] [int] NULL,
[element_id] [int] NULL,
[host_id] [int] NULL,
[host_group_id] [int] NULL,
[cluster_id] [int] NULL,
[profile_id] [int] NULL,
[task_id] [int] NULL,
[operation] [smallint] NULL,
[severity] [smallint] NULL,
[func_category] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[audit_message] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[timestamp] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_audit_log] ADD CONSTRAINT [PK__cc_audit_log__145C0A3F] PRIMARY KEY CLUSTERED ([audit_log_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2cc_audit_log] ON [cohesion].[cc_audit_log] ([application_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE7cc_audit_log] ON [cohesion].[cc_audit_log] ([cluster_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE4cc_audit_log] ON [cohesion].[cc_audit_log] ([element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE6cc_audit_log] ON [cohesion].[cc_audit_log] ([host_group_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE8cc_audit_log] ON [cohesion].[cc_audit_log] ([host_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE3cc_audit_log] ON [cohesion].[cc_audit_log] ([module_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE5cc_audit_log] ON [cohesion].[cc_audit_log] ([operation], [timestamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_audit_log] ON [cohesion].[cc_audit_log] ([session_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_audit_log] ADD CONSTRAINT [FK__cc_audit___sessi__15502E78] FOREIGN KEY ([session_id]) REFERENCES [cohesion].[cc_session] ([session_id])
GO