S9MXrNU2

1-- MySQL Workbench Forward Engineering
2-- MySQL Workbench Forward Engineering
3
4SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
6SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
7
8-- -----------------------------------------------------
9-- Schema mydb
10-- -----------------------------------------------------
11
12-- -----------------------------------------------------
13-- Schema mydb
14-- -----------------------------------------------------
15DROP SCHEMA IF EXISTS `mydb`;
16CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
17USE `mydb` ;
18
19-- -----------------------------------------------------
20-- Table `mydb`.`AirPorts`
21-- -----------------------------------------------------
22CREATE TABLE IF NOT EXISTS `mydb`.`AirPorts` (
23  `FPKode` VARCHAR(45) NOT NULL,
24  `FPNavn` VARCHAR(45) NULL,
25  `FPtlf` VARCHAR(45) NULL,
26  PRIMARY KEY (`FPKode`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Runways`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Runways` (
34  `RKode` INT NOT NULL,
35  `RPos` VARCHAR(45) NULL,
36  `RLengde` VARCHAR(45) NULL,
37  `AirPorts_FPKode` VARCHAR(45) NOT NULL,
38  PRIMARY KEY (`RKode`),
39  INDEX `fk_Runways_AirPorts_idx` (`AirPorts_FPKode` ASC),
40  CONSTRAINT `fk_Runways_AirPorts`
41    FOREIGN KEY (`AirPorts_FPKode`)
42    REFERENCES `mydb`.`AirPorts` (`FPKode`)
43    ON DELETE NO ACTION
44    ON UPDATE NO ACTION)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`Airplanes`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`Airplanes` (
52  `FKode` INT NOT NULL,
53  `FSelskap` VARCHAR(45) NULL,
54  `MaxPass` VARCHAR(45) NULL,
55  PRIMARY KEY (`FKode`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `mydb`.`ArivalsDeparture`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `mydb`.`ArrivalsDeparture` (
63  `Runways_RKode` INT NOT NULL,
64  `Airplanes_FKode` INT NOT NULL,
65  `AntPass` VARCHAR(45) NULL,
66  `FReise` VARCHAR(45) NULL,
67  `dato` DATE NOT NULL,
68  `tid` TIME NOT NULL,
69  INDEX `fk_Arivals Departure_Runways1_idx` (`Runways_RKode` ASC),
70  INDEX `fk_Arivals Departure_Airplanes1_idx` (`Airplanes_FKode` ASC),
71  PRIMARY KEY (`Airplanes_FKode`, `Runways_RKode`, `dato`, `tid`),
72  CONSTRAINT `fk_Arivals Departure_Runways1`
73    FOREIGN KEY (`Runways_RKode`)
74    REFERENCES `mydb`.`Runways` (`RKode`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION,
77  CONSTRAINT `fk_Arivals Departure_Airplanes1`
78    FOREIGN KEY (`Airplanes_FKode`)
79    REFERENCES `mydb`.`Airplanes` (`FKode`)
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION)
82ENGINE = InnoDB;
83
84
85SET SQL_MODE=@OLD_SQL_MODE;
86SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
87SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;