#11
CREATE TABLE `directors` (
    `id` INT PRIMARY KEY AUTO_INCREMENT,
    `director_name` VARCHAR(50) NOT NULL,
    `notes` TEXT(500)
);
CREATE TABLE `genres` (
    `id` INT PRIMARY KEY AUTO_INCREMENT,
    `genre_name` VARCHAR(50) NOT NULL,
    `notes` TEXT(500)
);
CREATE TABLE `categories` (
    `id` INT PRIMARY KEY AUTO_INCREMENT,
    `category_name` VARCHAR(50) NOT NULL,
    `notes` TEXT(500)
);
CREATE TABLE `movies` (
    `id` INT PRIMARY KEY AUTO_INCREMENT,
    `title` CHAR(30) NOT NULL,
    `director_id` INT NOT NULL,
    `copyright_year` YEAR NOT NULL,
    `length` INT NOT NULL,
    `genre_id` INT NOT NULL,
    `category_id` INT NOT NULL,
    `rating` INT NOT NULL,
    `notes` TEXT(500)
);

INSERT INTO `directors` (`id`, `director_name`,`notes`) VALUES
(1, 'hui1','hahaha'),
(2, 'hui2','hahaha'),
(3, 'hui3','hahaha'),
(4, 'hui4','hahaha'),
(5, 'hui5','hahaha');
INSERT INTO `genres` (`id`, `genre_name`,`notes`) VALUES
(1, 'drama1','hahaha'),
(2, 'drama2','hahaha'),
(3, 'drama3','hahaha'),
(4, 'drama4','hahaha'),
(5, 'drama5','hahaha');
INSERT INTO `categories` (`id`, `category_name`,`notes`) VALUES
(1, 'porn1','hahaha'),
(2, 'porn2','hahaha'),
(3, 'porn3','hahaha'),
(4, 'porn4','hahaha'),
(5, 'porn5','hahaha');

INSERT INTO `movies` (`id`, `title`, `director_id`, `copyright_year`, `length`, `genre_id`, `category_id`, `rating`, `notes`) VALUES
(1, 'guz1',5,'1990',120,1,1,5,'hahaha'),
(2, 'guz2',4,'1990',120,2,2,4,'hahaha'),
(3, 'guz3',3,'1990',120,3,3,3,'hahaha'),
(4, 'guz4',2,'1990',120,4,4,2,'hahaha'),
(5, 'guz5',1,'1990',120,5,5,1,'hahaha');