science-ation/db/db.update.25.sql

ALTER TABLE `award_contacts` ADD `position` VARCHAR( 64 ) NOT NULL AFTER `lastname` ;
ALTER TABLE `award_prizes` ADD `value` INT NOT NULL AFTER `scholarship` ;
UPDATE `award_prizes` SET `value` = `cash` + `scholarship`;
Add a position field to the award sponsors contacts 2006-09-20 15:33:46 +00:00			ALTER TABLE `award_contacts` ADD `position` VARCHAR( 64 ) NOT NULL AFTER `lastname` ;
Add a prize value field to award prizes, also add editor the the value, as well add editor for the contact position 2006-09-20 16:24:52 +00:00			ALTER TABLE `award_prizes` ADD `value` INT NOT NULL AFTER `scholarship` ;
			UPDATE `award_prizes` SET `value` = `cash` + `scholarship`;