CREATE TABLE [dbo].[ai_fddef_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[fddevice] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fdvendor] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fddef___fdven__35E97D41] DEFAULT (' '),
[fdmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fddef___fdmod__36DDA17A] DEFAULT (' '),
[fdinterface] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fddef___fdint__37D1C5B3] DEFAULT (' '),
[fdsize] [float] NOT NULL CONSTRAINT [DF__ai_fddef___fdsiz__38C5E9EC] DEFAULT ((0)),
[fdsn] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fddef_p__fdsn__39BA0E25] DEFAULT (' '),
[fdstatus] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fddef___fdsta__3AAE325E] DEFAULT (' ')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_fddef_prop] ADD CONSTRAINT [ai_fddef_prop_pk] PRIMARY KEY NONCLUSTERED ([hwuuid], [fddevice]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak2] ON [dbo].[ai_fddef_prop] ([fddevice]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak5] ON [dbo].[ai_fddef_prop] ([fdinterface]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak4] ON [dbo].[ai_fddef_prop] ([fdmodel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak6] ON [dbo].[ai_fddef_prop] ([fdsize]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak7] ON [dbo].[ai_fddef_prop] ([fdsn]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak8] ON [dbo].[ai_fddef_prop] ([fdstatus]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fddef_prop_ak3] ON [dbo].[ai_fddef_prop] ([fdvendor]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_fddef_prop_ak1] ON [dbo].[ai_fddef_prop] ([hwuuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_fddef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_fddef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_fddef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_fddef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_fddef_prop] TO [aipublic]
GO