DROP DATABASE IF EXISTS `Test`;
CREATE DATABASE IF NOT EXISTS `Test`;

USE `Test`;

CREATE TABLE `TestTable1` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(10) NOT NULL,
  `description` varchar(50) NOT NULL,
  `ts_created` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `ts_updated` timestamp(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `TestTable2` (
  `id` int(10) unsigned NOT NULL,
  `ts_created` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `ts_updated` timestamp(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;