BVubnPWe

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='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15-- -----------------------------------------------------
16-- Schema flyplass
17-- -----------------------------------------------------
18
19-- -----------------------------------------------------
20-- Schema flyplass
21-- -----------------------------------------------------
22CREATE SCHEMA IF NOT EXISTS `flyplass` DEFAULT CHARACTER SET utf8 ;
23USE `mydb` ;
24
25-- -----------------------------------------------------
26-- Table `mydb`.`Flyplass`
27-- -----------------------------------------------------
28CREATE TABLE IF NOT EXISTS `mydb`.`Flyplass` (
29  `FPKode` INT NOT NULL,
30  `Fnavn` VARCHAR(45) NULL,
31  `Tlf` VARCHAR(45) NULL,
32  PRIMARY KEY (`FPKode`))
33ENGINE = InnoDB;
34
35
36-- -----------------------------------------------------
37-- Table `mydb`.`Rullebane`
38-- -----------------------------------------------------
39CREATE TABLE IF NOT EXISTS `mydb`.`Rullebane` (
40  `RKode` INT NOT NULL,
41  `Pos` VARCHAR(45) NULL,
42  `Lengde` VARCHAR(45) NULL,
43  `Flyplass_FPKode` INT NOT NULL,
44  PRIMARY KEY (`RKode`),
45  INDEX `fk_Rullebane_Flyplass1_idx` (`Flyplass_FPKode` ASC),
46  CONSTRAINT `fk_Rullebane_Flyplass1`
47    FOREIGN KEY (`Flyplass_FPKode`)
48    REFERENCES `mydb`.`Flyplass` (`FPKode`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION)
51ENGINE = InnoDB;
52
53
54-- -----------------------------------------------------
55-- Table `mydb`.`Fly`
56-- -----------------------------------------------------
57CREATE TABLE IF NOT EXISTS `mydb`.`Fly` (
58  `FKode` INT NOT NULL,
59  `FSelskap` VARCHAR(45) NULL,
60  `Pplass` VARCHAR(45) NULL,
61  PRIMARY KEY (`FKode`))
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `mydb`.`Tid`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `mydb`.`Tid` (
69  `tid` VARCHAR(50) NOT NULL,
70  PRIMARY KEY (`tid`))
71ENGINE = InnoDB;
72
73
74-- -----------------------------------------------------
75-- Table `mydb`.`Reise`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `mydb`.`Reise` (
78  `table1_tid` VARCHAR(50) NOT NULL,
79  `Rullebane_RKode` INT NOT NULL,
80  `Ank_Avr` VARCHAR(45) NULL,
81  `AntPerson` VARCHAR(45) NULL,
82  `Fly_FKode` INT NOT NULL,
83  PRIMARY KEY (`table1_tid`, `Rullebane_RKode`),
84  INDEX `fk_table1_has_Rullebane_Rullebane1_idx` (`Rullebane_RKode` ASC),
85  INDEX `fk_table1_has_Rullebane_table11_idx` (`table1_tid` ASC),
86  INDEX `fk_Reise1_Fly1_idx` (`Fly_FKode` ASC),
87  CONSTRAINT `fk_table1_has_Rullebane_table11`
88    FOREIGN KEY (`table1_tid`)
89    REFERENCES `mydb`.`Tid` (`tid`)
90    ON DELETE NO ACTION
91    ON UPDATE NO ACTION,
92  CONSTRAINT `fk_table1_has_Rullebane_Rullebane1`
93    FOREIGN KEY (`Rullebane_RKode`)
94    REFERENCES `mydb`.`Rullebane` (`RKode`)
95    ON DELETE NO ACTION
96    ON UPDATE NO ACTION,
97  CONSTRAINT `fk_Reise1_Fly1`
98    FOREIGN KEY (`Fly_FKode`)
99    REFERENCES `mydb`.`Fly` (`FKode`)
100    ON DELETE NO ACTION
101    ON UPDATE NO ACTION)
102ENGINE = InnoDB;
103
104USE `flyplass` ;
105
106-- -----------------------------------------------------
107-- Table `flyplass`.`flyplass`
108-- -----------------------------------------------------
109CREATE TABLE IF NOT EXISTS `flyplass`.`flyplass` (
110  `FPkode` INT(11) NOT NULL,
111  `Fnavn` VARCHAR(50) NULL DEFAULT NULL,
112  `TLF` VARCHAR(50) NULL DEFAULT NULL,
113  PRIMARY KEY (`FPkode`))
114ENGINE = InnoDB
115DEFAULT CHARACTER SET = utf8;
116
117
118-- -----------------------------------------------------
119-- Table `flyplass`.`rullebane`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `flyplass`.`rullebane` (
122  `Lengde` INT(11) NULL DEFAULT NULL,
123  `Pos` VARCHAR(50) NULL DEFAULT NULL,
124  `FPkode` INT(11) NULL DEFAULT NULL,
125  `Rkode` INT(11) NOT NULL,
126  PRIMARY KEY (`Rkode`),
127  INDEX `FPkode` (`FPkode` ASC),
128  CONSTRAINT `rullebane_ibfk_1`
129    FOREIGN KEY (`FPkode`)
130    REFERENCES `flyplass`.`flyplass` (`FPkode`))
131ENGINE = InnoDB
132DEFAULT CHARACTER SET = utf8;
133
134
135SET SQL_MODE=@OLD_SQL_MODE;
136SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
137SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;