science-ation/db/db.update.233.sql
2011-03-03 17:39:14 +00:00

4 lines
1.0 KiB
SQL

INSERT INTO `config` (`var`, `val`, `category`, `type`, `type_values`, `ord`, `description`, `year`, `conferences_id`, `section`, `conferencetypes`) VALUES
('participant_personal_fields', 'phonehome,phonecell,address,city,province,lang', 'Participant Registration', 'multisel', 'sex=Gender|phonehome=Home Phone|phonecell=Cell Phone|birthdate=Birthdate|lang=Preferred Language|address=Address and PostalCode|city=City|province=Province', 501, 'Personal Information to ask for on the Participant personal information page (in addition to Name and Email)', -1, -1, 'conference', 'sciencefair,scienceolympics'),
('participant_personal_required', 'phonehome,phonecell,address,city,province,lang', 'Participant Registration', 'multisel', 'sex=Gender|phonehome=Home Phone|phonecell=Cell Phone|birthdate=Birthdate|lang=Preferred Language|address=Address and PostalCode|city=City|province=Province', 502, 'Required Personal Information on the Participant personal information page (Name and Email is always required)', -1, -1, 'conference', 'sciencefair,scienceolympics');