CREATE TABLE `Devices` (
`DeviceID` INT NOT NULL AUTO_INCREMENT, 
`SystemID` INT NULL, 
`DeviceReportedName` VARCHAR(50) NULL, 
`DeviceAssignedName` VARCHAR(50) NULL, 
`DeviceIPMain` VARCHAR(50) NULL, 
`DeviceType` INT NULL, 
`ShortDescription` VARCHAR(60) NULL, 
`LongDescription` LONGTEXT NULL, 
`Location` VARCHAR(50) NULL, 
`DeviceTZ` INT NULL, 
`AdminName` VARCHAR(50) NULL, 
`AdminOfficePhone` VARCHAR(16) NULL, 
`AdminMobilePhone` VARCHAR(16) NULL, 
`AdminHomePhone` VARCHAR(50) NULL, 
`AdminEMail` VARCHAR(50) NULL, 
`AdminPager` VARCHAR(50) NULL, 
`Status` INT NULL, 
`AutoCreated` INT NULL, 
`DateCreated` DATETIME NULL, 
`DateLastSeen` DATETIME NULL, 
`DatePurchased` DATETIME NULL, 
`DateRetired` DATETIME NULL, 
`RecordStatus` INT NULL, 
PRIMARY KEY(DeviceID)
);

