--CREATION DE LA BASE FILMS

-- Artiste(idArtiste,nom,prénom,annéeNaiss) --
CREATE TABLE Artiste(
    idArtiste int(11) NOT NULL AUTO_INCREMENT ,
    nom varchar(30),
    prénom varchar(30),
    annéeNaiss int(4),
    PRIMARY KEY (idArtiste));

-- Pays(code,nom,langue) -- 
CREATE TABLE Pays(
    code varchar(3) ,
    nom varchar(30),
    langue varchar(30),
    PRIMARY KEY (code));

-- Internaute(email,nom,prénom,région)
CREATE TABLE Internaute(
    email varchar(30) NOT NULL,
    nom varchar(30),
    prénom varchar(30),
    région varchar(3),
    PRIMARY KEY (email),
    FOREIGN KEY (région) REFERENCES Pays(code));

-- Film(idFilm,titre,année,genre,résumé,idRéalisateur,codePays)
CREATE TABLE Film(
    idFilm int(11) NOT NULL AUTO_INCREMENT,
    titre varchar(80),
    année int(4),
    genre varchar(20),
    résumé text,
    idRéalisateur int(11),
    codePays varchar(3) ,
    PRIMARY KEY(idFilm),
    FOREIGN KEY(idRéalisateur) REFERENCES Artiste(idArtiste),
    FOREIGN KEY(codePays) REFERENCES Pays(code));
 
-- Rôle(idFilm,iActeur,nomRôle)
CREATE TABLE Rôle(
  idFilm int(11),
  idActeur int(11),
  nomRôle varchar(20),
  PRIMARY KEY(idFilm,idActeur),
  FOREIGN KEY(idFilm) REFERENCES Film(idFilm),
  FOREIGN KEY(idActeur) REFERENCES Artiste(idArtiste));

-- Notation(email,idFilm,note)
CREATE TABLE Notation(
  email varchar(30) ,
  idFilm int(11),
  note int(2),
  PRIMARY KEY(email,idFilm),
  FOREIGN KEY(email) REFERENCES Internaute(email),
  FOREIGN KEY(idFilm) REFERENCES Film(idFilm));

-- 
--  INSERTION DE VALEURS
--

