· 5 years ago · Mar 04, 2020, 12:26 AM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Mar 2 20:42:02 2020
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13-- -----------------------------------------------------
14-- Schema Schema
15-- -----------------------------------------------------
16
17-- -----------------------------------------------------
18-- Schema Schema
19-- -----------------------------------------------------
20CREATE SCHEMA IF NOT EXISTS `Schema` DEFAULT CHARACTER SET latin1 ;
21USE `Schema` ;
22
23-- -----------------------------------------------------
24-- Table `Schema`.`customer`
25-- -----------------------------------------------------
26DROP TABLE IF EXISTS `Schema`.`customer` ;
27
28CREATE TABLE IF NOT EXISTS `Schema`.`customer` (
29 `CustomerID` INT(11) NOT NULL AUTO_INCREMENT,
30 `CustomerFirst` VARCHAR(45) NOT NULL,
31 `CustomerLast` VARCHAR(45) NOT NULL,
32 PRIMARY KEY (`CustomerID`),
33 UNIQUE INDEX `CustomerID_UNIQUE` (`CustomerID` ASC) VISIBLE)
34ENGINE = InnoDB
35DEFAULT CHARACTER SET = latin1;
36
37
38-- -----------------------------------------------------
39-- Table `Schema`.`order`
40-- -----------------------------------------------------
41DROP TABLE IF EXISTS `Schema`.`order` ;
42
43CREATE TABLE IF NOT EXISTS `Schema`.`order` (
44 `OrderID` INT(11) NOT NULL,
45 `CustomerID` INT(11) NOT NULL,
46 `Price` FLOAT NOT NULL,
47 `OrderAddress` VARCHAR(45) NOT NULL,
48 `OrderCity` VARCHAR(45) NOT NULL,
49 `OrderState` VARCHAR(45) NOT NULL,
50 `OrderZip` INT(5) NOT NULL,
51 PRIMARY KEY (`OrderID`),
52 INDEX `CustomerID_idx` (`CustomerID` ASC) VISIBLE,
53 CONSTRAINT `CustomerID`
54 FOREIGN KEY (`CustomerID`)
55 REFERENCES `Schema`.`customer` (`CustomerID`)
56 ON DELETE NO ACTION
57 ON UPDATE NO ACTION)
58ENGINE = InnoDB
59DEFAULT CHARACTER SET = latin1;
60
61
62-- -----------------------------------------------------
63-- Table `Schema`.`product`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `Schema`.`product` ;
66
67CREATE TABLE IF NOT EXISTS `Schema`.`product` (
68 `ProductID` INT(11) NOT NULL,
69 `ProductName` VARCHAR(85) NOT NULL,
70 `Cost` FLOAT NULL,
71 `productcol` VARCHAR(45) NULL,
72 PRIMARY KEY (`ProductID`))
73ENGINE = InnoDB
74DEFAULT CHARACTER SET = latin1;
75
76
77-- -----------------------------------------------------
78-- Table `Schema`.`orderproduct`
79-- -----------------------------------------------------
80DROP TABLE IF EXISTS `Schema`.`orderproduct` ;
81
82CREATE TABLE IF NOT EXISTS `Schema`.`orderproduct` (
83 `OrderID` INT(11) NOT NULL,
84 `ProductID` INT(11) NOT NULL,
85 `Quantity` INT(10) NOT NULL,
86 PRIMARY KEY (`OrderID`, `ProductID`),
87 INDEX `ProductID_idx` (`ProductID` ASC) VISIBLE,
88 CONSTRAINT `OrderID`
89 FOREIGN KEY (`OrderID`)
90 REFERENCES `Schema`.`order` (`OrderID`),
91 CONSTRAINT `ProductID`
92 FOREIGN KEY (`ProductID`)
93 REFERENCES `Schema`.`product` (`ProductID`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION)
96ENGINE = InnoDB
97DEFAULT CHARACTER SET = latin1;
98
99
100SET SQL_MODE=@OLD_SQL_MODE;
101SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
102SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;