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'; CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ; SHOW WARNINGS; USE `mydb`; -- ----------------------------------------------------- -- Table `mydb`.`foo` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`foo` ( `foo_GN` INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (`foo_GN`) ) ENGINE = InnoDB; SHOW WARNINGS; -- ----------------------------------------------------- -- Table `mydb`.`bar` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`bar` ( `bar_GN` INT NOT NULL AUTO_INCREMENT , PRIMARY KEY (`bar_GN`) ) ENGINE = InnoDB; SHOW WARNINGS; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;