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

   1 {* file to handle db changes in 4.7.8 during upgrade *}
   2
   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
   7 -- CRM-18537
   8 DELETE FROM civicrm_state_province WHERE name = 'Fernando de Noronha';
   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
  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;