-- Artiste --
INSERT INTO `Artiste` (`idArtiste`, `nom`, `prénom`, `annéeNaiss`) VALUES
(1, 'Lucas', 'George', 1944),
(2, 'Hamill', 'Mark', 1951),
(3, 'Ford', 'Harrison', 1942),
(4, 'Fisher', 'Carrie', 1956),
(5, 'Cushing', 'Peter', 1913),
(6, 'Daniels', 'Anthony', 1946),
(31, 'Hanks', 'Tom', 1956),
(32, 'Wright', 'Robin', 1966),
(39, 'Mendes', 'Sam', 1965),
(40, 'Welles', 'Orson', 1915),
(42, 'von Trier', 'Lars', 1956),
(48, 'Bean', 'Sean', 1959),
(49, 'Bello', 'Maria', 1967),
(50, 'Deneuve', 'Catherine', 1943),
(53, 'Stormare', 'Peter', 1953),
(59, 'Besson', 'Luc', 1959),
(62, 'Willis', 'Bruce', 1955),
(64, 'Oldman', 'Gary', 1958),
(65, 'Holm', 'Ian', 1931),
(66, 'Tucker', 'Chris', 1971),
(68, 'Lang', 'Fritz', 1890),
(85, 'Depp', 'Johnny', 1963),
(99, 'Plummer', 'Amanda', 1957),
(103, 'Ruffalo', 'Mark', 1967),
(108, 'Jackson', 'Peter', 1961),
(109, 'Wood', 'Elijah', 1981),
(110, 'Mortensen', 'Viggo', 1958),
(112, 'Blanchett', 'Cate', 1969),
(113, 'Lee', 'Christopher', 1922),
(130, 'Baker', 'Kenny', 1934),
(131, 'Gyllenhaal', 'Jake', 1980),
(134, 'Foxx', 'Jamie', 1967),
(138, 'Tarantino', 'Quentin', 1963),
(139, 'Thurman', 'Uma', 1970),
(140, 'Liu', 'Lucy', 1968),
(141, 'Carradine', 'David', 1936),
(147, 'Madsen', 'Michael', 1957),
(190, 'Eastwood', 'Clint', 1930),
(192, 'Freeman', 'Morgan', 1937),
(193, 'Hackman', 'Gene', 1930),
(194, 'Harris', 'Richard', 1930),
(201, 'Gondry', 'Michel', 1963),
(204, 'Winslet', 'Kate', 1975),
(205, 'Dunst', 'Kirsten', 1982),
(206, 'Carrey', 'Jim', 1962),
(207, 'Wilkinson', 'Tom', 1948),
(223, 'González Iñárritu', 'Alejandro', 1963),
(224, 'Cronenberg', 'David', 1943),
(225, 'Holmes', 'Ashton', 1978),
(227, 'Hurt', 'William', 1950),
(228, 'Harris', 'Ed', 1950),
(240, 'Kubrick', 'Stanley', 1928),
(245, 'Dullea', 'Keir', 1936),
(246, 'Lockwood', 'Gary', 1937),
(247, 'Sylvester', 'William', 1922),
(248, 'Richter', 'Daniel', 1939),
(253, 'Rain', 'Douglas', 1928),
(258, 'García Bernal', 'Gael', 1978),
(270, 'Barraza', 'Adriana', 1956),
(287, 'Pitt', 'Brad', 1963),
(289, 'Stowe', 'Madeleine', 1958),
(290, 'Plummer', 'Christopher', 1929),
(335, 'Shannon', 'Michael', 1974),
(349, 'Glenn', 'Scott', 1939),
(351, 'Davis', 'Judy', 1955),
(368, 'Witherspoon', 'Reese', 1976),
(380, 'De Niro', 'Robert', 1943),
(418, 'Patrick', 'Robert', 1958),
(478, 'Bell', 'Jamie', 1986),
(488, 'Spielberg', 'Steven', 1946),
(500, 'Cruise', 'Tom', 1962),
(501, 'Fanning', 'Dakota', 1994),
(502, 'Otto', 'Miranda', 1967),
(503, 'Chatwin', 'Justin', 1982),
(504, 'Robbins', 'Tim', 1958),
(510, 'Burton', 'Tim', 1958),
(514, 'Nicholson', 'Jack', 1937),
(515, 'Close', 'Glenn', 1947),
(516, 'Bening', 'Annette', 1958),
(517, 'Brosnan', 'Pierce', 1953),
(518, 'DeVito', 'Danny', 1944),
(519, 'Short', 'Martin', 1950),
(520, 'Jessica Parker', 'Sarah', 1965),
(521, 'J. Fox', 'Michael', 1961),
(522, 'Steiger', 'Rod', 1925),
(524, 'Portman', 'Natalie', 1981),
(525, 'Nolan', 'Christopher', 1970),
(526, 'Haas', 'Lukas', 1976),
(529, 'Pearce', 'Guy', 1967),
(530, 'Moss', 'Carrie-Anne', 1967),
(532, 'Pantoliano', 'Joe', 1951),
(534, 'Boone Junior', 'Mark', 1955),
(535, 'Fega', 'Russ', NULL),
(536, 'Fox', 'Jorja', 1968),
(537, 'Tobolowsky', 'Stephen', 1951),
(578, 'Scott', 'Ridley', 1937),
(585, 'Hauer', 'Rutger', 1944),
(586, 'Young', 'Sean', 1959),
(587, 'James Olmos', 'Edward', 1947),
(588, 'Emmet Walsh', 'M.', 1935),
(589, 'Hannah', 'Daryl', 1960),
(638, 'Mann', 'Michael', 1943),
(650, 'Allen', 'Karen', 1951),
(652, 'Freeman', 'Paul', 1943),
(653, 'Lacey', 'Ronald', 1935),
(655, 'Rhys-Davies', 'John', 1944),
(656, 'Elliott', 'Denholm', 1922),
(658, 'Molina', 'Alfred', 1953),
(659, 'Kahler', 'Wolf', 1940),
(660, 'Higgins', 'Anthony', 1947),
(678, 'Gedeck', 'Martina', 1961),
(689, 'Capshaw', 'Kate', 1953),
(690, 'Huy Quan', 'Ke', 1971),
(691, 'Puri', 'Amrish', 1932),
(693, 'Seth', 'Roshan', 1942),
(694, 'Stone', 'Philip', 1924),
(695, 'Chiao', 'Roy', 1927),
(738, 'Connery', 'Sean', 1930),
(739, 'Doody', 'Alison', 1966),
(740, 'Glover', 'Julian', 1935),
(741, 'Phoenix', 'River', 1970),
(780, 'Cox', 'Ronny', 1938),
(793, 'Buñuel', 'Luis', 1900),
(819, 'Norton', 'Edward', 1969),
(820, 'Furlong', 'Edward', 1977),
(854, 'Stewart', 'James', 1908),
(856, 'Gazzara', 'Ben', 1930),
(880, 'Affleck', 'Ben', 1972),
(884, 'Buscemi', 'Steve', 1957),
(887, 'Wilson', 'Owen', 1968),
(920, 'Prochnow', 'Jürgen', 1941),
(922, 'Garfield', 'Allen', 1939),
(934, 'Crowe', 'Russell', 1964),
(935, 'Nielsen', 'Connie', 1965),
(936, 'Reed', 'Oliver', 1938),
(937, 'Jacobi', 'Derek', 1938),
(938, 'Hounsou', 'Djimon', 1964),
(1003, 'Reno', 'Jean', 1948),
(1019, 'Mikkelsen', 'Mads', 1965),
(1032, 'Scorsese', 'Martin', 1942),
(1036, 'Shepherd', 'Cybill', 1950),
(1037, 'Keitel', 'Harvey', 1939),
(1038, 'Foster', 'Jodie', 1962),
(1039, 'Boyle', 'Peter', 1935),
(1090, 'McTiernan', 'John', 1951),
(1100, 'Schwarzenegger', 'Arnold', 1947),
(1101, 'Weathers', 'Carl', 1948),
(1102, 'Carrillo', 'Elpidia', 1961),
(1103, 'Duke', 'Bill', 1943),
(1104, 'Ventura', 'Jesse', 1951),
(1105, 'Landham', 'Sonny', 1941),
(1106, 'Chaves', 'Richard', 1951),
(1121, 'del Toro', 'Benicio', 1967),
(1141, 'Vincent', 'Hélène', 1943),
(1150, 'De Palma', 'Brian', 1940),
(1158, 'Pacino', 'Al', 1940),
(1164, 'Murray Abraham', 'F.', 1939),
(1204, 'Roberts', 'Julia', 1967),
(1205, 'Gere', 'Richard', 1949),
(1223, 'Coen', 'Joel', 1954),
(1224, 'Coen', 'Ethan', 1957),
(1229, 'Bridges', 'Jeff', 1949),
(1230, 'Goodman', 'John', 1952),
(1231, 'Moore', 'Julianne', 1960),
(1232, 'Huddleston', 'David', 1930),
(1233, 'Seymour Hoffman', 'Philip', 1967),
(1234, 'Reid', 'Tara', 1975),
(1235, 'Moon', 'Philip', NULL),
(1236, 'Pellegrino', 'Mark', 1965),
(1243, 'Allen', 'Woody', 1935),
(1244, 'Rhys Meyers', 'Jonathan', 1977),
(1245, 'Johansson', 'Scarlett', 1984),
(1246, 'Mortimer', 'Emily', 1971),
(1248, 'Cox', 'Brian', 1946),
(1249, 'Wilton', 'Penelope', 1946),
(1270, 'Martin Smith', 'Charles', 1953),
(1271, 'García', 'Andy', 1956),
(1283, 'Bonham Carter', 'Helena', 1966),
(1327, 'McKellen', 'Ian', 1939),
(1328, 'Astin', 'Sean', 1971),
(1329, 'Boyd', 'Billy', 1968),
(1330, 'Monaghan', 'Dominic', 1976),
(1331, 'Weaving', 'Hugo', 1960),
(1333, 'Serkis', 'Andy', 1964),
(1337, 'Leung Chiu-wai', 'Tony', 1962),
(1338, 'Cheung', 'Maggie', 1964),
(1339, 'Ziyi', 'Zhang', 1979),
(1341, 'Yen', 'Donnie', 1963),
(1369, 'Hill', 'Bernard', 1944),
(1370, 'Dourif', 'Brad', 1950),
(1381, 'Noble', 'John', 1948),
(1466, 'Durning', 'Charles', 1923),
(1472, 'McKinnon', 'Ray', 1957),
(1524, 'Ramis', 'Harold', 1944),
(1532, 'Murray', 'Bill', 1950),
(1533, 'MacDowell', 'Andie', 1958),
(1534, 'Elliott', 'Chris', 1960),
(1535, 'Doyle-Murray', 'Brian', 1945),
(1579, 'Gyllenhaal', 'Maggie', 1977),
(1614, 'Lee', 'Ang', 1954),
(1619, 'Yun-fat', 'Chow', 1955),
(1620, 'Yeoh', 'Michelle', 1962),
(1622, 'Chen', 'Chang', 1976),
(1623, 'Lung', 'Sihung', 1930),
(1624, 'Pei-pei', 'Cheng', 1946),
(1625, 'Fazeng', 'Li', NULL),
(1639, 'Watson', 'Emily', 1967),
(1640, 'Skarsgård', 'Stellan', 1951),
(1641, 'Cartlidge', 'Katrin', 1961),
(1642, 'Barr', 'Jean-Marc', 1960),
(1643, 'Rawlins', 'Adrian', 1958),
(1650, 'Truffaut', 'François', 1932),
(1653, 'Léaud', 'Jean-Pierre', 1944),
(1654, 'Maurier', 'Claire', 1929),
(1655, 'Rémy', 'Albert', 1911),
(1656, 'Decomble', 'Guy', 1910),
(1658, 'Flamant', 'Georges', 1903),
(1659, 'Auffay', 'Patrick', NULL),
(1733, 'Nolte', 'Nick', 1941),
(1736, 'Remar', 'James', 1953),
(1769, 'Coppola', 'Sofia', 1971),
(1771, 'Ribisi', 'Giovanni', 1974),
(1776, 'Ford Coppola', 'Francis', 1939),
(1810, 'Ledger', 'Heath', 1979),
(1811, 'Quaid', 'Randy', 1950),
(1812, 'Williams', 'Michelle', 1980),
(1813, 'Hathaway', 'Anne', 1982),
(1817, 'Cardellini', 'Linda', 1975),
(1818, 'Winfield', 'Paul', 1939),
(1844, 'Schweiger', 'Til', 1963),
(1892, 'Damon', 'Matt', 1970),
(1893, 'Affleck', 'Casey', 1975),
(1903, 'Arkin', 'Alan', 1934),
(1920, 'Ryder', 'Winona', 1971),
(1924, 'Krabbé', 'Jeroen', 1944),
(1925, 'Cassel', 'Vincent', 1966),
(1927, 'Edwards', 'Blake', 1922),
(1932, 'Hepburn', 'Audrey', 1929),
(1936, 'Balsam', 'Martin', 1919),
(1954, 'Zane', 'Billy', 1966),
(1972, 'Lavanant', 'Dominique', 1944),
(1979, 'Spacey', 'Kevin', 1959),
(2037, 'Murphy', 'Cillian', 1976),
(2038, 'Harris', 'Naomie', 1976),
(2087, 'Fleischer', 'Richard', 1916),
(2090, 'Douglas', 'Kirk', 1916),
(2091, 'Mason', 'James', 1909),
(2094, 'Lorre', 'Peter', 1904),
(2096, 'J. Wilke', 'Robert', 1914),
(2097, 'de Corsia', 'Ted', 1905),
(2109, 'Cattrall', 'Kim', 1956),
(2115, 'Smith', 'Kurtwood', 1943),
(2133, 'Meyer', 'Dina', 1968),
(2170, 'Duret', 'Marc', 1957),
(2176, 'Lee Jones', 'Tommy', 1946),
(2179, 'Amis', 'Suzy', 1962),
(2192, 'Wilson', 'Lambert', 1958),
(2201, 'von Sydow', 'Max', 1929),
(2202, 'Harris', 'Steve', 1965),
(2203, 'McDonough', 'Neal', 1966),
(2206, 'Morton', 'Samantha', 1977),
(2208, 'Morris', 'Kathryn', 1969),
(2219, 'Maguire', 'Tobey', 1975),
(2224, 'Slater', 'Christian', 1969),
(2226, 'Pollack', 'Sydney', 1934),
(2227, 'Kidman', 'Nicole', 1967),
(2228, 'Penn', 'Sean', 1960),
(2229, 'Keener', 'Catherine', 1959),
(2230, 'Grier', 'Pam', 1949),
(2231, 'L. Jackson', 'Samuel', 1948),
(2232, 'Keaton', 'Michael', 1951),
(2233, 'Fonda', 'Bridget', 1964),
(2234, 'Bowen', 'Michael', 1953),
(2264, 'Magee', 'Patrick', 1922),
(2280, 'Francis', 'Clive', 1946),
(2282, 'Kingsley', 'Ben', 1943),
(2299, 'Hartnett', 'Josh', 1978),
(2314, 'Falk', 'Peter', 1927),
(2319, 'de Medeiros', 'Maria', 1965),
(2352, 'Annaud', 'Jean-Jacques', 1943),
(2367, 'Qualtinger', 'Helmut', 1928),
(2368, 'Baskin', 'Elya', 1950),
(2369, 'Lonsdale', 'Michael', 1931),
(2370, 'Prechtel', 'Volker', 1941),
(2411, 'Mollet', 'Clotilde', NULL),
(2413, 'Pinon', 'Dominique', 1955),
(2440, 'Nighy', 'Bill', 1949),
(2464, 'Macfadyen', 'Angus', 1963),
(2524, 'Hardy', 'Tom', 1977),
(2535, 'A. Fox', 'Vivica', 1964),
(2536, 'Parks', 'Michael', 1940),
(2537, 'Chiba', 'Sonny', 1939),
(2538, 'Kuriyama', 'Chiaki', 1984),
(2539, 'Dreyfus', 'Julie', 1966),
(2558, 'Danova', 'Cesare', 1926),
(2559, 'Clouzot', 'Henri-Georges', 1907),
(2561, 'Argo', 'Victor', 1934),
(2565, 'Montand', 'Yves', 1921),
(2566, 'Vanel', 'Charles', 1892),
(2567, 'van Eyck', 'Peter', 1911),
(2568, 'Lulli', 'Folco', 1912),
(2569, 'Clouzot', 'Véra', 1913),
(2570, 'Centa', 'Antonio', 1907),
(2628, 'Sutherland', 'Kiefer', 1966),
(2636, 'Hitchcock', 'Alfred', 1899),
(2638, 'Grant', 'Cary', 1904),
(2639, 'Marie Saint', 'Eva', 1924),
(2640, 'Royce Landis', 'Jessie', 1896),
(2642, 'G. Carroll', 'Leo', 1886),
(2662, 'Capra', 'Frank', 1897),
(2690, 'Weir', 'Peter', 1944),
(2710, 'Cameron', 'James', 1954),
(2712, 'Biehn', 'Michael', 1956),
(2713, 'Hamilton', 'Linda', 1956),
(2714, 'Henriksen', 'Lance', 1940),
(2716, 'Boen', 'Earl', 1941),
(2888, 'Smith', 'Will', 1968),
(2954, 'Wright', 'Jeffrey', 1965),
(2963, 'Cage', 'Nicolas', 1964),
(2975, 'Fishburne', 'Laurence', 1961),
(2978, 'Minghella', 'Max', 1985),
(2979, 'Higgins', 'Michael', 1920),
(3001, 'Veidt', 'Conrad', 1893),
(3011, 'Manz', 'Linda', 1961),
(3017, 'Williams', 'Samm-Art', 1946),
(3036, 'Cusack', 'John', 1966),
(3037, 'Dreyfuss', 'Richard', 1947),
(3041, 'Bell', 'Marshall', 1942),
(3051, 'Collette', 'Toni', 1972),
(3061, 'McGregor', 'Ewan', 1971),
(3063, 'Swinton', 'Tilda', 1960),
(3084, 'Brando', 'Marlon', 1924),
(3085, 'Caan', 'James', 1940),
(3086, 'S. Castellano', 'Richard', 1933),
(3087, 'Duvall', 'Robert', 1931),
(3088, 'Hayden', 'Sterling', 1916),
(3092, 'Keaton', 'Diane', 1946),
(3094, 'Shire', 'Talia', 1946),
(3095, 'Russo', 'Gianni', 1943),
(3096, 'Cazale', 'John', 1935),
(3124, 'Golino', 'Valeria', 1966),
(3129, 'Roth', 'Tim', 1961),
(3146, 'Wilder', 'Billy', 1906),
(3149, 'Monroe', 'Marilyn', 1926),
(3150, 'Curtis', 'Tony', 1925),
(3151, 'Lemmon', 'Jack', 1925),
(3152, 'Raft', 'George', 1895),
(3155, 'O’Brien', 'Pat', 1899),
(3171, 'Strasberg', 'Lee', 1901),
(3172, 'V. Gazzo', 'Michael', 1923),
(3173, 'D. Spradlin', 'G.', 1920),
(3174, 'Bright', 'Richard', 1937),
(3196, 'Lewis', 'Juliette', 1973),
(3197, 'Sizemore', 'Tom', 1961);
--
INSERT INTO Pays VALUES
('FR','France','français'),
('CA','Canada','français-anglais'),
('GB','Great Britain','english'),
('US','United States','english(US)'),
('MX','Mexique','espagnol'),
('JP','Japon','japonais'),
('CN','Chine','chinois'),
('NZ','New Zealand','english'),
('IT','Italie','italien'),
('DE','Allemagne','allemand'),
('DK','Danemark','danois'),
('SE','Suède','suédois');

