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.'; | |
f61cf6ab FW |
18 | |
19 | {* https://lab.civicrm.org/dev/core/-/issues/2122 *} | |
20 | UPDATE `civicrm_event` SET `start_date` = NULL WHERE `start_date` < 19700102; | |
21 | UPDATE `civicrm_event` SET `end_date` = NULL WHERE `end_date` < 19700102; | |
22 | UPDATE `civicrm_event` SET `registration_start_date` = NULL WHERE `registration_start_date` < 19700102; | |
23 | UPDATE `civicrm_event` SET `registration_end_date` = NULL WHERE `registration_end_date` < 19700102; | |
24 | ALTER TABLE `civicrm_event` | |
25 | MODIFY COLUMN `start_date` timestamp NULL DEFAULT NULL COMMENT 'Date and time that event starts.', | |
26 | MODIFY COLUMN `end_date` timestamp NULL DEFAULT NULL COMMENT 'Date and time that event ends. May be NULL if no defined end date/time', | |
27 | MODIFY COLUMN `registration_start_date` timestamp NULL DEFAULT NULL COMMENT 'Date and time that online registration starts.', | |
28 | MODIFY COLUMN `registration_end_date` timestamp NULL DEFAULT NULL COMMENT 'Date and time that online registration ends.'; | |
79b6ac2b CW |
29 | |
30 | {* Ensure CustomGroup.name is unique *} | |
31 | 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; |