CREATE TABLE episodes (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `number` TINYINT UNSIGNED NOT NULL,
    title VARCHAR(100) NOT NULL,
    release_date DATE NOT NULL,
    director VARCHAR(100) NOT NULL,
    trilogy VARCHAR(20) NOT NULL,
    UNIQUE INDEX ix_episodes_1(`number`)
);

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(1, 'The Phantom Menace', '1999-05-19', '<NAME>', 'prequel');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(2, 'Attack of the Clones', '2002-05-16', '<NAME>', 'prequel');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(3, 'Revenge of the Sith', '2005-05-19', '<NAME>', 'prequel');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(4, 'A New Hope', '1977-05-25', '<NAME>', 'original');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(5, 'The Empire Strikes Back', '1980-05-21', '<NAME>', 'original');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(6, 'Return of the Jedi', '1983-05-25', '<NAME>', 'original');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(7, 'The Force Awakens', '2015-12-18', '<NAME>', 'sequel');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(8, 'The Last Jedi', '2017-12-15', '<NAME>', 'sequel');

INSERT INTO episodes(number, title, release_date, director, trilogy)
VALUES(9, 'The Rise of Skywalker', '2019-12-20', '<NAME>', 'sequel');