CREATE TABLE [dbo].[ai_hwdef_login_all_rel]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[loginid] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[logindomain] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___login__60D3DB46] DEFAULT (' ')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ai_hwdef_login_all_rel] ADD CONSTRAINT [ai_hwdef_login_all_rel_pk] PRIMARY KEY NONCLUSTERED ([hwuuid], [loginid], [logindomain]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_hwdef_login_all_rel_ak1] ON [dbo].[ai_hwdef_login_all_rel] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_login_all_rel_ak3] ON [dbo].[ai_hwdef_login_all_rel] ([logindomain]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_login_all_rel_ak2] ON [dbo].[ai_hwdef_login_all_rel] ([loginid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hwdef_login_all_rel] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hwdef_login_all_rel] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hwdef_login_all_rel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hwdef_login_all_rel] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hwdef_login_all_rel] TO [aipublic]
GO