From 606dfab68ba109dfdde75659484603873d36bf4f Mon Sep 17 00:00:00 2001 From: eileenmcnaugton Date: Mon, 23 May 2016 10:02:31 +1200 Subject: [PATCH] CRM-18683 4.6.17 ver of upgrade script --- CRM/Upgrade/Incremental/sql/4.6.18.mysql.tpl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.6.18.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.18.mysql.tpl index 8317dce026..09edb02619 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.18.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.18.mysql.tpl @@ -1 +1,4 @@ {* file to handle db changes in 4.6.18 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; -- 2.25.1