forked from science-ation/science-ation
34 lines
1.3 KiB
SQL
34 lines
1.3 KiB
SQL
INSERT INTO `config` (
|
|
`var` ,
|
|
`val` ,
|
|
`category` ,
|
|
`type` ,
|
|
`type_values` ,
|
|
`ord` ,
|
|
`description` ,
|
|
`year` ,
|
|
`conferences_id` ,
|
|
`section` ,
|
|
`conferencetypes`
|
|
)
|
|
VALUES (
|
|
'teacher_personal_fields', 'phonehome,phonecell,phonework,org,address,city,province,lang', 'Teacher Registration', 'multisel', 'sex=Gender|phonehome=Home Phone|phonework=Work Phone|phonecell=Cell Phone|fax=Fax|org=Organization|birthdate=Birthdate|lang=Preferred Language|address=Address and PostalCode|city=City|province=Province', '500', 'Personal Information to ask for on the Teacher personal information page (in addition to Name and Email)', '-1', '-1', 'conference', 'sciencefair,scienceolympics'
|
|
);
|
|
|
|
INSERT INTO `config` (
|
|
`var` ,
|
|
`val` ,
|
|
`category` ,
|
|
`type` ,
|
|
`type_values` ,
|
|
`ord` ,
|
|
`description` ,
|
|
`year` ,
|
|
`conferences_id` ,
|
|
`section` ,
|
|
`conferencetypes`
|
|
)
|
|
VALUES (
|
|
'teacher_personal_required', 'phonehome,address,city,province', 'Teacher Registration', 'multisel', 'sex=Gender|phonehome=Home Phone|phonework=Work Phone|phonecell=Cell Phone|fax=Fax|org=Organization|birthdate=Birthdate|lang=Preferred Language|address=Address and PostalCode|city=City|province=Province', '600', 'Required Personal Information on the Teacher personal information page (Name and Email is always required)', '-1', '-1', 'conference', 'sciencefair,scienceolympics'
|
|
);
|