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

   1 {* file to handle db changes in 4.7.13 during upgrade *}
   2
   3 -- CRM-19427
   4 ALTER TABLE  `civicrm_price_field_value` CHANGE  `deductible_amount`  `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT  '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.';
   5
   6 ALTER TABLE  `civicrm_line_item` CHANGE  `deductible_amount`  `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT  '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.';
   7
   8 -- CRM-15371 Manage tags with new *manage tags* permission (used to need *administer CiviCRM* permission)
   9 UPDATE civicrm_navigation SET
  10   `url` = 'civicrm/tag?reset=1',
  11   `permission` = 'manage tags'
  12 WHERE `name` = 'Manage Tags (Categories)';
  13
  14 UPDATE civicrm_navigation SET
  15   `url` = 'civicrm/tag?reset=1&action=add',
  16   `permission` = 'manage tags'
  17 WHERE `name` = 'New Tag';
  18
  19 UPDATE civicrm_navigation SET
  20   `url` = 'civicrm/tag?reset=1'
  21 WHERE `name` = 'Tags (Categories)';
  22
  23 -- CRM-16352: Add language filter support for mass mailing
  24 ALTER TABLE civicrm_mailing ADD COLUMN `language` varchar(5) DEFAULT NULL COMMENT 'Language of the content of the mailing. Useful for tokens.';