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

   1 -- adding inbound activity CRM-5290
   2 {if $addInboundEmail}
   3   SELECT @option_group_id_activity_type := max(id) from civicrm_option_group where name = 'activity_type';
   4   SELECT @max_val    := MAX(ROUND(op.value)) FROM civicrm_option_value op WHERE op.option_group_id  = @option_group_id_activity_type;
   5   SELECT @max_wt     := max(weight) from civicrm_option_value where option_group_id=@option_group_id_activity_type;
   6
   7   INSERT INTO civicrm_option_value
   8         (option_group_id,                {localize field='label'}label{/localize}, {localize field='description'}description{/localize}, value,                           name,                    weight,                      filter, is_reserved)
   9         VALUES
  10         (@option_group_id_activity_type, {localize}'Inbound Email'{/localize},        {localize}'Inbound Email.'{/localize},              (SELECT @max_val := @max_val+1), 'Inbound Email',       (SELECT @max_wt := @max_wt+1), 1,     1);
  11 {/if}