Instead of default of 0, use NOW() for UPDATE_TIME
MariaDB/MySQL running in strict mode doesn't allow a 0 date as a default
value for a TIMESTAMP column.  Also, there is no longer the restriction
that only one TIMESTAMP column on a table can default to NOW().
@@ -28,8 +28,7 @@ CREATE TABLE WORKFLOW
GRAPH LONGTEXT,
IMAGE BLOB,
CREATION_TIME timestamp DEFAULT NOW(),
- UPDATE_TIME TIMESTAMP DEFAULT '0000-00-00 00:00:00',
--- UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
+ UPDATE_TIME TIMESTAMP DEFAULT NOW() ON UPDATE NOW(),
PRIMARY KEY (TEMPLATE_ID)
);
