INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(91, '2007-01-18 14:49:03', '2005-07-24', 0, 10, 'Les Triplettes de Belleville', 0, NULL, NULL, 'http://imdb.com/title/tt0286244/', '', '', '', 'Imported from old Movienight wiki.', ' When her grandson is kidnapped during the Tour de France, Madame Souza and her beloved pooch Bruno team up with the Belleville Sisters--an aged song-and-dance team from the days of Fred Astaire--to rescue him. ', 7.7, 0x[BLOB], '1:20'),
(92, '2007-01-18 14:49:03', '2005-07-22', 0, 10, 'Back to the Future Part III', 0, NULL, NULL, 'http://imdb.com/title/tt0099088/', '', '', '', 'Imported from old Movienight wiki.', ' Doctor Emmet Brown was living in peace in 1885 until he was killed by Buford &#34;Mad Dog&#34; Tannen. Marty McFly travels back in time to save his friend. ', 6.8, 0x[BLOB], '1:58'),
(93, '2007-01-18 14:49:03', '2005-07-21', 0, 10, 'Back to the Future Part II', 0, NULL, NULL, 'http://imdb.com/title/tt0096874/', '', '', '', 'Imported from old Movienight wiki.', ' After visiting 2015, Marty must repeat his visit to 1955 to prevent disastrous changes to 1985... without interfering with his first trip. ', 7.1, 0x[BLOB], '1:48'),
(94, '2007-01-18 14:49:03', '2005-07-19', 0, 10, 'Back to the Future', 0, NULL, NULL, 'http://imdb.com/title/tt0088763/', '', '', '', 'Imported from old Movienight wiki.', ' In 1985, Doc Brown invented time travel, in 1955, Marty McFly accidentally prevented his parents from meeting, putting his own existence at stake. ', 8.1, 0x[BLOB], '1:56');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(95, '2007-01-18 14:49:03', '2005-07-13', 0, 10, 'Festen', 0, NULL, NULL, 'http://imdb.com/title/tt0154420/', '', '', '', 'Imported from old Movienight wiki.', ' At Helge''s 60th birthday party, some unpleasant family truths are revealed. ', 8, 0x[BLOB], '1:45'),
(96, '2007-01-18 14:49:03', '2005-03-10', 0, 10, 'Napoleon Dynamite', 0, NULL, NULL, 'http://www.imdb.com/title/tt0374900/', '', '', '', 'Imported from old Movienight wiki.', ' A listless and alienated teenager decides to help his new friend win the class presidency in their small western high school, while he must deal with his bizarre family life back home. ', 6.9, 0x[BLOB], '1:22'),
(97, '2007-01-18 14:49:03', '2005-03-10', 0, 10, 'Shrek 2', 0, NULL, NULL, 'http://www.imdb.com/title/tt0298148/', '', '', '', 'Imported from old Movienight wiki.', ' Princess Fiona''s parents invite her and Shrek to dinner to celebrate her marriage. If only they knew the newlyweds were both ogres. ', 7.7, 0x[BLOB], '1:32'),
(98, '2007-01-18 14:49:03', '2005-03-03', 0, 10, 'He Died with a Felafel in His Hand', 0, NULL, NULL, 'http://www.imdb.com/title/tt0172543/', '', '', '', 'Imported from old Movienight wiki.', ' A nightmare chase through hell in a never-ending, unrequited daisy chain of desire... ', 6.7, 0x[BLOB], '1:47');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(99, '2007-01-18 14:49:03', '2005-03-02', 0, 10, 'Napoleon Dynamite', 0, NULL, NULL, 'http://www.imdb.com/title/tt0374900/', '', '', '', 'Imported from old Movienight wiki.', ' A listless and alienated teenager decides to help his new friend win the class presidency in their small western high school, while he must deal with his bizarre family life back home. ', 6.9, 0x[BLOB], '1:22'),
(100, '2007-01-18 14:49:03', '2005-02-24', 0, 10, 'Elephant', 0, NULL, NULL, 'http://www.imdb.com/title/tt0363589/', '', '', '', 'Imported from old Movienight wiki.', ' Several ordinary high school students go through their daily routine as two others prepare for something more malevolent. ', 7.2, 0x[BLOB], '1:21'),
(101, '2007-01-19 12:17:31', NULL, 0, 4, 'Cry_Wolf', 0, NULL, NULL, 'http://imdb.com/title/tt0384286/', '', '', '', 'Voor liefhebbers van het spelletje Weerwolven :)\r\n\r\nDeze is vast te eng voor mij he? - Anne', ' Eight unsuspecting high school seniors at a posh boarding school, who delight themselves on playing games of lies, come face-to-face with terror and learn that nobody believes a liar - even when they''re telling the truth. ', 5.8, 0x[BLOB], '1:30'),
(102, '2007-01-19 16:17:29', NULL, -1, 4, 'Asterix en de Britten', 0, NULL, NULL, 'http://www.imdb.com/title/tt0090667/', '', '', '', '', ' The diminutive Asterix and his rather larger companion Obelix, warriors of the last village in Gaul still free after the Roman invasion...\n ', 6.7, '', '1:19'),
(103, '2007-01-19 16:20:31', NULL, 6, 4, 'The Shining', 0, NULL, NULL, 'http://www.imdb.com/title/tt0081505/', '', '', '', '', ' A family heads to an isolated hotel for the winter where an evil and spiritual presence influences the father into violence, while his psychic son sees horrific forebodings from the past and of the future. ', 8.4, 0x[BLOB], '1:59');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(104, '2007-01-19 20:16:51', NULL, 5, 4, 'A Scanner Darkly', 0, NULL, NULL, 'http://imdb.com/title/tt0405296/', '', '', '', '', ' An undercover cop in a not-too-distant future becomes involved with a dangerous new drug and begins to lose his own identity as a result. ', 7.3, 0x[BLOB], '1:40'),
(105, '2007-01-21 00:02:12', NULL, 2, 4, 'Nordrand', 0, NULL, NULL, 'http://imdb.com/title/tt0209187/', '', '', '', 'Oostenrijkse cinema.\r\n\r\nGezien op Reykjavík International Film Festival', ' Vienna, 1995. Jasmin, Tamara, Valentin, Senad and Roman live near the northern border of Austria. Their lives repeatedly intersect and drift apart...\n ', 6.9, '', '1:43'),
(106, '2007-01-21 00:04:09', NULL, 5, 4, 'Böse Zellen', 0, NULL, NULL, 'http://imdb.com/title/tt0372814/', 'http://www.cineman.ch/movie/trailer/7226/trailerhigh1.mov', '2474963', 'video/quicktime', 'Free Radicals is comparable to Magnolia by Paul Thomas Anderson and Short Cuts by Robert Altman, but Barbara Albert is both more compassionate and more detached towards her characters in this film. Main character Manu is the sole survivor of a plane crash in the Amazon on her way home from a vacation in Brazil. Six years later Manu is still trying to adjust to her hometown life when she is involved in a serious car accident. In Free Radicals we are told stories of Manu, her friends, relatives and the group of teenagers in the other car, without the characters ever having met, but still leaving the impression that we are all somehow interconnected.', '', 6.3, '', '2:00'),
(107, '2007-01-21 00:05:32', NULL, 2, 4, 'Fallen', 0, NULL, NULL, 'http://imdb.com/title/tt0832347/', '', '', '', 'Oostenrijkse cinema.\r\n\r\nFive women in their early thirties meet for the first time in fourteen years when they return to their small hometown to attend the funeral of their favorite teacher. The reunion unexpectedly continues through the night and the following day, taking them on a journey to the past, present, and future, in which old wounds are reopened, but friendships are also rediscovered. Have these women’s dreams simply gotten lost over the years or is there a place in their lives for new utopias?', '', 6.1, '', '1:28'),
(108, '2007-01-21 00:08:14', NULL, 5, 4, 'En Soap', 0, NULL, NULL, 'http://imdb.com/title/tt0419146/', '', '', '', '', ' A tragicomedy focused on the relationship between the owner of a beauty clinic and a transsexual. ', 6.8, 0x[BLOB], '1:44'),
(109, '2007-01-21 00:13:02', NULL, 6, 4, 'Interstella 5555: The 5tory of the 5ecret 5tar 5ystem', 0, NULL, NULL, 'http://imdb.com/title/tt0368667/', '', '', '', 'Daft Prick!\r\nFlauw hoor, je naam er niet bijzetten', ' A continuation of the story told in the Daft Punk music videos &#34;One More Time,&#34; &#34;Aerodynamic,&#34; &#34;Digital Love,&#34; and &#34;Harder, Better, Faster, Stronger.&#34; ', 7.8, 0x[BLOB], '1:08'),
(110, '2007-01-22 23:49:15', NULL, 4, 6, 'Last Days', 0, NULL, NULL, 'http://imdb.com/title/tt0403217/', '', '', '', 'Fantastische film... alhoewel het voor mij net zo goed over eenofander willekeurig persoon had kunnen gaan als over iemand die blijkbaar op Kurt Cobain moet lijken.  Geregisseerd door Gus van Sant, ons allen bekend van Elephant.', ' Michael Pitt stars in a Seattle-set rock &#38; roll drama as a musician whose life and career is reminiscent of Kurt Cobain''s. ', 5.8, 0x[BLOB], '1:37');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(111, '2007-01-23 14:39:37', NULL, 5, 6, 'Tape', 0, NULL, NULL, 'http://imdb.com/title/tt0275719/', '', '', '', 'Als we toch Richard Linklater films gaan kijken (A Scanner Darkly, Waking Life) kan deze er ook wel bij.', ' Three old high school friends pass the time in a Michigan motel room dissecting the painful memories of their high school years. ', 7.3, 0x[BLOB], '1:26'),
(112, '2007-01-23 14:46:45', NULL, 5, 6, 'The Straight Story', 0, NULL, NULL, 'http://imdb.com/title/tt0166896/', '', '', '', 'De "normaalste" film ooit van David Lynch... en alleen daarvoor al de moeite waard.', ' An old man makes a long journey by tractor to mend his relationship with an ill brother. ', 8, 0x[BLOB], '1:52'),
(113, '2007-01-23 14:48:02', NULL, 5, 6, 'Death Race 2000', 0, NULL, NULL, 'http://imdb.com/title/tt0072856/', '', '', '', 'B-film, wheeeee! :D  En kort zat om ergens even tussendoor te kijken.', ' A champion of a brutal cross-country car race of the future where pedestrians are run down for points...\n ', 5.8, 0x[BLOB], '1:19'),
(114, '2007-01-23 14:51:18', NULL, 4, 6, 'They Live', 0, NULL, NULL, 'http://imdb.com/title/tt0096256/', '', '', '', 'Eigenlijk toch wel de ultieme B-film.', ' Nada, a down-on-his-luck construction worker, discovers a pair of special sunglasses. Wearing them,...\n ', 6.6, 0x[BLOB], '1:33');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(115, '2007-01-23 15:06:11', NULL, 4, 6, 'The Day the Earth Stood Still', 0, NULL, NULL, 'http://imdb.com/title/tt0043456/', '', '', '', '', ' An alien lands and tells the people of Earth that they must live peacefully or be destroyed as a danger to other planets. ', 8.1, 0x[BLOB], '1:32'),
(116, '2007-01-24 21:04:47', NULL, 8, 4, 'Lady in the Water', 0, NULL, NULL, 'http://imdb.com/title/tt0452637/', 'http://movies.apple.com/movies/wb/ladyinthewater/ladyinthewater-tlr3_h640w.mov', '17233783', 'video/quicktime', '', ' Apartment building superintendent Cleveland Heep (Giamatti) rescues what he thinks is a young woman from the pool he maintains. When he discovers that she is actually a character from a bedtime story who is trying to make the journey back to her home, he works with his tenants to protect his new friend from the creatures that are determined to keep her in our world. ', 6.2, 0x[BLOB], '1:50'),
(117, '2007-01-24 23:11:09', NULL, 9, 5, 'Six Feet Under', 1, NULL, NULL, 'http://imdb.com/title/tt0248654/', '', '', '', '', ' A drama series that takes a darkly comical look at members of a dysfunctional Pasadena family that runs an independent funeral home. ', 9.2, 0x[BLOB], '0:55'),
(118, '2007-01-25 15:01:18', NULL, 9, 6, 'Serial Experiments: Lain', 1, NULL, NULL, 'http://imdb.com/title/tt0500092/', '', '', '', 'Rare anime-serie voor Admar natuurlijk :D', ' Strange events begin to occur as a withdrawn girl named Lain becomes obsessed with interconnected virtual realm of &#34;The Wired&#34;. ', 8.7, 0x[BLOB], '0:24'),
(119, '2007-01-26 01:06:23', NULL, 4, 6, 'Angels in America', 1, NULL, NULL, 'http://imdb.com/title/tt0318997/', '', '', '', 'Meer Jeffrey Wright! En muziek van Thomas Newman! En verder ook goede, mooie miniserie ;)', ' Playwright Tony Kushner adapts his political epic about the AIDS crisis during the mid-eighties, around a group of separate but connected individuals. ', 8.2, 0x[BLOB], '5:52');
INSERT INTO `movie` (`movieid`, `added`, `watched`, `_charisma`, `userid`, `movietitle`, `serie`, `buried`, `buriedby`, `link`, `trailer_link`, `trailer_length`, `trailer_type`, `remarks`, `imdb_plot`, `imdb_score`, `imdb_picture`, `imdb_runtime`) VALUES 
(120, '2007-01-26 12:43:14', NULL, 5, 6, 'Mean Creek', 0, NULL, NULL, 'http://imdb.com/title/tt0377091/', 'http://meancreekmovie.com/_media/meancreek_domestic-trailer-texted_480x272.mov', '23702473', 'video/quicktime', 'Zoals gezien tussen de voorfilmpjes van Basquiat.', ' When a teen is bullied, his brother and friends lure the bully into the woods to seek vengeance. ', 7.3, 0x[BLOB], '1:30');

