ALTER TABLE `bus` 
CHANGE COLUMN `code_bus` `code_bus` VARCHAR(35) NOT NULL ;

ALTER TABLE `route` 
CHANGE COLUMN `code_rot` `code_rot` VARCHAR(35) NOT NULL ;