createdb fails with: ERROR 1067 (42000) at line 31: Invalid default value for 'dtime'

[4001982248998]

Reason: it apparently is not allowed to specify a “null time” like 0000-00-00 00:00:00 anymore. Better use 1970-01-01 00:00:01

--- etc/createdb        2018-01-19 10:57:14.300834370 +0100
+++ /usr/local/rtg2/etc/createdb        2018-01-19 12:30:15.710919040 +0100
@@ -23,11 +23,8 @@

 # Create the necessary SQL in two /tmp files
 cat <<EOT >/tmp/mysql.sql
-INSERT INTO user (Host, User, Password) VALUES ('$HOST','$USER',PASSWORD("$RTGPASS"));
-INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
-Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv)
-VALUES ('$HOST','$DATABASE','$USER','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
-FLUSH PRIVILEGES;
+CREATE USER '$USER'@'localhost' IDENTIFIED BY '$RTGPASS';
+GRANT ALL PRIVILEGES ON rtg.* TO '$USER'@'localhost';
 EOT

 cat <<EOT >/tmp/rtg.sql
@@ -63,7 +60,7 @@

 CREATE TABLE ifInOctets (
   id int(11) unsigned NOT NULL default '0',
-  dtime datetime NOT NULL default '0000-00-00 00:00:00',
+  dtime datetime NOT NULL default '1970-01-01 00:00:01',
   counter bigint(20) unsigned NOT NULL default '0',
   rate DOUBLE unsigned NOT NULL,
   KEY ifInOctets_idx (dtime)
@@ -75,7 +72,7 @@

 CREATE TABLE ifOutOctets (
   id int(11) unsigned NOT NULL default '0',
-  dtime datetime NOT NULL default '0000-00-00 00:00:00',
+  dtime datetime NOT NULL default '1970-01-01 00:00:01',
   counter bigint(20) unsigned NOT NULL default '0',
   rate DOUBLE unsigned NOT NULL,
   KEY ifOutOctets_idx (dtime)
@@ -87,7 +84,7 @@

 CREATE TABLE ifInUcastPkts (
   id int(11) unsigned NOT NULL default '0',
-  dtime datetime NOT NULL default '0000-00-00 00:00:00',
+  dtime datetime NOT NULL default '1970-01-01 00:00:01',
   counter bigint(20) unsigned NOT NULL default '0',
   rate DOUBLE unsigned NOT NULL,
   KEY ifInUcastPkts_idx (dtime)
@@ -99,7 +96,7 @@

 CREATE TABLE ifOutUcastPkts (
   id int(11) unsigned NOT NULL default '0',
-  dtime datetime NOT NULL default '0000-00-00 00:00:00',
+  dtime datetime NOT NULL default '1970-01-01 00:00:01',
   counter bigint(20) unsigned NOT NULL default '0',
   rate DOUBLE unsigned NOT NULL,
   KEY ifOutUcastPkts_idx (dtime)
@@ -111,7 +108,7 @@

 CREATE TABLE ifInErrors (
   id int(11) unsigned NOT NULL default '0',
-  dtime datetime NOT NULL default '0000-00-00 00:00:00',
+  dtime datetime NOT NULL default '1970-01-01 00:00:01',
   counter bigint(20) unsigned NOT NULL default '0',
   rate DOUBLE unsigned NOT NULL,
   KEY ifInErrors_idx (dtime)