DROP DATABASE IF EXISTS `testdb`;
CREATE DATABASE `testdb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;

USE `testdb`;

DROP TABLE IF EXISTS `testTable1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `testTable1` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `column1` timestamp NULL DEFAULT NULL,
  `column2` int(11) GENERATED ALWAYS AS (ifnull(timestampdiff(SECOND,'1970-01-01 00:00:00',`column1`),0)) VIRTUAL,
  `column3` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;