[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.47.alpha1.mysql.tpl

{* 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`
  MODIFY COLUMN `is_active` tinyint NOT NULL DEFAULT 1 COMMENT 'Is this navigation item active?',
  MODIFY COLUMN `weight` int NOT NULL DEFAULT 0 COMMENT 'Ordering of the navigation items in various blocks.';
Commit	Line	Data
9ea6ff40	1	{* file to handle db changes in 5.47.alpha1 during upgrade *}
27010e05	2
89c5efb8 TO	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?',
	8	PRIMARY KEY (`id`),
	9	UNIQUE INDEX `UI_name`(name)
	10	)
	11	ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
	12
27010e05 CW	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.';