USE [logging2006]
GO

/****** Object:  Table [dbo].[Asset_HW_NetworkDevice]    Script Date: 17-11-2017 13:01:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Asset_HW_NetworkDevice](
	[ID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[DeviceID] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[Model] [nvarchar](50) NULL,
	[Manufacturer] [nvarchar](250) NULL,
	[DeviceType] [int] NULL,
	[SerialNumber] [nvarchar](50) NULL,
	[HardwareVersion] [nvarchar](250) NULL,
	[SoftwareVersion] [nvarchar](250) NULL,
	[DeviceOID] [nvarchar](250) NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Asset_HW_NetworkDevice] ADD  CONSTRAINT [DF_Asset_HW_NetworkDevice_ID]  DEFAULT (newid()) FOR [ID]
GO