INSERT INTO movie(title, production_year, review_rating, status) VALUES('Jason Bourne', 2016, 3.5, 'Released');

INSERT INTO person(name, birthday, gender, placeOfBirth, biography, age)
VALUES ('Matt Damon', '1970-10-8', 'Male', 'Boston, Massachusetts', 'Matthew Paige Damon was born on October 8, 1970, in Boston, Massachusetts, to Kent Damon, a stockbroker, realtor and tax preparer, and Nancy Carlsson-Paige, an early childhood education professor at Lesley University. Matt has an older brother named Kyle who is now a sculptor. His father is of English and Scottish descent, and his mother is of Finnish and Swedish ancestry. The family lived in Newton until his parents divorced in 1973, when Damon and his brother moved with his mother to Cambridge. He grew up in a stable community, and was raised near actor Ben Affleck.', 46),
('Tommy Lee Jones', '1946-9-15', 'Male', 'San Saba, Texas', 'Tommy Lee Jones was born in San Saba, Texas, the son of Lucille Marie (Scott), a police officer and beauty shop owner, and Clyde C. Jones, who worked on oil fields. Tommy himself worked in underwater construction and on an oil rig. He attended St. Marks School of Texas, a prestigious prep school for boys in Dallas, on a scholarship, and went to Harvard on another scholarship. He roomed with future Vice President Al Gore and played offensive guard in the famous 29-29 Harvard-Yale football game of 68 known as "The Tie." He received a B.A. in English literature and graduated cum laude from Harvard in 1969.', 70),
('Alicia Vikander', '1988-10-3', 'Female', 'Gothenburg, Västra Götalands län, Sweden', 'Alicia Vikander is a Swedish actress, dancer and producer. She was born and raised in Gothenburg, Västra Götalands län, Sweden, to Maria Fahl-Vikander, an actress of stage and screen, and Svante Vikander, a psychiatrist. She is of Swedish and one quarter Finnish descent. Alicia began acting as a child in minor stage productions at The Göteborg Opera, and trained as a ballet dancer at the Royal Swedish Ballet School in Stockholm, and the School of American Ballet in New York. She began her professional acting career by appearing in Swedish short films and television series, and first gained recognition in Northern Europe for her role as Josefin Björn-Tegebrandt in the TV drama Andra Avenyn (2007). Vikander made her feature film debut in Pure (2009), for which she won the Guldbagge Award for Best Actress. She attracted widespread recognition in 2012 for portraying Princess Ekaterina "Kitty" Alexandrovna Shcherbatskaya in Joe Wrights film adaptation of Anna Karenina (2012), and Queen Caroline Mathilde in the acclaimed Danish film Um Caso Real (2012), receiving a BAFTA Rising Star Award nomination for her breakthrough. She went on to star in the 2013 Swedish drama film Hotell (2013)and appeared in the Julian Assange biopic O Quinto Poder (2013) that same year. In 2014 and 2015, Vikander achieved global recognition and acclaim for her roles as activist Vera Brittain in Testemunho de Juventude (2014), an AI in Ex Machina (2014), for which she was nominated for the Golden Globe and BAFTA Award for Best Supporting Actress, and painter Gerda Wegener in A Rapariga Dinamarquesa (2015), for which she received the Academy Award and the Screen Actors Guild Award for Best Supporting Actress.', 28),
('Paul Greengrass', '1955-8-13', 'Male', 'Cheam, Surrey, UK', 'Paul Greengrass started his filmmaking career with a super 8 camera he found in his art room in secondary school. Those short movies were animation horror films he made using old dolls, artist dummies, and the general art room clutter.After studying in Cambridge University he got into Granada Television School and spent the first ten years of his career roving global hot spots for the hard-hitting documentary series, World in Action. By this time he became very interested in the Northern Ireland conflict.In 1989, he directed his first fiction movie, "Resurrected", that won an award in Berlin. He continued his career as a fiction filmmaker with a serial of TV movies dealing with social and political issues: Open Fire (a police scandal about a policeman accused of murder), The One that got away (about a military operation during the first Gulf War).His documentary style became more dynamic and intense with each movie. In 2002, Bloody Sunday achieved international acclamation and won the first prize in the Berlin Festival. After that he has continued his career in the United States with "The Bourne Supremacy" starring Matt Damon.', 61),
('Christopher Rouse', '1958-11-28', 'Male', 'Los Angeles, California, USA', 'Christopher Rouse was born on November 28, 1958 in Los Angeles, California, USA as Christopher Russell Rouse. He is known for his work on Ultimato (2007), Capitão Phillips (2013) and Voo 93 (2006).', 58);