INSERT INTO `Film` (`idFilm`, `titre`, `année`, `idRéalisateur`, `genre`, `résumé`, `codePays`) VALUES
(11, 'Star Wars', 1977, 1, 'Adventure', 'Princess Leia is captured and held hostage by the evil Imperial forces in their effort to take over the galactic Empire. Venturesome Luke Skywalker and dashing captain Han Solo team together with the loveable robot duo R2-D2 and C-3PO to rescue the beautiful princess and restore peace and justice in the Empire.', 'US'),
(15, 'Citizen Kane', 1941, 40, 'Mystery', 'Newspaper magnate, Charles Foster Kane is taken from his mother as a boy and made the ward of a rich industrialist. As a result, every well-meaning, tyrannical or self-destructive move he makes for the rest of his life appears in some way to be a reaction to that deeply wounding event.', 'US'),
(24, 'Kill Bill: Vol. 1', 2003, 138, 'Action', 'An assassin is shot by her ruthless employer, Bill, and other members of their assassination circle – but she lives to plot her vengeance.', 'US'),
(28, 'Apocalypse Now', 1979, 1776, 'Drama', 'At the height of the Vietnam war, Captain Benjamin Willard is sent on a dangerous mission that, officially, \"does not exist, nor will it ever exist.\" His goal is to locate - and eliminate - a mysterious Green Beret Colonel named Walter Kurtz, who has been leading his personal army on illegal guerrilla missions into enemy territory.', 'US'),
(33, 'Unforgiven', 1992, 190, 'Western', 'William Munny is a retired, once-ruthless killer turned gentle widower and hog farmer. To help support his two motherless children, he accepts one last bounty-hunter mission to find the men who brutalized a prostitute. Joined by his former partner and a cocky greenhorn, he takes on a corrupt sheriff.', 'US'),
(38, 'Eternal Sunshine of the Spotless Mind', 2004, 201, 'Science Fiction', 'Joel Barish, heartbroken that his girlfriend underwent a procedure to erase him from her memory, decides to do the same. However, as he watches his memories of her fade away, he realises that he still loves her, and may be too late to correct his mistake.', 'US'),
(59, 'A History of Violence', 2005, 224, 'Drama', 'An average family is thrust into the spotlight after the father commits a seemingly self-defense murder at his diner.', 'CA'),
(62, '2001: A Space Odyssey', 1968, 240, 'Science Fiction', 'Humanity finds a mysterious object buried beneath the lunar surface and sets off to find its origins with the help of HAL 9000, the world\'s most advanced super computer.', 'GB'),
(74, 'War of the Worlds', 2005, 488, 'Adventure', 'Ray Ferrier is a divorced dockworker and less-than-perfect father. Soon after his ex-wife and her new husband drop off his teenage son and young daughter for a rare weekend visit, a strange and powerful lightning storm touches down.', 'US'),
(75, 'Mars Attacks!', 1996, 510, 'Comedy', 'A fleet of Martian spacecraft surrounds the world\'s major cities and all of humanity waits to see if the extraterrestrial visitors have, as they claim, \"come in peace.\" U.S. President James Dale receives assurance from science professor Donald Kessler that the Martians\' mission is a friendly one. But when a peaceful exchange ends in the total annihilation of the U.S. Congress, military men call for a full-scale nuclear retaliation.', 'US'),
(77, 'Memento', 2000, 525, 'Mystery', 'Leonard Shelby is tracking down the man who raped and murdered his wife. The difficulty of locating his wife\'s killer, however, is compounded by the fact that he suffers from a rare, untreatable form of short-term memory loss. Although he can recall details of life before his accident, Leonard cannot remember what happened fifteen minutes ago, where he\'s going, or why.', 'US'),
(78, 'Blade Runner', 1982, 578, 'Science Fiction', 'In the smog-choked dystopian Los Angeles of 2019, blade runner Rick Deckard is called out of retirement to terminate a quartet of replicants who have escaped to Earth seeking their creator for a way to extend their short life spans.', 'US'),
(85, 'Raiders of the Lost Ark', 1981, 488, 'Adventure', 'When Dr. Indiana Jones – the tweed-suited professor who just happens to be a celebrated archaeologist – is hired by the government to locate the legendary Ark of the Covenant, he finds himself up against the entire Nazi regime.', 'US'),
(87, 'Indiana Jones and the Temple of Doom', 1984, 488, 'Adventure', 'After arriving in India, Indiana Jones is asked by a desperate village to find a mystical stone. He agrees – and stumbles upon a secret cult plotting a terrible plan in the catacombs of an ancient palace.', 'US'),
(89, 'Indiana Jones and the Last Crusade', 1989, 488, 'Adventure', 'In 1938, an art collector appeals to eminent archaeologist Dr. Indiana Jones to embark on a search for the Holy Grail. Indy learns that a medieval historian has vanished while searching for it, and the missing man is his own father, Dr. Henry Jones Sr.. He sets out to rescue his father by following clues in the old man\'s notebook, which his father had mailed to him before he went missing. Indy arrives in Venice, where he enlists the help of a beautiful academic, Dr. Elsa Schneider, along with Marcus Brody and Sallah. Together they must stop the Nazis from recovering the power of eternal life and taking over the world!', 'US'),
(98, 'Gladiator', 2000, 578, 'Action', 'In the year 180, the death of emperor Marcus Aurelius throws the Roman Empire into chaos.  Maximus is one of the Roman army\'s most capable and trusted generals and a key advisor to the emperor.  As Marcus\' devious son Commodus ascends to the throne, Maximus is set to be executed.  He escapes, but is captured by slave traders.  Renamed Spaniard and forced to become a gladiator, Maximus must battle to the death with other men for the amusement of paying audiences.', 'GB'),
(103, 'Taxi Driver', 1976, 1032, 'Crime', 'A mentally unstable Vietnam War veteran works as a night-time taxi driver in New York City where the perceived decadence and sleaze feed his urge for violent action.', 'US'),
(106, 'Predator', 1987, 1090, 'Science Fiction', 'A team of elite commandos on a secret mission in a Central American jungle come to find themselves hunted by an extraterrestrial warrior.', 'MX'),
(115, 'The Big Lebowski', 1998, 1224, 'Comedy', 'Jeffrey \'The Dude\' Lebowski, a Los Angeles slacker who only wants to bowl and drink White Russians, is mistaken for another Jeffrey Lebowski, a wheelchair-bound millionaire, and finds himself dragged into a strange series of events involving nihilists, adult film producers, ferrets, errant toes, and large sums of money.', 'GB'),
(116, 'Match Point', 2005, 1243, 'Drama', 'Chris, a former tennis player, looks for work as an instructor. He meets Tom Hewett, a wealthy young man whose sister Chloe fall in love with Chris. But Chris has his eye on Tom\'s fiancee Nola.', 'GB'),
(120, 'The Lord of the Rings: The Fellowship of the Ring', 2001, 108, 'Adventure', 'Young hobbit Frodo Baggins, after inheriting a mysterious ring from his uncle Bilbo, must leave his home in order to keep it from falling into the hands of its evil creator. Along the way, a fellowship is formed to protect the ringbearer and make sure that the ring arrives at its final destination: Mt. Doom, the only place where it can be destroyed.', 'NZ'),
(121, 'The Lord of the Rings: The Two Towers', 2002, 108, 'Adventure', 'Frodo and Sam are trekking to Mordor to destroy the One Ring of Power while Gimli, Legolas and Aragorn search for the orc-captured Merry and Pippin. All along, nefarious wizard Saruman awaits the Fellowship members at the Orthanc Tower in Isengard.', 'NZ'),
(122, 'The Lord of the Rings: The Return of the King', 2003, 108, 'Adventure', 'Aragorn is revealed as the heir to the ancient kings as he, Gandalf and the other members of the broken fellowship struggle to save Gondor from Sauron\'s forces. Meanwhile, Frodo and Sam take the ring closer to the heart of Mordor, the dark lord\'s realm.', 'NZ'),
(137, 'Groundhog Day', 1993, 1524, 'Romance', 'A narcissistic TV weatherman, along with his attractive-but-distant producer, and his mawkish cameraman, is sent to report on Groundhog Day in the small town of Punxsutawney, where he finds himself repeating the same day over and over.', 'US'),
(142, 'Brokeback Mountain', 2005, 1614, 'Drama', 'Rodeo cowboy Jack and ranch hand Ennis are hired as sheepherders in 1963 Wyoming. One night on Brokeback Mountain, they spark a physical relationship. Though Ennis marries his longtime sweetheart and Jack marries a fellow rodeo rider, they keep up their tortured, sporadic love affair for 20 years.', 'CA'),
(145, 'Breaking the Waves', 1996, 42, 'Drama', 'In a small and conservative Scottish village, a woman\'s paralytic husband convinces her to have extramarital intercourse so she can tell him about it and give him a reason for living.', 'DK'),
(146, 'Crouching Tiger, Hidden Dragon', 2000, 1614, 'Adventure', 'Two warriors in pursuit of a stolen sword and a notorious fugitive are led to an impetuous, physically-skilled, teenage nobleman\'s daughter, who is at a crossroads in her life.', 'CN'),
(147, 'The 400 Blows', 1959, 1650, 'Drama', 'For young Parisian boy Antoine Doinel, life is one difficult situation after another. Surrounded by inconsiderate adults, including his neglectful parents, Antoine spends his days with his best friend, Rene, trying to plan for a better life. When one of their schemes goes awry, Antoine ends up in trouble with the law, leading to even more conflicts with unsympathetic authority figures.', 'FR'),
(153, 'Lost in Translation', 2003, 1769, 'Drama', 'Two lost souls visiting Tokyo -- the young, neglected wife of a photographer and a washed-up movie star shooting a TV commercial -- find an odd solace and pensive freedom to be real in each other\'s company, away from their lives in America.', 'JP'),
(155, 'The Dark Knight', 2008, 525, 'Drama', 'Batman raises the stakes in his war on crime. With the help of Lt. Jim Gordon and District Attorney Harvey Dent, Batman sets out to dismantle the remaining criminal organizations that plague the streets. The partnership proves to be effective, but they soon find themselves prey to a reign of chaos unleashed by a rising criminal mastermind known to the terrified citizens of Gotham as the Joker.', 'GB'),
(180, 'Minority Report', 2002, 488, 'Science Fiction', 'John Anderton is a top \'Precrime\' cop in the late-21st century, when technology can predict crimes before they\'re committed. But Anderton becomes the quarry when another investigator targets him for a murder charge.', 'US'),
(184, 'Jackie Brown', 1997, 138, 'Crime', 'Jackie Brown is a flight attendant who gets caught in the middle of smuggling cash into the country for her gunrunner boss. When the cops try to use Jackie to get to her boss, she hatches a plan — with help from a bail bondsman — to keep the money for herself.', 'US'),
(192, 'The Name of the Rose', 1986, 2352, 'Drama', '14th-century Franciscan monk William of Baskerville and his young novice arrive at a conference to find that several monks have been murdered under mysterious circumstances. To solve the crimes, William must rise up against the Church\'s authority and fight the shadowy conspiracy of monastery monks using only his intelligence – which is considerable.', 'FR'),
(204, 'The Wages of Fear', 1953, 2559, 'Drama', 'In a run-down South American town, four men are paid to drive trucks loaded with nitroglycerin into the jungle through to the oil field. Friendships are tested and rivalries develop as they embark upon the perilous journey.', 'FR'),
(213, 'North by Northwest', 1959, 2636, 'Mystery', 'Advertising man Roger Thornhill is mistaken for a spy, triggering a deadly cross-country chase.', 'US'),
(218, 'The Terminator', 1984, 2710, 'Action', 'In the post-apocalyptic future, reigning tyrannical supercomputers teleport a cyborg assassin known as the \"Terminator\" back to 1984 to kill Sarah Connor, whose unborn son is destined to lead insurgents against 21st century mechanical hegemony. Meanwhile, the human-resistance movement dispatches a lone warrior to safeguard Sarah. Can he stop the virtually indestructible killing machine?', 'GB'),
(223, 'Rebecca', 1940, 2636, 'Mystery', 'Story of a young woman who marries a fascinating widower only to find out that she must live in the shadow of his former wife, Rebecca, who died mysteriously several years earlier. The young wife must come to grips with the terrible secret of her handsome, cold husband, Max De Winter. She must also deal with the jealous, obsessed Mrs. Danvers, the housekeeper, who will not accept her as the mistress of the house.', 'US'),
(238, 'The Godfather', 1972, 1776, 'Drama', 'Spanning the years 1945 to 1955, a chronicle of the fictional Italian-American Corleone crime family. When organized crime family patriarch, Vito Corleone barely survives an attempt on his life, his youngest son, Michael steps in to take care of the would-be killers, launching a campaign of bloody revenge.', 'US'),
(239, 'Some Like It Hot', 1959, 3146, 'Comedy', 'Two musicians witness a mob hit and struggle to find a way out of the city before they are found by the gangsters. Their only opportunity is to join an all-girl band as they leave on a tour. To make their getaway they must first disguise themselves as women, then keep their identities secret and deal with the problems this brings - such as an attractive bandmate and a very determined suitor.', 'US'),
(240, 'The Godfather Part II', 1974, 1776, 'Drama', 'In the continuing saga of the Corleone crime family, a young Vito Corleone grows up in Sicily and in 1910s New York. In the 1950s, Michael Corleone attempts to expand the family business into Las Vegas, Hollywood and Cuba.', 'US'),
(242, 'The Godfather Part III', 1990, 1776, 'Crime', 'In the midst of trying to legitimize his business dealings in 1979 New York and Italy, aging mafia don, Michael Corleone seeks forgiveness for his sins while taking a young protege under his wing.', 'US');

