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

   1
   2 -- CRM-5711
   3
   4 UPDATE civicrm_custom_group SET extends_entity_column_value = CONCAT(CHAR( 01 ), extends_entity_column_value, CHAR( 01 ))
   5 WHERE LOCATE( char( 01 ), extends_entity_column_value ) <= 0;
   6
   7 -- CRM-5472
   8 INSERT INTO civicrm_acl
   9     (name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active)
  10 VALUES
  11     ('Core ACL', 0, 'civicrm_acl_role', 1, 'All', 'edit all events', NULL, NULL, NULL, 1);
  12
  13 -- CRM-5636
  14 {if $addDeceasedStatus}
  15    {if $multilingual}
  16       INSERT INTO  civicrm_membership_status
  17           ( {foreach from=$locales item=locale}name_{$locale}, {/foreach} is_current_member, is_admin, is_active, is_reserved, weight, is_default )
  18       VALUES
  19           ( {foreach from=$locales item=locale}'Deceased',{/foreach} 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );
  20    {else}
  21       INSERT INTO  civicrm_membership_status
  22           ( name, is_current_member, is_admin, is_active, is_reserved, weight, is_default )
  23       VALUES
  24           ( 'Deceased', 0, 1, 1, 1, (SELECT @maxWeight := @maxWeight + 1), 0 );
  25    {/if}
  26 {/if}