INSERT INTO person_movie_role(name, movie_id, person_id)
VALUES('Actor', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Matt Damon')),
('Actor', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Tommy Lee Jones')),
('Actor', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Alicia Vikander')),
('Writer', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Paul Greengrass')),
('Director', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Paul Greengrass')),
('Writer', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT person_id FROM person WHERE name = 'Christopher Rouse'));

INSERT INTO productioncompany(name, country) VALUES(1, 'Captivate Entertainment', 'US'),
('Double Negative', 'GB'),
('Kennedy/Marshall Company, The', 'US'),
('Pearl Street Films', 'US'),
('Perfect World Pictures (Beijing)', 'CN');

INSERT INTO movie_production_company(movie_id, production_company_id)
VALUES((SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT production_company_id FROM productioncompany WHERE name = 'Double Negative')),
((SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT production_company_id FROM productioncompany WHERE name = 'Kennedy/Marshall Company')),
((SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT production_company_id FROM productioncompany WHERE name = 'Pearl Street Films')),
((SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT production_company_id FROM productioncompany WHERE name = 'Perfect World Pictures (Beijing)')),
((SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016), (SELECT production_company_id FROM productioncompany WHERE name = 'Captivate Entertainment'));

INSERT INTO users(name, user_name, email, password)
	VALUES	('John', 'john1978', 'john1978@gmail.com', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824'),
			('Kevin Spacey', 'czarcasm2', 'kevinspacey@yahoo.com', '58756879c05c68dfac9866712fad6a93f8146f337a69afe7dd238f3364946366'),
			('Nicklas Bendtner', 'bendtner1988', 'imanidiot@hotmail.com', 'c0e81794384491161f1777c232bc6bd9ec38f616560b120fda8e90f383853542'),
			('Adrian Val Olonan', 'adrian_val', 'someemail@gmail.com', '5206b8b8a996cf5320cb12ca91c7b790fba9f030408efe83ebb83548dc3007bd'),
			('Littlebear87', 'littlebear87', 'someemail@hotmail.com', '9e209040c863f84a31e719795b2577523954739fe5ed3b58a75cff2127075ed1');

INSERT INTO review(user_rating, headline, review_text, user_id, movie_id)
	VALUES (5, 'Lacks intelligence of all previous',
	'Lacklustre story line lacking intelligence, dialogue, and character development. I am a big fan of the franchise and my expectations may have been too high for this sequel. Was hoping for same kind of substance and kept waiting for something impressively unexpected, like previous. Legacy was a better film. Even fight scenes and car chases from all previous had a different "feel" than typical action films, but formula made these redundant and confusing, not fun like others. The predictable plot had me thinking, hoping for intelligent twist that did not happen. Its a good rental I suppose.',
	(SELECT user_id From Users WHERE user_name = 'adrian_val'),
	(SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016)),

	(0.5, 'Pathetic!!!!!',
	'Any true fan of Jason Bourne knows Matt Damon said that the next Bourne after Ultimatum should be named The Bourne Redundancy. He was right! The story line is stupid and lazy. The directing is also lazy. The special effects are good. Bourne is no longer a meticulous planner, his actions are ridiculously reckless and would make you wonder WTH !!!!! The technology used by the CIA is fantasy technology imagined by the kind of people who dont know anything about technology or even science, you would probably laugh at the programming language used by the CIA in the first few minutes of the movie, and it only gets more ridiculous from there. This movie also serves as a advertising tool for some very wealthy and infamous businesses, and those scenes showing the business names are so painfully long and awkward. The story line also has to serve those special interests.Go see it and youl know exactly what Im talking about. In general, dont waste your time, other peoples time, and money to see this piece of junk.',
	(SELECT user_id From Users WHERE user_name = 'littlebear87'),
	(SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016));

INSERT INTO image(title, description, url, movie_id)
VALUES('Jason Bourne', 'Matt Damon in Jason Bourne (2016)', 'http://www.imdb.com/title/tt4196776/mediaviewer/rm928849152', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016)),
('Jason Bourne', 'Matt Damon in Jason Bourne (2016)', 'http://www.imdb.com/title/tt4196776/mediaviewer/rm4254393856', (SELECT movie_id FROM Movie WHERE title = 'Jason Bourne' AND production_year = 2016));

INSERT INTO image_person(image_id, person_id)
VALUES((SELECT image_id FROM image WHERE url = 'http://www.imdb.com/title/tt4196776/mediaviewer/rm928849152'), (SELECT person_id FROM person WHERE name = 'Matt Damon')),
((SELECT image_id FROM image WHERE url = 'http://www.imdb.com/title/tt4196776/mediaviewer/rm4254393856'), (SELECT person_id FROM person WHERE name = 'Matt Damon'));

INSERT INTO users_users(follow_start_date, follower, followee)
VALUES('2016-10-7', (SELECT user_id FROM users WHERE user_name = 'john1978'), (SELECT user_id FROM users WHERE user_name = 'czarcasm2')),
('2015-3-2', (SELECT user_id FROM users WHERE user_name = 'bendtner1988'), (SELECT user_id FROM users WHERE user_name = 'littlebear87')),
('2016-4-7', (SELECT user_id FROM users WHERE user_name = 'adrian_val'), (SELECT user_id FROM users WHERE user_name = 'john1978'));