arman/science-ation
1
1
Fork 0
forked from science-ation/science-ation
Code Pull Requests Activity
master
science-ation/db/db.update.38.sql

7 lines
777 B
MySQL
Raw Permalink Normal View History

- Properly copy the config type in the config editor when copying -1 config values into the current year - Add 2 new config options. - 'participant_student_tshirt_cost' allows the cost of each fair tshirt to be set (vancouver charges $10 for tshirts, because not all students want them), this also adds a 'none' option to the tshirt selection box, and a note indicating the tshirt cost if the costs is nonzero. - 'regfee_show_info' adds a "Registration Fee Information" to the main student registration page, showing a breakdown of the registration fee computation (including tshirts, per_student and per_project registration, and indicates the total. - Convert the tshirt field to VARCHAR(32) instead of enum so the "none" option described above works, also, some fairs may want to add more optoins, like female/male sizes.. so turn this into a text field for those fairs. The next step would be to make a config option for the tshirt options. :)
2007-01-21 01:40:46 +00:00
INSERT INTO `config` ( `var` , `val` , `category` , `type` , `type_values` , `ord` , `description` , `year` ) VALUES ( 'participant_student_tshirt_cost', '0.00', 'Participant Registration', 'number', '', '1310', 'The cost of each T-Shirt. If this is non-zero, a "None" option is added to the T-Shirt size selection box, and a note is added indicating the cost of each T-Shirt', '-1');
INSERT INTO `config` ( `var` , `val` , `category` , `type` , `type_values` , `ord` , `description` , `year` ) VALUES ( 'regfee_show_info', 'no', 'Participant Registration', 'yesno', '', '410', 'Show a breakdown of the total Registration Fee calculation on the main student registration page', '-1');
ALTER TABLE `students` CHANGE `tshirt` `tshirt` VARCHAR( 32 ) NOT NULL DEFAULT 'medium';
Copy Permalink