From a1820dcc029ede162dbac1d58e73afa006e77210 Mon Sep 17 00:00:00 2001 From: Matthew Wire Date: Thu, 23 Sep 2021 16:59:18 +0100 Subject: [PATCH] Add upgrader to update comments on civicrm_contribution_recur table --- CRM/Upgrade/Incremental/sql/5.48.alpha1.mysql.tpl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.48.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.48.alpha1.mysql.tpl index d6dbb993f3..046e9eae1f 100644 --- a/CRM/Upgrade/Incremental/sql/5.48.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.48.alpha1.mysql.tpl @@ -1 +1,5 @@ {* file to handle db changes in 5.48.alpha1 during upgrade *} + +{* https://github.com/civicrm/civicrm-core/pull/21539 Deprecate civicrm_contribution_recur.trxn_id *} +ALTER TABLE `civicrm_contribution_recur` MODIFY `processor_id` varchar(255) DEFAULT NULL COMMENT 'May store an identifier used to link this recurring contribution record to a third party payment processor\'s system'; +ALTER TABLE `civicrm_contribution_recur` MODIFY `trxn_id` varchar(255) DEFAULT NULL COMMENT 'unique transaction id (deprecated - use processor_id)'; -- 2.25.1