init.sql

CREATE DATABASE IF NOT EXISTS movieproject;
USE movieproject;

CREATE TABLE IF NOT EXISTS movies (
    id    INT AUTO_INCREMENT PRIMARY KEY,
    Title VARCHAR(255) NOT NULL,
    Genre VARCHAR(100) NOT NULL,
    Year  INT          NOT NULL
);

CREATE TABLE IF NOT EXISTS customers (
    id         INT AUTO_INCREMENT PRIMARY KEY,
    Name       VARCHAR(255) NOT NULL,
    Email      VARCHAR(255) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS bookings (
    id          INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT          NOT NULL,
    movie_id    INT          NOT NULL,
    seat        VARCHAR(10)  NOT NULL,
    price       DECIMAL(8,2) NOT NULL,
    booked_at   TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT fk_customer FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE,
    CONSTRAINT fk_movie    FOREIGN KEY (movie_id)    REFERENCES movies(id)    ON DELETE CASCADE
) ENGINE=InnoDB;