USE Fletnix
go

SELECT * FROM Contract
SELECT * FROM Country
SELECT * FROM Customer
SELECT * FROM Payment
SELECT * FROM watchhistory
SELECT * FROM Person
SELECT * FROM Genre
SELECT * FROM Movie
SELECT * FROM Movie_Cast
SELECT * FROM Movie_Genre
SELECT * FROM Movie_Directors

INSERT Person (person_id, lastname, firstname, gender )
VALUES (151786, 'Fishburne', 'Laurence', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (729933, 'Moss', 'Carrie-Anne', 'F')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (393411, 'Reeves', 'Keanu', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (83617, 'Wachowski', 'Larry', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (83616, 'Wachowski', 'Andy', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (666, 'Sandler', 'Adam', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (123,'James', 'Kevin' , 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (999, 'Monaghan', 'Michelle', 'F')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (1357, 'Dinklage', 'Peter', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (10101, 'Gad', 'Josh', 'M')
INSERT Person (person_id, lastname, firstname, gender )
VALUES (99275, 'Columbus', 'Chris', 'M')
INSERT Person (person_id, lastname, firstname, gender )
Values(69, 'Rashid Lynn, Jr.', 'Rashid', 'M')
INSERT Person (person_id, lastname, firstname, gender )
Values(12555, 'Scamarcio', 'Riccard', 'M')
INSERT Person (person_id, lastname, firstname, gender )
Values(77201, 'Stahelski', 'Chad', 'M')

INSERT Genre (genre_name, description)
VALUES ('Action', 'Creative works characterized by emphasis on exciting action sequences')
INSERT Genre (genre_name, description)
VALUES ('Drama', 'Fictional division between comedy and tragedy')
INSERT Genre (genre_name, description)
VALUES ('Family', 'Movies suitable for a wide range of age groups')
INSERT Genre (genre_name, description)
VALUES ('Sci-Fi', 'Fictional movies dealing with imaginative content such as futuristic settings, futuristic science and technology, space travel, time travel, parallel universes, and extraterrestrial life')
INSERT Genre (genre_name, description)
VALUES ('Adventure', 'Typically use its action scenes to display and explore exotic locations in an energetic way')
INSERT Genre (genre_name, description)
VALUES ('Comedy', 'Genre which the main emphasis is on humour')
INSERT Genre (genre_name, description)
VALUES ('Thriller', 'Thriller is a broad genre of literature, film and television, having numerous, often overlapping subgenres')
INSERT Genre (genre_name, description)
VALUES ('Neo-noir', 'The film noir genre includes stylish Hollywood crime dramas; neo-noir is the same, but with updated themes, content, style, visual elements or media that were absent in the films of the film noir period from the 1940s and 1950s')

INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (11, 'Matrix, The', 122, 'Description of Matrix, The', 1999, NULL, NULL, 2.50, 'https://www.youtube.com/watch?v=m8e-FF8MsqU')
INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (12, 'Matrix Reloaded, The', 106, 'Description of Matrix Reloaded, The', 2003, NULL, 11, 2.50, 'https://www.youtube.com/watch?v=HVrGMnk5E_M')
INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (15, 'Kingsman: The Secret Service', 129, 'Description of Kingsman: The Secret Service', 2014, NULL, NULL, 6.70, 'https://www.youtube.com/watch?v=xkX8jKeKUEA')
INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (16, 'Kingsman: The Golden Circle', 141, 'Description of Kingsman: The Golden Circle', 2017, NULL, 15, 6.80, 'https://www.youtube.com/watch?v=J6bnbmQvgUk')

INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (13, 'Pixels', 106, 'Description of Pixel', 2015, NULL, NULL, 0.20, 'https://www.youtube.com/watch?v=XAHprLW48no')
INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (14, 'John Wick', 101, 'Description of John Wick', 2014, NULL, NULL, 3.33, 'https://www.youtube.com/watch?v=C0BMx-qxsP4')
INSERT Movie (movie_id, title, duration, description, publication_year, cover_image, previous_part, price, URL)
VALUES (17, 'John Wick: Chapter 2', 122, 'Description of John Wick: Chapter 2', 2017, NULL, 14, 6.66, 'https://www.youtube.com/watch?v=XGk2EfbD_Ps')

INSERT Movie_Cast (movie_id, person_id, role)
VALUES (11, 393411, 'Neo')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (11, 729933, 'Trinity')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (11, 151786, 'Morpheus')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (12, 393411, 'Neo')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (12, 729933, 'Trinity')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (12, 151786, 'Morpheus')

INSERT Movie_Cast (movie_id, person_id, role)
VALUES (13, 666, 'Sam Brenner')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (13, 123, ' President Will Cooper')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (13, 999, ' Luitenant-kolonel Violet van Patten')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (13, 1357, 'Eddie Plant')
INSERT Movie_Cast (movie_id, person_id, role)
VALUES (13,10101, 'Ludlow Lamonsoff')
INSERT Movie_Cast (movie_id, person_id, role)
Values (14, 393411, 'John Wick')
INSERT Movie_Cast (movie_id, person_id, role)
Values (17, 393411, 'John Wick')
INSERT Movie_Cast (movie_id, person_id, role)
Values (17, 69, 'Cassian')
INSERT Movie_Cast (movie_id, person_id, role)
Values (17, 151786, 'The Bowery King')
INSERT Movie_Cast (movie_id, person_id, role)
Values (17, 12555, 'Santino Di antonio')

INSERT Movie_Genre (movie_id, genre_name)
VALUES (11, 'Action')
INSERT Movie_Genre (movie_id, genre_name)
VALUES(11, 'Sci-Fi')

INSERT Movie_Genre (movie_id, genre_name)
VALUES (12, 'Action')
INSERT Movie_Genre (movie_id, genre_name)
VALUES(12, 'Sci-Fi')

INSERT Movie_Genre (movie_id, genre_name)
VALUES (15, 'Adventure')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (15, 'Comedy')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (15, 'Action')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (15, 'Thriller')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (16, 'Adventure')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (16, 'Comedy')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (16, 'Action')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (13, 'Action')
INSERT Movie_Genre (movie_id, genre_name)
VALUES(13, 'Sci-Fi')
INSERT Movie_Genre (movie_id, genre_name)
VALUES (13, 'Comedy')
INSERT Movie_genre (movie_id, genre_name)
VALUES (14, 'Action')
INSERT Movie_genre (movie_id, genre_name)
VALUES (17, 'Action')
INSERT Movie_genre (movie_id, genre_name)
VALUES (17, 'Neo-Noir')

INSERT Movie_Directors (movie_id,Person_id)
VALUES(13,99275)
INSERT Movie_Directors (movie_id,Person_id)
VALUES(14,77201)
INSERT Movie_Directors (movie_id,Person_id)
VALUES(17,77201)

INSERT Payment(payment_method)
VALUES ('iDeal')
INSERT Payment(payment_method)
VALUES ('PayPal')
INSERT Payment(payment_method)
VALUES ('Creditcard')
INSERT Payment(payment_method)
VALUES ('Bitcoin')

INSERT Contract (contract_type, price_per_month, discount_percentage)
VALUES ('Basic', 7.50, 0)
INSERT Contract (contract_type, price_per_month, discount_percentage)
VALUES ('Pro', 10.00, 0)
INSERT Contract (contract_type, price_per_month, discount_percentage)
VALUES ('Supreme', 12.50, 0)

INSERT Country (country_name)
VALUES ('Nederland')

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Woutje@gmail.com','Jansen', 'Wout', 'Bitcoin', '69', 'Supreme', '2017-11-20', NULL,'Woutje69', 'Password1', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Cannabis@gmail.com','Bis', 'Canna', 'iDeal', '1337', 'Basic', '2017-11-20', NULL,'Can69', 'Password2', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Niels@gmail.com','Anaam', 'Niels', 'iDeal', '1339', 'Supreme', '2017-11-20', NULL,'Niels69', 'Password3', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Thaisa@gmail.com','Gumbs', 'Thaisa', 'Creditcard', '14', 'Supreme', '2017-11-20', NULL,'Thaisa69', 'Password4', 'Nederland', 'M', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('StonerMitch@gmail.com','Stoner', 'Mitch', 'Bitcoin', '665', 'Supreme', '2017-11-20', NULL,'Mitch69', 'Password5', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Roelieboy@gmail.com','Ieboy', 'Roel', 'Bitcoin', '2222', 'Pro', '2017-11-20', NULL,'Roel69', 'Password6', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Marascha@gmail.com','Meisje', 'Marascha', 'iDeal', '11111', 'Supreme', '2017-11-20', NULL,'Marascha69', 'Password7', 'Nederland', 'M', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Esmee@gmail.com','Meid', 'Esmee', 'Bitcoin', '7999', 'Supreme', '2017-11-20', NULL,'Esmee69', 'Password8', 'Nederland', 'M', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Vlaailover69@gmail.com','Vlaaibakker', 'Jorien', 'Bitcoin', '2', 'Basic', '2017-11-20', NULL,'Jorien69', 'Password9', 'Nederland', 'F', NULL)

INSERT Customer (customer_mail_address, lastname, firstname, payment_method, payment_card_number, contract_type, subscription_start, subscription_end, user_name, password, country_name, gender, birth_date)
VALUES ('Weeaboostrijder@gmail.com','Weeb', 'Yorick', 'Bitcoin', '339', 'Supreme', '2017-11-20', NULL,'Yorick69', 'Password10', 'Nederland', 'F', NULL)


INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Woutje@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Cannabis@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Niels@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Thaisa@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'StonerMitch@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Roelieboy@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Marascha@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Esmee@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Vlaailover69@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (11, 'Weeaboostrijder@gmail.com', '2017-11-20', 2.50, 0)


INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (12, 'Woutje@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (13, 'Woutje@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Woutje@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Cannabis@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (16, 'Cannabis@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (17, 'Cannabis@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (13, 'Niels@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Niels@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Niels@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (13, 'Thaisa@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Thaisa@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Thaisa@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (12, 'StonerMitch@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (13, 'StonerMitch@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'StonerMitch@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (12, 'Roelieboy@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (13, 'Roelieboy@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Roelieboy@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Marascha@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (16, 'Marascha@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Marascha@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Esmee@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (16, 'Esmee@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Esmee@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (12, 'Vlaailover69@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (14, 'Vlaailover69@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (17, 'Vlaailover69@gmail.com', '2017-11-20', 2.50, 1)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (12, 'Weeaboostrijder@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (15, 'Weeaboostrijder@gmail.com', '2017-11-20', 2.50, 0)
INSERT WatchHistory (movie_id, customer_mail_address, watch_date, price, invoiced)
VALUES (17, 'Weeaboostrijder@gmail.com', '2017-11-20', 2.50, 0)