CREATE TABLE `StateList` ( `serial_number` INT NOT NULL,  `class_code` DOUBLE NULL,  `landings` DOUBLE NULL,  `last_passed` DATE NULL,  `location_name` VARCHAR(255) NULL,  `business_name` VARCHAR(255) NULL,  `location_address` VARCHAR(255) NULL,  `location_city` VARCHAR(255) NULL,  `location_state` VARCHAR(255) NULL,  `location_zip` VARCHAR(255) NULL,  `mailing_address` VARCHAR(255) NULL,  `mailing_address_2` VARCHAR(255) NULL,  `mailing_city` VARCHAR(255) NULL,  `mailing_state` VARCHAR(255) NULL,  `mailing_zip` VARCHAR(255) NULL,  `mailing_phone` VARCHAR(255) NULL,  `cert_status` VARCHAR(255) NULL,  `exp_date` DATE NULL,  `class_description` VARCHAR(255) NULL,  `year_installed` DOUBLE NULL,  `install_comp` VARCHAR(255) NULL,  `bldg_type` VARCHAR(255) NULL,  `capacity` DOUBLE NULL,  `speed_up` DOUBLE NULL,  `speed_down` DOUBLE NULL,  `travel` DOUBLE NULL,  `two_stop` VARCHAR(255) NULL,  `maint_cont` VARCHAR(255) NULL,  `maint_comp` VARCHAR(255) NULL,  `last_updated` DATETIME NULL ,PRIMARY KEY (`serial_number`), UNIQUE KEY `PRIMARY` (`serial_number`));
