TYPO3 calendarize 4.x auf 6.x Update

Folgende SQL Befehle müssen durchgeführt werden, falls sich die Spalten start_date und end_date im INT-Format befinden. Die neue calendarize Version arbeiten mit DATE.

ALTER TABLE `tx_calendarize_domain_model_configuration` ADD `start_date2` DATE DEFAULT NULL AFTER `start_date`;
UPDATE `tx_calendarize_domain_model_configuration` SET start_date2 = FROM_UNIXTIME(start_date);
ALTER TABLE `tx_calendarize_domain_model_configuration` DROP `start_date`;
ALTER TABLE `tx_calendarize_domain_model_configuration` CHANGE `start_date2` `start_date` DATE DEFAULT NULL;

ALTER TABLE `tx_calendarize_domain_model_configuration` ADD `end_date2` DATE DEFAULT NULL AFTER `end_date`;
UPDATE `tx_calendarize_domain_model_configuration` SET end_date2 = FROM_UNIXTIME(end_date);
ALTER TABLE `tx_calendarize_domain_model_configuration` DROP `end_date`;
ALTER TABLE `tx_calendarize_domain_model_configuration` CHANGE `end_date2` `end_date` DATE DEFAULT NULL;

UPDATE `tx_calendarize_domain_model_configuration` SET `groups` = '' WHERE `tx_calendarize_domain_model_configuration`.`groups` IS NULL;


ALTER TABLE `tx_calendarize_domain_model_index` ADD `start_date2` DATE DEFAULT NULL AFTER `start_date`;
UPDATE `tx_calendarize_domain_model_index` SET start_date2 = FROM_UNIXTIME(start_date);
ALTER TABLE `tx_calendarize_domain_model_index` DROP `start_date`;
ALTER TABLE `tx_calendarize_domain_model_index` CHANGE `start_date2` `start_date` DATE DEFAULT NULL;

ALTER TABLE `tx_calendarize_domain_model_index` ADD `end_date2` DATE DEFAULT NULL AFTER `end_date`;
UPDATE `tx_calendarize_domain_model_index` SET end_date2 = FROM_UNIXTIME(end_date);
ALTER TABLE `tx_calendarize_domain_model_index` DROP `end_date`;
ALTER TABLE `tx_calendarize_domain_model_index` CHANGE `end_date2` `end_date` DATE DEFAULT NULL;

UPDATE `tx_calendarize_domain_model_configuration` SET `end_date` = NULL WHERE `tx_calendarize_domain_model_configuration`.`end_date` = '1970-01-01';