53T31ii5

1-- MySQL Script generated by MySQL Workbench
2-- 12/12/16 10:41:19
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema testdb
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `testdb` ;
14
15-- -----------------------------------------------------
16-- Schema testdb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `testdb` DEFAULT CHARACTER SET utf8 ;
19USE `testdb` ;
20
21-- -----------------------------------------------------
22-- Table `testdb`.`table1`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `testdb`.`table1` ;
25
26CREATE TABLE IF NOT EXISTS `testdb`.`table1` (
27  `idtable1` INT NOT NULL,
28  `table1col` VARCHAR(45) NULL,
29  `table1col1` VARCHAR(45) NULL,
30  PRIMARY KEY (`idtable1`))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `testdb`.`table2`
36-- -----------------------------------------------------
37DROP TABLE IF EXISTS `testdb`.`table2` ;
38
39CREATE TABLE IF NOT EXISTS `testdb`.`table2` (
40  `idtable2` INT NOT NULL,
41  `table2col` VARCHAR(45) NULL,
42  `table2col1` VARCHAR(45) NULL,
43  `table2col2` VARCHAR(45) NULL,
44  PRIMARY KEY (`idtable2`))
45ENGINE = InnoDB;
46
47
48SET SQL_MODE=@OLD_SQL_MODE;
49SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
50SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;