50 lines
2.0 KiB
SQL
50 lines
2.0 KiB
SQL
INSERT INTO Genre VALUES
|
|
('action', 1, 0, 0, 0, 0, 0, 0, 0),
|
|
('horror', 0, 1, 0, 0, 0, 0, 0, 0),
|
|
('comedy', 0, 0, 1, 0, 0, 0, 0, 0),
|
|
('suspense', 0, 0, 0, 1, 0, 0, 0, 0),
|
|
('adventure', 0, 0, 0, 0, 1, 0, 0, 0);
|
|
|
|
INSERT INTO Films VALUES
|
|
('AAAAAAAA', 'The Great Gatsby', 'Guy is rich but unhappy', '2:23', 7, 'Comedy'),
|
|
('AAAAAAAB', 'American Psycho', 'Guy is rich but unhappy', '2:10', 8, 'Suspense'),
|
|
('AAAAAAAC', 'Batman', 'Guy is rich and fights crime while being unhappy', '2:10', 9, 'Action'),
|
|
('AAAAAAAD', 'The Mist', 'Spooky things occur after the mist rolls in', '2:02', 6, 'Horror'),
|
|
('AAAAAAAE', 'Shrek', 'An ogre goes on a quest', '1:33', 10, "Adventure");
|
|
|
|
INSERT INTO Actors VALUES
|
|
('AAAAAAAA', 'Leonardo DiCaprio', 'M', '38', 'Big moviestar, been in many films'),
|
|
('AAAAAAAB', 'Christian Bale', 'M', '46', 'Big moviestar, been in many films'),
|
|
('AAAAAAAC', 'Adam West', 'M', '75', 'Big moviestar, been in many films'),
|
|
('AAAAAAAD', 'Thomas Jane', 'M', '55', 'Big moviestar, been in many films'),
|
|
('AAAAAAAE', 'Mike Myers', 'M', '65', 'Big moviestar, been in many films');
|
|
|
|
INSERT INTO Directors VALUES
|
|
('AAAAAAAA', 'Andrew Adamson', 'M', '38', 'Big hollywood director, directed many films'),
|
|
('AAAAAAAB', 'Vicky Jenson', 'F', '35', 'Big hollywood director, directed many films'),
|
|
('AAAAAAAC', 'Baz Luhrmann', 'M', '30', 'Big hollywood director, directed many films'),
|
|
('AAAAAAAD', 'Mary Harron', 'F', '51', 'Big hollywood director, directed many films'),
|
|
('AAAAAAAE', 'Frank Darabont', 'M', '48', 'Big hollywood director, directed many films');
|
|
|
|
INSERT INTO Actor_has_films VALUES
|
|
('AAAAAAAA', 'AAAAAAAA'),
|
|
('AAAAAAAB', 'AAAAAAAB'),
|
|
('AAAAAAAC', 'AAAAAAAC'),
|
|
('AAAAAAAD', 'AAAAAAAD'),
|
|
('AAAAAAAE', 'AAAAAAAE');
|
|
|
|
INSERT INTO Genre_has_films VALUES
|
|
('Action', 'AAAAAAAC'),
|
|
('Comedy', 'AAAAAAAA'),
|
|
('Horror', 'AAAAAAAD'),
|
|
('Suspense', 'AAAAAAAB'),
|
|
('Adventure', 'AAAAAAAE');
|
|
|
|
INSERT INTO Directs VALUES
|
|
('AAAAAAAA', 'AAAAAAAA'),
|
|
('AAAAAAAB', 'AAAAAAAB'),
|
|
('AAAAAAAC', 'AAAAAAAC'),
|
|
('AAAAAAAD', 'AAAAAAAD'),
|
|
('AAAAAAAE', 'AAAAAAAE');
|
|
|