science-ation/db/db.update.137.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` ;
- Server-side award uploading. Tag registrations, proejcts, and students with 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) 2009-09-21 07:20:49 +00:00			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` ;