CREATE TABLE `stop_times` ( `trip_id` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `arrival_time` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `departure_time` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `stop_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `stop_sequence` int(11) NOT NULL, `stop_headsign` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `pickup_type` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `drop_off_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `shape_dist_traveled` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;