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

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

-- CRM-18516 Convert the date fields relating to group caching and acl caching timestamp
ALTER TABLE civicrm_group CHANGE cache_date cache_date timestamp NULL DEFAULT NULL , CHANGE refresh_date refresh_date timestamp NULL DEFAULT NULL;
ALTER TABLE civicrm_acl_cache CHANGE modified_date modified_date timestamp NULL DEFAULT NULL;

-- CRM-18537
DELETE FROM civicrm_state_province WHERE name = 'Fernando de Noronha';

-- CRM-17118 extend civicrm_address postal_code to accept full data strings from paypal etc.
ALTER TABLE civicrm_address CHANGE `postal_code` `postal_code` varchar(64) ;

-- CRM-16189
SELECT @contributionNavId := id, @domainID := domain_id FROM civicrm_navigation WHERE name = 'Contributions';
SELECT @navMaxWeight := MAX(ROUND(weight))+1 from civicrm_navigation WHERE parent_id = @contributionNavId;

UPDATE civicrm_navigation SET has_separator = 1 WHERE name = 'Manage Price Sets' AND parent_id = @contributionNavId;
Commit	Line	Data
38e14c77	1	{* file to handle db changes in 4.7.8 during upgrade *}
4d83a459	2
a986056d	3	-- CRM-18516 Convert the date fields relating to group caching and acl caching timestamp
	4	ALTER TABLE civicrm_group CHANGE cache_date cache_date timestamp NULL DEFAULT NULL , CHANGE refresh_date refresh_date timestamp NULL DEFAULT NULL;
	5	ALTER TABLE civicrm_acl_cache CHANGE modified_date modified_date timestamp NULL DEFAULT NULL;
	6
9811b68d SB	7	-- CRM-18537
9811b68d SB	8	DELETE FROM civicrm_state_province WHERE name = 'Fernando de Noronha';
c5219185	9
	10	-- CRM-17118 extend civicrm_address postal_code to accept full data strings from paypal etc.
	11	ALTER TABLE civicrm_address CHANGE `postal_code` `postal_code` varchar(64) ;
	12
1776e967 PN	13	-- CRM-16189
	14	SELECT @contributionNavId := id, @domainID := domain_id FROM civicrm_navigation WHERE name = 'Contributions';
	15	SELECT @navMaxWeight := MAX(ROUND(weight))+1 from civicrm_navigation WHERE parent_id = @contributionNavId;
	16
	17	UPDATE civicrm_navigation SET has_separator = 1 WHERE name = 'Manage Price Sets' AND parent_id = @contributionNavId;