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

arman/science-ation

forked from science-ation/science-ation

james 0551a65e93 Add trophy selection (student keeper, student return, school keeper, school return) to prizes

Add description to award & update awards ceremony script to include description if available

2007-11-23 21:21:37 +00:00

7 lines

325 B

SQL

Raw Permalink Blame History

 ALTER TABLE `award_prizes`
 	ADD `trophystudentkeeper` BOOL DEFAULT '0' NOT NULL ,
 	ADD `trophystudentreturn` BOOL DEFAULT '0' NOT NULL ,
 	ADD `trophyschoolkeeper` BOOL DEFAULT '0' NOT NULL ,
 	ADD `trophyschoolreturn` BOOL DEFAULT '0' NOT NULL ;
 ALTER TABLE `award_awards` ADD `description` TEXT NOT NULL AFTER `criteria` ;