CREATE TABLE [dbo].[kpi_process_stats]
(
[kpi_process_stats_key] [binary] (17) NOT NULL,
[log_date] [datetime] NOT NULL,
[doc_class_key] [binary] (17) NOT NULL,
[doc_type_key] [binary] (17) NOT NULL,
[doc_name_key] [binary] (17) NOT NULL,
[doc_rulebase_dt] [datetime] NOT NULL,
[sess_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[asset_id] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[doc_timestamp] [datetime] NOT NULL,
[msg_name_key] [binary] (17) NOT NULL,
[msg_value_key] [binary] (17) NOT NULL,
[p1_name_key] [binary] (17) NULL,
[p1_value_key] [binary] (17) NULL,
[p2_name_key] [binary] (17) NULL,
[p2_value_key] [binary] (17) NULL,
[p3_name_key] [binary] (17) NULL,
[p3_value_key] [binary] (17) NULL,
[p4_name_key] [binary] (17) NULL,
[p4_value_key] [binary] (17) NULL,
[p5_name_key] [binary] (17) NULL,
[p5_value_key] [binary] (17) NULL,
[p6_name_key] [binary] (17) NULL,
[p6_value_key] [binary] (17) NULL,
[p7_name_key] [binary] (17) NULL,
[p7_value_key] [binary] (17) NULL,
[p8_name_key] [binary] (17) NULL,
[p8_value_key] [binary] (17) NULL,
[p9_name_key] [binary] (17) NULL,
[p9_value_key] [binary] (17) NULL,
[p10_name_key] [binary] (17) NULL,
[p10_value_key] [binary] (17) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[kpi_process_stats] ADD CONSTRAINT [XPKkpi_process_stats] PRIMARY KEY CLUSTERED ([kpi_process_stats_key]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [kpi_process_stats_idx1] ON [dbo].[kpi_process_stats] ([log_date], [msg_name_key]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[kpi_process_stats] TO [aionadmin_group]
GRANT INSERT ON  [dbo].[kpi_process_stats] TO [aionadmin_group]
GRANT DELETE ON  [dbo].[kpi_process_stats] TO [aionadmin_group]
GRANT UPDATE ON  [dbo].[kpi_process_stats] TO [aionadmin_group]
GO