-- MySQL Script generated by MySQL Workbench -- 11/15/14 22:24:48 -- 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 -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema test -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema test -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `test` DEFAULT CHARACTER SET utf8 ; USE `test` ; -- ----------------------------------------------------- -- Table `test`.`table2` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `test`.`table1` ( `c` INT NOT NULL, `b` INT NOT NULL, PRIMARY KEY (`b`)) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;