CuSJgmsp

1DROP DATABASE IF EXISTS MovieDatabase;
2
3
4
5CREATE DATABASE MovieDatabase CHARACTER SET = utf8;
6
7USE MovieDatabase;
8
9CREATE TABLE IF NOT EXISTS Actor (
10actorFirstName VARCHAR(200) NOT NULL,
11actorLastName VARCHAR(200) NOT NULL,
12actorBirthYear YEAR NOT NULL,
13actorID VARCHAR(200) NOT NULL
14);
15
16CREATE TABLE IF NOT EXISTS Reviewv(
17movieReview VARCHAR(2000) NULL
18);
19
20CREATE TABLE IF NOT EXISTS ReviewUser(
21userID VARCHAR(200), NOT NULL
22username VARCHAR(20) NOT NULL
23
24);
25
26CREATE TABLE IF NOT EXISTS Genre (
27movieGenre VARCHAR(200) NOT NULL
28);
29
30
31CREATE TABLE IF NOT EXISTS Movie (
32	title VARCHAR(200) NOT NULL, 
33	productionYear YEAR NOT NULL,
34	
35);
36
37
38
39# CREATE
40INSERT INTO Movie (title, productionYear) VALUES ('Back to the future', 1985);
41INSERT INTO Actor (actorFirstName, actorLastName, actorBirthYear, actorID) VALUES ('Micheal', 'J, Fox', 1961, '1001');
42INSERT INTO Review (movieReview) VALUES ('Very good movie, I like it alot!');
43INSERT INTO ReviewUser(userID, userName) VALUES ('23091', 'Master');
44INSERT INTRO Genre(movieGenre) VALUES ('ADVENTURE');
45
46
47# READ
48SELECT * FROM Movie;
49SELECT * FROM Actor;
50SELECT * FROM Review;
51SELECT * FROM ReviewUser;
52SELECT * FROM Genre;
53#SELECT title FROM Movie;
54
55
56# UPDATE
57#UPDATE Movie SET productionYear = 2017 WHERE productionYear = 2016;
58
59# DELETE
60#DELETE FROM Movie WHERE productionYear = 2017;