CRM/Upgrade/Incremental/sql/4.4.1.mysql.tpl

   1 {* file to handle db changes in 4.4.1 during upgrade *}
   2 -- CRM-13327
   3 SELECT @option_group_id_name_badge := max(id) from civicrm_option_group where name = 'name_badge';
   4 UPDATE civicrm_option_value
   5 SET value = '{literal}{"name":"Avery 5395","paper-size":"a4","metric":"mm","lMargin":15,"tMargin":26,"NX":2,"NY":4,"SpaceX":10,"SpaceY":5,"width":83,"height":57,"font-size":12,"orientation":"portrait","font-name":"helvetica","font-style":"","lPadding":3,"tPadding":3}{/literal}'
   6 WHERE option_group_id = @option_group_id_name_badge AND name = 'Avery 5395';
   7
   8 -- CRM-13669
   9 {literal}
  10 UPDATE civicrm_option_value SET name = 'Dear {contact.household_name}'
  11 WHERE name = 'Dear {contact.househols_name}';
  12 {/literal}