From 1c6eee9d3f8c4567199d3e7ae22467ae83c087da Mon Sep 17 00:00:00 2001 From: Romain Thouvenin Date: Fri, 13 Jul 2018 15:55:43 +0200 Subject: [PATCH] dev/core#256 - use unsigned int for temporary recipient ids --- CRM/Mailing/BAO/Recipients.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Mailing/BAO/Recipients.php b/CRM/Mailing/BAO/Recipients.php index 4ca5be9cde..5dfeb1e58a 100644 --- a/CRM/Mailing/BAO/Recipients.php +++ b/CRM/Mailing/BAO/Recipients.php @@ -102,7 +102,7 @@ WHERE mailing_id = %1 CRM_Core_DAO::executeQuery("DROP TEMPORARY TABLE IF EXISTS srcMailing_$sourceMailingId"); $sql = " CREATE TEMPORARY TABLE srcMailing_$sourceMailingId - (mailing_recipient_id int, id int PRIMARY KEY AUTO_INCREMENT, INDEX(mailing_recipient_id)) + (mailing_recipient_id int unsigned, id int PRIMARY KEY AUTO_INCREMENT, INDEX(mailing_recipient_id)) ENGINE=HEAP"; CRM_Core_DAO::executeQuery($sql); $sql = " -- 2.25.1