fBSXN9kC

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
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 szymon
17-- -----------------------------------------------------
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`port`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`port` (
24  `idPortu` INT(11) NOT NULL AUTO_INCREMENT,
25  `Nazwa` VARCHAR(45) NULL DEFAULT NULL,
26  `Miasto` VARCHAR(45) NULL DEFAULT NULL,
27  `Kraj` VARCHAR(45) NULL DEFAULT NULL,
28  PRIMARY KEY (`idPortu`),
29  UNIQUE INDEX `idPortu_UNIQUE` (`idPortu` ASC) VISIBLE)
30ENGINE = InnoDB
31AUTO_INCREMENT = 6
32DEFAULT CHARACTER SET = utf8;
33
34
35-- -----------------------------------------------------
36-- Table `mydb`.`zalogant`
37-- -----------------------------------------------------
38CREATE TABLE IF NOT EXISTS `mydb`.`zalogant` (
39  `IdZaloganta` INT(11) NOT NULL AUTO_INCREMENT,
40  `Imie` VARCHAR(45) NULL DEFAULT NULL,
41  `Nazwisko` VARCHAR(45) NULL DEFAULT NULL,
42  `Zarobki` INT(11) NULL DEFAULT NULL,
43  `DataZatrudnienia` DATE NULL DEFAULT NULL,
44  `Stanowisko` VARCHAR(45) NULL DEFAULT NULL,
45  PRIMARY KEY (`IdZaloganta`),
46  UNIQUE INDEX `IdZaloganta_UNIQUE` (`IdZaloganta` ASC) VISIBLE)
47ENGINE = InnoDB
48AUTO_INCREMENT = 10
49DEFAULT CHARACTER SET = utf8;
50
51
52-- -----------------------------------------------------
53-- Table `mydb`.`statek`
54-- -----------------------------------------------------
55CREATE TABLE IF NOT EXISTS `mydb`.`statek` (
56  `idStatku` INT(11) NOT NULL AUTO_INCREMENT,
57  `Nazwa` VARCHAR(45) NULL DEFAULT NULL,
58  `Bandera` VARCHAR(45) NULL DEFAULT NULL,
59  `IdKapitana` INT(11) NOT NULL,
60  `Å‚adownosc` INT(11) NULL DEFAULT NULL,
61  `DataWodowania` DATE NULL DEFAULT NULL,
62  `Cena` INT(11) NULL DEFAULT NULL,
63  PRIMARY KEY (`idStatku`),
64  UNIQUE INDEX `idStatku_UNIQUE` (`idStatku` ASC) VISIBLE,
65  UNIQUE INDEX `IdKapitana_UNIQUE` (`IdKapitana` ASC) VISIBLE,
66  CONSTRAINT `fk_Statek_Zalogant`
67    FOREIGN KEY (`IdKapitana`)
68    REFERENCES `mydb`.`zalogant` (`IdZaloganta`))
69ENGINE = InnoDB
70AUTO_INCREMENT = 7
71DEFAULT CHARACTER SET = utf8;
72
73
74-- -----------------------------------------------------
75-- Table `mydb`.`rejsy`
76-- -----------------------------------------------------
77CREATE TABLE IF NOT EXISTS `mydb`.`rejsy` (
78  `idPortuStart` INT(11) NULL DEFAULT NULL,
79  `IdPortuKoniec` INT(11) NULL DEFAULT NULL,
80  `IdStatku` INT(11) NULL DEFAULT NULL,
81  `DataWyplyniecia` DATE NULL DEFAULT NULL,
82  `DataDoplyniecia` DATE NULL DEFAULT NULL,
83  `Koszt` INT(11) NULL DEFAULT NULL,
84  INDEX `fk_Rejsy_Port1` (`idPortuStart` ASC) VISIBLE,
85  INDEX `fk_Rejsy_Port2` (`IdPortuKoniec` ASC) VISIBLE,
86  INDEX `fk_Rejsy_Statek1` (`IdStatku` ASC) VISIBLE,
87  CONSTRAINT `fk_Rejsy_Port1`
88    FOREIGN KEY (`idPortuStart`)
89    REFERENCES `mydb`.`port` (`idPortu`),
90  CONSTRAINT `fk_Rejsy_Port2`
91    FOREIGN KEY (`IdPortuKoniec`)
92    REFERENCES `mydb`.`port` (`idPortu`),
93  CONSTRAINT `fk_Rejsy_Statek1`
94    FOREIGN KEY (`IdStatku`)
95    REFERENCES `mydb`.`statek` (`idStatku`))
96ENGINE = InnoDB
97DEFAULT CHARACTER SET = utf8;
98
99
100SET SQL_MODE=@OLD_SQL_MODE;
101SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
102SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;