ALTER TABLE traveltime_submissions DROP FOREIGN KEY traveltime_submissions_ibfk_1;

ALTER TABLE traveltime_managers DROP PRIMARY KEY;

ALTER TABLE traveltime_managers ADD PRIMARY KEY (service_number, cost_centre);

ALTER TABLE traveltime_submissions ADD FOREIGN KEY fk_manager (manager_id) REFERENCES traveltime_managers (service_number);