
START TRANSACTION;

UPDATE `options` SET  
	`key` = 'o_rf_include_fname',
	`tab_id` = '3',
	`value` = '1|2|3::3',
	`label` = 'No|Yes|Yes (required)',
	`type` = 'enum',
	`order` = '1',
	`is_visible` = '1',
	`style` = ':NULL'
	WHERE `key` = 'o_registration_form';
	
UPDATE `options` SET  
	`key` = 'o_rf_include_lname',
	`tab_id` = '3',
	`value` = '1|2|3::3',
	`label` = 'No|Yes|Yes (required)',
	`type` = 'enum',
	`order` = '2',
	`is_visible` = '1',
	`style` = ':NULL'
	WHERE `key` = 'o_profile_form';

INSERT INTO `options` (`foreign_id`, `key`, `tab_id`, `value`, `label`, `type`, `order`, `is_visible`, `style`) VALUES
(1, 'o_rf_include_email', 3, '1|2|3::3', 'No|Yes|Yes (required)', 'enum', 3, 1, NULL),
(1, 'o_rf_include_password', 3, '1|2|3::3', 'No|Yes|Yes (required)', 'enum', 4, 1, NULL),
(1, 'o_rf_include_phone', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 5, 1, NULL),
(1, 'o_rf_include_website', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 6, 1, NULL),
(1, 'o_rf_include_gender', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 7, 1, NULL),
(1, 'o_rf_include_age', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 8, 1, NULL),
(1, 'o_rf_include_birthday', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 9, 1, NULL),
(1, 'o_rf_include_address', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 10, 1, NULL),
(1, 'o_rf_include_city', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 11, 1, NULL),
(1, 'o_rf_include_state', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 12, 1, NULL),
(1, 'o_rf_include_country', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 13, 1, NULL),
(1, 'o_rf_include_zip', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 14, 1, NULL),
(1, 'o_rf_include_company', 3, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 15, 1, NULL),

(1, 'o_pf_include_fname', 4, '1|2|3::3', 'No|Yes|Yes (required)', 'enum', 1, 1, NULL),
(1, 'o_pf_include_lname', 4, '1|2|3::3', 'No|Yes|Yes (required)', 'enum', 2, 1, NULL),
(1, 'o_pf_include_email', 4, '1|2|3::3', 'No|Yes|Yes (required)', 'enum', 3, 1, NULL),
(1, 'o_pf_include_password', 4, '1|2::2', 'No|Yes', 'enum', 4, 1, NULL),
(1, 'o_pf_include_phone', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 5, 1, NULL),
(1, 'o_pf_include_website', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 6, 1, NULL),
(1, 'o_pf_include_gender', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 7, 1, NULL),
(1, 'o_pf_include_age', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 8, 1, NULL),
(1, 'o_pf_include_birthday', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 9, 1, NULL),
(1, 'o_pf_include_address', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 10, 1, NULL),
(1, 'o_pf_include_city', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 11, 1, NULL),
(1, 'o_pf_include_state', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 12, 1, NULL),
(1, 'o_pf_include_country', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 13, 1, NULL),
(1, 'o_pf_include_zip', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 14, 1, NULL),
(1, 'o_pf_include_company', 4, '1|2|3::1', 'No|Yes|Yes (required)', 'enum', 15, 1, NULL);

COMMIT;