2 SELECT @option_group_id_pi := max(id) from civicrm_option_group where name = 'payment_instrument';
3 UPDATE civicrm_option_value
5 WHERE option_group_id = @option_group_id_pi AND name = 'Check';
6 UPDATE civicrm_option_value
8 WHERE option_group_id = @option_group_id_pi AND name = 'Debit Card';
11 UPDATE civicrm_uf_field SET field_name = 'participant_status' WHERE field_name = 'participant_status_id';
13 UPDATE civicrm_uf_field SET field_name = 'participant_role' WHERE field_name = 'participant_role_id';
15 UPDATE civicrm_uf_field SET field_name = 'membership_type' WHERE field_name = 'membership_type_id';
17 UPDATE civicrm_uf_field SET field_name = 'membership_status' WHERE field_name = 'status_id';
19 UPDATE civicrm_uf_field SET field_name = 'contribution_type' WHERE field_name = 'contribution_type_id';