From e39a7c67ffe68b671b8e97d8a2a0573f58d354f4 Mon Sep 17 00:00:00 2001
From: Omar abu hussein <opetmar91@gmail.com>
Date: Tue, 20 Apr 2021 12:47:40 +0100
Subject: [PATCH] Increase civicrm_queue_item.data field size

civicrm_queue_item.data field holds information about the task in the
job queue that is going to be excuted. But if we are using queues to
import large data (as we might do in an extension such as
nz.co.fuzion.csvimport) then the current field type might not be able to
handle the data size. So here I am changing it from TEXT to LONGTEXT to
accomdate for such cases.
---
 CRM/Queue/DAO/QueueItem.php    | 6 +++---
 xml/schema/Queue/QueueItem.xml | 2 +-
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/CRM/Queue/DAO/QueueItem.php b/CRM/Queue/DAO/QueueItem.php
index 7b45686dd5..53162ce6bd 100644
--- a/CRM/Queue/DAO/QueueItem.php
+++ b/CRM/Queue/DAO/QueueItem.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Queue/QueueItem.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:e720570f92fa1a377b108e5fdacf046f)
+ * (GenCodeChecksum:cb6bf44fc806a2a4e88aefe65f7a8fab)
  */
 
 /**
@@ -64,7 +64,7 @@ class CRM_Queue_DAO_QueueItem extends CRM_Core_DAO {
   /**
    * Serialized queue data
    *
-   * @var text
+   * @var longtext
    */
   public $data;
 
@@ -178,7 +178,7 @@ class CRM_Queue_DAO_QueueItem extends CRM_Core_DAO {
         ],
         'data' => [
           'name' => 'data',
-          'type' => CRM_Utils_Type::T_TEXT,
+          'type' => CRM_Utils_Type::T_LONGTEXT,
           'title' => ts('Queue item data'),
           'description' => ts('Serialized queue data'),
           'where' => 'civicrm_queue_item.data',
diff --git a/xml/schema/Queue/QueueItem.xml b/xml/schema/Queue/QueueItem.xml
index 9feedb4f20..92b35e8cf3 100644
--- a/xml/schema/Queue/QueueItem.xml
+++ b/xml/schema/Queue/QueueItem.xml
@@ -68,7 +68,7 @@
   <field>
     <name>data</name>
     <title>Queue item data</title>
-    <type>text</type>
+    <type>longtext</type>
     <comment>Serialized queue data</comment>
     <serialize>PHP</serialize>
   </field>
-- 
2.25.1