-- MySQL Script generated by MySQL Workbench -- 03/31/15 02:35:38 -- Model: New Model Version: 1.0 -- MySQL Workbench Forward Engineering 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'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- DROP SCHEMA IF EXISTS `mydb` ; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; USE `mydb` ; -- ----------------------------------------------------- -- Table `mydb`.`table1` -- ----------------------------------------------------- DROP TABLE IF EXISTS `mydb`.`table1` ; CREATE TABLE IF NOT EXISTS `mydb`.`table1` ( `idtable1` INT NOT NULL, `table1col` VARCHAR(45) NULL, PRIMARY KEY (`idtable1`), UNIQUE INDEX `table1col_UNIQUE` (`table1col` ASC) COMMENT /* comment truncated */ /*Lorem Ipsum is simply dummy text of the printing and typesetting industry.*/) ENGINE = InnoDB COMMENT = 'Lorem Ipsum is simply dummy text of the printing and typeset' /* comment truncated */ /*ting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.*/; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;