-- MySQL Workbench Synchronization -- Generated: 2017-03-20 20:08 -- Model: New Model -- Version: 1.0 -- Project: Name of the project -- Author: Erwin SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `testdb_bug_2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ; CREATE TABLE IF NOT EXISTS `testdb_bug_2`.`testtable` ( `testtable_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `testtable_text` VARCHAR(46) NOT NULL DEFAULT 'text', `testtable_num` INT(11) NULL DEFAULT NULL, `testtable_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `testtable_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`testtable_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `testdb_bug_2`.`testtable_problem` ( `testtable_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `testtable_text` VARCHAR(45) NOT NULL DEFAULT 'text', `testtable_num` INT(11) NOT NULL DEFAULT 1234567890, `testtable_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `testtable_updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `testtable_virtual` INT(11) GENERATED ALWAYS AS (SUBSTRING(`testtable_num`,6)) VIRTUAL, PRIMARY KEY (`testtable_id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;