-- 
-- Gegevens worden uitgevoerd voor tabel `moviecopy`
-- 

INSERT INTO `moviecopy` (`movieid`, `format`, `location`, `copyid`, `userid`) VALUES 
(18, 'DVD', '', 16, 6),
(19, 'DVD', 'Moeder', 17, 6),
(21, 'DVD', '', 18, 6),
(26, 'DVDR', '', 19, 6),
(27, 'DVD', 'Zusje', 20, 6),
(25, 'DVDR', 'spindle', 21, 4),
(24, 'DVDR', 'kast', 22, 4),
(23, 'DVD', 'kast', 23, 4),
(28, 'XviD + rare subs', '', 24, 6),
(20, 'DivX', 'LaCie', 25, 4),
(31, 'DVDR', '', 26, 6),
(32, 'DVDR', 'kast', 27, 4),
(35, 'DVD', 'kast', 28, 4),
(37, 'DVD', 'kast', 29, 4),
(43, 'XviD', '', 30, 6),
(102, 'DVDR', 'spindle', 31, 4),
(103, 'DVDR', 'spindle', 32, 4),
(104, 'DVD', 'Bram', 33, 5),
(46, 'DivX', 'LaCie', 34, 4),
(110, 'XviD', '', 35, 6),
(117, 'DVD seizoen 1', '', 37, 6),
(115, 'DivX', 'Space', 38, 5),
(119, 'XviD', '', 39, 6);

