CREATE TABLE [dbo].[Devices] (
	[DeviceID] [int] IDENTITY (1, 1) NOT NULL ,
	[SystemID] [int] NULL ,
	[DeviceReportedName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DeviceAssignedName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DeviceIPMain] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DeviceType] [int] NULL ,
	[ShortDescription] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LongDescription] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Location] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DeviceTZ] [int] NULL ,
	[AdminName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AdminOfficePhone] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AdminMobilePhone] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AdminHomePhone] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AdminEMail] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[AdminPager] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Status] [int] NULL ,
	[AutoCreated] [int] NULL ,
	[DateCreated] [datetime] NULL ,
	[DateLastSeen] [datetime] NULL ,
	[DatePurchased] [datetime] NULL ,
	[DateRetired] [datetime] NULL ,
	[RecordStatus] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

