mysql script with warnings and errors

[ngong]

I created a mysql database, granted all priviledges to a user, started mysql -u user -p, than 'use ea1' and 'source EASchema_1220_MySQL.sql'
The consol output is here: https://paste.debian.net/1103544/. It shows lots of warnings and some errors - which look severe.
"dpkg -l | grep mysql" shows https://paste.debian.net/1103545/ on an Ubuntu server.

As this is my first trial with mysql database, I would like to know whether this is acceptable or not.
Do you know whether it will lead to problems when transferring an eapx based model into the mysql db?
If transfer wents ok, may these errors lead to failures later on?

[Eve]

I'm not a db expert, but from what I can see a handful of tables failed to create because MySQL didn't like the default date for some fields. But you certainly wouldn't be able to use that database for EA.

From what I can see at https://dev.mysql.com/doc/refman/5.7/en/datetime.html you might have NO_ZERO_DATE SQL mode disabled.

I'd expect there may be other places in EA that rely on that being enabled so it would be safer to change that setting than search and replace '0000-00-00 00:00:00' to CURRENT_TIMESTAMP or '1000-01-01 00:00:00'.