-- 
-- Gegevens worden uitgevoerd voor tabel `vote`
-- 

INSERT INTO `vote` (`voteid`, `movieid`, `userid`, `vote`) VALUES 
(15, 18, 6, 1),
(16, 19, 6, 2),
(17, 21, 6, 2),
(18, 19, 5, 1),
(19, 26, 6, 2),
(20, 27, 6, 2),
(21, 25, 4, 2),
(22, 26, 4, 2),
(23, 24, 4, 1),
(24, 23, 4, 1),
(25, 25, 5, 0),
(26, 21, 4, 2),
(27, 26, 5, 1),
(28, 28, 6, 1),
(29, 22, 4, 2),
(30, 24, 5, 0),
(31, 18, 5, 1),
(32, 21, 5, 1),
(33, 20, 4, 2),
(34, 23, 5, 1),
(35, 22, 5, 1),
(36, 25, 6, 0),
(37, 28, 4, 2),
(38, 27, 4, 0),
(39, 18, 4, 1),
(40, 24, 6, 2),
(41, 19, 4, 1),
(42, 20, 5, 1),
(43, 27, 5, 0),
(44, 28, 5, 2),
(45, 23, 6, 0),
(46, 29, 6, 2),
(47, 25, 8, 2),
(48, 22, 6, 0),
(49, 29, 5, 1),
(50, 20, 6, 1),
(51, 30, 5, 2),
(52, 29, 4, 1),
(53, 30, 4, 2),
(54, 30, 6, 2),
(55, 31, 6, 1),
(56, 31, 4, 0),
(57, 32, 4, 2),
(58, 32, 6, 2),
(59, 33, 4, 2),
(60, 34, 4, 2),
(61, 35, 4, 2),
(62, 31, 5, -1),
(63, 33, 5, 1),
(64, 33, 6, 1),
(65, 34, 6, 2),
(66, 35, 6, 1),
(67, 32, 5, 2),
(68, 35, 5, 1),
(69, 34, 5, 1),
(70, 36, 4, 1),
(71, 37, 4, 1),
(72, 37, 8, -1),
(73, 36, 5, 0),
(74, 37, 5, 0),
(75, 26, 8, 2),
(76, 24, 8, -1),
(77, 18, 8, 0),
(78, 36, 8, 1),
(79, 19, 8, 2),
(80, 23, 8, -1),
(81, 34, 8, 1),
(82, 21, 8, 0),
(83, 35, 8, 1),
(84, 22, 8, 0),
(85, 32, 8, 2),
(86, 20, 8, 0),
(87, 33, 8, 0),
(88, 29, 8, 0),
(89, 31, 8, 0),
(90, 27, 8, -2),
(91, 28, 8, 0),
(92, 38, 8, 2),
(93, 38, 4, 1),
(94, 36, 6, 1),
(95, 38, 5, 0),
(96, 37, 6, -1),
(97, 38, 6, 2),
(98, 40, 8, 1),
(99, 39, 8, 2),
(100, 40, 5, -1),
(101, 39, 5, -1),
(102, 41, 8, 2),
(103, 42, 5, 1),
(104, 41, 5, 1),
(105, 42, 8, 1),
(106, 41, 4, 1),
(107, 42, 4, 1),
(108, 39, 6, 1),
(109, 40, 6, 0),
(110, 39, 4, 0),
(111, 41, 6, 2),
(112, 30, 8, 0),
(113, 40, 4, 0),
(114, 42, 6, 1),
(115, 43, 6, 2),
(116, 43, 5, 0),
(117, 43, 8, -1),
(118, 43, 4, 0),
(119, 44, 6, 2),
(120, 44, 5, 2),
(121, 44, 4, 1),
(122, 44, 8, 0),
(123, 101, 4, 1),
(124, 101, 6, 0),
(125, 103, 4, 1),
(126, 102, 6, 0),
(127, 103, 6, 1),
(128, 102, 4, 0),
(129, 104, 4, 2),
(130, 104, 5, 1),
(131, 102, 5, 0),
(132, 101, 5, 0),
(133, 103, 5, 2),
(134, 105, 4, 1),
(135, 107, 4, 1),
(136, 106, 4, 1),
(137, 108, 4, 2),
(138, 109, 4, 2),
(139, 109, 6, 2),
(140, 108, 6, 1),
(141, 104, 6, 1),
(142, 107, 6, 1),
(143, 110, 6, 2),
(144, 105, 6, 1),
(145, 106, 6, 2),
(146, 110, 4, 1),
(147, 111, 6, 2),
(148, 112, 6, 2),
(149, 113, 6, 2),
(150, 114, 6, 2),
(151, 106, 5, 0),
(152, 113, 5, 0),
(153, 108, 5, 1),
(154, 107, 5, 0),
(155, 109, 5, 0),
(156, 115, 6, 1),
(157, 110, 5, 0),
(158, 105, 5, 0),
(159, 111, 5, 1),
(160, 115, 5, 2),
(161, 114, 5, 1),
(162, 112, 5, 1),
(163, 111, 4, 1),
(164, 113, 4, 1),
(165, 115, 4, 0),
(166, 112, 4, 1),
(167, 114, 4, 0),
(168, 116, 5, 2),
(169, 116, 4, 2),
(170, 117, 5, 2),
(171, 116, 6, 1),
(172, 117, 6, 2),
(173, 117, 4, 2),
(174, 118, 6, 2),
(175, 118, 5, 2),
(176, 23, 9, 2),
(177, 38, 9, 1),
(178, 36, 9, 0),
(179, 19, 9, 0),
(180, 42, 9, 1),
(181, 103, 9, 1),
(182, 33, 9, 0),
(183, 113, 9, 1),
(184, 32, 9, 2),
(185, 116, 9, 1),
(186, 19, 12, -1),
(187, 119, 6, 2),
(188, 119, 5, 1),
(189, 120, 6, 2),
(190, 120, 5, 1),
(191, 120, 4, 1),
(192, 119, 4, 0),
(193, 118, 4, 2),
(194, 25, 12, 1),
(195, 37, 12, -2),
(196, 104, 12, 0),
(197, 24, 12, 0),
(198, 38, 12, 0),
(199, 102, 12, -1),
(200, 106, 12, 1),
(201, 36, 12, 2),
(202, 101, 12, -1),
(203, 23, 12, 0);
