CREATE TABLE category (
    category_id SERIAL NOT NULL PRIMARY KEY,
    name VARCHAR(25) NOT NULL,
    last_update TIMESTAMP WITH TIME ZONE NOT NULL
);
CREATE TABLE film_category (
    film_id INTEGER NOT NULL REFERENCES film (id),
    category_id INTEGER NOT NULL
        REFERENCES category (category_id),
    last_update TIMESTAMP WITH TIME ZONE NOT NULL,
    PRIMARY KEY (film_id, category_id)
);

CREATE TABLE genre (
    genre_id INTEGER PRIMARY KEY,
    name VARCHAR(25) NOT NULL
);
CREATE TABLE film_genre (
    film_id INTEGER NOT NULL REFERENCES film (id),
    genre_id INTEGER NOT NULL
        REFERENCES genre (genre_id),
    last_update TIMESTAMP WITH TIME ZONE NOT NULL,
    PRIMARY KEY (film_id, genre_id)
);

Change film functional tests to use 'genre' instead of 'category'.
Change film functional tests to use 'genre' instead of 'category'.
