Merge pull request #4054 from eileenmcnaughton/CRM-15237

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 3.0.4.mysql.tpl

-- CRM-5636
{if $addDeceasedStatus}
SELECT @maxWeight := MAX(ROUND(weight)) FROM civicrm_membership_status;
   {if $multilingual}
      INSERT INTO  civicrm_membership_status
          ( {foreach from=$locales item=locale}name_{$locale}, {/foreach} is_current_member, is_admin, is_active, is_reserved, weight, is_default )
      VALUES
          ( {foreach from=$locales item=locale}'Deceased',{/foreach} 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );
   {else}
      INSERT INTO  civicrm_membership_status
          ( name, is_current_member, is_admin, is_active, is_reserved, weight, is_default )
      VALUES
          ( 'Deceased', 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );
   {/if}
{/if}