CREATE TABLE [dbo].[ai_ipdef_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[ipaddr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ipmask] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_ipdef___ipmas__0234CF11] DEFAULT (' '),
[ipnwaddr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_ipdef___ipnwa__0328F34A] DEFAULT (' ')
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_ipdef_prop_ak1] ON [dbo].[ai_ipdef_prop] ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipdef_prop_ak2] ON [dbo].[ai_ipdef_prop] ([ipaddr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipdef_prop_ak3] ON [dbo].[ai_ipdef_prop] ([ipmask]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_ipdef_prop_ak4] ON [dbo].[ai_ipdef_prop] ([ipnwaddr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_ipdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_ipdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_ipdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_ipdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_ipdef_prop] TO [aipublic]
GO