[aiowner].[ai_hwdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	157
Created	9:12:21 AM Thursday, November 06, 2008
Last Modified	9:12:21 AM Thursday, November 06, 2008

Name	Data Type	Max Length (Bytes)	Default
hwuuid	uniqueidentifier	16	(newid())
hwdom	nvarchar(128)	256
hwname	nvarchar(128)	256
hwsn	nvarchar(128)	256
hwtype	nvarchar(128)	256
hwmfgr	nvarchar(128)	256
hwmodel	nvarchar(128)	256
hwmem	int	4
hwbiosmfgr	nvarchar(128)	256
hwbiosver	nvarchar(128)	256
hwbiosdate	nvarchar(128)	256
hwprocmfgr	nvarchar(128)	256
hwprocmodel	nvarchar(128)	256
hwproctype	nvarchar(128)	256
hwproccount	int	4
hwprocspeed	int	4

SQL Script

CREATE TABLE [aiowner].[ai_hwdef_prop_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_hwdef___hwuui__79796491] DEFAULT (newid()),
[hwdom] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[hwsn] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwtype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmem] [int] NULL,
[hwbiosmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwbiosver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwbiosdate] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwprocmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwprocmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwproctype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwproccount] [int] NULL,
[hwprocspeed] [int] NULL
) ON [PRIMARY]
GO