-- phpMyAdmin SQL Dump
-- version 3.3.2deb1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mar 06 Septembre 2011 à 14:56
-- Version du serveur: 5.1.41
-- Version de PHP: 5.3.2-1ubuntu4.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données: `Base_des_films`
--
-- --------------------------------------------------------
--
-- Structure de la table `acteurs`
--
CREATE TABLE IF NOT EXISTS `acteurs` (
`id` int(11) NOT NULL,
`nom` varchar(35) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `acteurs`
--
INSERT INTO `acteurs` (`id`, `nom`) VALUES
(1, 'Woody Allen'),
(2, 'Clint Eastwood'),
(3, 'Robert De Niro'),
(6, 'Harrison Ford'),
(8, 'Tom Hanks'),
(12, 'Al Pacino'),
(13, 'Bruce Willis'),
(16, 'Gene Hackman'),
(24, 'Danny DeVito'),
(25, 'Tim Robbins'),
(27, 'Dustin Hoffman'),
(28, 'Francis Ford Coppola'),
(32, 'John Cusack'),
(34, 'John Travolta'),
(36, 'Robert Redford'),
(39, 'Anthony Hopkins'),
(41, 'Denzel Washington'),
(42, 'Paul Newman'),
(43, 'Jack Nicholson'),
(44, 'Robert Duvall'),
(50, 'Matthew Broderick'),
(54, 'Sigourney Weaver'),
(59, 'Terry Gilliam'),
(63, 'Meryl Streep'),
(73, 'Harvey Keitel'),
(75, 'Cary Grant'),
(76, 'Kevin Spacey'),
(85, 'Marlon Brando'),
(89, 'Samuel L. Jackson'),
(90, 'Roman Polanski'),
(91, 'Morgan Freeman'),
(94, 'Diane Keaton'),
(99, 'Christopher Walken'),
(100, 'Liam Neeson'),
(106, 'Jack Lemmon'),
(115, 'Peter Sellers'),
(118, 'James Stewart'),
(123, 'Frank Oz'),
(125, 'Dennis Hopper'),
(127, 'Jack Warden'),
(130, 'Bill Paxton'),
(145, 'Charles Chaplin'),
(152, 'Joan Cusack'),
(158, 'Billy Crystal'),
(160, 'Max von Sydow'),
(164, 'Gregory Peck'),
(165, 'Charlton Heston'),
(167, 'Donald Pleasence'),
(170, 'John Wayne'),
(177, 'Ralph Fiennes'),
(181, 'Matt Damon'),
(182, 'Faye Dunaway'),
(183, 'William Holden'),
(186, 'Steve Buscemi'),
(195, 'John Cleese'),
(211, 'Gwyneth Paltrow'),
(213, 'Humphrey Bogart'),
(215, 'Jodie Foster'),
(217, 'J.T. Walsh'),
(222, 'Cary Elwes'),
(225, 'Anne Bancroft'),
(226, 'William H. Macy'),
(235, 'Richard Attenborough'),
(239, 'Ian Holm'),
(243, 'Uma Thurman'),
(244, 'Michael Madsen'),
(246, 'Dan Hedaya'),
(247, 'Albert Brooks'),
(249, 'Annette Bening'),
(250, 'James Caan'),
(252, 'Lance Henriksen'),
(253, 'Orson Welles'),
(258, 'Brad Pitt'),
(259, 'Joe Pesci'),
(279, 'Steve McQueen'),
(282, 'Cameron Diaz'),
(295, 'Harry Dean Stanton'),
(298, 'Billy Bob Thornton'),
(301, 'Peter Boyle'),
(302, 'Benicio Del Toro'),
(304, 'Malcolm McDowell'),
(306, 'Martin Sheen'),
(307, 'Bonnie Hunt'),
(308, 'Gabriel Byrne'),
(312, 'John Huston'),
(318, 'Tom Sizemore'),
(324, 'Russell Crowe'),
(329, 'Ben Kingsley'),
(331, 'Laurence Fishburne'),
(333, 'Minnie Driver'),
(336, 'Jürgen Prochnow'),
(340, 'Shirley MacLaine'),
(342, 'Claire Danes'),
(345, 'Henry Fonda'),
(348, 'Giovanni Ribisi'),
(352, 'Christopher Guest'),
(354, 'Charles Durning'),
(355, 'Ving Rhames'),
(356, 'Tom Skerritt'),
(357, 'Bruno Kirby'),
(360, 'George Lucas'),
(368, 'Rosanna Arquette'),
(370, 'Laurence Olivier'),
(373, 'Lloyd Bridges'),
(393, 'Yun-Fat Chow'),
(404, 'Kirk Douglas'),
(417, 'David Morse'),
(427, 'Edward Norton'),
(429, 'Katharine Hepburn'),
(431, 'James Cromwell'),
(436, 'Carol Kane'),
(437, 'M. Emmet Walsh'),
(438, 'John Hurt'),
(439, 'Jeffrey Jones'),
(441, 'Chazz Palminteri'),
(442, 'Joaquin Phoenix'),
(443, 'Philip Seymour Hoffman'),
(444, 'Quentin Tarantino'),
(449, 'Vincent D''Onofrio'),
(453, 'Martin Balsam'),
(460, 'Giancarlo Esposito'),
(462, 'Carrie Fisher'),
(463, 'Sissy Spacek'),
(472, 'James Coburn'),
(474, 'Natalie Wood'),
(476, 'George Kennedy'),
(479, 'George C. Scott'),
(481, 'Oliver Reed'),
(482, 'R. Lee Ermey'),
(485, 'Edward Burns (I)'),
(489, 'Don Taylor (I)'),
(493, 'Michael Biehn'),
(494, 'Cloris Leachman'),
(495, 'Frances McDormand'),
(496, 'Catherine Deneuve'),
(502, 'Talia Shire'),
(503, 'John Malkovich'),
(507, 'Bob Gunton'),
(509, 'Simon Callow'),
(512, 'Matthew Modine'),
(515, 'Brion James'),
(518, 'Martin Landau'),
(519, 'Christopher Plummer'),
(520, 'Stephen Tobolowsky'),
(527, 'Denholm Elliott'),
(528, 'Kevin Pollak'),
(534, 'Lauren Bacall'),
(536, 'Robin Wright'),
(539, 'Elizabeth Taylor'),
(541, 'Lindsay Crouse'),
(546, 'James Earl Jones'),
(549, 'Gina Gershon'),
(550, 'Ben Gazzara'),
(552, 'Mark Hamill'),
(554, 'Hume Cronyn'),
(555, 'Teri Garr'),
(558, 'Shelley Duvall'),
(560, 'Philip Baker Hall'),
(578, 'Toni Collette'),
(587, 'Mike Starr (I)'),
(591, 'Daryl Hannah'),
(594, 'Beverly D''Angelo'),
(625, 'Peter Sallis'),
(626, 'Gene Kelly'),
(629, 'George Dzundza'),
(634, 'Graham Chapman'),
(643, 'Veronica Cartwright'),
(680, 'Chris Sarandon'),
(682, 'Melinda Dillon'),
(684, 'Tim Allen'),
(687, 'John Ritter'),
(688, 'Takashi Shimura'),
(693, 'John Milius'),
(694, 'Terry Jones'),
(698, 'Keith David (I)'),
(702, 'Eric Stoltz'),
(710, 'Chris Penn'),
(711, 'Murray Hamilton'),
(713, 'Brian Cox'),
(716, 'Helena Bonham Carter'),
(719, 'Warren Oates'),
(722, 'Ernest Borgnine'),
(725, 'Eileen Brennan'),
(728, 'Chris Cooper (I)'),
(731, 'William Daniels (I)'),
(735, 'Toshirô Mifune'),
(736, 'Embeth Davidtz'),
(743, 'Rip Torn'),
(745, 'Udo Kier'),
(747, 'Scott Glenn'),
(749, 'Eric Idle'),
(751, 'Rod Steiger'),
(752, 'Dennis Farina'),
(757, 'Ray Walston'),
(762, 'Debi Mazar'),
(763, 'Louise Fletcher'),
(770, 'Fairuza Balk'),
(775, 'Rade Serbedzija'),
(776, 'Ray Liotta'),
(780, 'Joseph Cotten'),
(791, 'Tim Roth'),
(792, 'Jean-Marc Barr'),
(799, 'Michael Palin'),
(802, 'James Mason'),
(805, 'Richard Burton'),
(811, 'Irène Jacob'),
(815, 'Luis Buñuel'),
(820, 'Roberto Benigni'),
(827, 'Ingrid Bergman'),
(828, 'Bette Davis'),
(831, 'Edward Furlong'),
(833, 'Colleen Camp'),
(837, 'John Carradine'),
(839, 'Bernard Lee (I)'),
(845, 'Robert Stack'),
(849, 'Amanda Plummer'),
(862, 'Pete Postlethwaite'),
(881, 'Peter Gallagher'),
(887, 'Ed O''Ross'),
(891, 'Tom Hulce'),
(892, 'Teresa Wright'),
(893, 'James Garner'),
(899, 'Gunnar Björnstrand'),
(900, 'Strother Martin'),
(907, 'Joe Grifasi'),
(915, 'Marilyn Monroe'),
(925, 'Alec Guinness'),
(930, 'John Savage'),
(933, 'Karen Allen'),
(937, 'John Cazale'),
(938, 'Kim Hunter'),
(941, 'Robert Mitchum'),
(943, 'Anthony Quinn'),
(946, 'Gillian Anderson'),
(947, 'Elliott Gould'),
(963, 'Allen Garfield'),
(964, 'F. Murray Abraham'),
(969, 'Thora Birch'),
(981, 'Groucho Marx'),
(984, 'William Sadler'),
(986, 'Caroline Goodall'),
(1005, 'Edward James Olmos'),
(1024, 'Penélope Cruz'),
(1031, 'Grace Kelly'),
(1038, 'Paul Sorvino'),
(1045, 'Fred MacMurray'),
(1056, 'George Sanders'),
(1077, 'Thomas Mitchell (I)'),
(1100, 'Rutger Hauer'),
(1108, 'Clark Gable'),
(1128, 'Claude Rains'),
(1145, 'Sean Young'),
(1148, 'Bibi Andersson'),
(1162, 'Don Rickles'),
(1165, 'Kelsey Grammer'),
(1176, 'Diane Venora'),
(1181, 'Annie Potts'),
(1183, 'Charles Laughton'),
(1184, 'Robert Shaw'),
(1187, 'Patricia Clarkson'),
(1195, 'Ted Danson'),
(1198, 'Frederic Forrest'),
(1202, 'Clancy Brown'),
(1207, 'Anna Paquin'),
(1215, 'Jason Lee (I)'),
(1217, 'Everett McGill'),
(1221, 'Peter Falk'),
(1222, 'Wallace Shawn'),
(1230, 'E.G. Marshall'),
(1231, 'Ralph Bellamy'),
(1232, 'Kasi Lemmons'),
(1233, 'Cliff De Young'),
(1234, 'Michael Gambon'),
(1239, 'James Hampton'),
(1242, 'Jeffrey DeMunn'),
(1243, 'Stephen Baldwin'),
(1248, 'Connie Nielsen'),
(1249, 'Tony Burton'),
(1250, 'Vin Diesel'),
(1252, 'Piper Laurie'),
(1255, 'Graham Greene (II)'),
(1257, 'George Segal'),
(1266, 'Yaphet Kotto'),
(1276, 'Ward Bond'),
(1286, 'Andre Braugher'),
(1290, 'Henry Jones (I)'),
(1305, 'Tony Roberts (I)'),
(1308, 'Michael Jeter'),
(1310, 'Bruce McGill'),
(1313, 'Peter Stormare'),
(1314, 'Patrick McGoohan'),
(1322, 'Leo G. Carroll'),
(1323, 'Cathy Moriarty'),
(1329, 'Paul Bartel'),
(1333, 'Kenneth Mars'),
(1336, 'Porter Hall'),
(1342, 'James Cosmo'),
(1344, 'Joanna Cassidy'),
(1346, 'Jack MacGowran'),
(1351, 'Lee Van Cleef'),
(1353, 'Jason Robards'),
(1370, 'Ed Binns'),
(1376, 'Billy Crudup'),
(1377, 'Wallace Ford'),
(1390, 'Claudia Cardinale'),
(1396, 'Tony Darrow'),
(1402, 'Mary Kay Place'),
(1406, 'Otto Preminger'),
(1414, 'Olivia Williams'),
(1419, 'Katharine Ross'),
(1420, 'Elizabeth Wilson (I)'),
(1427, 'Keir Dullea'),
(1430, 'Marco Leonardi'),
(1437, 'Trevor Howard'),
(1438, 'Rosalind Russell'),
(1442, 'Karl Malden'),
(1443, 'Julie Walters'),
(1449, 'Jack Hawkins'),
(1450, 'James Hong'),
(1453, 'Sterling Hayden'),
(1458, 'Roy Dotrice'),
(1461, 'Danny Kaye'),
(1464, 'Myrna Loy'),
(1467, 'Charles Bronson'),
(1471, 'Sofia Coppola'),
(1472, 'Michelle Yeoh'),
(1476, 'Sihung Lung'),
(1488, 'Maureen O''Hara'),
(1491, 'Ruth Warrick'),
(1496, 'John Williams (II)'),
(1509, 'Jean Arthur'),
(1524, 'Vivien Leigh'),
(1526, 'Warren Clarke'),
(1527, 'Farley Granger'),
(1536, 'Walter Brennan'),
(1543, 'William Powell'),
(1544, 'Akira Terao'),
(1545, 'Lee J. Cobb'),
(1546, 'Angela Lansbury'),
(1552, 'Richard Farnsworth'),
(1553, 'Glynis Johns'),
(1554, 'Kenneth Tsang'),
(1557, 'Peter Graves (I)'),
(1565, 'Allison Janney'),
(1570, 'Frankie Faison'),
(1574, 'Derek Jacobi'),
(1576, 'Anthony Heald'),
(1579, 'Ronald Lacey'),
(1582, 'G.D. Spradlin'),
(1586, 'Jeff Corey'),
(1591, 'Sam Rockwell'),
(1615, 'Lorraine Bracco'),
(1619, 'Lena Olin'),
(1623, 'Albert Hall (I)'),
(1640, 'Paul Giamatti'),
(1651, 'Judith Anderson'),
(1653, 'Barry Pepper'),
(1655, 'Anthony Daniels'),
(1660, 'James Whitmore'),
(1669, 'Elsa Lanchester'),
(1678, 'John Rhys-Davies'),
(1679, 'Edward G. Robinson'),
(1698, 'Tatsuya Nakadai'),
(1704, 'Darren McGavin'),
(1709, 'Cybill Shepherd'),
(1715, 'Michael Clarke Duncan'),
(1717, 'Janet Leigh'),
(1720, 'Michael Bates (I)'),
(1725, 'Stacy Keach'),
(1726, 'Ben Johnson (I)'),
(1727, 'Billy Dee Williams'),
(1736, 'Christine Ebersole'),
(1742, 'Harry Morgan'),
(1743, 'Pupella Maggio'),
(1748, 'Wayne Knight'),
(1750, 'Slim Pickens'),
(1762, 'Colm Feore'),
(1766, 'Lew Ayres'),
(1772, 'Anatoli Solonitsyn'),
(1774, 'Keenan Wynn'),
(1781, 'Joel Grey'),
(1784, 'Victor Argo'),
(1789, 'Mildred Natwick'),
(1792, 'Jack Kehoe'),
(1797, 'Stefan Gierasch'),
(1801, 'Jenette Goldstein'),
(1802, 'Zach Grenier'),
(1803, 'Zeljko Ivanek'),
(1808, 'Mark Rolston'),
(1813, 'Richard Harris'),
(1814, 'David Proval'),
(1817, 'Frank Vincent (I)'),
(1824, 'William Windom'),
(1827, 'Laurie Metcalf'),
(1831, 'Adam Baldwin'),
(1835, 'Patrick Magee (I)'),
(1845, 'Robert Webber (I)'),
(1847, 'John Hillerman'),
(1860, 'Billy Gilbert (I)'),
(1864, 'Mel Smith'),
(1868, 'Suzy Amis'),
(1881, 'Abe Vigoda'),
(1895, 'Ted Levine'),
(1901, 'Leslie Carlson'),
(1906, 'Cecil B. DeMille'),
(1909, 'Barry Dennen'),
(1913, 'Adam Goldberg'),
(1933, 'Paul Reiser'),
(1939, 'Sean McGinley'),
(1946, 'Minoru Chiaki'),
(1951, 'Jeremy Davies'),
(1953, 'Ethan Suplee'),
(1961, 'Nicoletta Braschi'),
(1966, 'Djimon Hounsou'),
(1976, 'Erland Josephson'),
(1977, 'Jean-Pierre Léaud'),
(1985, 'Jessie Royce Landis'),
(1989, 'Robert J. Wilke'),
(1996, 'Miki Manojlovic'),
(2000, 'Barry Fitzgerald'),
(2003, 'Anne Baxter'),
(2009, 'Errol Flynn'),
(2012, 'Henry Travers'),
(2030, 'Fernanda Montenegro'),
(2034, 'Henry Bergman'),
(2049, 'Arletty'),
(2070, 'Kamatari Fujiwara'),
(2076, 'Erich von Stroheim'),
(2078, 'Hermione Baddeley'),
(2081, 'Eli Wallach'),
(2083, 'Antonella Attili'),
(2085, 'Bajram Severdzan'),
(2100, 'Gene Lockhart'),
(2104, 'Gaspard Manesse'),
(2113, 'Alastair Sim'),
(2123, 'Lee Remick'),
(2141, 'Gladys Cooper'),
(2143, 'Élodie Bouchez'),
(2147, 'Gary Cooper'),
(2159, 'Grégoire Colin'),
(2171, 'Frank Overton'),
(2173, 'Harpo Marx'),
(2177, 'Kristina Adolphson'),
(2192, 'Basil Rathbone'),
(2198, 'Fred Clark (I)'),
(2202, 'Gabriele Ferzetti'),
(2210, 'Gustav Botz'),
(2225, 'Haley Joel Osment'),
(2227, 'Fredric March'),
(2229, 'Alexandra Dahlström'),
(2238, 'Carole Lombard'),
(2246, 'Cecilia Roth'),
(2268, 'Jean Gabin'),
(2313, 'Claire Trevor'),
(2319, 'Cindy Williams (I)'),
(2321, 'Joan Fontaine'),
(2329, 'Chico Marx'),
(2333, 'Jennifer Lien'),
(2381, 'Björk'),
(2393, 'Jack Carson (I)'),
(2396, 'Jack Kruschen'),
(2412, 'Judy Garland'),
(2416, 'Dorian Harewood'),
(2446, 'James Robinson (II)'),
(2465, 'James Donald (I)'),
(2475, 'Debbie Reynolds'),
(2484, 'Boris Karloff'),
(2486, 'Olivia de Havilland'),
(2495, 'Sam Bottoms'),
(2505, 'Vincent Gardenia'),
(2534, 'Nikolai Grinko'),
(2538, 'Victor Sjöström'),
(2553, 'Robert Strauss (I)'),
(2576, 'Paul Freeman (I)'),
(2604, 'Marion Mack'),
(2624, 'Michael Hordern'),
(2635, 'Vera Miles'),
(2648, 'Michael Constantine'),
(2649, 'Tom Helmore'),
(2650, 'Tsutomu Tatsumi'),
(2662, 'Tony Curtis'),
(2672, 'Mieko Harada'),
(2723, 'Maureen O''Sullivan'),
(2724, 'Montgomery Clift'),
(2728, 'Tyrone Power'),
(2748, 'Robert Morley (I)'),
(2773, 'Magali Noël'),
(2792, 'Peter Lorre'),
(2800, 'Yôji Matsuda'),
(2812, 'Luigi Pistilli'),
(2821, 'Pierre Batcheff'),
(2832, 'Raymond Massey (I)'),
(2834, 'Shelley Winters'),
(2872, 'Walter Gotell'),
(2881, 'Kenny Baker (I)'),
(2882, 'Jason Flemyng'),
(2883, 'Ian Wolfe'),
(2891, 'Richard Bright'),
(2894, 'Scatman Crothers'),
(2900, 'Amy Wright'),
(2905, 'Brock Peters'),
(2911, 'Jay O. Sanders'),
(2915, 'Philip Stone (I)'),
(2920, 'Buck Henry'),
(2935, 'Ewen Bremner'),
(2936, 'Bo Hopkins'),
(2937, 'Alfred Molina'),
(2939, 'Leonard Rossiter'),
(2941, 'Catherine Keener'),
(2942, 'John Finn'),
(2945, 'Diane Ladd'),
(2950, 'Sheb Wooley'),
(2953, 'Mena Suvari'),
(2957, 'John Fiedler (I)'),
(2973, 'Leopoldo Trieste'),
(2981, 'David Andrews (I)'),
(2986, 'Clifton James'),
(2991, 'Siobhan Fallon'),
(2998, 'Philippe Morier-Genoud'),
(2999, 'Evelyn Keyes'),
(3003, 'Meat Loaf'),
(3004, 'Janet Margolin'),
(3005, 'Arthur O''Connell'),
(3006, 'John Ratzenberger'),
(3017, 'Harve Presnell'),
(3018, 'Peter Greene (I)'),
(3020, 'Harold Gould'),
(3031, 'L.Q. Jones'),
(3039, 'Henry Daniell'),
(3046, 'Gary Lewis (III)'),
(3059, 'Dylan Bruno'),
(3065, 'Alan North'),
(3070, 'Spencer Treat Clark'),
(3074, 'Lucas Black (II)'),
(3101, 'Patric Knowles'),
(3107, 'Hugh Marlowe'),
(3110, 'Hugh Griffith (I)'),
(3111, 'Paul Henreid'),
(3119, 'Jim Varney'),
(3120, 'Hoagy Carmichael'),
(3123, 'Ralph Carlsson'),
(3124, 'Charley Grapewin'),
(3126, 'Ralph Meeker'),
(3127, 'Howard St. John'),
(3132, 'Richard Basehart'),
(3137, 'Paulette Goddard'),
(3138, 'Stephen Young (I)'),
(3141, 'Sig Ruman'),
(3149, 'Scott Bakula'),
(3153, 'Fernando Fernán Gómez'),
(3157, 'Stanislas Carré de Malberg'),
(3161, 'James Gleason (I)'),
(3165, 'Theodore Bikel'),
(3173, 'Perry Lopez'),
(3175, 'Finlay Currie'),
(3178, 'Peter Mayhew (II)'),
(3181, 'Nigel Bruce'),
(3190, 'Raymond Burr'),
(3198, 'Srdjan Todorovic'),
(3213, 'Hattie McDaniel'),
(3215, 'Carol Cleveland'),
(3228, 'Jean Hagen'),
(3233, 'Moroni Olsen'),
(3234, 'Peter Cushing'),
(3237, 'Randy Brooks (I)'),
(3243, 'Dana Elcar'),
(3244, 'Peter Bull (I)'),
(3247, 'Marlene Dietrich'),
(3253, 'David Schofield'),
(3260, 'Josephine Hull'),
(3261, 'Anthony Higgins'),
(3268, 'Ruth White (II)'),
(3273, 'Sam Jaffe (I)'),
(3280, 'Andy Devine (I)'),
(3298, 'Arliss Howard'),
(3301, 'Barry Nelson (I)'),
(3307, 'Tracy Reed (I)'),
(3312, 'Michael Angarano'),
(3326, 'Donald O''Connor'),
(3330, 'Kate Hudson'),
(3344, 'Lee Strasberg'),
(3345, 'Louis Calhern'),
(3347, 'Rita Moreno'),
(3362, 'Maria de Medeiros'),
(3366, 'Margaret Dumont'),
(3368, 'Roscoe Karns'),
(3370, 'Dorothy Malone'),
(3372, 'Kirk Baltz'),
(3377, 'Dwight Yoakam'),
(3379, 'Joe Turkel'),
(3390, 'John Qualen'),
(3397, 'Rudy Bond'),
(3403, 'Lynne Thigpen'),
(3413, 'Michael Higgins (I)'),
(3417, 'Edie Adams'),
(3419, 'Peter Brocco'),
(3422, 'Reg E. Cathey'),
(3425, 'Sophie Marceau'),
(3428, 'Tommy Flanagan (I)'),
(3434, 'Eve Arden'),
(3438, 'Alida Valli'),
(3449, 'Paul Calderon'),
(3481, 'Dub Taylor'),
(3498, 'David Hemmings (I)'),
(3500, 'Robert Beatty (I)'),
(3501, 'Dimitra Arliss'),
(3507, 'Mandy Patinkin'),
(3511, 'Les Tremayne'),
(3514, 'Henry Victor'),
(3523, 'Jihmi Kennedy'),
(3527, 'Curt Bois'),
(3530, 'Estelle Harris'),
(3533, 'Horst Buchholz'),
(3552, 'George Raft'),
(3561, 'George Macready'),
(3564, 'Robert Ryan'),
(3575, 'Wilfrid Hyde-White'),
(3586, 'Lewis Martin (I)'),
(3592, 'Daisuke Katô (I)'),
(3619, 'Ray Collins (I)'),
(3637, 'Larry Brandenburg'),
(3646, 'Leib Lensky'),
(3655, 'Ernest Thesiger'),
(3664, 'Chester Conklin'),
(3677, 'Don Keefer'),
(3681, 'Macdonald Carey'),
(3697, 'Sam Robards'),
(3705, 'Orson Bean'),
(3707, 'David Prowse'),
(3729, 'Cara Seymour'),
(3733, 'Sean Sullivan (I)'),
(3737, 'Norman Fell'),
(3738, 'Victor Jory (I)'),
(3739, 'John Shrapnel'),
(3740, 'Elisha Cook Jr.'),
(3750, 'Mischa Barton'),
(3756, 'Jens Albinus'),
(3761, 'Thelma Ritter'),
(3767, 'John Ridgely'),
(3774, 'Minna Gombell'),
(3792, 'Edward Brophy'),
(3794, 'James Sloyan'),
(3796, 'Michael Berryman'),
(3797, 'Marisa Paredes'),
(3809, 'Fortunio Bonanova'),
(3821, 'Richard Davalos'),
(3827, 'John Clive'),
(3838, 'Brent Briscoe'),
(3844, 'Tim Holt'),
(3846, 'Vinnie Jones'),
(3857, 'Conrad Veidt'),
(3858, 'Scott Schwartz'),
(3861, 'Daniel Zacapa'),
(3865, 'Connie Booth'),
(3871, 'Coleen Gray'),
(3883, 'Sandy Dennis'),
(3898, 'Samuel Le Bihan'),
(3902, 'Collin Wilcox Paxton'),
(3907, 'Colleen Dewhurst'),
(3910, 'Danny Lloyd'),
(3914, 'Colin Clive'),
(3916, 'Sandy Nelson (II)'),
(3921, 'Danny Lee (I)'),
(3952, 'Dana Andrews'),
(3956, 'Seiji Miyaguchi'),
(3966, 'Ruth Hussey'),
(3970, 'Ruth Roman'),
(3971, 'Sergio Bini Bustric'),
(3985, 'Sessue Hayakawa'),
(3987, 'Daisuke Ryu'),
(3988, 'Rosemary Murphy'),
(3991, 'Sean Lawlor'),
(4000, 'Seizaburô Kawazu'),
(4004, 'Daniel Richter (I)'),
(4022, 'Salvador Dalí'),
(4023, 'Sally Yeh (I)'),
(4052, 'Vinícius de Oliveira'),
(4060, 'Anne Reid'),
(4073, 'Antonia San Juan'),
(4082, 'Victor McLaglen'),
(4093, 'Virginia Mayo'),
(4124, 'Barton MacLane'),
(4133, 'Barbara Stanwyck'),
(4141, 'Bengt Ekerot'),
(4154, 'Armando Brancia'),
(4159, 'Arnold Lucy'),
(4169, 'Andrew Kevin Walker'),
(4171, 'Ayano Shiraishi'),
(4174, 'Barbara Bel Geddes'),
(4178, 'Valerie Hobson'),
(4182, 'Avery Brooks'),
(4188, 'Börje Ahlstedt'),
(4190, 'Yoshiko Shinohara'),
(4195, 'Yûko Tanaka'),
(4196, 'Alan Hale'),
(4199, 'Akim Tamiroff'),
(4201, 'Akihiro Miwa'),
(4202, 'Akemi Yamaguchi'),
(4207, 'Albert Rémy'),
(4209, 'William Sylvester'),
(4218, 'Wolfgang Heinz'),
(4233, 'Zeppo Marx'),
(4236, 'Zhang Ziyi'),
(4241, 'Yoshio Inaba'),
(4242, 'Agnes Moorehead'),
(4248, 'Yuriko Ishida'),
(4253, 'Adolphe Menjou'),
(4258, 'Aldo Giuffrè'),
(4259, 'Wayne Morris (I)'),
(4260, 'Wendell Corey'),
(4274, 'Walter Huston'),
(4278, 'Walter Catlett'),
(4283, 'Allan Jones'),
(4293, 'William Hope'),
(4304, 'William Redfield'),
(4309, 'Aldo Silvani (I)'),
(4323, 'Alexander Granach'),
(4324, 'Wes Bentley'),
(4335, 'Chen Chang'),
(4339, 'Charles Smith (V)'),
(4340, 'Charles Ruggles'),
(4344, 'Stephen Boyd'),
(4352, 'Charles Kay'),
(4362, 'Cathy O''Donnell (I)'),
(4389, 'Celeste Holm'),
(4392, 'Cecil Parker (I)'),
(4396, 'Soia Lira'),
(4399, 'Claire Maurier'),
(4401, 'Clarence Kolb'),
(4403, 'Slim Summerville'),
(4408, 'Ciccio Ingrassia'),
(4415, 'Cliff Edwards'),
(4417, 'Simone Mareuil'),
(4428, 'Stefan Hörberg'),
(4450, 'Chu Kong'),
(4492, 'Branka Katic'),
(4503, 'Beulah Bondi'),
(4504, 'Tiny Sandford'),
(4510, 'Bert Lahr'),
(4526, 'Tom Murray (I)'),
(4535, 'Candela Peña'),
(4552, 'Carrie Henn'),
(4594, 'Bruce Bennett'),
(4601, 'Jinpachi Nezu'),
(4608, 'Jo Van Fleet'),
(4619, 'Jo Prestia'),
(4628, 'Joan Shawlee'),
(4636, 'Joanne Dru'),
(4657, 'Mathias Rust (I)'),
(4662, 'Jim Farley (I)'),
(4684, 'John Megna'),
(4705, 'John Terry (I)'),
(4716, 'John Ireland'),
(4736, 'Millard Mitchell'),
(4738, 'Mervyn Johns'),
(4741, 'Melville Cooper'),
(4743, 'John Howard (I)'),
(4749, 'John Gottowt'),
(4755, 'John Farley'),
(4761, 'Jamie Draven'),
(4762, 'Jamie Bell'),
(4788, 'Jane Darwell'),
(4790, 'Nicholas Colasanto (I)'),
(4805, 'Nikolai Sergeyev'),
(4815, 'Othon Bastos'),
(4817, 'Nils Poppe'),
(4822, 'Nobuo Kaneko'),
(4836, 'Myron McCormick'),
(4851, 'Jean-Pierre Lorit'),
(4865, 'Jeffrey Hunter'),
(4883, 'Natalie Canerday'),
(4884, 'Ned Bellamy'),
(4895, 'Nat Pendleton'),
(4898, 'Jean-Louis Trintignant'),
(4899, 'Jean-Louis Barrault'),
(4900, 'Nancy Olson'),
(4901, 'Nando Orfei'),
(4908, 'Natacha Régnier'),
(4909, 'Jean Heywood'),
(4910, 'Jean Heather'),
(4918, 'Kristin Rudrüd'),
(4919, 'Kristian Almgren'),
(4923, 'Machiko Kyô'),
(4924, 'Klaus Wennemann'),
(4927, 'Kitty Carlisle'),
(4946, 'Kyôko Seki'),
(4949, 'Kumeko Urabe'),
(4952, 'Mack Swain'),
(4957, 'Kevin P. Farley'),
(4966, 'Marília Pêra'),
(4971, 'John Wray (I)'),
(4977, 'Madeleine LeBeau'),
(4981, 'Makoto Kobori'),
(4985, 'Madison Lanc'),
(4992, 'Kim Novak'),
(5002, 'Leopoldine Konstantin'),
(5003, 'Leslie Howard'),
(5006, 'Leonard Harris (II)'),
(5010, 'Leo Gullotta'),
(5011, 'Ljubica Adzovic'),
(5017, 'Lionel Atwill'),
(5019, 'Lillian Gish'),
(5034, 'Louis Wolheim'),
(5064, 'Lou Antonio'),
(5068, 'Lawrence T. Wrentz'),
(5070, 'Lawrence A. Bonney'),
(5085, 'Martha Vickers'),
(5126, 'Masayuki Mori (I)'),
(5132, 'Martin Semmelrogge'),
(5136, 'Joseph Calleia'),
(5138, 'Jonathan Sagall'),
(5139, 'Zooey Deschanel'),
(5160, 'Maria Casarès'),
(5163, 'Kathleen Harrison'),
(5173, 'Marcella Rovere'),
(5177, 'Katy Jurado'),
(5195, 'Jullan Kindahl'),
(5201, 'Julien Carette'),
(5214, 'Karl Etlinger'),
(5223, 'Kaoru Kobayashi'),
(5239, 'Francine Racette'),
(5242, 'Frédérique Feder'),
(5254, 'Frank Morgan (I)'),
(5258, 'Florijan Ajdini'),
(5264, 'Francis De Wolff'),
(5272, 'Richmond Arquette'),
(5273, 'Evelyn Varden'),
(5279, 'Eva Marie Saint'),
(5281, 'Eugene Pallette'),
(5297, 'Felix Bressart'),
(5300, 'Richard S. Castellano'),
(5312, 'Raphael Fejtö'),
(5318, 'Ray Bolger'),
(5330, 'Georgia Hale'),
(5342, 'Georges Flamant'),
(5358, 'Richard Allen (I)'),
(5359, 'Richard Anderson (I)'),
(5364, 'Gary Merrill'),
(5365, 'Gary Lockwood'),
(5378, 'Reginald Gardiner'),
(5382, 'Dorris Bowdon'),
(5392, 'Douglas Rain'),
(5403, 'Edmond O''Brien'),
(5410, 'Dorothy Comingore'),
(5413, 'Ed Begley'),
(5416, 'Robert Walker (I)'),
(5435, 'Dita Parlo'),
(5441, 'Donnie Wahlberg'),
(5448, 'Edward Arnold'),
(5462, 'Enzo Cannavale'),
(5489, 'Erica Carlson (II)'),
(5490, 'Eric Weinstein'),
(5501, 'Eleanor Coppola'),
(5507, 'Eijirô Tono'),
(5511, 'Edward Everett Horton'),
(5527, 'Robert Drivas'),
(5529, 'Elizabeth Berridge'),
(5540, 'Harriet Andersson'),
(5545, 'Paul Simon (I)'),
(5546, 'Herbert Grönemeyer'),
(5554, 'Hubertus Bengsch'),
(5556, 'Paul Hörbiger'),
(5570, 'Peter Billingsley'),
(5572, 'Pernilla Allwin'),
(5573, 'Pernilla August'),
(5574, 'Haya Harareet'),
(5577, 'Harvey Lembeck'),
(5586, 'Harry Carey Jr.'),
(5592, 'Rebecka Liljeberg'),
(5608, 'Patricia Hitchcock'),
(5610, 'Jack Elam'),
(5611, 'Jack Creley'),
(5614, 'Jack Benny'),
(5615, 'J.D. Cannon'),
(5618, 'Jack Haley (I)'),
(5623, 'Ivan Lapikov'),
(5626, 'Patricia Collinge'),
(5632, 'Jackie Gleason'),
(5638, 'Jack Oakie'),
(5641, 'Pat Henning'),
(5643, 'Pat O''Brien'),
(5651, 'Ian Petrella'),
(5665, 'Ingrid Thulin'),
(5668, 'Patrick Fugit'),
(5669, 'Isa Danieli'),
(5670, 'Irma Raush'),
(5683, 'Patrick Mercado'),
(5684, 'Giulietta Masina'),
(5685, 'Giuliana Lojodice'),
(5692, 'Giustino Durano'),
(5700, 'Pierre Brasseur'),
(5705, 'Philip Ober'),
(5709, 'Guy Decomble'),
(5710, 'Pierre Renoir'),
(5714, 'Gloria Swanson'),
(5715, 'Glen Cavender'),
(5717, 'Guy Kibbee'),
(5718, 'Pierre Fresnay'),
(5727, 'Priscilla Lane'),
(5759, 'William Hootkins'),
(5770, 'Frank Adonis'),
(5776, 'Jack Walsh (I)'),
(5777, 'Jude Ciccolella'),
(5778, 'Shane Rimmer'),
(5779, 'Norbert Weisser'),
(5788, 'Jack Purvis'),
(5791, 'James Keane (I)'),
(5799, 'George Furth'),
(5800, 'Edward Bunker'),
(5811, 'Benito Stefanelli'),
(5813, 'Eddra Gale'),
(5829, 'Octavia Spencer'),
(5840, 'Una O''Connor'),
(5842, 'Godfrey Quigley'),
(5861, 'Darrell Zwerling'),
(5862, 'Henry Brandon'),
(5863, 'André Morell'),
(5866, 'Frank Sivero'),
(5883, 'Joyce Jameson'),
(5904, 'Paul Fix'),
(5924, 'H.B. Warner'),
(5934, 'Regis Toomey'),
(5936, 'Manning Redwood'),
(5944, 'Ken Curtis (I)');
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `actors`
--
CREATE TABLE IF NOT EXISTS `actors` (
`id` int(11)
,`name` varchar(35)
);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `ACTORS`
--
CREATE TABLE IF NOT EXISTS `ACTORS` (
`id` int(11)
,`name` varchar(35)
);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `castings`
--
CREATE TABLE IF NOT EXISTS `castings` (
`movieid` int(11)
,`actorid` int(11)
,`ord` int(11)
);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `CASTINGS`
--
CREATE TABLE IF NOT EXISTS `CASTINGS` (
`movieid` int(11)
,`actorid` int(11)
,`ord` int(11)
);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `DIRECTORS`
--
CREATE TABLE IF NOT EXISTS `DIRECTORS` (
`id` int(11)
,`name` varchar(35)
);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `directors`
--
CREATE TABLE IF NOT EXISTS `directors` (
`id` int(11)
,`name` varchar(35)
);
-- --------------------------------------------------------
--
-- Structure de la table `distributions`
--
CREATE TABLE IF NOT EXISTS `distributions` (
`idfilm` int(11) NOT NULL,
`idacteur` int(11) NOT NULL,
`rang` int(11) DEFAULT NULL,
PRIMARY KEY (`idfilm`,`idacteur`),
KEY `idacteur` (`idacteur`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `distributions`
--
INSERT INTO `distributions` (`idfilm`, `idacteur`, `rang`) VALUES
(1, 6, 2),
(1, 462, 3),
(1, 552, 1),
(1, 925, 5),
(1, 1655, 6),
(1, 2881, 7),
(1, 3178, 8),
(1, 3234, 4),
(1, 3707, 9),
(1, 5788, 12),
(2, 25, 1),
(2, 91, 2),
(2, 507, 3),
(2, 984, 4),
(2, 1202, 5),
(2, 1242, 9),
(2, 1660, 8),
(2, 1808, 7),
(2, 1814, 13),
(2, 3637, 10),
(2, 5777, 15),
(3, 13, 12),
(3, 34, 1),
(3, 73, 4),
(3, 89, 2),
(3, 99, 11),
(3, 243, 3),
(3, 355, 8),
(3, 368, 10),
(3, 702, 9),
(3, 791, 5),
(3, 849, 6),
(3, 3018, 15),
(3, 3362, 7),
(3, 3449, 13),
(5, 6, 2),
(5, 123, 9),
(5, 462, 3),
(5, 552, 1),
(5, 925, 10),
(5, 1655, 5),
(5, 1727, 4),
(5, 2881, 8),
(5, 3178, 7),
(5, 3707, 6),
(5, 5788, 13),
(6, 76, 5),
(6, 246, 10),
(6, 302, 3),
(6, 308, 2),
(6, 441, 6),
(6, 460, 9),
(6, 528, 4),
(6, 862, 7),
(6, 1243, 1),
(6, 1329, 11),
(6, 1868, 8),
(7, 100, 1),
(7, 177, 3),
(7, 329, 2),
(7, 736, 6),
(7, 986, 4),
(7, 5138, 5),
(7, 5779, 15),
(8, 8, 1),
(8, 181, 9),
(8, 318, 2),
(8, 348, 7),
(8, 485, 3),
(8, 752, 12),
(8, 1195, 10),
(8, 1250, 6),
(8, 1640, 11),
(8, 1653, 4),
(8, 1913, 5),
(8, 1951, 8),
(8, 3059, 15),
(9, 713, 11),
(9, 1314, 12),
(9, 1342, 4),
(9, 1939, 5),
(9, 2446, 1),
(9, 3425, 14),
(9, 3916, 3),
(9, 3991, 2),
(10, 76, 1),
(10, 249, 2),
(10, 728, 8),
(10, 881, 6),
(10, 969, 3),
(10, 1565, 7),
(10, 2953, 5),
(10, 3149, 9),
(10, 3697, 10),
(10, 4324, 4),
(11, 6, 1),
(11, 527, 7),
(11, 933, 2),
(11, 1579, 4),
(11, 1678, 5),
(11, 2576, 3),
(11, 2937, 6),
(11, 3261, 9),
(11, 5759, 12),
(12, 12, 2),
(12, 44, 4),
(12, 85, 1),
(12, 94, 3),
(12, 250, 6),
(12, 502, 7),
(12, 937, 14),
(12, 1453, 8),
(12, 1881, 12),
(12, 3397, 15),
(12, 5300, 5),
(14, 6, 1),
(14, 437, 5),
(14, 515, 8),
(14, 591, 6),
(14, 1005, 4),
(14, 1100, 2),
(14, 1145, 3),
(14, 1344, 10),
(14, 1450, 11),
(14, 3379, 9),
(15, 39, 1),
(15, 215, 2),
(15, 747, 7),
(15, 1232, 6),
(15, 1570, 9),
(15, 1576, 8),
(15, 1895, 3),
(15, 3646, 15),
(15, 5068, 4),
(15, 5070, 5),
(18, 13, 1),
(18, 578, 3),
(18, 1414, 4),
(18, 2225, 2),
(18, 3750, 5),
(18, 5441, 7),
(21, 91, 1),
(21, 211, 5),
(21, 258, 2),
(21, 482, 10),
(21, 3422, 9),
(21, 3861, 4),
(21, 4169, 3),
(22, 186, 2),
(22, 226, 1),
(22, 495, 3),
(22, 1313, 4),
(22, 3017, 6),
(22, 4918, 5),
(23, 1427, 1),
(23, 2939, 5),
(23, 3500, 7),
(23, 3733, 8),
(23, 4004, 4),
(23, 4209, 3),
(23, 5365, 2),
(23, 5392, 9),
(24, 54, 1),
(24, 130, 6),
(24, 252, 5),
(24, 493, 3),
(24, 1801, 8),
(24, 1808, 10),
(24, 1933, 4),
(24, 4293, 7),
(24, 4552, 2),
(27, 213, 1),
(27, 827, 2),
(27, 1128, 4),
(27, 2792, 7),
(27, 3111, 3),
(27, 3390, 12),
(27, 3527, 14),
(27, 3857, 5),
(27, 4977, 9),
(28, 24, 10),
(28, 43, 1),
(28, 763, 2),
(28, 2894, 8),
(28, 3419, 5),
(28, 3796, 4),
(28, 4304, 3),
(32, 324, 1),
(32, 442, 2),
(32, 481, 4),
(32, 1248, 3),
(32, 1574, 6),
(32, 1813, 5),
(32, 1966, 7),
(32, 3070, 12),
(32, 3253, 8),
(32, 3428, 14),
(32, 3498, 13),
(32, 3739, 9),
(33, 258, 2),
(33, 427, 1),
(33, 716, 10),
(33, 1802, 3),
(33, 2981, 6),
(33, 3003, 4),
(33, 5272, 5),
(34, 304, 1),
(34, 1526, 4),
(34, 1720, 3),
(34, 1835, 2),
(34, 3827, 5),
(34, 5842, 14),
(35, 54, 2),
(35, 239, 6),
(35, 295, 4),
(35, 356, 1),
(35, 438, 5),
(35, 643, 3),
(35, 1266, 7),
(36, 158, 13),
(36, 222, 1),
(36, 352, 4),
(36, 436, 12),
(36, 536, 8),
(36, 680, 3),
(36, 1221, 9),
(36, 1222, 5),
(36, 1864, 11),
(36, 3507, 2),
(39, 73, 1),
(39, 186, 5),
(39, 244, 3),
(39, 444, 10),
(39, 710, 4),
(39, 791, 2),
(39, 3237, 7),
(39, 3372, 8),
(39, 5800, 9),
(40, 253, 1),
(40, 780, 2),
(40, 1491, 5),
(40, 3619, 6),
(40, 3809, 12),
(40, 4242, 4),
(40, 5410, 3),
(41, 115, 1),
(41, 479, 2),
(41, 546, 7),
(41, 1453, 3),
(41, 1750, 5),
(41, 1774, 4),
(41, 3244, 6),
(41, 3307, 8),
(41, 5611, 9),
(41, 5778, 14),
(43, 3, 1),
(43, 259, 3),
(43, 587, 8),
(43, 776, 2),
(43, 1038, 5),
(43, 1396, 7),
(43, 1615, 4),
(43, 1817, 9),
(43, 5866, 6),
(45, 6, 10),
(45, 44, 2),
(45, 85, 1),
(45, 125, 8),
(45, 306, 3),
(45, 331, 7),
(45, 747, 12),
(45, 1198, 4),
(45, 1582, 9),
(45, 1623, 5),
(45, 2495, 6),
(45, 5791, 14),
(49, 59, 4),
(49, 195, 2),
(49, 634, 1),
(49, 694, 5),
(49, 749, 3),
(49, 799, 6),
(49, 3215, 8),
(49, 3865, 7),
(61, 3, 4),
(61, 12, 1),
(61, 44, 2),
(61, 94, 3),
(61, 357, 13),
(61, 502, 6),
(61, 937, 5),
(61, 1582, 9),
(61, 2891, 10),
(61, 3344, 7),
(61, 5866, 14),
(63, 43, 1),
(63, 558, 2),
(63, 1249, 9),
(63, 1909, 12),
(63, 2894, 4),
(63, 2915, 6),
(63, 3301, 5),
(63, 3379, 7),
(63, 3910, 3),
(63, 5936, 14),
(64, 439, 7),
(64, 509, 4),
(64, 891, 2),
(64, 964, 1),
(64, 1458, 5),
(64, 1736, 6),
(64, 2881, 9),
(64, 4352, 8),
(64, 5529, 3),
(65, 3, 1),
(65, 73, 4),
(65, 215, 2),
(65, 247, 3),
(65, 301, 6),
(65, 1709, 7),
(65, 1784, 11),
(65, 5006, 5),
(69, 449, 3),
(69, 482, 4),
(69, 512, 1),
(69, 887, 8),
(69, 1831, 2),
(69, 2416, 5),
(69, 3298, 6),
(69, 4705, 9),
(70, 32, 1),
(70, 282, 2),
(70, 503, 14),
(70, 1402, 7),
(70, 2941, 9),
(70, 3705, 8),
(70, 4884, 3),
(70, 4985, 5),
(70, 5490, 4),
(70, 5829, 6),
(72, 2412, 1),
(72, 3124, 8),
(72, 4510, 4),
(72, 5254, 5),
(72, 5318, 2),
(72, 5618, 3),
(73, 8, 1),
(73, 295, 13),
(73, 307, 3),
(73, 417, 2),
(73, 431, 5),
(73, 1187, 12),
(73, 1242, 11),
(73, 1255, 7),
(73, 1308, 6),
(73, 1591, 9),
(73, 1653, 10),
(73, 1715, 4),
(74, 820, 1),
(74, 1961, 2),
(74, 3533, 12),
(74, 3797, 11),
(74, 3971, 5),
(74, 5685, 4),
(74, 5692, 3),
(82, 427, 1),
(82, 594, 3),
(82, 770, 6),
(82, 831, 2),
(82, 947, 8),
(82, 1725, 9),
(82, 1953, 5),
(82, 2333, 4),
(82, 4182, 7),
(87, 118, 1),
(87, 1031, 2),
(87, 3190, 5),
(87, 3761, 4),
(87, 4260, 3),
(94, 75, 1),
(94, 518, 8),
(94, 802, 3),
(94, 1322, 5),
(94, 1370, 15),
(94, 1985, 4),
(94, 3511, 12),
(94, 5279, 2),
(94, 5705, 7),
(97, 118, 1),
(97, 1290, 5),
(97, 2649, 4),
(97, 4174, 3),
(97, 4992, 2),
(105, 1077, 6),
(105, 1108, 1),
(105, 1524, 2),
(105, 2486, 4),
(105, 2999, 8),
(105, 3213, 5),
(105, 3738, 14),
(105, 5003, 3),
(116, 8, 1),
(116, 152, 3),
(116, 482, 14),
(116, 684, 2),
(116, 1162, 5),
(116, 1165, 4),
(116, 1181, 9),
(116, 1222, 7),
(116, 1748, 10),
(116, 1827, 12),
(116, 3006, 8),
(116, 3119, 6),
(116, 3530, 13),
(121, 44, 12),
(121, 164, 1),
(121, 1824, 13),
(121, 2171, 3),
(121, 2905, 6),
(121, 3268, 5),
(121, 3902, 9),
(121, 3988, 4),
(121, 4684, 2),
(121, 5904, 8),
(123, 27, 2),
(123, 225, 1),
(123, 711, 5),
(123, 731, 4),
(123, 1419, 3),
(123, 1420, 6),
(123, 2920, 11),
(123, 3737, 9),
(123, 5813, 13),
(143, 44, 8),
(143, 217, 3),
(143, 298, 1),
(143, 687, 4),
(143, 1239, 7),
(143, 3074, 5),
(143, 3377, 2),
(143, 3838, 10),
(143, 4883, 6),
(149, 3, 1),
(149, 63, 5),
(149, 99, 4),
(149, 629, 6),
(149, 907, 15),
(149, 930, 3),
(149, 937, 2),
(149, 2900, 12),
(150, 336, 1),
(150, 4924, 3),
(150, 5132, 5),
(150, 5546, 2),
(150, 5554, 4),
(154, 43, 1),
(154, 90, 9),
(154, 182, 2),
(154, 312, 3),
(154, 1450, 15),
(154, 1847, 5),
(154, 2945, 7),
(154, 3173, 4),
(154, 5861, 6),
(159, 127, 5),
(159, 345, 1),
(159, 453, 6),
(159, 1230, 4),
(159, 1370, 9),
(159, 1545, 2),
(159, 1845, 12),
(159, 2957, 7),
(159, 5413, 3),
(161, 36, 2),
(161, 42, 1),
(161, 354, 4),
(161, 725, 6),
(161, 757, 5),
(161, 1184, 3),
(161, 1792, 10),
(161, 3020, 7),
(161, 3243, 9),
(161, 3501, 11),
(161, 3794, 13),
(162, 41, 2),
(162, 50, 1),
(162, 91, 4),
(162, 222, 3),
(162, 507, 11),
(162, 1233, 12),
(162, 1286, 6),
(162, 2911, 15),
(162, 2942, 7),
(162, 3065, 10),
(162, 3523, 5),
(163, 3, 1),
(163, 259, 3),
(163, 1323, 2),
(163, 1817, 4),
(163, 4790, 5),
(163, 5770, 8),
(165, 625, 1),
(186, 12, 1),
(186, 324, 2),
(186, 519, 3),
(186, 520, 8),
(186, 541, 6),
(186, 549, 11),
(186, 560, 5),
(186, 743, 13),
(186, 762, 7),
(186, 1176, 4),
(186, 1234, 12),
(186, 1310, 10),
(186, 1762, 9),
(186, 3403, 14),
(189, 183, 1),
(189, 925, 2),
(189, 1449, 3),
(189, 2465, 5),
(189, 3985, 4),
(189, 5863, 7),
(208, 1, 1),
(208, 94, 2),
(208, 99, 9),
(208, 436, 4),
(208, 558, 6),
(208, 1305, 3),
(208, 3004, 7),
(208, 3907, 8),
(208, 5545, 5),
(211, 165, 1),
(211, 1449, 2),
(211, 3110, 5),
(211, 3175, 9),
(211, 3273, 8),
(211, 4344, 4),
(211, 4362, 7),
(211, 5574, 3),
(211, 5863, 13),
(221, 682, 1),
(221, 1704, 2),
(221, 1901, 13),
(221, 3858, 5),
(221, 5570, 3),
(221, 5651, 4),
(222, 626, 1),
(222, 2475, 3),
(222, 3228, 4),
(222, 3326, 2),
(222, 3347, 8),
(222, 4736, 5),
(225, 36, 2),
(225, 42, 1),
(225, 494, 8),
(225, 900, 4),
(225, 1290, 5),
(225, 1333, 10),
(225, 1419, 3),
(225, 1586, 6),
(225, 3677, 14),
(225, 5799, 7),
(237, 106, 3),
(237, 915, 1),
(237, 2662, 2),
(237, 3552, 4),
(237, 4628, 8),
(237, 5643, 5),
(241, 688, 1),
(241, 735, 2),
(241, 1946, 5),
(241, 2070, 8),
(241, 3592, 6),
(241, 3956, 4),
(241, 4241, 3),
(249, 2, 1),
(249, 1351, 2),
(249, 2081, 4),
(249, 2812, 5),
(249, 4258, 3),
(249, 5811, 13),
(271, 167, 6),
(271, 235, 3),
(271, 279, 1),
(271, 472, 7),
(271, 893, 2),
(271, 1467, 5),
(271, 2465, 4),
(288, 253, 3),
(288, 780, 1),
(288, 839, 10),
(288, 1437, 4),
(288, 3438, 2),
(288, 3575, 11),
(288, 5556, 5),
(299, 213, 1),
(299, 429, 2),
(299, 2748, 3),
(299, 2872, 6),
(299, 3165, 5),
(299, 3244, 4),
(303, 2030, 1),
(303, 4052, 3),
(303, 4396, 4),
(303, 4815, 5),
(303, 4966, 2),
(324, 1430, 5),
(324, 1743, 6),
(324, 2083, 1),
(324, 2973, 8),
(324, 5010, 4),
(324, 5462, 2),
(324, 5669, 3),
(331, 393, 1),
(331, 1472, 2),
(331, 1476, 5),
(331, 4236, 3),
(331, 4335, 4),
(376, 479, 1),
(376, 1370, 4),
(376, 1442, 2),
(376, 1720, 3),
(376, 3138, 5),
(377, 42, 1),
(377, 125, 15),
(377, 476, 2),
(377, 900, 6),
(377, 2986, 8),
(377, 3821, 12),
(377, 4608, 7),
(377, 5064, 4),
(377, 5527, 5),
(377, 5615, 3),
(383, 625, 1),
(383, 4060, 2),
(435, 811, 1),
(435, 3898, 5),
(435, 4851, 4),
(435, 4898, 2),
(435, 5242, 3),
(442, 183, 1),
(442, 1906, 11),
(442, 2076, 3),
(442, 2198, 5),
(442, 4900, 4),
(442, 5714, 2),
(442, 5924, 15),
(453, 118, 2),
(453, 1077, 6),
(453, 1128, 3),
(453, 1336, 14),
(453, 1509, 1),
(453, 4503, 8),
(453, 5281, 7),
(453, 5448, 4),
(453, 5717, 5),
(453, 5924, 9),
(455, 75, 1),
(455, 2393, 4),
(455, 2792, 6),
(455, 2832, 3),
(455, 3161, 7),
(455, 3260, 8),
(455, 3767, 14),
(455, 5511, 5),
(455, 5727, 2),
(473, 828, 1),
(473, 915, 9),
(473, 1056, 3),
(473, 2003, 2),
(473, 3107, 6),
(473, 3761, 10),
(473, 4389, 4),
(473, 5364, 5),
(476, 373, 3),
(476, 1031, 5),
(476, 1077, 2),
(476, 1351, 13),
(476, 1742, 8),
(476, 1989, 14),
(476, 2147, 1),
(476, 2950, 15),
(476, 5177, 4),
(478, 75, 1),
(478, 118, 3),
(478, 429, 2),
(478, 3039, 10),
(478, 3966, 4),
(478, 4743, 5),
(483, 183, 1),
(483, 719, 5),
(483, 722, 2),
(483, 900, 9),
(483, 1726, 7),
(483, 2936, 12),
(483, 3031, 10),
(483, 3481, 13),
(483, 3564, 3),
(483, 5403, 4),
(486, 85, 1),
(486, 751, 4),
(486, 1442, 2),
(486, 1545, 3),
(486, 3397, 12),
(486, 5641, 5),
(510, 1544, 2),
(510, 1698, 1),
(510, 2672, 5),
(510, 3987, 4),
(510, 4601, 3),
(515, 443, 15),
(515, 495, 2),
(515, 770, 11),
(515, 1207, 12),
(515, 1215, 4),
(515, 1376, 1),
(515, 3312, 7),
(515, 3330, 3),
(515, 5139, 6),
(515, 5668, 5),
(518, 404, 1),
(518, 3126, 2),
(518, 3379, 7),
(518, 3561, 4),
(518, 4253, 3),
(518, 4259, 5),
(518, 5359, 6),
(522, 165, 2),
(522, 253, 1),
(522, 1717, 3),
(522, 3247, 7),
(522, 3619, 8),
(522, 4199, 5),
(522, 5136, 4),
(541, 1024, 5),
(541, 2246, 1),
(541, 3153, 7),
(541, 3797, 2),
(541, 4073, 4),
(541, 4535, 3),
(551, 370, 1),
(551, 1056, 3),
(551, 1322, 12),
(551, 1651, 4),
(551, 2141, 5),
(551, 2321, 2),
(551, 3181, 6),
(551, 4741, 9),
(555, 981, 1),
(555, 2173, 2),
(555, 2329, 3),
(555, 3345, 7),
(555, 3366, 5),
(555, 4233, 4),
(565, 213, 1),
(565, 3844, 3),
(565, 4124, 5),
(565, 4274, 2),
(565, 4594, 4),
(570, 463, 1),
(570, 1217, 3),
(570, 1552, 2),
(570, 4755, 4),
(570, 4957, 5),
(570, 5776, 13),
(580, 345, 2),
(580, 1353, 3),
(580, 1390, 1),
(580, 1467, 4),
(580, 1774, 9),
(580, 2202, 5),
(580, 5610, 8),
(582, 1045, 1),
(582, 1336, 4),
(582, 1679, 3),
(582, 3809, 9),
(582, 4133, 2),
(582, 4910, 5),
(584, 213, 1),
(584, 534, 2),
(584, 3370, 5),
(584, 3740, 11),
(584, 3767, 3),
(584, 5085, 4),
(584, 5934, 7),
(589, 145, 1),
(589, 2034, 3),
(589, 3137, 2),
(589, 3664, 5),
(589, 4504, 4),
(644, 170, 1),
(644, 474, 5),
(644, 1276, 4),
(644, 2635, 3),
(644, 3390, 6),
(644, 4865, 2),
(644, 5586, 10),
(644, 5862, 8),
(644, 5944, 9),
(646, 75, 1),
(646, 827, 2),
(646, 1128, 3),
(646, 3233, 7),
(646, 3345, 4),
(646, 5002, 5),
(660, 688, 4),
(660, 735, 1),
(660, 1946, 5),
(660, 3592, 8),
(660, 4923, 2),
(660, 5126, 3),
(664, 298, 18),
(664, 333, 15),
(664, 342, 13),
(664, 698, 14),
(664, 946, 11),
(664, 1376, 12),
(664, 2800, 1),
(664, 4195, 3),
(664, 4201, 5),
(664, 4248, 2),
(664, 5223, 4),
(667, 75, 2),
(667, 429, 1),
(667, 2000, 5),
(667, 4278, 4),
(667, 4340, 3),
(683, 1322, 4),
(683, 1527, 1),
(683, 3127, 9),
(683, 3970, 2),
(683, 5416, 3),
(683, 5608, 5),
(686, 393, 1),
(686, 1554, 5),
(686, 3921, 2),
(686, 4023, 3),
(686, 4450, 4),
(689, 2229, 1),
(689, 3123, 6),
(689, 4428, 5),
(689, 4657, 4),
(689, 5489, 3),
(689, 5592, 2),
(694, 85, 2),
(694, 938, 3),
(694, 1442, 4),
(694, 1524, 1),
(694, 3397, 5),
(700, 6, 9),
(700, 16, 1),
(700, 555, 8),
(700, 937, 2),
(700, 963, 3),
(700, 1198, 4),
(700, 2319, 5),
(700, 3413, 6),
(707, 106, 1),
(707, 340, 2),
(707, 757, 4),
(707, 1045, 3),
(707, 2396, 5),
(707, 3417, 14),
(707, 4628, 8),
(707, 5883, 11),
(715, 145, 1),
(715, 1860, 5),
(715, 3039, 4),
(715, 3137, 8),
(715, 3664, 13),
(715, 5378, 3),
(715, 5638, 2),
(734, 170, 1),
(734, 1276, 4),
(734, 1346, 14),
(734, 1488, 2),
(734, 1789, 6),
(734, 2000, 3),
(734, 4082, 5),
(758, 417, 3),
(758, 496, 2),
(758, 745, 5),
(758, 792, 9),
(758, 1313, 4),
(758, 1781, 6),
(758, 1803, 11),
(758, 2381, 1),
(758, 2991, 12),
(758, 3729, 8),
(758, 3756, 13),
(777, 160, 4),
(777, 899, 1),
(777, 1148, 5),
(777, 4141, 2),
(777, 4817, 3),
(778, 345, 1),
(778, 837, 3),
(778, 3124, 4),
(778, 3390, 8),
(778, 4788, 2),
(778, 5382, 5),
(785, 42, 1),
(785, 479, 4),
(785, 711, 6),
(785, 1252, 3),
(785, 1797, 8),
(785, 2505, 9),
(785, 2648, 7),
(785, 4836, 5),
(785, 5632, 2),
(827, 539, 1),
(827, 805, 2),
(827, 1257, 3),
(827, 3883, 4),
(922, 145, 1),
(922, 2034, 5),
(922, 4526, 3),
(922, 4952, 2),
(922, 5330, 4),
(924, 1128, 4),
(924, 2009, 1),
(924, 2192, 3),
(924, 2486, 2),
(924, 3101, 5),
(924, 4196, 7),
(924, 4741, 8),
(924, 5281, 6),
(924, 5840, 10),
(950, 941, 1),
(950, 1557, 6),
(950, 2834, 2),
(950, 3161, 4),
(950, 5019, 3),
(950, 5273, 5),
(952, 75, 1),
(952, 1231, 3),
(952, 1336, 5),
(952, 1438, 2),
(952, 2100, 4),
(952, 3368, 9),
(952, 3390, 14),
(952, 4401, 8),
(952, 4415, 7),
(952, 5934, 11),
(958, 892, 4),
(958, 1464, 1),
(958, 2227, 2),
(958, 3120, 7),
(958, 3619, 11),
(958, 3774, 12),
(958, 3952, 3),
(958, 4093, 5),
(958, 4362, 6),
(960, 1766, 1),
(960, 4159, 5),
(960, 4403, 4),
(960, 4971, 3),
(960, 5034, 2),
(962, 258, 4),
(962, 302, 1),
(962, 752, 2),
(962, 775, 5),
(962, 2882, 12),
(962, 2935, 11),
(962, 3846, 3),
(966, 981, 1),
(966, 1860, 16),
(966, 2173, 3),
(966, 2329, 2),
(966, 3141, 7),
(966, 3366, 8),
(966, 4283, 5),
(966, 4927, 4),
(974, 688, 4),
(974, 735, 1),
(974, 1698, 9),
(974, 2070, 3),
(974, 3592, 10),
(974, 4000, 5),
(974, 5507, 2),
(976, 1443, 1),
(976, 3046, 4),
(976, 4761, 3),
(976, 4762, 2),
(976, 4909, 5),
(982, 183, 1),
(982, 489, 2),
(982, 1406, 3),
(982, 1557, 7),
(982, 2553, 4),
(982, 3141, 9),
(982, 5577, 5),
(983, 2210, 1),
(983, 4218, 5),
(983, 4323, 4),
(983, 4749, 3),
(983, 5214, 2),
(993, 2604, 1),
(993, 4339, 2),
(993, 4662, 5),
(993, 5358, 3),
(993, 5715, 4),
(1103, 170, 2),
(1103, 837, 4),
(1103, 1077, 5),
(1103, 2313, 1),
(1103, 3280, 3),
(1103, 3844, 10),
(1130, 1743, 1),
(1130, 2773, 3),
(1130, 4154, 2),
(1130, 4408, 4),
(1130, 4901, 5),
(1134, 1977, 1),
(1134, 4207, 3),
(1134, 4399, 2),
(1134, 5342, 5),
(1134, 5709, 4),
(1145, 2078, 4),
(1145, 2113, 1),
(1145, 2624, 5),
(1145, 3655, 13),
(1145, 4738, 3),
(1145, 5163, 2),
(1145, 5264, 8),
(1181, 2104, 1),
(1181, 2998, 5),
(1181, 3157, 4),
(1181, 5239, 3),
(1181, 5312, 2),
(1193, 943, 1),
(1193, 3132, 3),
(1193, 4309, 4),
(1193, 5173, 5),
(1193, 5684, 2),
(1200, 899, 9),
(1200, 1619, 25),
(1200, 1976, 20),
(1200, 2177, 1),
(1200, 4188, 2),
(1200, 4919, 4),
(1200, 5540, 5),
(1200, 5572, 3),
(1200, 5573, 6),
(1215, 1336, 6),
(1215, 1464, 2),
(1215, 1543, 1),
(1215, 2723, 3),
(1215, 3774, 5),
(1215, 3792, 12),
(1215, 4895, 4),
(1234, 2076, 4),
(1234, 2268, 1),
(1234, 5201, 5),
(1234, 5435, 2),
(1234, 5718, 3),
(1247, 554, 6),
(1247, 780, 2),
(1247, 892, 1),
(1247, 1377, 7),
(1247, 2012, 4),
(1247, 3681, 3),
(1247, 5626, 5),
(1248, 1183, 3),
(1248, 1496, 5),
(1248, 1669, 4),
(1248, 2728, 1),
(1248, 2883, 7),
(1248, 3039, 6),
(1248, 3247, 2),
(1248, 5840, 10),
(1299, 160, 13),
(1299, 899, 4),
(1299, 1148, 2),
(1299, 2538, 1),
(1299, 5195, 5),
(1299, 5665, 3),
(1350, 1996, 11),
(1350, 2085, 1),
(1350, 3198, 2),
(1350, 4492, 3),
(1350, 5011, 5),
(1350, 5258, 4),
(1379, 118, 1),
(1379, 479, 7),
(1379, 550, 3),
(1379, 711, 10),
(1379, 2123, 2),
(1379, 3005, 4),
(1379, 3390, 13),
(1379, 3434, 5),
(1379, 3705, 8),
(1402, 2049, 1),
(1402, 4899, 2),
(1402, 5160, 5),
(1402, 5700, 3),
(1402, 5710, 4),
(1499, 2143, 1),
(1499, 2159, 3),
(1499, 4619, 5),
(1499, 4908, 2),
(1499, 5683, 4),
(1522, 1772, 1),
(1522, 2534, 3),
(1522, 4805, 4),
(1522, 5623, 2),
(1522, 5670, 5),
(1568, 1669, 5),
(1568, 2484, 1),
(1568, 3655, 4),
(1568, 3914, 2),
(1568, 4178, 3),
(1568, 5840, 8),
(1723, 2650, 1),
(1723, 4171, 2),
(1723, 4190, 3),
(1723, 4202, 4),
(1741, 170, 1),
(1741, 1536, 4),
(1741, 2724, 2),
(1741, 3871, 5),
(1741, 4636, 3),
(1741, 4716, 6),
(1741, 5586, 10),
(1741, 5904, 12),
(1749, 688, 1),
(1749, 1946, 13),
(1749, 2070, 8),
(1749, 4822, 2),
(1749, 4946, 3),
(1749, 4949, 5),
(1749, 4981, 4),
(1768, 845, 3),
(1768, 2238, 1),
(1768, 3141, 7),
(1768, 3514, 11),
(1768, 5017, 5),
(1768, 5297, 4),
(1768, 5614, 2),
(1790, 837, 11),
(1790, 1461, 1),
(1790, 1546, 4),
(1790, 1553, 2),
(1790, 1789, 6),
(1790, 2192, 3),
(1790, 3586, 14),
(1790, 4392, 5),
(1800, 815, 3),
(1800, 2821, 1),
(1800, 4022, 4),
(1800, 4417, 2),
(1801, 28, 6),
(1801, 44, 10),
(1801, 85, 3),
(1801, 125, 14),
(1801, 306, 16),
(1801, 331, 11),
(1801, 360, 15),
(1801, 693, 1),
(1801, 833, 4),
(1801, 1198, 12),
(1801, 1471, 9),
(1801, 1623, 13),
(1801, 2495, 2),
(1801, 5501, 5);
-- --------------------------------------------------------
--
-- Structure de la table `films`
--
CREATE TABLE IF NOT EXISTS `films` (
`id` int(11) NOT NULL,
`titre` varchar(70) DEFAULT NULL,
`annee` decimal(4,0) DEFAULT NULL,
`score` float DEFAULT NULL,
`nbvotant` int(11) DEFAULT NULL,
`idrealisateur` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idrealisateur` (`idrealisateur`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `films`
--
INSERT INTO `films` (`id`, `titre`, `annee`, `score`, `nbvotant`, `idrealisateur`) VALUES
(1, 'Star Wars', '1977', 8.8, 53567, 360),
(2, 'Shawshank Redemption, The', '1994', 9, 44974, 1040),
(3, 'Pulp Fiction', '1994', 8.6, 43993, 444),
(5, 'Star Wars: Episode V - The Empire Strikes Back', '1980', 8.6, 39446, 651),
(6, 'Usual Suspects, The', '1995', 8.7, 35027, 639),
(7, 'Schindler''s List', '1993', 8.8, 34251, 18),
(8, 'Saving Private Ryan', '1998', 8.5, 34113, 18),
(9, 'Braveheart', '1995', 8.3, 32870, 22),
(10, 'American Beauty', '1999', 8.8, 32547, 2542),
(11, 'Raiders of the Lost Ark', '1981', 8.6, 31750, 18),
(12, 'Godfather, The', '1972', 9, 31225, 28),
(14, 'Blade Runner', '1982', 8.3, 29877, 110),
(15, 'Silence of the Lambs, The', '1991', 8.5, 29582, 281),
(18, 'Sixth Sense, The', '1999', 8.5, 27626, 966),
(21, 'Se7en', '1995', 8.1, 25158, 414),
(22, 'Fargo', '1996', 8.2, 25044, 111),
(23, '2001: A Space Odyssey', '1968', 8.3, 24536, 82),
(24, 'Aliens', '1986', 8.2, 23965, 198),
(27, 'Casablanca', '1942', 8.8, 23283, 675),
(28, 'One Flew Over the Cuckoo''s Nest', '1975', 8.7, 22868, 408),
(32, 'Gladiator', '2000', 8.3, 21955, 110),
(33, 'Fight Club', '1999', 8.5, 21391, 414),
(34, 'Clockwork Orange, A', '1971', 8.2, 21216, 82),
(35, 'Alien', '1979', 8.2, 20998, 110),
(36, 'Princess Bride, The', '1987', 8.2, 20931, 37),
(39, 'Reservoir Dogs', '1992', 8.2, 20343, 444),
(40, 'Citizen Kane', '1941', 8.8, 20269, 253),
(41, 'Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb', '1964', 8.7, 20034, 82),
(43, 'Goodfellas', '1990', 8.5, 19430, 78),
(45, 'Apocalypse Now', '1979', 8.3, 19335, 28),
(49, 'Monty Python and the Holy Grail', '1975', 8.3, 18640, 59),
(54, 'Psycho', '1960', 8.6, 17734, 11),
(61, 'Godfather: Part II, The', '1974', 8.8, 15487, 28),
(63, 'Shining, The', '1980', 8.1, 14653, 82),
(64, 'Amadeus', '1984', 8.2, 14351, 408),
(65, 'Taxi Driver', '1976', 8.4, 14090, 78),
(69, 'Full Metal Jacket', '1987', 8.1, 13863, 82),
(70, 'Being John Malkovich', '1999', 8.3, 13809, 1485),
(72, 'Wizard of Oz, The', '1939', 8.3, 13444, 1151),
(73, 'Green Mile, The', '1999', 8.3, 13409, 1040),
(74, 'Vita è bella, La', '1997', 8.6, 13403, 820),
(82, 'American History X', '1998', 8.3, 12977, 2663),
(87, 'Rear Window', '1954', 8.7, 12484, 11),
(94, 'North by Northwest', '1959', 8.6, 11588, 11),
(97, 'Vertigo', '1958', 8.5, 11231, 11),
(105, 'Gone with the Wind', '1939', 8.1, 10628, 1151),
(116, 'Toy Story 2', '1999', 8.5, 10020, 2043),
(121, 'To Kill a Mockingbird', '1962', 8.5, 9707, 2586),
(123, 'Graduate, The', '1967', 8.1, 9558, 47),
(143, 'Sling Blade', '1996', 8.1, 8740, 298),
(149, 'Deer Hunter, The', '1978', 8.1, 8393, 2645),
(150, 'Boot, Das', '1981', 8.5, 8392, 140),
(154, 'Chinatown', '1974', 8.4, 8280, 90),
(159, '12 Angry Men', '1957', 8.6, 8158, 80),
(161, 'Sting, The', '1973', 8.2, 8108, 276),
(162, 'Glory', '1989', 8.1, 8079, 382),
(163, 'Raging Bull', '1980', 8.4, 8029, 78),
(165, 'Wallace & Gromit: The Wrong Trousers', '1993', 8.5, 8024, 572),
(186, 'Insider, The', '1999', 8.2, 7429, 1106),
(189, 'Bridge on the River Kwai, The', '1957', 8.4, 7395, 1080),
(208, 'Annie Hall', '1977', 8.2, 6989, 1),
(211, 'Ben-Hur', '1959', 8.1, 6927, 620),
(221, 'Christmas Story, A', '1983', 8.1, 6693, 579),
(222, 'Singin'' in the Rain', '1952', 8.5, 6662, 428),
(225, 'Butch Cassidy and the Sundance Kid', '1969', 8.1, 6637, 276),
(237, 'Some Like It Hot', '1959', 8.4, 6445, 79),
(241, 'Shichinin no samurai', '1954', 9, 6357, 208),
(249, 'Buono, il brutto, il cattivo, Il', '1966', 8.5, 6161, 268),
(271, 'Great Escape, The', '1963', 8.2, 5783, 2473),
(288, 'Third Man, The', '1949', 8.6, 5576, 1003),
(299, 'African Queen, The', '1951', 8.2, 5468, 312),
(303, 'Central do Brasil', '1998', 8.1, 5429, 2560),
(324, 'Nuovo cinema Paradiso', '1988', 8.2, 5178, 2142),
(331, 'Wo hu zang long', '2000', 9, 5016, 273),
(376, 'Patton', '1970', 8.1, 4637, 405),
(377, 'Cool Hand Luke', '1967', 8.1, 4635, 1029),
(383, 'Wallace & Gromit: A Close Shave', '1995', 8.2, 4561, 572),
(435, 'Trois couleurs: Rouge', '1994', 8.2, 4113, 398),
(442, 'Sunset Blvd.', '1950', 8.6, 4050, 79),
(453, 'Mr. Smith Goes to Washington', '1939', 8.4, 3977, 392),
(455, 'Arsenic and Old Lace', '1944', 8.1, 3970, 392),
(473, 'All About Eve', '1950', 8.6, 3876, 1111),
(476, 'High Noon', '1952', 8.2, 3864, 617),
(478, 'Philadelphia Story, The', '1940', 8.2, 3856, 628),
(483, 'Wild Bunch, The', '1969', 8.1, 3814, 1072),
(486, 'On the Waterfront', '1954', 8.3, 3800, 655),
(510, 'Ran', '1985', 8.5, 3654, 208),
(515, 'Almost Famous', '2000', 8.6, 3639, 391),
(518, 'Paths of Glory', '1957', 8.8, 3620, 82),
(522, 'Touch of Evil', '1958', 8.5, 3607, 253),
(541, 'Todo sobre mi madre', '1999', 8.3, 3501, 394),
(551, 'Rebecca', '1940', 8.2, 3476, 11),
(555, 'Duck Soup', '1933', 8.4, 3447, 992),
(565, 'Treasure of the Sierra Madre, The', '1948', 8.5, 3392, 312),
(570, 'Straight Story, The', '1999', 8.4, 3353, 139),
(580, 'C''era una volta il West', '1969', 8.5, 3297, 268),
(582, 'Double Indemnity', '1944', 8.5, 3283, 79),
(584, 'Big Sleep, The', '1946', 8.2, 3274, 197),
(589, 'Modern Times', '1936', 8.4, 3249, 145),
(644, 'Searchers, The', '1956', 8.3, 3042, 287),
(646, 'Notorious', '1946', 8.2, 3030, 11),
(660, 'Rashomon', '1950', 8.6, 3004, 208),
(664, 'Mononoke Hime', '1997', 8.5, 2989, 1051),
(667, 'Bringing Up Baby', '1938', 8.3, 2983, 197),
(683, 'Strangers on a Train', '1951', 8.3, 2937, 11),
(686, 'Die xue shuang xiong', '1989', 8.2, 2935, 204),
(689, 'Fucking Åmål', '1998', 8.2, 2919, 2803),
(694, 'Streetcar Named Desire, A', '1951', 8.2, 2904, 655),
(700, 'Conversation, The', '1974', 8.1, 2876, 28),
(707, 'Apartment, The', '1960', 8.3, 2846, 79),
(715, 'Great Dictator, The', '1940', 8.3, 2819, 145),
(734, 'Quiet Man, The', '1952', 8.1, 2729, 287),
(758, 'Dancer in the Dark', '2000', 8.3, 2614, 615),
(777, 'Sjunde inseglet, Det', '1957', 8.4, 2559, 420),
(778, 'Grapes of Wrath, The', '1940', 8.3, 2552, 287),
(785, 'Hustler, The', '1961', 8.2, 2541, 2605),
(827, 'Who''s Afraid of Virginia Woolf?', '1966', 8.2, 2395, 47),
(848, 'City Lights', '1931', 8.6, 2325, 145),
(922, 'Gold Rush, The', '1925', 8.3, 2113, 145),
(924, 'Adventures of Robin Hood, The', '1938', 8.1, 2111, 675),
(950, 'Night of the Hunter, The', '1955', 8.4, 2027, 1183),
(952, 'His Girl Friday', '1940', 8.3, 2023, 197),
(958, 'Best Years of Our Lives, The', '1946', 8.5, 2010, 620),
(960, 'All Quiet on the Western Front', '1930', 8.4, 2002, 2138),
(962, 'Snatch', '2000', 8.1, 1996, 2205),
(966, 'Night at the Opera, A', '1935', 8.2, 1983, 2532),
(974, 'Yojimbo', '1961', 8.6, 1961, 208),
(976, 'Billy Elliot', '2000', 8.3, 1960, 2784),
(982, 'Stalag 17', '1953', 8.3, 1941, 79),
(983, 'Nosferatu, eine Symphonie des Grauens', '1922', 8.2, 1941, 2035),
(993, 'General, The', '1927', 8.7, 1926, 2343),
(1103, 'Stagecoach', '1939', 8.1, 1689, 287),
(1125, 'Bronenosets Potyomkin', '1925', 8.4, 1634, 2128),
(1130, 'Amarcord', '1974', 8.2, 1624, 399),
(1134, 'Quatre cents coups, Les', '1959', 8.6, 1619, 505),
(1145, 'Scrooge', '1951', 8.2, 1591, 2434),
(1181, 'Au revoir les enfants', '1987', 8.1, 1503, 619),
(1193, 'Strada, La', '1954', 8.3, 1475, 399),
(1200, 'Fanny och Alexander', '1982', 8.2, 1467, 420),
(1202, 'Requiem for a Dream', '2000', 8.7, 1466, 1136),
(1215, 'Thin Man, The', '1934', 8.1, 1444, 2564),
(1230, 'Da hong deng long gao gao gua', '1991', 8.3, 1403, 2830),
(1234, 'Grande illusion, La', '1937', 8.6, 1393, 2292),
(1247, 'Shadow of a Doubt', '1943', 8.3, 1370, 11),
(1248, 'Witness for the Prosecution', '1957', 8.3, 1370, 79),
(1299, 'Smultronstället', '1957', 8.5, 1278, 420),
(1350, 'Crna macka, beli macor', '1998', 8.1, 1189, 663),
(1379, 'Anatomy of a Murder', '1959', 8.2, 1143, 1406),
(1402, 'Enfants du paradis, Les', '1945', 8.4, 1106, 2573),
(1406, 'Aguirre, der Zorn Gottes', '1972', 8.1, 1101, 1886),
(1499, 'Vie rêvée des anges, La', '1998', 8.1, 1017, 2073),
(1522, 'Andrei Rublyov', '1969', 8.4, 996, 658),
(1568, 'Bride of Frankenstein', '1935', 8.1, 945, 1097),
(1723, 'Hotaru no haka', '1988', 8.5, 822, 2401),
(1741, 'Red River', '1948', 8.4, 813, 197),
(1749, 'Ikiru', '1952', 8.8, 805, 208),
(1768, 'To Be or Not to Be', '1942', 8.5, 789, 2014),
(1790, 'Court Jester, The', '1956', 8.2, 777, 2717),
(1800, 'Un chien andalou', '1929', 8.3, 772, 815),
(1801, 'Hearts of Darkness: A Filmmaker''s Apocalypse', '1991', 8.2, 772, 2031);
-- --------------------------------------------------------
--
-- Doublure de structure pour la vue `MOVIES`
--
CREATE TABLE IF NOT EXISTS `MOVIES` (
`id` int(11)
,`title` varchar(70)
,`yr` decimal(4,0)
,`score` float
,`votes` int(11)
,`director` int(11)
);
-- --------------------------------------------------------
Posté le 6 septembre 2011