CREATE TABLE IF NOT EXISTS manager_cost_centres (
  service_number INT NOT NULL,
  cost_centre INT NOT NULL,
  PRIMARY KEY (service_number, cost_centre),
  KEY idx_cost_centre (cost_centre)
) ENGINE=InnoDB;