1 {* file to handle db changes in 5.47.alpha1 during upgrade *}
3 CREATE TABLE IF NOT EXISTS `civicrm_queue` (
4 `id` int unsigned NOT NULL AUTO_INCREMENT,
5 `name` varchar(64) NOT NULL COMMENT 'Name of the queue',
6 `type` varchar(64) NOT NULL COMMENT 'Type of the queue',
7 `is_autorun` tinyint COMMENT 'Should the standard background attempt to autorun tasks in this queue?',
9 UNIQUE INDEX `UI_name`(name)
11 ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
13 UPDATE `civicrm_navigation` SET `is_active` = 0 WHERE `is_active` IS NULL;
14 UPDATE `civicrm_navigation` SET `weight` = 0 WHERE `weight` IS NULL;
15 ALTER TABLE `civicrm_navigation`
16 MODIFY COLUMN `is_active` tinyint NOT NULL DEFAULT 1 COMMENT 'Is this navigation item active?',
17 MODIFY COLUMN `weight` int NOT NULL DEFAULT 0 COMMENT 'Ordering of the navigation items in various blocks.';
19 {* Ensure CustomGroup.name is unique *}
20 UPDATE civicrm_custom_group g1, civicrm_custom_group g2 SET g1.name = CONCAT(g1.name, '_1') WHERE g1.name = g2.name AND g1.id > g2.id;