CREATE TABLE [dbo].[ai_hwdef_cpuperf_kpi]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[earlyavg] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___early__5379E028] DEFAULT ('0'),
[earlymax] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___early__546E0461] DEFAULT ('0'),
[earlymin] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___early__5562289A] DEFAULT ('0'),
[coreavg] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___corea__56564CD3] DEFAULT ('0'),
[coremax] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___corem__574A710C] DEFAULT ('0'),
[coremin] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___corem__583E9545] DEFAULT ('0'),
[lateavg] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___latea__5932B97E] DEFAULT ('0'),
[latemax] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___latem__5A26DDB7] DEFAULT ('0'),
[latemin] [float] NOT NULL CONSTRAINT [DF__ai_hwdef___latem__5B1B01F0] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ai_hwdef_cpuperf_kpi] ADD CONSTRAINT [ai_hwdef_cpuperf_kpi_pk] PRIMARY KEY CLUSTERED ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak4] ON [dbo].[ai_hwdef_cpuperf_kpi] ([coreavg]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak5] ON [dbo].[ai_hwdef_cpuperf_kpi] ([coremax]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak6] ON [dbo].[ai_hwdef_cpuperf_kpi] ([coremin]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak1] ON [dbo].[ai_hwdef_cpuperf_kpi] ([earlyavg]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak2] ON [dbo].[ai_hwdef_cpuperf_kpi] ([earlymax]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak3] ON [dbo].[ai_hwdef_cpuperf_kpi] ([earlymin]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak7] ON [dbo].[ai_hwdef_cpuperf_kpi] ([lateavg]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak8] ON [dbo].[ai_hwdef_cpuperf_kpi] ([latemax]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_cpuperf_kpi_ak9] ON [dbo].[ai_hwdef_cpuperf_kpi] ([latemin]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hwdef_cpuperf_kpi] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hwdef_cpuperf_kpi] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hwdef_cpuperf_kpi] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hwdef_cpuperf_kpi] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hwdef_cpuperf_kpi] TO [aipublic]
GO