forked from science-ation/science-ation
5ec38a7314
a fair_id. This is ignored for regular operation, but now needed to have multiple students from multiple feeder fairs attached to the same award. (so we know which ones to delete when we update the winners)
4 lines
175 B
SQL
4 lines
175 B
SQL
ALTER TABLE `winners` ADD `fairs_id` INT NOT NULL;
|
|
ALTER TABLE `projects` ADD `fairs_id` INT NOT NULL;
|
|
ALTER TABLE `students` ADD `fairs_id` INT NOT NULL AFTER `schools_id` ;
|