crm.fsf.org/20131203/files/sites/all/modules-old/civicrm/CRM/Upgrade/Incremental/sql/4.2.2.mysql.tpl

   1 -- CRM-10810
   2 SELECT @max_strict := max(id), @cnt_strict := count(*) FROM `civicrm_dedupe_rule_group` WHERE `contact_type` = 'Individual' AND `level` = 'Strict' AND `is_default` = 1;
   3 UPDATE `civicrm_dedupe_rule_group` SET  `is_default` = 0 WHERE @cnt_strict > 1 AND id = @max_strict;
   4
   5 SELECT @max_fuzzy := max(id), @cnt_fuzzy := count(*) FROM `civicrm_dedupe_rule_group` WHERE `contact_type` = 'Individual' AND `level` = 'Fuzzy' AND `is_default` = 1;
   6 UPDATE `civicrm_dedupe_rule_group` SET  `is_default` = 0 WHERE @cnt_fuzzy > 1 AND id = @max_fuzzy;
   7
   8 -- Insert line items for contribution for api/import
   9 SELECT @fieldID := cpf.id, @fieldValueID := cpfv.id FROM civicrm_price_set cps
  10 LEFT JOIN civicrm_price_field cpf ON  cps.id = cpf.price_set_id
  11 LEFT JOIN civicrm_price_field_value cpfv ON cpf.id = cpfv.price_field_id
  12 WHERE cps.name = 'default_contribution_amount';
  13
  14 INSERT INTO civicrm_line_item ( entity_table, entity_id, price_field_id,label, qty, unit_price, line_total, participant_count, price_field_value_id )
  15 SELECT 'civicrm_contribution', cc.id, @fieldID, 'Contribution Amount', 1, total_amount, total_amount , 0, @fieldValueID
  16 FROM `civicrm_contribution` cc
  17 LEFT JOIN civicrm_line_item cli ON cc.id=cli.entity_id and cli.entity_table = 'civicrm_contribution'
  18 LEFT JOIN civicrm_membership_payment cmp ON cc.id = cmp.contribution_id
  19 LEFT JOIN civicrm_participant_payment cpp ON cc.id = cpp.contribution_id
  20 WHERE cli.entity_id IS NULL AND cc.contribution_page_id IS NULL AND cmp.contribution_id IS NULL AND cpp.contribution_id IS NULL
  21 GROUP BY cc.id;