From f6cecca82b633c59425f51d27f7ae0db689233fc Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Mon, 24 Jul 2017 23:13:15 -0700 Subject: [PATCH] CRM-20958 - On upgrade, declare created/modified timestamps for case+activity --- CRM/Upgrade/Incremental/php/FourSeven.php | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/CRM/Upgrade/Incremental/php/FourSeven.php b/CRM/Upgrade/Incremental/php/FourSeven.php index 08c8a722fb..c49eaad4c8 100644 --- a/CRM/Upgrade/Incremental/php/FourSeven.php +++ b/CRM/Upgrade/Incremental/php/FourSeven.php @@ -418,6 +418,17 @@ class CRM_Upgrade_Incremental_php_FourSeven extends CRM_Upgrade_Incremental_Base 'civicrm_uf_group', 'cancel_button_text', "varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Custom Text to display on the cancel button when used in create or edit mode'", TRUE); $this->addTask('Add Submit button text column to civicrm_uf_group', 'addColumn', 'civicrm_uf_group', 'submit_button_text', "varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Custom Text to display on the submit button on profile edit/create screens'", TRUE); + + $this->addTask('CRM-20958 - Add created_date to civicrm_activity', 'addColumn', + 'civicrm_activity', 'created_date', "timestamp NULL DEFAULT NULL COMMENT 'When was the activity was created.'"); + $this->addTask('CRM-20958 - Add modified_date to civicrm_activity', 'addColumn', + 'civicrm_activity', 'modified_date', "timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was the activity (or closely related entity) was created or modified or deleted.'"); + $this->addTask('CRM-20958 - Add created_date to civicrm_case', 'addColumn', + 'civicrm_case', 'created_date', "timestamp NULL DEFAULT NULL COMMENT 'When was the case was created.'"); + $this->addTask('CRM-20958 - Add modified_date to civicrm_case', 'addColumn', + 'civicrm_case', 'modified_date', "timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was the case (or closely related entity) was created or modified or deleted.'"); + + return TRUE; } -- 2.25.1