create table formats ( formatcode char, description text );
insert into formats values ('v','Video Tape');
insert into formats values ('s','SVHS Tape');
insert into formats values ('d','Video Disk');


create table movies (title text, formatcode char, location text, comments text, links text);

insert into movies values ('1900','v','B6','','');
insert into movies values ('Accidental Tourist, The','v','L5','','');
insert into movies values ('Adams Family, The','v','C9','','');
insert into movies values ('After Hours','v','C5','','');
insert into movies values ('Age of Innocence, The','v','','','');
insert into movies values ('Alexander Nevsky','v','J2','','');
insert into movies values ('Alfredo, Alfredo','v','E3','','');
insert into movies values ('Alien III','v','D5','','');
insert into movies values ('Alive','v','','','');
insert into movies values ('Alphaville','v','H3','','');
insert into movies values ('Always','v','G3','','');
insert into movies values ('Amadeus','v','K3','','');
insert into movies values ('And God Created Woman (Brigitte Bardot)','v','G6','','');
insert into movies values ('And Now My Love','v','I6','','');
insert into movies values ('Angry Harvest','v','H4','','');
insert into movies values ('Animal Crackers','v','G3','','');
insert into movies values ('Another Woman','v','G9','','');
insert into movies values ('Apartment Zero','v','','','');
insert into movies values ('Apocalypse Now','s','SVHS0-SVHS1','','');
insert into movies values ('Apollo 13','v','','','');
insert into movies values ('Assault, The','v','E1','','');
insert into movies values ('At Play In the Fields of the Lord','v','L9','','');
insert into movies values ('Au Reviour Les Enfants','v','F7','','');
insert into movies values ('Aviator\'s Wife, The','v','H2','','');
insert into movies values ('Babette\'s Feast','v','K1','','');
insert into movies values ('Baby Boom','v','H3','','');
insert into movies values ('Bad Timing: A Sensual Obsession','v','E0','','');
insert into movies values ('Baghdad Cafe','v','N1','','');
insert into movies values ('Bandit Queen','v','','','');
insert into movies values ('Baraka','v','','','');
insert into movies values ('Barfly','v','H9','','');
insert into movies values ('Barry Lyndon','v','H5','','');
insert into movies values ('Barton Finke','v','D2','','');
insert into movies values ('Basic Instinct','v','P7','','');
insert into movies values ('Batman (1989)','s','SVHS25','','');
insert into movies values ('Batman Returns','v','D8','','');
insert into movies values ('Bear, The','v','G4','','');
insert into movies values ('Beau Ideal','v','A0','','');
insert into movies values ('Being There','v','H2','','');
insert into movies values ('Bell of an Architect','v','','','');
insert into movies values ('Berlin Alexanderplatz, I-VIII','v','F3-F5','','');
insert into movies values ('Betrayal, The','v','F6','','');
insert into movies values ('Betrayed','s','SVHS24','','');
insert into movies values ('Betty Blue (72 degres 2 Le Matin)','v','','','');
insert into movies values ('Between the Lines','v','Q1','','');
insert into movies values ('Bicycle Thief','v','','','');
insert into movies values ('Bird','v','K1','','');
insert into movies values ('Black and White in Color','v','A7','','');
insert into movies values ('Black Narcissus','v','D3','','');
insert into movies values ('Black Orpheus','s','SVHS4-SVHS5','','');
insert into movies values ('Black Rain','v','G6','','');
insert into movies values ('Black Robe','v','P6','','');
insert into movies values ('Black Widow','v','M1','','');
insert into movies values ('Blade Runner','s','SVHS12-SVHS13','','');
insert into movies values ('Blue','v','','','');
insert into movies values ('Blue Ice','v','N7','','');
insert into movies values ('Blue Velvet','s','SVHS20','','');
insert into movies values ('Body of Evidence','v','O9','','');
insert into movies values ('Bodyguard','v','O4','','');
insert into movies values ('Bonfire of the Vanities','v','E4','','');
insert into movies values ('Boomerang','v','O6','','');
insert into movies values ('Boy and His Dog, A','v','K9','','');
insert into movies values ('Boy meets Girl','v','K5','','');
insert into movies values ('Boyfriends and Girlfriends','v','H2','','');
insert into movies values ('Bram Stoker\'s Dracula','v','A2','','');
insert into movies values ('Brasil','s','SVHS2-SVHS3','','');
insert into movies values ('Braveheart','v','','','');
insert into movies values ('Breaking Away','v','E5','','');
insert into movies values ('Breathless (french version)','v','K4','','');
insert into movies values ('Bride, The','v','D4','','');
insert into movies values ('Bridges of Madison County, The','v','','','');
insert into movies values ('Broadcast News','v','M1','','');
insert into movies values ('Broken Arrow','v','','','');
insert into movies values ('Bucaneers, The','v','','','');
insert into movies values ('Buckaroo Banzai','v','B2','','');
insert into movies values ('Bullets over Broadway','v','','','');
insert into movies values ('Cal','v','K2','','');
insert into movies values ('Cage aux Folles, La','v','L6','','');
insert into movies values ('Camille Claudel','v','H8','','');
insert into movies values ('Campbell, James -The Power of Myth','v','B9','','');
insert into movies values ('Cape Fear','v','P3','','');
insert into movies values ('Carlito\'s Way','v','','','');
insert into movies values ('Casablanca','v','C9','','');
insert into movies values ('Casino','v','','','');
insert into movies values ('Casino Royale','v','J8','','');
insert into movies values ('Castaway','v','D9','','');
insert into movies values ('Chan is Missing','v','E1','','');
insert into movies values ('Chariots of Fire','v','J4','','');
insert into movies values ('Chinatown','v','A4','','');
insert into movies values ('Cinema Paradiso','v','Q1','','');
insert into movies values ('Cirque de Soleil-A New Experience','v','Q0','','');
insert into movies values ('Citizen Kane','v','I4','','');
insert into movies values ('Clear and Present Danger, A','v','','','');
insert into movies values ('Clients','v','','','');
insert into movies values ('Clockwork Orange, A','v','A5','','');
insert into movies values ('Cocolat','v','E2','','');
insert into movies values ('Colors','v','C6','','');
insert into movies values ('Comfort and Joy','v','J9','','');
insert into movies values ('Conrad, James-Ten Great Writers','v','G5','','');
insert into movies values ('Cook, The Thief, His Wife and Her Lover, The','v','','','');
insert into movies values ('Cousins','v','G5','','');
insert into movies values ('Crime de Monseiur Lange, Le','v','H6','','');
insert into movies values ('Crimes and Misdemeanors','v','H5','','');
insert into movies values ('Crimson Tide','v','','','');
insert into movies values ('Crow, The','v','','','');
insert into movies values ('Cry Freedom','v','A9','','');
insert into movies values ('Cry In the Dark, A','v','N9','','');
insert into movies values ('Crossing Delancy','v','J8','','');
insert into movies values ('Cure, The-120 Minutes (MTV)','v','A0','','');
insert into movies values ('Cyrano de Bergerac','v','L7','','');
insert into movies values ('Dangerous Liasons','v','J7','','');
insert into movies values ('Dangerous Moves','v','E2','','');
insert into movies values ('Dark Eyes','v','I7','','');
insert into movies values ('Dark Obcession','v','C3','','');
insert into movies values ('Darkman','s','SVHS12','','');
insert into movies values ('Dead Again','v','C0','','');
insert into movies values ('Dead Man Walking','v','','','');
insert into movies values ('Dead Poet\'s Society, The','v','E5','','');
insert into movies values ('Dead Pool, The','v','M8','','');
insert into movies values ('Death In Venice','v','','','');
insert into movies values ('Deceived','v','P1','','');
insert into movies values ('Deep Space Nine (pilot)','v','C3','','');
insert into movies values ('Diamonds are Forever','v','','','');
insert into movies values ('Diary of a Chambermaid','v','G5','','');
insert into movies values ('Die Hard II','s','SVHS9-SVHS10','','');
insert into movies values ('Dim Sum','v','N2','','');
insert into movies values ('Discrete Charm of the Bourgeoisie, The','v','B5','','');
insert into movies values ('Diva','v','','','');
insert into movies values ('Dr. No','v','N8','','');
insert into movies values ('Dr. Strangelove','v','A5','','');
insert into movies values ('Driving Miss Daisy','s','SVHS16','','');
insert into movies values ('Do the Right Thing','s','SVHS11','','');
insert into movies values ('Dolce Vita, La','s','SVHS21-SVHS22','','');
insert into movies values ('Don Juan De Marco','v','','','');
insert into movies values ('Don\'t Look Back','v','L3','','');
insert into movies values ('Doors, The','v','B7','','');
insert into movies values ('Double Life of Veronique, The','v','','','');
insert into movies values ('Duelists, The','v','M0','','');
insert into movies values ('Dune','s','SVHS5-SVHS6','','');
insert into movies values ('Easy Rider','v','O5','','');
insert into movies values ('East of Eden','v','','','');
insert into movies values ('Ed Wood','v','','','');
insert into movies values ('Edith and Marcel I6','v','I6','','');
insert into movies values ('Edward II','v','L8','','');
insert into movies values ('Edward Sissorhands','v','N7','','');
insert into movies values ('El Sur','v','H1','','');
insert into movies values ('Elephant Man, The','v','B4','','');
insert into movies values ('Empire of the Sun','v','N1','','');
insert into movies values ('Empire Strikes Back, The','v','C7','','');
insert into movies values ('Enchanted April','v','','','');
insert into movies values ('Enemies: A Love Story','v','L4','','');
insert into movies values ('Englishman who Went up a Hill, The','v','','','');
insert into movies values ('Equus','v','L5','','');
insert into movies values ('Erendira','v','I3','','');
insert into movies values ('Eric the Viking','v','A0','','');
insert into movies values ('Escape','v','J3','','');
insert into movies values ('Europa, Europa','v','Q2','','');
insert into movies values ('Fabulous Baker Boys, The','v','E9','','');
insert into movies values ('Fall of the Roman Empire, The','v','C8','','');
insert into movies values ('Family Business','v','H4','','');
insert into movies values ('Far From the Madding Crowd (missing part)','v','M2','','');
insert into movies values ('Farewell My Concubine','v','','','');
insert into movies values ('Farinelli','v','','','');
insert into movies values ('Femme Nikita, La','v','B1','','');
insert into movies values ('Few Good Men, A','v','N4','','');
insert into movies values ('Firm, The','v','P8','','');
insert into movies values ('Fish Called Wanda, A','v','M8','','');
insert into movies values ('400 Blows, The','v','J5','','');
insert into movies values ('47 Ronin, The','v','L0','','');
insert into movies values ('For Your Eyes Only','v','O7','','');
insert into movies values ('Forbidden Planet','v','O0','','');
insert into movies values ('Foreign Correspondent','v','P7','','');
insert into movies values ('Forest Gump','v','','','');
insert into movies values ('Forget Paris','v','','','');
insert into movies values ('Four Weddings and a Funeral','v','','','');
insert into movies values ('Fox, The','v','O8','','');
insert into movies values ('Frantic N7 Fried Green Tomatoes','v','C9','','');
insert into movies values ('French Kiss','v','','','');
insert into movies values ('French Lieutenant\'s Woman, The','v','E0','','');
insert into movies values ('Freud','v','O6','','');
insert into movies values ('From Russia with Love','v','O7','','');
insert into movies values ('Fugitive, The','v','','','');
insert into movies values ('Full Metal Jacket','v','I5','','');
insert into movies values ('Funeral, The','v','E8','','');
insert into movies values ('Gaby-A True Story','v','H3','','');
insert into movies values ('Garcia Marquez, Gabriel-The South Bank Show','v','G4','','');
insert into movies values ('Ghandi','v','J1','','');
insert into movies values ('Ghost','s','SVHS8-SVHS9','','');
insert into movies values ('Girl from Hunan, The','v','E9','','');
insert into movies values ('Girl in the Swing, The','v','A8','','');
insert into movies values ('Girlfriends','v','D4','','');
insert into movies values ('Godfather, The','v','P3','','');
insert into movies values ('Godfather-Pt. II, The','v','B3','','');
insert into movies values ('Godfather-Pt. III, The','v','D6','','');
insert into movies values ('Gods must be Crazy, The','v','K8','','');
insert into movies values ('Goldfinger','v','','','');
insert into movies values ('Good Earth, The','v','C8','','');
insert into movies values ('Good Morning Vietnam','v','A7','','');
insert into movies values ('Goodfellas','v','C5','','');
insert into movies values ('Grand Chemin, Le','v','H6','','');
insert into movies values ('Grand Highway, The','v','I6','','');
insert into movies values ('Grand Illusion, The','v','','','');
insert into movies values ('Great Dictator, The','v','G3','','');
insert into movies values ('Great Gatsby, The','v','M2','','');
insert into movies values ('Great Wall, A','v','E7','','');
insert into movies values ('Gregory\'s Girl','v','L8','','');
insert into movies values ('Grey Fox, The','v','B2','','');
insert into movies values ('Grifters, The','v','D6','','');
insert into movies values ('Hamlet (1969)','v','F2','','');
insert into movies values ('Hamlet','v','L7','','');
insert into movies values ('Hammerhead','v','E0','','');
insert into movies values ('Handful of Dust, A','v','A0','','');
insert into movies values ('Handmaidens Tale, The','v','G2','','');
insert into movies values ('Hannah and Her Sisters','v','J3','','');
insert into movies values ('Hanna\'s War F1 (incomplete)','v','','','');
insert into movies values ('Hear No Evil','v','N5','','');
insert into movies values ('Heat','v','','','');
insert into movies values ('Heat and Dust','v','P4','','');
insert into movies values ('Heaven and','v','Earth','','');
insert into movies values ('Hidden Fortress, The','v','I8','','');
insert into movies values ('Hit, The','v','B4','','');
insert into movies values ('Hitchhiker\'s Guide to the Galaxy (all episodes)','v','P2','','');
insert into movies values ('Hoffa','v','O9','','');
insert into movies values ('Home Alone','v','D0','','');
insert into movies values ('Home of the Brave','v','B8','','');
insert into movies values ('Hope and Glory','v','H7','','');
insert into movies values ('Howard\'s End','v','A3','','');
insert into movies values ('Hudson Hawk','v','C7','','');
insert into movies values ('Hudsucker Proxy,','v','The','','');
insert into movies values ('Hunt for Red October, The','s','SVHS1-SVHS2','','');
insert into movies values ('Ibsen\'s Ghosts','v','K6','','');
insert into movies values ('Icicle Theif, The','v','D0','','');
insert into movies values ('I\'m Gonna Git You Sucka','v','E2','','');
insert into movies values ('Imitation of Life','v','','','');
insert into movies values ('Immortal Beloved','v','','','');
insert into movies values ('Impulse','v','C5','','');
insert into movies values ('In the Name of the Father','v','','','');
insert into movies values ('In the Realm of Passion','v','','','');
insert into movies values ('Indiana Jones and the Last Crusade','v','A4','','');
insert into movies values ('Indochine','v','P9','','');
insert into movies values ('Inn of the Sixth Happiness, The','v','O1','','');
insert into movies values ('Interiors','v','','','');
insert into movies values ('Interview with a Vampire','v','','','');
insert into movies values ('Ironweed','v','A5','','');
insert into movies values ('Ivan the Terrible','v','J2','','');
insert into movies values ('I\'ve Heard Mermaids Singing','v','M6','','');
insert into movies values ('Jean de Florette','v','I9','','');
insert into movies values ('JFK','v','P6','','');
insert into movies values ('Johnny Mneumonic','v','','','');
insert into movies values ('Jour Se Leve, Le','v','J6','','');
insert into movies values ('Joy Luck Club, The','v','P8','','');
insert into movies values ('Ju Dou','v','D3','','');
insert into movies values ('Jules and Jim','v','J5','','');
insert into movies values ('Julia and Julia','v','G9','','');
insert into movies values ('Jungle Fever','v','','','');
insert into movies values ('Just Cause','v','','','');
insert into movies values ('Justine','v','O3','','');
insert into movies values ('K2-The Ultimate High','v','C0','','');
insert into movies values ('Killing, The','v','P0','','');
insert into movies values ('Killing Fields, The','v','L2','','');
insert into movies values ('Kiss of Death','v','','','');
insert into movies values ('Klimov','v','K6','','');
insert into movies values ('La Strada','v','','','');
insert into movies values ('Lacemaker, The','v','F8','','');
insert into movies values ('Lair of the White Worm','v','K8','','');
insert into movies values ('Last Emperor, The','v','I1','','');
insert into movies values ('Last Metro, The','v','D1','','');
insert into movies values ('Last Picture Show, The','v','Q2','','');
insert into movies values ('Last Seduction, The','v','','','');
insert into movies values ('Last Temptation of Christ, The','v','I1','','');
insert into movies values ('Lawnmower Man, The','v','','','');
insert into movies values ('Lawrence of Arabia','v','M3','','');
insert into movies values ('Lawrence of Arabia (letterbox, restored)','v','D5','','');
insert into movies values ('Leaving Las Vegas','v','','','');
insert into movies values ('Liebestraum','v','D2','','');
insert into movies values ('Lifeboat','v','M9','','');
insert into movies values ('Light Horsemen, The','v','L6','','');
insert into movies values ('Like Water for Chocolate (dubbed :-()','v','','','');
insert into movies values ('Little Big Man','v','N2-N3','','');
insert into movies values ('Little Buddha','v','','','');
insert into movies values ('Little Drummer Girl, The','v','E6','','');
insert into movies values ('Little Women','v','','','');
insert into movies values ('Live and Let Die','v','P0','','');
insert into movies values ('Local Hero','v','F7','','');
insert into movies values ('Lolita','v','A6','','');
insert into movies values ('Lonely Hearts','v','G7','','');
insert into movies values ('Looking Glass War, The','v','Q2','','');
insert into movies values ('Love At Large','v','H8','','');
insert into movies values ('Lover, The','v','A1','','');
insert into movies values ('MacArthur\'s Children','v','M5','','');
insert into movies values ('Madame Bovary','v','','','');
insert into movies values ('Madame Sousatzka','v','I2','','');
insert into movies values ('Madness of King George, The','v','','','');
insert into movies values ('Making of Thelma and Louise, The','v','D5','','');
insert into movies values ('Malcolm X','v','N5','','');
insert into movies values ('Mama, There\'s a Man In Your Bed','v','P5','','');
insert into movies values ('Man in Love, A','s','SVHS24','','');
insert into movies values ('Man Who Fell to Earth, The','v','D8','','');
insert into movies values ('Man Who Would be King, The','s','SVHS22-SVHS23','','');
insert into movies values ('Manchurian Candidate, The','v','J9','','');
insert into movies values ('Manhattan','v','L3','','');
insert into movies values ('Manon of the Spring','v','I9','','');
insert into movies values ('Marathon Man','v','','','');
insert into movies values ('Marley, Bob-Time Will Tell','v','C0','','');
insert into movies values ('Mary Queen of Scotts','v','J9','','');
insert into movies values ('Mask, THe','v','','','');
insert into movies values ('Master Builder, The','v','H7','','');
insert into movies values ('Matewan','v','H4','','');
insert into movies values ('Maurice','v','E1','','');
insert into movies values ('Meditarraneo','v','','','');
insert into movies values ('Mephisto','v','L4','','');
insert into movies values ('Merry Christmas, Mr. Lawrence','v','D8','','');
insert into movies values ('Mighty Aphrodite','v','','','');
insert into movies values ('Milagro Beanfield War, The','v','M8','','');
insert into movies values ('Milky Way, The','v','B5','','');
insert into movies values ('Miller\'s Crossing','v','P5','','');
insert into movies values ('Mission, The','v','F9','','');
insert into movies values ('Missippi Burning','v','L3','','');
insert into movies values ('Missippi Masala','v','O4','','');
insert into movies values ('Mr. Holland\'s Opus','v','','','');
insert into movies values ('Mr. North','v','C2','','');
insert into movies values ('Moderns, The','v','','','');
insert into movies values ('Monster In a Box','v','A3','','');
insert into movies values ('Monty Python and the Holy Grail','v','Q0','','');
insert into movies values ('Moonstruck','v','M1','','');
insert into movies values ('Murder In the First','v','','','');
insert into movies values ('Music Box, The','v','F1','','');
insert into movies values ('My Blue Heaven','v','P5','','');
insert into movies values ('My Favorite Year','v','M3','','');
insert into movies values ('My Left Foot','v','J3','','');
insert into movies values ('My Life as a Dog (dubbed, yech!)','v','A9','','');
insert into movies values ('My Stepmother Is an Alien','v','K2','','');
insert into movies values ('Naked Lunch','v','C2','','');
insert into movies values ('Name of the Rose, The','v','B2','','');
insert into movies values ('Native Son','v','J1','','');
insert into movies values ('Natural, The','v','C1','','');
insert into movies values ('Natural Born Killers','v','','','');
insert into movies values ('Nell','v','','','');
insert into movies values ('Night in Casablanca, A','v','E4','','');
insert into movies values ('Night My Number Came Up, The','v','O3','','');
insert into movies values ('No Appologies-Andrew Dice Clay','v','O2','','');
insert into movies values ('Norman Conquests, The, I, II & III','v','K6-K7','','');
insert into movies values ('North by Northwest','v','M9','','');
insert into movies values ('Notte, La','v','N6','','');
insert into movies values ('Nuit De Varennes, La I3 (missing 1st 20 min.)','v','','','');
insert into movies values ('Nuns on the Run','v','G2','','');
insert into movies values ('Octopussy','v','N8','','');
insert into movies values ('Of Mice and Men','v','','','');
insert into movies values ('On the Waterfront','v','','','');
insert into movies values ('One Flew over the Cuckoo\'s Nest','v','K9','','');
insert into movies values ('Once Were Warriors','v','','','');
insert into movies values ('Once Upon a Time in America','v','G7','','');
insert into movies values ('Once Upon a Time in the West','v','A2','','');
insert into movies values ('Other People\'s Money','v','P4','','');
insert into movies values ('Out of Africa','s','SVHS18-SVHS19','','');
insert into movies values ('Outland','v','C2','','');
insert into movies values ('Outrageous','v','D4','','');
insert into movies values ('Pacific Heights','v','B3','','');
insert into movies values ('Paralax View, The','v','I3','','');
insert into movies values ('Paris, Texas','v','N0','','');
insert into movies values ('Paris Trout','v','O5','','');
insert into movies values ('Party, The','v','J0','','');
insert into movies values ('Pascali\'s Island','v','F1','','');
insert into movies values ('Passage to India','v','M6','','');
insert into movies values ('Patriot Games','v','C3','','');
insert into movies values ('Pele the Conqueror','v','B5','','');
insert into movies values ('Pelican Brief, The','v','','','');
insert into movies values ('Perfect Spy, The','v','H9-I0','','');
insert into movies values ('Personal Best','v','N4','','');
insert into movies values ('Personal Services','v','M5','','');
insert into movies values ('Philadelphia','v','','','');
insert into movies values ('Piano, The','v','P9','','');
insert into movies values ('Picnic, The','v','O9','','');
insert into movies values ('Pink Floyd-The Delicate Sound of Thunder','v','','','');
insert into movies values ('Platoon','v','L2','','');
insert into movies values ('Player, The','v','','','');
insert into movies values ('Presidio','v','K4','','');
insert into movies values ('Presumed Innocent','v','M7','','');
insert into movies values ('Pretty Woman','s','SVHS7-SVHS8','','');
insert into movies values ('Prick Up Your Ears','v','D9','','');
insert into movies values ('Pride and Prejudice','v','','','');
insert into movies values ('Priest of Love, The','v','G8','','');
insert into movies values ('Princess Bride, The','v','M6','','');
insert into movies values ('Private Function, A','v','G6','','');
insert into movies values ('Prizi\'s Honour','v','P4','','');
insert into movies values ('Prospero\'s Books','v','','','');
insert into movies values ('Pulp Fiction','v','','','');
insert into movies values ('QB VIII','v','','','');
insert into movies values ('Queen of Hearts','v','A8','','');
insert into movies values ('Quiet Earth, The','v','B8','','');
insert into movies values ('Quiz Show','v','','','');
insert into movies values ('Raging Bull','s','SVHS13-SVHS14','','');
insert into movies values ('Rain Man','v','K2','','');
insert into movies values ('Rainbow, The','s','SVHS24','','');
insert into movies values ('Raise the Red Lantern','v','P2','','');
insert into movies values ('Ran','v','I5','','');
insert into movies values ('Ragtime','v','E6','','');
insert into movies values ('Rashoman','v','K5','','');
insert into movies values ('Rattle & Hum-U2','v','Q0','','');
insert into movies values ('Rebel without a Cause, A','v','F2','','');
insert into movies values ('Red','v','','','');
insert into movies values ('Red Balloon, The','v','N2','','');
insert into movies values ('Red Tent, The','v','N6','','');
insert into movies values ('Remains of the Day, The','v','','','');
insert into movies values ('Repo Man','v','C4','','');
insert into movies values ('Repulsion','v','I7','','');
insert into movies values ('Resevoir Dogs','v','','','');
insert into movies values ('Return to Waterloo','v','J0','','');
insert into movies values ('Return of the Jedi','v','C6-C7','','');
insert into movies values ('Reversal of Fortune','v','N9','','');
insert into movies values ('Ricky and Pete','v','N1','','');
insert into movies values ('Rising Sun','v','','','');
insert into movies values ('River Runs Through It, A','v','P1','','');
insert into movies values ('Robin Hood, Prince of Thieves','v','B1','','');
insert into movies values ('Rocky & Bullwinkle special from PBS','v','I4','','');
insert into movies values ('Roger and Me','v','J0','','');
insert into movies values ('Room Service','v','E4','','');
insert into movies values ('Room with a View, A','v','E9','','');
insert into movies values ('Rogue Baiser, Le','v','D9','','');
insert into movies values ('Russia House','v','B7','','');
insert into movies values ('Ruthless People','v','C1','','');
insert into movies values ('Saboteur','v','O4','','');
insert into movies values ('Sahara Heat','s','SVHS25','','');
insert into movies values ('Salaam Bombay','v','F0','','');
insert into movies values ('St. Elmo\'s Fire','v','E3','','');
insert into movies values ('Samjuro','v','F9','','');
insert into movies values ('Samurai Trilogy-Duel at Ganryu Island','v','L1','','');
insert into movies values ('Samurai Trilogy-Duel at Ichijoji Temple','v','L1','','');
insert into movies values ('Samurai Trilogy-Legend of Musashi Miyamoto','v','L1','','');
insert into movies values ('Scenes from the Class Struggle in Beverley Hills','v','I4','','');
insert into movies values ('Scent of a Woman','v','O1','','');
insert into movies values ('Schindler\'s List','v','','','');
insert into movies values ('School Daze','v','O8','','');
insert into movies values ('Sense and Sensibility','v','','','');
insert into movies values ('Senso','v','O0','','');
insert into movies values ('Seven','v','','','');
insert into movies values ('sex, lies and videotape','v','K7','','');
insert into movies values ('Shadow of the Thin Man','v','M0','','');
insert into movies values ('Shadlowlands','v','','','');
insert into movies values ('Shawshank Redemption, The','v','','','');
insert into movies values ('She\'s Got to Have It','v','N4','','');
insert into movies values ('Shoa, I & II','v','G0-G1','','');
insert into movies values ('Silence of the Lambs','v','N9','','');
insert into movies values ('Single White Female, A','v','L9','','');
insert into movies values ('Skiing-Women\'s World Cup Super G 1989','v','I2','','');
insert into movies values ('Slackers','v','','','');
insert into movies values ('Slamdance','v','K4','','');
insert into movies values ('Slaughterhouse Five','v','P7','','');
insert into movies values ('Sleepless in Seattle','v','N6','','');
insert into movies values ('Smiley\'s People','v','I0','','');
insert into movies values ('Soccer-World Cup','v','','','');
insert into movies values ('Soldier of Orange','v','D7','','');
insert into movies values ('Sometimes a Great Notion','v','C1','','');
insert into movies values ('Sons and Lovers','v','O0','','');
insert into movies values ('Sorceror','v','K8','','');
insert into movies values ('Speed','v','','','');
insert into movies values ('Shanghai Lady, The','v','H1','','');
insert into movies values ('Shining, The','v','H1','','');
insert into movies values ('Stalin','v','A6','','');
insert into movies values ('Stand and Deliver','v','L6','','');
insert into movies values ('Stanley and Iris','v','D0','','');
insert into movies values ('Star Trek','v','J1','','');
insert into movies values ('Star Trek VI-The Undiscovered Country','v','P1','','');
insert into movies values ('Star Trek Generation','v','','','');
insert into movies values ('Star Wars','v','C4','','');
insert into movies values ('Stealing Heaven','v','A4','','');
insert into movies values ('Steel Magnolias','v','G4','','');
insert into movies values ('Strapless','v','B4','','');
insert into movies values ('Swimming to Cambodia B8','s','SVHS18','','');
insert into movies values ('Tale of Two Cities, A','v','','','');
insert into movies values ('Tampopo','v','E8','','');
insert into movies values ('Tea in the Harem','v','D1','','');
insert into movies values ('Tenant, The','v','B0','','');
insert into movies values ('Tender is the Night','v','K0','','');
insert into movies values ('Terminator II-Judgement Day','v','D7','','');
insert into movies values ('Testament of Orpheus','v','O6','','');
insert into movies values ('That Obscure Objct of Desire','s','SVHS3-SVHS4','','');
insert into movies values ('Thelma and Louise','v','C7','','');
insert into movies values ('Thief','v','G2','','');
insert into movies values ('Thin Blue Line, The','v','F7','','');
insert into movies values ('Thin Man Goes Home, THe','v','M0','','');
insert into movies values ('Thomas Crowne Affair, The','v','O8','','');
insert into movies values ('Three Days of the Condor','v','','','');
insert into movies values ('Three Men and a Baby','v','H0','','');
insert into movies values ('Three Women','v','A8','','');
insert into movies values ('Throne of Blood','v','I8','','');
insert into movies values ('Tie Me Up, Tie Me Down','v','E3','','');
insert into movies values ('Time Bandits','v','O5','','');
insert into movies values ('Tin Drum, The (subtitled)','v','I2','','');
insert into movies values ('Tinker, Tailor, Soldier, Spy','v','M4','','');
insert into movies values ('To Catch a Thief','v','M9','','');
insert into movies values ('To Live','v','','','');
insert into movies values ('Too Beautiful for You','v','B7','','');
insert into movies values ('Tom Jones','v','H0','','');
insert into movies values ('Top Gun','v','J8','','');
insert into movies values ('Topaz','v','F6','','');
insert into movies values ('Total Recall','s','SVHS15','','');
insert into movies values ('Tour de France-1989','v','','','');
insert into movies values ('Tour de Trump','v','F0','','');
insert into movies values ('Toys','v','A3','','');
insert into movies values ('True Stories','v','J4','','');
insert into movies values ('Truly Madly Deeply','v','L8','','');
insert into movies values ('Twelve','v','Monkeys','','');
insert into movies values ('Twenty Films about Glenn Gould','v','','','');
insert into movies values ('Twin Peaks-Fire Walk with Me','v','D3','','');
insert into movies values ('Two English Girls','v','D1','','');
insert into movies values ('Two Jakes','s','SVHS6-SVHS7','','');
insert into movies values ('Unbearable Lightness of Being, The','v','N0,O2','','');
insert into movies values ('Uncle Vanya','v','J6','','');
insert into movies values ('Under the Volcano','v','D2','','');
insert into movies values ('Unforgiven','v','A1','','');
insert into movies values ('Unsuitable Job for a Woman, An','v','O3','','');
insert into movies values ('Untouchables, The','s','SVHS17','','');
insert into movies values ('V. I. Warshawski','v','B1','','');
insert into movies values ('Valmont','v','F8','','');
insert into movies values ('Vanishing, The','v','O2','','');
insert into movies values ('Vertigo','v','B0','','');
insert into movies values ('Video Cycle...video clips of cycling in Hawaii, SF, Vermont N3','v','N3','','');
insert into movies values ('Villian, The','v','F8','','');
insert into movies values ('Volleyball-Olympics-1988-U.S.A. vs Japan(men), Holland(men), China(women)','v','','','');
insert into movies values ('Volleyball-Golddiggers v.s. L.A.','v','I7','','');
insert into movies values ('Waterworld','v','','','');
insert into movies values ('When Harry Met Sally','v','H0','','');
insert into movies values ('White','v','','','');
insert into movies values ('Who Framed Roger Rabbit','s','SVHS25','','');
insert into movies values ('Wild At Heart','v','F2','','');
insert into movies values ('Wild Duck, The','v','G8','','');
insert into movies values ('Wild Orchid','v','','','');
insert into movies values ('Wings of Desire','v','Q1','','');
insert into movies values ('Witches of Eastwick, The','v','K3','','');
insert into movies values ('Wolf','v','','','');
insert into movies values ('Wolf at the Door','v','G8','','');
insert into movies values ('Woman Next Door, The','v','J5','','');
insert into movies values ('Women on the Verge of a Nervous Breakdown','v','J4','','');
insert into movies values ('World Apart, A','v','A7','','');
insert into movies values ('World Championship of Cycling, 1989','v','','','');
insert into movies values ('Year of Living Dangerously, The','v','G9','','');
insert into movies values ('Yojimbo','v','F9','','');
insert into movies values ('You Only Live Twice','v','P0','','');
insert into movies values ('Young Einstein','v','H6','','');
insert into movies values ('Young Sherlock Holmes','v','J7','','');
insert into movies values ('Z','v','','','');
insert into movies values ('Blade Runner: The Director\'s Cut','d','','','');
insert into movies values ('The Cure-The Cure in Orange','d','','','');
insert into movies values ('The Cure-The Cure Play Out','d','','','');
insert into movies values ('Dances with Wolves','d','','','');
insert into movies values ('Depeche Mode-101','d','','','');
insert into movies values ('Erasure-Pop!','d','','','');
insert into movies values ('Koyaanisqatsi','d','','','');
insert into movies values ('National Gallery of Art','d','','','');
insert into movies values ('REM-This Film is On','d','','','');
insert into movies values ('U2-Achtung Baby','d','','','');