Code:
ALTER TABLE customers ADD customers_extrafield1 varchar(250) NOT NULL AFTER customers_fax;
ALTER TABLE customers ADD customers_extrafield2 varchar(250) NOT NULL AFTER customers_extrafield1;
ALTER TABLE customers ADD customers_extrafield3 varchar(250) NOT NULL AFTER customers_extrafield2;
ALTER TABLE customers ADD customers_extrafield4 varchar(250) NOT NULL AFTER customers_extrafield3;
ALTER TABLE customers ADD customers_extrafield5 varchar(250) NOT NULL AFTER customers_extrafield4;
ALTER TABLE customers ADD customers_extrafield6 varchar(250) NOT NULL AFTER customers_extrafield5;
ALTER TABLE customers ADD customers_extrafield7 varchar(250) NOT NULL AFTER customers_extrafield6;
ALTER TABLE customers ADD customers_extrafield8 varchar(250) NOT NULL AFTER customers_extrafield7;
ALTER TABLE customers ADD customers_extrafield9 varchar(250) NOT NULL AFTER customers_extrafield8;
ALTER TABLE customers ADD customers_extrafield0 varchar(250) NOT NULL AFTER customers_extrafield9;
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allergies? Please list here', 'DISPLAY_EXTRAFIELD1', 'true', 'Display "Allergies? Please list here" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Allergies? Please list here', 'EXTRAFIELD1_REQUIRED', 'true', 'Require Allergies? Please list here in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Height', 'DISPLAY_EXTRAFIELD2', 'true', 'Display "Height" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Height', 'EXTRAFIELD2_REQUIRED', 'true', 'Require Height in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Weight', 'DISPLAY_EXTRAFIELD3', 'true', 'Display "Weight" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Weight', 'EXTRAFIELD3_REQUIRED', 'true', 'Require Weight in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Do you drink coffee? If so, how often?', 'DISPLAY_EXTRAFIELD4', 'true', 'Display "Do you drink coffee? If so, how often?" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Do you drink coffee? If so, how often?', 'EXTRAFIELD4_REQUIRED', 'true', 'Require Do you drink coffee? If so, how often? in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Do you drink alcohol? If so, how often?', 'DISPLAY_EXTRAFIELD5', 'true', 'Display "Do you drink alcohol? If so, how often?" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Do you drink alcohol? If so, how often?', 'EXTRAFIELD5_REQUIRED', 'true', 'Require Do you drink alcohol? If so, how often? in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Do you exercise? If so, how often?', 'DISPLAY_EXTRAFIELD6', 'true', 'Display "Do you exercise? If so, how often?" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Do you exercise? If so, how often?', 'EXTRAFIELD6_REQUIRED', 'true', 'Require Do you exercise? If so, how often? in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Are you familiar with a vegan lifestyle?', 'DISPLAY_EXTRAFIELD7', 'true', 'Display "Are you familiar with a vegan lifestyle?" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Are you familiar with a vegan lifestyle?', 'EXTRAFIELD7_REQUIRED', 'true', 'Require Are you familiar with a vegan lifestyle? in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display How did you hear about us?', 'DISPLAY_EXTRAFIELD8', 'true', 'Display "How did you hear about us?" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require How did you hear about us?', 'EXTRAFIELD8_REQUIRED', 'true', 'Require How did you hear about us? in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Favorite Food', 'DISPLAY_EXTRAFIELD9', 'true', 'Display "Favorite Food" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Favorite Food', 'EXTRAFIELD9_REQUIRED', 'true', 'Require Favorite Food in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Favorite Passtime', 'DISPLAY_EXTRAFIELD0', 'true', 'Display "Favorite Passtime" on account creation page', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Favorite Passtime', 'EXTRAFIELD0_REQUIRED', 'true', 'Require Favorite Passtime in account creation', '5', '7', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
Bookmarks