CU81fpKv

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema orderdb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema orderdb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `orderdb` DEFAULT CHARACTER SET latin1 ;
18USE `orderdb` ;
19
20-- -----------------------------------------------------
21-- Table `orderdb`.`order`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `orderdb`.`order` (
24  `orderID` INT(11) NOT NULL AUTO_INCREMENT,
25  `tableNumber` INT(11) NOT NULL,
26  `orderName` VARCHAR(45) NOT NULL,
27  PRIMARY KEY (`orderID`))
28ENGINE = InnoDB
29DEFAULT CHARACTER SET = latin1;
30
31
32SET SQL_MODE=@OLD_SQL_MODE;
33SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
34SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;