3 SELECT @uf_group_id_sharedAddress := max(id) from civicrm_uf_group where name = 'shared_address';
5 UPDATE `civicrm_uf_field`
6 SET `is_reserved` = '1',
8 WHERE civicrm_uf_field.uf_group_id = @uf_group_id_sharedAddress AND civicrm_uf_field.field_name IN ('city', 'street_address' );
11 SELECT @opt_grp_id_frm_email_address := MAX(id) from civicrm_option_group where name = 'from_email_address';
12 UPDATE civicrm_option_value
13 SET {localize field='label'}label = REPLACE(label, '"<', '" <' ){/localize},
14 name = REPLACE( name, '"<', '" <' )
15 WHERE option_group_id = @opt_grp_id_frm_email_address;