-
-
Notifications
You must be signed in to change notification settings - Fork 3.6k
/
4.0.0-2019-07-27.sql
23 lines (22 loc) · 2.06 KB
/
4.0.0-2019-07-27.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
ALTER TABLE `#__banner_clients` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__categories` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__content` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__extensions` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__fields` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__fields_groups` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__finder_filters` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__menu` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__tags` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__ucm_content` MODIFY COLUMN `core_checked_out_time` DATETIME NULL DEFAULT NULL;
ALTER TABLE `#__user_notes` MODIFY COLUMN `checked_out_time` DATETIME NULL DEFAULT NULL;
UPDATE `#__banner_clients` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__categories` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__content` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__extensions` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__fields` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__fields_groups` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__finder_filters` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__menu` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__tags` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__ucm_content` SET `core_checked_out_time` = NULL WHERE `core_checked_out_time` = '0000-00-00 00:00:00';
UPDATE `#__user_notes` SET `checked_out_time` = NULL WHERE `checked_out_time` = '0000-00-00 00:00:00';