From 89c5efb8891897b77c6d43a7875f14cd916cce37 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Thu, 13 Jan 2022 21:35:56 -0800 Subject: [PATCH] Queue XML/DAO - Add upgrade step to 5.47.alpha1.mysql.tpl --- CRM/Upgrade/Incremental/sql/5.47.alpha1.mysql.tpl | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.47.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.47.alpha1.mysql.tpl index dd955c3e32..dadd1c58fd 100644 --- a/CRM/Upgrade/Incremental/sql/5.47.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.47.alpha1.mysql.tpl @@ -1,5 +1,15 @@ {* file to handle db changes in 5.47.alpha1 during upgrade *} +CREATE TABLE IF NOT EXISTS `civicrm_queue` ( + `id` int unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(64) NOT NULL COMMENT 'Name of the queue', + `type` varchar(64) NOT NULL COMMENT 'Type of the queue', + `is_autorun` tinyint COMMENT 'Should the standard background attempt to autorun tasks in this queue?', + PRIMARY KEY (`id`), + UNIQUE INDEX `UI_name`(name) +) +ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; + UPDATE `civicrm_navigation` SET `is_active` = 0 WHERE `is_active` IS NULL; UPDATE `civicrm_navigation` SET `weight` = 0 WHERE `weight` IS NULL; ALTER TABLE `civicrm_navigation` -- 2.25.1