INSERT INTO Rôle VALUES
-- Blade Runner
(78,3,'Rick Deckard'),
(85,3,'Indiana Jones'),
-- Apocalypse now
(28,3,'Colonel Lucas'),
(28,3084,'Colonel Walter Kurtz'),
(28,3087,'Colonel Bill Kilgore'),
-- 'Some Like It Hot'
(239,3149,'Sugar Kane Kowalczyk'),
(239,3150,'Joe / Joséphine '),
(239,3151,'Jerry / Géraldine');

-- Internaute(email,nom,prénom,région)
INSERT INTO Internaute VALUES
('paul.hinome@mail.fr','hinome','paul','FR'),
('john.doe@mail.us','doe','john','US'),
('paul.position@mail.de','position','paul','DE');

-- Notation(email,idFilm,note)
INSERT INTO Notation VALUES
('paul.hinome@mail.fr',11,8),
('paul.hinome@mail.fr',15,7),
('paul.hinome@mail.fr',28,8),
('paul.hinome@mail.fr',38,6),
('paul.hinome@mail.fr',59,9),
('paul.hinome@mail.fr',62,7),
('john.doe@mail.us',11,6),
('john.doe@mail.us',78,9),
('john.doe@mail.us',85,8),
('john.doe@mail.us',87,6),
('john.doe@mail.us',89,9),
('john.doe@mail.us',103,8),
('paul.position@mail.de',11,7),
('paul.position@mail.de',147,9),
('paul.position@mail.de',180,7),
('paul.position@mail.de',192,9);