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

{* file to handle db changes in 4.7.13 during upgrade *}

-- CRM-19427
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.';

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.';

-- CRM-15371 Manage tags with new *manage tags* permission (used to need *administer CiviCRM* permission)
UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1',
  `permission` = 'manage tags'
WHERE `name` = 'Manage Tags (Categories)';

UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1&action=add',
  `permission` = 'manage tags'
WHERE `name` = 'New Tag';

UPDATE civicrm_navigation SET
  `url` = 'civicrm/tag?reset=1'
WHERE `name` = 'Tags (Categories)';

-- CRM-16352: Add language filter support for mass mailing
ALTER TABLE civicrm_mailing ADD COLUMN `language` varchar(5) DEFAULT NULL COMMENT 'Language of the content of the mailing. Useful for tokens.';
Commit	Line	Data
09c30ff3	1	{* file to handle db changes in 4.7.13 during upgrade *}
5afce5ad	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.';
eaaaef83 I	7
	8	-- CRM-15371 Manage tags with new manage tags permission (used to need administer CiviCRM permission)
	9	UPDATE civicrm_navigation SET
b9bbfae7	10	`url` = 'civicrm/tag?reset=1',
eaaaef83 I	11	`permission` = 'manage tags'
	12	WHERE `name` = 'Manage Tags (Categories)';
	13
	14	UPDATE civicrm_navigation SET
b9bbfae7	15	`url` = 'civicrm/tag?reset=1&action=add',
eaaaef83 I	16	`permission` = 'manage tags'
	17	WHERE `name` = 'New Tag';
	18
	19	UPDATE civicrm_navigation SET
b9bbfae7	20	`url` = 'civicrm/tag?reset=1'
eaaaef83	21	WHERE `name` = 'Tags (Categories)';
0c12c90f	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.';