CREATE TABLE cars
(
    car_id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
    make VARCHAR(20) NOT NULL,
    model VARCHAR(30) NOT NULL,
    years INTEGER NOT NULL,
    motor VARCHAR(40) NOT NULL
) ENGINE=InnoDB;

CREATE TABLE owners
(
    owner_id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(28) NOT NULL,
    lname VARCHAR(30) NOT NULL
) ENGINE=InnoDB;

CREATE TABLE carbook
(
    id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
    car_id INTEGER NOT NULL,
    owner_id INTEGER NOT NULL,
    type VARCHAR(20) NOT NULL,

    FOREIGN KEY(car_id)
    REFERENCES cars(car_id)
    ON DELETE RESTRICT,

    FOREIGN KEY(owner_id)
    REFERENCES owners(owner_id)
    ON DELETE RESTRICT
) ENGINE=InnoDB;