# Database scripts

CREATE TABLE customer (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50)
);

INSERT INTO customer (first_name, last_name) VALUES
('Elsa', 'Andersson'),
('Liam', 'Johansson'),
('Alice', 'Lindgren'),
('Oscar', 'Svensson'),
('Maja', 'Gustafsson');

CREATE TABLE employee (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name INT NULL,
    age  INT NULL
);

CREATE TABLE flight (
  id INT AUTO_INCREMENT PRIMARY KEY,
  flight_no VARCHAR(255) NOT NULL UNIQUE
);

CREATE TABLE seat (
  id INT AUTO_INCREMENT PRIMARY KEY,
  flight_id INT,
  seat_no VARCHAR(255) NOT NULL,
  CONSTRAINT fk_seat_flight_id
  FOREIGN KEY (flight_id) REFERENCES flight(id)
  ON DELETE CASCADE
);