crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/3.3.alpha2.mysql.tpl

   1 -- CRM-4572
   2
   3 SELECT @uf_group_id_sharedAddress   := max(id) from civicrm_uf_group where name = 'shared_address';
   4
   5 UPDATE `civicrm_uf_field`
   6    SET `is_reserved` = '1',
   7        `is_required` = '1'
   8 WHERE civicrm_uf_field.uf_group_id = @uf_group_id_sharedAddress AND civicrm_uf_field.field_name IN ('city', 'street_address' );
   9
  10 -- CRM-6977
  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;
  16