tqnAgU89

1-- MySQL Workbench Forward Engineering
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @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';
5
6-- -----------------------------------------------------
7-- Schema passenger
8-- -----------------------------------------------------
9CREATE SCHEMA IF NOT EXISTS `MySQL` ;
10USE `MySQL` ;
11
12
13-- -----------------------------------------------------
14-- Table `passenger`.`Address`  
15-- -----------------------------------------------------
16CREATE TABLE IF NOT EXISTS `MySQL`.`Address` (
17  `id` INT AUTO_INCREMENT NOT NULL,
18  `street_name` VARCHAR(120) NOT NULL,
19  `house_number` VARCHAR(45) NOT NULL,
20  `city` VARCHAR(100) NOT NULL,
21  PRIMARY KEY (`id`))
22ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table `mydb`.`Passenger`
27-- -----------------------------------------------------
28CREATE TABLE IF NOT EXISTS `MySQL`.`Passenger` (
29  `id` INT AUTO_INCREMENT NOT NULL,
30  `first_name` VARCHAR(255) NOT NULL,
31  `last_name` VARCHAR(255) NOT NULL,
32  `address` INT NOT NULL,
33  PRIMARY KEY (`id`),
34  INDEX `fk_address_idx` (`address` ASC),
35  CONSTRAINT `fk_address`
36    FOREIGN KEY (`address`)
37    REFERENCES `MySQL`.`Address` (`id`)
38    ON DELETE CASCADE
39    ON UPDATE NO ACTION)
40ENGINE = InnoDB;
41-- -----------------------------------------------------
42
43-- 1th Create
44INSERT INTO Address VALUES (NULL, 'Dorpstraat', '203', 'Lunteren');
45SELECT @last := LAST_INSERT_id();
46INSERT INTO Passenger VALUES (NULL, 'Batuhan', 'Maes', @last);
47-- -----------------------------------------------------
48
49-- 2th Create
50INSERT INTO Address VALUES (NULL, 'Provinciale weg', '37', 'Hoorn');
51SELECT @last := LAST_INSERT_id();
52INSERT INTO Passenger VALUES (NULL, 'Arthur', 'Schmidt', @last);
53-- -----------------------------------------------------
54
55-- 3th Create
56INSERT INTO Address VALUES (NULL, 'Commandeurstraat', '23C', 'Nes');
57SELECT @last := LAST_INSERT_id();
58INSERT INTO Passenger VALUES (NULL, 'Vik', 'Yilmaz', @last);
59-- -----------------------------------------------------
60
61-- 4th Create
62INSERT INTO Address VALUES (NULL, 'Van Beijerenstraat', '2341', 'Hoorn');
63SELECT @last := LAST_INSERT_id();
64INSERT INTO Passenger VALUES (NULL, 'Carmen', 'Castro', @last);
65-- -----------------------------------------------------
66
67-- 5th Create
68INSERT INTO Address VALUES (NULL, 'Pekmanshiem', '62-352', 'Nes');
69SELECT @last := LAST_INSERT_id();
70INSERT INTO Passenger VALUES (NULL, 'Anna', 'Willems', @last);
71-- -----------------------------------------------------
72
73SET SQL_MODE=@OLD_SQL_MODE;
74SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
75SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;