CREATE TABLE `NewInspections` ( `inspection_id` INT NULL AUTO_INCREMENT,  `inspection_date` VARCHAR(8) NOT NULL,  `serial_number` INT NOT NULL,  `work_order_number` VARCHAR(11) NOT NULL,  `type` VARCHAR(15) NOT NULL,  `test_witness` VARCHAR(32) NOT NULL,  `cei_number` VARCHAR(4) NOT NULL,  `alt_power_req` VARCHAR(7) NOT NULL,  `firekeys` VARCHAR(7) NOT NULL,  `hydro_capacity` VARCHAR(8) NULL,  `hydro_full_load_pressure` VARCHAR(7) NULL,  `hydro_relief_pressure` VARCHAR(7) NULL,  `hydro_drop` VARCHAR(10) NULL,  `v1` VARCHAR(5) NULL,  `v1_comments` VARCHAR(255) NULL,  `v2` VARCHAR(5) NULL,  `v2_comments` VARCHAR(255) NULL,  `v3` VARCHAR(5) NULL,  `v3_comments` VARCHAR(255) NULL,  `v4` VARCHAR(5) NULL,  `v4_comments` VARCHAR(255) NULL,  `v5` VARCHAR(5) NULL,  `v5_comments` VARCHAR(255) NULL,  `v6` VARCHAR(5) NULL,  `v6_comments` VARCHAR(255) NULL,  `v7` VARCHAR(5) NULL,  `v7_comments` VARCHAR(255) NULL,  `v8` VARCHAR(5) NULL,  `v8_comments` VARCHAR(255) NULL,  `v9` VARCHAR(5) NULL,  `v9_comments` VARCHAR(255) NULL,  `mileage` INT NOT NULL,  `overtime` VARCHAR(10) NOT NULL,  `hours` VARCHAR(10) NOT NULL,  `bill_to` VARCHAR(255) NULL,  `maintenance_company` VARCHAR(255) NULL,  `client_sig` VARCHAR(65535) NULL,  `client_name` VARCHAR(75) NULL,  `client_title` VARCHAR(25) NULL,  `client_phone_number` INT NULL,  `client_type` VARCHAR(38) NULL ,PRIMARY KEY (`inspection_id`), UNIQUE KEY `PRIMARY` (`inspection_id`));
