science-ation/db.update.101.sql at master - science-ation - Science-ation

arman/science-ation

forked from science-ation/science-ation

dave 125437dd55 - More GVRSF stuff that I missed. Add two fields to the award_awards:

'self_nominate', and 'schedule_judges'.
- self_nominate defaults to 'yes' for all new and existing awards.  If turned
  off, the award will not appear in the student self-nomination pages.
- schedule_judges specifies whether an award should have judges or not, we have
  some special awards that students can nominate for but do not require judges
  to find the winner.  Similarly we have some awards students cannot nominate
  for but do require judges to determine a winner.  This allows both cases to
  be handled.

2008-01-24 07:46:12 +00:00

7 lines

332 B

SQL

Raw Permalink Blame History

 ALTER TABLE `award_awards` ADD `self_nominate` ENUM('yes', 'no') NOT NULL DEFAULT 'yes' AFTER `cwsfaward` ;
 ALTER TABLE `award_awards` ADD `schedule_judges` ENUM('yes', 'no') NOT NULL DEFAULT 'yes' AFTER `self_nominate` ;
 UPDATE award_awards SET self_nominate='yes' WHERE 1;
 UPDATE award_awards SET schedule_judges='yes' WHERE 1;