-- Add migration script here

CREATE TABLE IF NOT EXISTS public.movies
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY,
    title text NOT NULL,
    overview text NOT NULL,
    poster_path text NOT NULL,
    backdrop_path text,
    release_date date NOT NULL,
    tmdb_id integer NOT NULL,
    created_at timestamp without time zone NOT NULL DEFAULT now(),
    updated_at timestamp without time zone NOT NULL DEFAULT now(),
    PRIMARY KEY (id)
);