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

ALTER TABLE `students` ADD `webfirst` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ,
ADD `weblast` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ,
ADD `webphoto` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ;
Implement web consent restrictions, settable by the admin (under the admin->participant registration menu) to prevent firstname and or lastname (and or photos once they are implemented) of students, on a per studnet basis, from being displayed on the website. It currently affects the confirmed participants page, and the winners page (the only two public places where sutdent info is available thorugh the system) 2007-03-31 01:10:08 +00:00			ALTER TABLE `students` ADD `webfirst` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ,
			ADD `weblast` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ,
			ADD `webphoto` ENUM( 'no', 'yes' ) DEFAULT 'yes' NOT NULL ;