title: MySQL error #1067 Invalid default value for 'UpdatedAt'
body: <p>I made restore my MySQL database from backup, but i noticed that encoding characters are set to latin1_swedish_ci, i cant change it to utf8_unicode_ci because i get error as in the header. Any suggestions? output of show create table players; is below and select version(); 8.0.18</p>
  <pre><code>CREATE TABLE `players` (
   `Id` mediumint(9) NOT NULL AUTO_INCREMENT,
   `Login` varchar(50) NOT NULL DEFAULT '',
   `Game` varchar(3) NOT NULL DEFAULT '',
   `NickName` varchar(100) NOT NULL DEFAULT '',
   `Nation` varchar(3) NOT NULL DEFAULT '',
   `UpdatedAt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `Wins` mediumint(9) NOT NULL DEFAULT '0',
   `TimePlayed` int(10) unsigned NOT NULL DEFAULT '0',
   `TeamName` char(60) NOT NULL DEFAULT '',
   PRIMARY KEY (`Id`),
   UNIQUE KEY `Login` (`Login`),
   KEY `Game` (`Game`),
   KEY `Nation` (`Nation`),
   KEY `Wins` (`Wins`),
   KEY `UpdatedAt` (`UpdatedAt`)
  ) ENGINE=MyISAM AUTO_INCREMENT=1014 DEFAULT CHARSET=latin1
  </code></pre>