8muZxSW2

1CREATE TABLE IF NOT EXISTS `directors`(
2    `id` INT AUTO_INCREMENT PRIMARY KEY,
3    `director_name` VARCHAR(50) NOT NULL,
4    `notes` TEXT
5);
6 
7INSERT INTO `directors` (`director_name`)
8    VALUES ('Kiro'),
9        ('Miro'),
10        ('Tosho'),
11        ('Gosho'),
12        ('Ani');
13 
14CREATE TABLE IF NOT EXISTS `genres`(
15    `id` INT AUTO_INCREMENT PRIMARY KEY,
16    `genre_name` VARCHAR(50) NOT NULL,
17    `notes` TEXT
18);
19 
20INSERT INTO `genres` (`genre_name`)
21    VALUES ('KiroG'),
22        ('MiroG'),
23        ('ToshoG'),
24        ('GoshoG'),
25        ('AniG');
26 
27CREATE TABLE IF NOT EXISTS `categories`(
28    `id` INT AUTO_INCREMENT PRIMARY KEY,
29    `category_name` VARCHAR(50) NOT NULL,
30    `notes` TEXT
31);
32 
33INSERT INTO `categories` (`category_name`)
34    VALUES ('KiroC'),
35        ('MiroC'),
36        ('ToshoC'),
37        ('GoshoC'),
38        ('AniC');
39 
40CREATE TABLE IF NOT EXISTS `movies`(
41    `id` INT AUTO_INCREMENT PRIMARY KEY,
42    `title` VARCHAR(50) NOT NULL,
43    `director_id` INT,
44    `copyright_year` YEAR,
45    `length` INT(3),
46    `genre_id` INT,
47    `category_id` INT,
48    `rating` INT,
49    `notes` TEXT
50);  
51   
52INSERT INTO `movies` (`title`)
53    VALUES ('KiroM'),
54        ('MiroM'),
55        ('ToshoM'),
56        ('GoshoM'),
57        ('AniM');