CREATE TABLE [dbo].[ai_fsdef_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[fsdevice] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fsname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fsdef___fsnam__3D8A9F09] DEFAULT (' '),
[fslabel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fsdef___fslab__3E7EC342] DEFAULT (' '),
[fstype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_fsdef___fstyp__3F72E77B] DEFAULT (' '),
[fssize] [float] NOT NULL CONSTRAINT [DF__ai_fsdef___fssiz__40670BB4] DEFAULT ((0)),
[fsused] [float] NOT NULL CONSTRAINT [DF__ai_fsdef___fsuse__415B2FED] DEFAULT ((0)),
[fsfree] [float] NOT NULL CONSTRAINT [DF__ai_fsdef___fsfre__424F5426] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_fsdef_prop] ADD CONSTRAINT [ai_fsdef_prop_pk] PRIMARY KEY NONCLUSTERED ([hwuuid], [fsdevice]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak2] ON [dbo].[ai_fsdef_prop] ([fsdevice]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak8] ON [dbo].[ai_fsdef_prop] ([fsfree]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak4] ON [dbo].[ai_fsdef_prop] ([fslabel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak3] ON [dbo].[ai_fsdef_prop] ([fsname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak6] ON [dbo].[ai_fsdef_prop] ([fssize]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak5] ON [dbo].[ai_fsdef_prop] ([fstype]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_fsdef_prop_ak7] ON [dbo].[ai_fsdef_prop] ([fsused]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [ai_fsdef_prop_ak1] ON [dbo].[ai_fsdef_prop] ([hwuuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_fsdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_fsdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_fsdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_fsdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_fsdef_prop] TO [aipublic]
GO