1.0.2 1.0.3 postfix fix not work

[ccr1969]

1.0.2 1.0.3 postfix fix not work

Code:

USE `sentora_postfix`;

CREATE TABLE IF NOT EXISTS `vacation` (
 `email` varchar(255) NOT NULL,
 `subject` varchar(255) CHARACTER SET utf8 NOT NULL,
 `body` text CHARACTER SET utf8 NOT NULL,
 `cache` text NOT NULL,
 `domain` varchar(255) NOT NULL,
 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 `active` tinyint(1) NOT NULL DEFAULT '1',
 PRIMARY KEY (`email`),
 KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation/ autoresponder';

CREATE TABLE IF NOT EXISTS `vacation_notification` (
 `on_vacation` varchar(255) CHARACTER SET utf8 NOT NULL,
 `notified` varchar(255) CHARACTER SET utf8 NOT NULL,
 `notified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`on_vacation`,`notified`),
 CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix - Virtual Vacation Notifications LOG';

/* Update Sentora Version */
USE `sentora_core`;

/* Update the sentora database version number */
UPDATE `x_settings` SET `so_value_tx` = '1.0.3' WHERE `so_name_vc` = 'dbversion';

sql error return
for vacation table

Code:

# 1067 - Invalid default value for 'created'

for vacation_notification table

Code:

# 1215 - Cannot add foreign key constraint

mysql server version 5.7.34

would someone have a solution because without it is postfix table does not work

try change this
/etc/mysql/my.cnf

#set

the complete "forgiving" mode
sql-mode = ""
# alternatively you can set sql mode to the following
#sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"

restart mysql