From 3068477b8f54306dcf0de2301ab5918c7324a972 Mon Sep 17 00:00:00 2001 From: Matthew Wire Date: Mon, 6 Sep 2021 10:25:34 +0100 Subject: [PATCH] Don't specify character set for civicrm_relationship_cache table --- CRM/Upgrade/Incremental/sql/5.29.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/5.29.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.29.alpha1.mysql.tpl index 18b176d4b0..b28c407113 100644 --- a/CRM/Upgrade/Incremental/sql/5.29.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.29.alpha1.mysql.tpl @@ -27,7 +27,7 @@ CREATE TABLE `civicrm_relationship_cache` ( CONSTRAINT FK_civicrm_relationship_cache_relationship_type_id FOREIGN KEY (`relationship_type_id`) REFERENCES `civicrm_relationship_type`(`id`) ON DELETE CASCADE, CONSTRAINT FK_civicrm_relationship_cache_near_contact_id FOREIGN KEY (`near_contact_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE CASCADE, CONSTRAINT FK_civicrm_relationship_cache_far_contact_id FOREIGN KEY (`far_contact_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; +) ENGINE=InnoDB; -- Fix missing resubscribeUrl token. There doesn't seem to be any precedent -- for doing an upgrade for these, since the last update was in 2009 when -- 2.25.1