Merge pull request #4054 from eileenmcnaughton/CRM-15237

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

-- CRM-4257

SELECT @og_id_pl := max(id) from civicrm_option_group where name = 'participant_listing';

DELETE FROM `civicrm_option_value` WHERE `option_group_id` = @og_id_pl;

 {if $multilingual}
    INSERT INTO civicrm_option_value
      (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach}  value, name, filter, weight, is_reserved, is_active) VALUES
      (@og_id_pl, {foreach from=$locales item=locale}'Name Only', 'CRM_Event_Page_ParticipantListing_Name',{/foreach}  1, 'Name Only', 0, 1, 1, 1),
      (@og_id_pl, {foreach from=$locales item=locale}'Name and Email', 'CRM_Event_Page_ParticipantListing_NameAndEmail',{/foreach}  2, 'Name and Email', 0, 2, 1, 1),
      (@og_id_pl, {foreach from=$locales item=locale}'Name, Status and Register Date', 'CRM_Event_Page_ParticipantListing_NameStatusAndDate',{/foreach}  3, 'Name, Status and Register Date', 0, 3, 1, 1);

 {else}
    INSERT INTO `civicrm_option_value`
      (`option_group_id`, `label`, `value`, `name`, `filter`, `weight`, `description`, `is_reserved`, `is_active`) VALUES
      (@og_id_pl, 'Name Only', 1, 'Name Only', 0, 1, 'CRM_Event_Page_ParticipantListing_Name', 1, 1),
      (@og_id_pl, 'Name and Email', 2, 'Name and Email', 0, 2, 'CRM_Event_Page_ParticipantListing_NameAndEmail', 1, 1),
      (@og_id_pl, 'Name, Status and Register Date', 3, 'Name, Status and Register Date', 0, 3, 'CRM_Event_Page_ParticipantListing_NameStatusAndDate', 1, 1);
 {/if}

--CRM-4256
-- Update table name in civicrm_price_set_entity (Price Set)

UPDATE `civicrm_price_set_entity` c SET c.`entity_table`='civicrm_event' WHERE c.`entity_table`='civicrm_event_page';

--Adding new custom search for Contribution Amounts by Tag.

SELECT @og_id_cs  := id FROM civicrm_option_group WHERE name = 'custom_search';
SELECT @maxValue  := max(CAST( `value` AS UNSIGNED )) FROM civicrm_option_value WHERE option_group_id = @og_id_cs;

 {if $multilingual}
     INSERT INTO civicrm_option_value
        (option_group_id, {foreach from=$locales item=locale}label_{$locale}, description_{$locale}, {/foreach} value, name, weight, is_active) VALUES
           (@og_id_cs, {foreach from=$locales item=locale}'CRM_Contact_Form_Search_Custom_TagContributions', 'Find Contribution Amounts by Tag', {/foreach} @maxValue + 1, 'CRM_Contact_Form_Search_Custom_TagContributions', @maxValue + 1, 1);
 {else}
     INSERT INTO civicrm_option_value
         (option_group_id, label, value, name, description, weight, is_active ) VALUES
             (@og_id_cs, 'CRM_Contact_Form_Search_Custom_TagContributions', @maxValue + 1, 'CRM_Contact_Form_Search_Custom_TagContributions', 'Find Contribution Amounts by Tag', @maxValue + 1, 1);
 {/if}