CREATE TABLE [dbo].[ai_hwdef_mac_kpi]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[hwmac] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_hwdef_mac_kpi] ADD CONSTRAINT [ai_hwdef_mac_kpi_pk] PRIMARY KEY NONCLUSTERED ([hwuuid], [hwmac]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_mac_kpi_ak2] ON [dbo].[ai_hwdef_mac_kpi] ([hwmac]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_hwdef_mac_kpi_ak1] ON [dbo].[ai_hwdef_mac_kpi] ([hwuuid]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ai_hwdef_mac_kpi] TO [aiadmin]
GRANT INSERT ON [dbo].[ai_hwdef_mac_kpi] TO [aiadmin]
GRANT DELETE ON [dbo].[ai_hwdef_mac_kpi] TO [aiadmin]
GRANT UPDATE ON [dbo].[ai_hwdef_mac_kpi] TO [aiadmin]
GRANT SELECT ON [dbo].[ai_hwdef_mac_kpi] TO [aipublic]
GO
[dbo].[ai_hwdef_mac_kpi]
