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

   1 {* file to handle db changes in 4.7.17 during upgrade *}
   2
   3 -- CRM-19943
   4 UPDATE civicrm_navigation SET url = 'civicrm/tag' WHERE url = 'civicrm/tag?reset=1';
   5 UPDATE civicrm_navigation SET url = REPLACE(url, 'civicrm/tag', 'civicrm/tag/edit') WHERE url LIKE 'civicrm/tag?%';
   6
   7 -- CRM-19815, CRM-19830 update references to check_number to reflect unique name
   8 UPDATE civicrm_uf_field SET field_name = 'contribution_check_number' WHERE field_name = 'check_number';
   9 UPDATE civicrm_mapping_field SET name = 'contribution_check_number' WHERE name = 'check_number';
  10
  11 -- CRM-20158
  12 ALTER TABLE `civicrm_financial_trxn`
  13   ADD card_type INT( 10 ) UNSIGNED NULL DEFAULT NULL COMMENT 'FK to accept_creditcard option group values' AFTER payment_instrument_id,
  14   ADD pan_truncation INT UNSIGNED NULL COMMENT 'Last 4 digits of credit card.' AFTER check_number;