science-ation/db/db.update.42.sql
dave caeb7cbe78 - Add a config option (default 'no') to ask the students for a pronunciation
key for their name.  The idea is that it's for those often mis-pronounced
  names at the award ceremony.
2007-01-31 07:35:08 +00:00

5 lines
385 B
SQL

ALTER TABLE `students` ADD `pronunciation` VARCHAR( 64 ) NOT NULL AFTER `lastname`;
INSERT INTO `config` ( `var` , `val` , `category` , `type` , `type_values` , `ord` , `description` , `year` ) VALUES ( 'participant_student_pronunciation', 'no', 'Participant Registration', 'yesno', '', '1020', 'Ask the student for a pronunciation key for their name (for award ceremonies)', '-1');