Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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 mydb
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
- USE `mydb` ;
- -- -----------------------------------------------------
- -- Table `mydb`.`item_list`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`item_list` (
- `iditem_list` INT NOT NULL AUTO_INCREMENT,
- `item_name` VARCHAR(45) NULL,
- `quantity` INT NULL,
- PRIMARY KEY (`iditem_list`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`car`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`car` (
- `idcar` INT NOT NULL AUTO_INCREMENT COMMENT ' ',
- `car_name` VARCHAR(45) NULL,
- PRIMARY KEY (`idcar`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `mydb`.`car_item`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `mydb`.`car_item` (
- `id_car_item` INT NOT NULL AUTO_INCREMENT,
- `car_idcar` INT NOT NULL,
- `item_list_iditem_list` INT NOT NULL,
- INDEX `fk_car_has_item_list_item_list1_idx` (`item_list_iditem_list` ASC),
- INDEX `fk_car_has_item_list_car1_idx` (`car_idcar` ASC),
- PRIMARY KEY (`id_car_item`),
- UNIQUE INDEX `car_idcar_UNIQUE` (`car_idcar` ASC),
- UNIQUE INDEX `item_list_iditem_list_UNIQUE` (`item_list_iditem_list` ASC),
- CONSTRAINT `fk_car_has_item_list_car1`
- FOREIGN KEY (`car_idcar`)
- REFERENCES `mydb`.`car` (`idcar`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION,
- CONSTRAINT `fk_car_has_item_list_item_list1`
- FOREIGN KEY (`item_list_iditem_list`)
- REFERENCES `mydb`.`item_list` (`iditem_list`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB;
- SET SQL_MODE=@OLD_SQL_MODE;
- SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
- SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement