MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();


VERSION()


5.7.39


SELECT
  @@GLOBAL.sql_mode
UNION ALL
SELECT
  @@SESSION.sql_mode;


@@GLOBAL.sql_mode


ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


SET @@SESSION.sql_mode := 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

DROP TABLE IF EXISTS `maintable`;

CREATE TABLE IF NOT EXISTS `maintable` (
 `id_session` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
 `worker` VARCHAR(75),
 `time_start` TIMESTAMP NOT NULL,
 `time_end` TIMESTAMP NOT NULL
);

SHOW CREATE TABLE `maintable`;


Table
Create Table


maintable
CREATE TABLE `maintable` (
  `id_session` int(11) NOT NULL AUTO_INCREMENT,
  `worker` varchar(75) DEFAULT NULL,
  `time_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `time_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_session`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1