CREATE TABLE [dbo].[ai_undef_hwdef_rel]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[domuuid] [uniqueidentifier] NOT NULL,
[domainid] [int] NOT NULL,
[unitid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_undef_hwdef_rel] ADD CONSTRAINT [ai_undef_hwdef_rel_pk] PRIMARY KEY NONCLUSTERED ([domuuid], [hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_hwdef_rel_ak3] ON [dbo].[ai_undef_hwdef_rel] ([domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_hwdef_rel_ak2] ON [dbo].[ai_undef_hwdef_rel] ([domuuid]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_undef_hwdef_rel_ak1] ON [dbo].[ai_undef_hwdef_rel] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_undef_hwdef_rel_ak4] ON [dbo].[ai_undef_hwdef_rel] ([unitid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_undef_hwdef_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_undef_hwdef_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_undef_hwdef_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_undef_hwdef_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_undef_hwdef_rel] TO [aipublic]
GO