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
