jomarin38 / F3FChrono

Race managment system for F3F competition
GNU General Public License v3.0
2 stars 2 forks source link

Force different fly order for each round #239

Open jomarin38 opened 1 month ago

jomarin38 commented 1 month ago
CREATE TABLE `f3f_chrono`.`imposed_fly_order` (
  `event_id` INT(11) NOT NULL,
  `round_number` INT NOT NULL,
  `flight_order` TEXT NULL,
  PRIMARY KEY (`event_id`, `round_number`),
  CONSTRAINT `fk_imposed_fly_order_event`
    FOREIGN KEY (`event_id`)
    REFERENCES `f3f_chrono`.`event` (`event_id`)
    ON DELETE NO ACTION
    ON UPDATE CASCADE);