
ALTER TABLE `redwingc_app`.`route_pickup_point` 
ADD COLUMN `description` VARCHAR(250) NULL DEFAULT NULL AFTER `longitude`;

ALTER TABLE `redwingc_app`.`route_pickup_point` 
ADD COLUMN `waypoint_id` VARCHAR(45) NOT NULL AFTER `description`;

ALTER TABLE `redwingc_app`.`route_driver_point` 
ADD COLUMN `waypoint_id` VARCHAR(45) NOT NULL AFTER `longitude`;

ALTER TABLE `redwingc_app`.`route` 
ADD COLUMN `route_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `deleted`;

ALTER TABLE `redwingc_app`.`route_driver_point` 
CHANGE COLUMN `expected_time` `expected_time` VARCHAR(30) NOT NULL ;

ALTER TABLE `redwingc_app`.`route_pickup_point` 
CHANGE COLUMN `expected_time` `expected_time` VARCHAR(30) NOT NULL ;

ALTER TABLE `redwingc_app`.`route` 
CHANGE COLUMN `departure_time` `departure_time` VARCHAR(45) NOT NULL ,
ADD COLUMN `arrival_time` VARCHAR(45) NOT NULL AFTER `route_date`;
