MySQL_Basic_intro_11

CREATE TABLE directors(
	id INT(11) UNSIGNED PRIMARY KEY UNIQUE NOT NULL AUTO_INCREMENT,
    director_name VARCHAR(30) NOT NULL,
    notes TEXT
);

CREATE TABLE genres(
	id INT(11) UNSIGNED PRIMARY KEY UNIQUE NOT NULL AUTO_INCREMENT,
    genre_name VARCHAR(30) NOT NULL,
    notes TEXT
);

CREATE TABLE categories(
	id INT(11) UNSIGNED PRIMARY KEY UNIQUE NOT NULL AUTO_INCREMENT,
    category_name VARCHAR(30) NOT NULL,
    notes TEXT
);

CREATE TABLE movies(
	id INT(11) UNSIGNED PRIMARY KEY UNIQUE NOT NULL AUTO_INCREMENT,
    title VARCHAR(30) NOT NULL,
    director_id INT(11) NOT NULL,
    copyright_year YEAR NOT NULL,
    length INT(11) NOT NULL,
    genre_id INT(11) NOT NULL,
    category_id INT(11) NOT NULL,
    rating DOUBLE DEFAULT 0,
    notes TEXT
);

INSERT INTO directors
		(id, director_name, notes)
VALUES
		(1, 'asdaagag', 'fdfgdgd'),
		(2, 'dsad', 'fdfgdgd'),
		(3, 'ghsfg', 'fdfgdgd'),
		(4, 'dfgjsj', 'fdfgdgd'),
		(5, 'sdaaga', 'fdfgdgd');

INSERT INTO movies
		(id, title, director_id, copyright_year, length, genre_id, category_id)
VALUES
		(1, 'fgdgfd', 2, '2018', 100, 1, 2),
		(2, 'dsfgdgdad', 2, '2018', 100, 1, 2),
		(3, 'ghshghffg', 2, '2018', 100, 1, 2),
		(4, 'jhjhjhjhjh', 2, '2018', 100, 1, 2),
		(5, 'sdaakhkjkjkjga', 2, '2018', 100, 1, 2);

INSERT INTO categories
		(id, category_name)
VALUES
		(1, 'dsfsg'),
		(2, 'sdagfag'),
		(3, 'sadassadgf'),
		(4, 'sdasdadadasda'),
		(5, 'xccbbnf');

INSERT INTO genres
		(id, genre_name)
VALUES
		(1, 'dsfsdadassg'),
		(2, 'sdagsdadsadsfag'),
		(3, 'sadazzssadgf'),
		(4, 'sdasdzzadadasda'),
		(5, 'xccbzzbnf');