CREATE TABLE [dbo].[ai_ipv6def_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[ipv6addr] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_ipv6def_1] DEFAULT (' '),
[zone_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_ipv6def_2] DEFAULT (' '),
[primary_dns_server] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_ipv6def_3] DEFAULT (' ')
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_ipv6def_prop_ak1] ON [dbo].[ai_ipv6def_prop] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipv6def_prop_ak2] ON [dbo].[ai_ipv6def_prop] ([ipv6addr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipv6def_prop_ak] ON [dbo].[ai_ipv6def_prop] ([primary_dns_server]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipv6def_prop_ak3] ON [dbo].[ai_ipv6def_prop] ([zone_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_ipv6def_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_ipv6def_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_ipv6def_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_ipv6def_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_ipv6def_prop] TO [aipublic]
GO