When I publish my database schema to server by command “Database/Forward engineering” in MySQL Workbench I have a error
ERROR: Error 1067: Invalid default value for 'updated'
“updated” is Timestamp column and there is solution how you can fix this problem.
- Open MySQL Workbench
- Open Preferences “Edit / Preferences”
- Go to “Modeling / MySQL”
- Sets “SQL_MODE to be used in generated scripts:” to “STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
- OK button
You can do “Database/Forward engineering” again, problem with timestamo should be fixed.