2 {if $addDeceasedStatus}
3 SELECT @maxWeight := MAX(ROUND(weight)) FROM civicrm_membership_status;
5 INSERT INTO civicrm_membership_status
6 ( {foreach from=$locales item=locale}name_{$locale}, {/foreach} is_current_member, is_admin, is_active, is_reserved, weight, is_default )
8 ( {foreach from=$locales item=locale}'Deceased',{/foreach} 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );
10 INSERT INTO civicrm_membership_status
11 ( name, is_current_member, is_admin, is_active, is_reserved, weight, is_default )
13 ( 'Deceased', 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );