OK - progress using the MySQLWorkbench tool to migrate my old database to the new one. I receive this one error:
ERROR: Error executing 'CREATE TABLE IF NOT EXISTS osticketdb
.ost_email_account
(
id
INT UNSIGNED NOT NULL AUTO_INCREMENT,
name
VARCHAR(128) NOT NULL,
active
TINYINT(1) NOT NULL DEFAULT '1',
protocol
VARCHAR(64) NOT NULL DEFAULT '',
host
VARCHAR(128) NOT NULL DEFAULT '',
port
INT NOT NULL,
username
VARCHAR(128) NULL DEFAULT NULL,
password
VARCHAR(255) NULL DEFAULT NULL,
options
VARCHAR(512) NULL DEFAULT NULL,
errors
INT UNSIGNED NULL DEFAULT NULL,
created
TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
updated
TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP,
lastconnect
TIMESTAMP NULL DEFAULT NULL,
lasterror
TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (id
))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3'
Invalid default value for 'created'.
SQL Error: 1067