CREATE TABLE `DisplayScreenSurvey` (`ID` INT (3) UNSIGNED AUTO_INCREMENT, PRIMARY KEY(`ID`))  COMMENT = "Responses from display screen survey";
ALTER TABLE `DisplayScreenSurvey` add `UserName`   VARCHAR(64);
ALTER TABLE `DisplayScreenSurvey` add `RoomNumber` VARCHAR(16);
ALTER TABLE `DisplayScreenSurvey` add `HostName`   VARCHAR(64);
ALTER TABLE `DisplayScreenSurvey` add `DateStamp`  Date;
ALTER TABLE `DisplayScreenSurvey` add `CharReadable` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `CharReadableAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `ScreenClean` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `ScreenCleanAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Flicker` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `FlickerAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `BrightnessContrast` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `BrightnessContrastAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Swivel` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `SwivelAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Glare` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `GlareAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `KeyboardSeparate` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `KeyboardSeparateAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `KeyboardComfortable` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `KeyboardComfortableAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `HandRest` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `HandRestAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `KeyboardReadable` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `KeyboardReadableAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `WorkSurface` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `WorkSurfaceAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `WSGlare` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `WSGlareAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `ChairOK` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `ChairOKAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `UserOK` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `UserOKAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `RoomOK` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `RoomOKAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `LightOK` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `LightOKAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `AirOK` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `AirOKAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Software` TINYINT UNSIGNED DEFAULT "1";
ALTER TABLE `DisplayScreenSurvey` add `SoftwareAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Safty` TINYINT UNSIGNED; 
ALTER TABLE `DisplayScreenSurvey` add `SafetyAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Estates` TINYINT UNSIGNED; 
ALTER TABLE `DisplayScreenSurvey` add `EstatesAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add `Other` TINYINT UNSIGNED ;
ALTER TABLE `DisplayScreenSurvey` add `OtherAction` TEXT;
ALTER TABLE `DisplayScreenSurvey` add INDEX host (HostName);
ALTER TABLE `DisplayScreenSurvey` add INDEX user (UserName);
ALTER TABLE `DisplayScreenSurvey` add INDEX date (DateStamp);
ALTER TABLE `DisplayScreenSurvey` add INDEX room (RoomNumber);
