CREATE TABLE [dbo].[ai_hwdef_prop]
(
[hwuuid] [uniqueidentifier] NOT NULL,
[hwdom] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwdom__72F28B81] DEFAULT (' '),
[hwname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hwsn] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef_p__hwsn__73E6AFBA] DEFAULT (' '),
[hwtype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwtyp__74DAD3F3] DEFAULT (' '),
[hwmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwmfg__75CEF82C] DEFAULT (' '),
[hwmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwmod__76C31C65] DEFAULT (' '),
[hwmem] [int] NOT NULL CONSTRAINT [DF__ai_hwdef___hwmem__77B7409E] DEFAULT ((0)),
[hwbiosmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwbio__78AB64D7] DEFAULT (' '),
[hwbiosver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwbio__799F8910] DEFAULT (' '),
[hwbiosdate] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwbio__7A93AD49] DEFAULT (' '),
[hwprocmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwpro__7B87D182] DEFAULT (' '),
[hwprocmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwpro__7C7BF5BB] DEFAULT (' '),
[hwproctype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_hwdef___hwpro__7D7019F4] DEFAULT (' '),
[hwproccount] [int] NOT NULL CONSTRAINT [DF__ai_hwdef___hwpro__7E643E2D] DEFAULT ((0)),
[hwprocspeed] [int] NOT NULL CONSTRAINT [DF__ai_hwdef___hwpro__7F586266] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ai_hwdef_prop] ADD CONSTRAINT [ai_hwdef_prop_pk] PRIMARY KEY CLUSTERED ([hwuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak11] ON [dbo].[ai_hwdef_prop] ([hwbiosdate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak8] ON [dbo].[ai_hwdef_prop] ([hwbiosmfgr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak9] ON [dbo].[ai_hwdef_prop] ([hwbiosmfgr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak10] ON [dbo].[ai_hwdef_prop] ([hwbiosver]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak1] ON [dbo].[ai_hwdef_prop] ([hwdom]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak6] ON [dbo].[ai_hwdef_prop] ([hwmem]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak5] ON [dbo].[ai_hwdef_prop] ([hwmfgr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak7] ON [dbo].[ai_hwdef_prop] ([hwmodel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak2] ON [dbo].[ai_hwdef_prop] ([hwname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak15] ON [dbo].[ai_hwdef_prop] ([hwproccount]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak12] ON [dbo].[ai_hwdef_prop] ([hwprocmfgr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak13] ON [dbo].[ai_hwdef_prop] ([hwprocmodel]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak16] ON [dbo].[ai_hwdef_prop] ([hwprocspeed]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak14] ON [dbo].[ai_hwdef_prop] ([hwproctype]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak3] ON [dbo].[ai_hwdef_prop] ([hwsn]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ai_hwdef_prop_ak4] ON [dbo].[ai_hwdef_prop] ([hwtype]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ai_hwdef_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_hwdef_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_hwdef_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_hwdef_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_hwdef_prop] TO [aipublic]
GO