aecFv7Xz

1-- MySQL Script generated by MySQL Workbench
2-- Wed Nov 15 18:39:15 2017
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema airplanesystem
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema airplanesystem
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `airplanesystem` DEFAULT CHARACTER SET utf8 ;
18USE `airplanesystem` ;
19
20-- -----------------------------------------------------
21-- Table `airplanesystem`.`flightData`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `airplanesystem`.`flightData` (
24  `flightID` INT NOT NULL AUTO_INCREMENT,
25  `flightDestinationFrom` VARCHAR(250) NOT NULL,
26  `flightDestinationTo` VARCHAR(250) NOT NULL,
27  `flightDeparture` DATE NOT NULL,
28  `flightArrival` DATE NOT NULL,
29  `flightCompany` VARCHAR(250) NOT NULL,
30  PRIMARY KEY (`flightID`))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `airplanesystem`.`passengerData`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `airplanesystem`.`passengerData` (
38  `passengerID` INT NOT NULL AUTO_INCREMENT,
39  `passengerName` VARCHAR(45) NOT NULL,
40  `passengerSurename` VARCHAR(45) NOT NULL,
41  `passengerSeat` INT NOT NULL,
42  `passengerAge` INT NOT NULL,
43  `passengerFlightDestinationFrom` VARCHAR(45) NOT NULL,
44  `passengerFlightDestinationTo` VARCHAR(45) NOT NULL,
45  `passengerFlightDeparture` VARCHAR(45) NOT NULL,
46  `passengerFlightArrival` VARCHAR(45) NOT NULL,
47  `passengerFlightCompany` VARCHAR(45) NOT NULL,
48  `passengerDatacol` VARCHAR(45) NOT NULL,
49  PRIMARY KEY (`passengerID`))
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `airplanesystem`.`airplaneData`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `airplanesystem`.`airplaneData` (
57  `airplaneID` INT NOT NULL AUTO_INCREMENT,
58  `airplaneName` VARCHAR(45) NOT NULL,
59  `airplaneSpace` VARCHAR(45) NOT NULL,
60  PRIMARY KEY (`airplaneID`))
61ENGINE = InnoDB;
62
63
64SET SQL_MODE=@OLD_SQL_MODE;
65SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
66SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;