-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 28, 2011 at 10:17 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `videogames`
--

-- --------------------------------------------------------

--
-- Table structure for table `developer`
--

CREATE TABLE IF NOT EXISTS `developer` (
  `developerid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `founded` year(4) NOT NULL,
  `country` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`developerid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=101 ;

--
-- Dumping data for table `developer`
--

INSERT INTO `developer` (`developerid`, `name`, `founded`, `country`) VALUES
(1, 'Tribecca', 1998, 'USA'),
(2, 'GlyphX Games', 2008, 'France'),
(5, 'Karma Labs; Inc.', 1992, 'Great Britain'),
(6, 'AWE Games', 2000, 'USA'),
(7, 'Ensemble Studios', 2009, 'Great Britain'),
(8, 'Private Moon Studios', 2008, 'Canada'),
(9, 'Himalaya Studios; LLC', 1994, 'Japan'),
(10, 'Bean', 1998, 'Great Britain'),
(11, 'Housemarque', 2005, 'France'),
(12, 'Trecision', 2007, 'France'),
(13, 'I-Motion; Inc.', 2003, 'USA'),
(14, 'Spiral House Ltd.', 1991, 'Great Britain'),
(15, 'Microids', 1994, 'France'),
(16, 'Electric Dreams Inc.', 2007, 'Canada'),
(17, 'Deck 13', 1999, 'Canada'),
(18, 'DreamForge Entertainment; Inc', 1999, 'Japan'),
(19, 'Troika', 1994, 'France'),
(21, 'Midway', 2004, 'USA'),
(22, 'Planet Moon Studios', 1990, 'USA'),
(23, 'Arkane Studios', 1990, 'France'),
(24, 'Etranges Libellules', 1991, 'Canada'),
(25, 'Cryo Interactive Entertainment', 2000, 'France'),
(26, 'ClockStone Software', 2005, 'Japan'),
(27, 'Intelligent Games; Ltd.', 1997, 'Great Britain'),
(29, 'Animagination', 2008, 'Canada'),
(30, 'Pulse Entertainment', 1996, 'Canada'),
(31, 'BioWare Corp.', 1992, 'USA'),
(32, 'Shadow Tor Studios', 1996, 'USA'),
(33, 'Take 2 Interactive; Inc.', 1997, 'Great Britain'),
(34, 'Westwood Studios', 2005, 'France'),
(35, 'Terminal Reality', 2006, 'USA'),
(36, 'Human Head Studios; Inc.', 1995, 'USA'),
(37, 'Ritual', 2004, 'Canada'),
(39, 'Tsunami Media; Inc.', 1998, 'Japan'),
(42, 'Brat Designs', 1996, 'France'),
(43, 'Revolution Software', 1992, 'France'),
(44, 'Merit Studios', 1990, 'USA'),
(45, 'Trip Media', 2002, 'Japan'),
(46, 'Headfirst Productions', 1994, 'France'),
(47, 'Infinity Ward', 2005, 'France'),
(48, 'Techland', 2003, 'USA'),
(49, 'Activision', 1991, 'USA'),
(52, 'SCi', 2003, 'Great Britain'),
(53, 'Rainbow Studios; Inc.', 2004, 'Canada'),
(54, 'Absurdus', 1992, 'Canada'),
(55, 'Artech Digital Entertainment; Ltd.', 1990, 'Japan'),
(56, 'Blue Byte', 1996, 'Japan'),
(58, 'DreamForge', 1994, 'Canada'),
(59, 'Psyg0sis', 1997, 'Great Britain'),
(60, 'MicroProse Software; Inc.', 2002, 'Canada'),
(61, 'Trilobyte', 2000, 'Great Britain'),
(62, 'DreamWorks Interactive', 1994, 'Canada'),
(63, 'Codemasters', 1994, 'Great Britain'),
(64, '0valogic', 2001, 'France'),
(66, 'Pyro Studios', 1995, 'USA'),
(67, 'Mo0lith Productions; Inc.', 2003, 'France'),
(68, 'Viacom New Media', 2007, 'Canada'),
(70, 'Fever Pitch Studios', 2001, 'Japan'),
(71, 'Various', 1993, 'Great Britain'),
(72, 'Artematica', 2008, 'Japan'),
(73, 'Sweet Basil', 2002, 'France'),
(74, 'Argonaut Software Ltd.', 2005, 'USA'),
(75, 'Origin Systems', 1998, 'USA'),
(76, 'Some Interactive', 1990, 'USA'),
(78, '369 Interactive', 2002, 'Great Britain'),
(80, 'Telltale Games', 2008, 'Canada'),
(82, 'Ubisoft', 2007, 'France'),
(83, 'Nu Generation', 2005, 'France'),
(84, 'Beam Software Pty. Ltd.', 1991, 'France'),
(85, 'Konami Co.; Ltd.', 2002, 'Japan'),
(86, 'Kalisto Entertainment', 2009, 'Canada'),
(87, 'Inscape', 1999, 'USA'),
(89, 'XXv Productions', 2005, 'Great Britain'),
(90, 'Pandemic', 1992, 'Great Britain'),
(91, 'Cyberdreams; Inc', 1991, 'Japan'),
(92, 'Orion Versand GmbH & Co. KG', 2007, 'France'),
(93, 'Legend Entertainment Company', 1999, 'France'),
(95, 'Spellbound', 2007, 'USA'),
(96, 'Ion Storm', 2007, 'Japan'),
(97, 'GameSquad', 2008, 'USA'),
(98, 'Capcom', 2002, 'USA'),
(100, 'Perfect Entertainment', 1998, 'Great Britain');

-- --------------------------------------------------------

--
-- Table structure for table `game`
--

CREATE TABLE IF NOT EXISTS `game` (
  `gameid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `genre` varchar(100) NOT NULL,
  `completed` tinyint(1) NOT NULL,
  `year` year(4) NOT NULL,
  `rating` int(11) DEFAULT NULL,
  `disknumber` int(11) NOT NULL,
  `developer` int(11) DEFAULT NULL,
  `storage` int(11) DEFAULT NULL,
  PRIMARY KEY (`gameid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=500 ;

--
-- Dumping data for table `game`
--

INSERT INTO `game` (`gameid`, `title`, `genre`, `completed`, `year`, `rating`, `disknumber`, `developer`, `storage`) VALUES
(1, 'Agon: The Mysterious Codex', 'Adventure', 1, 2007, 8, 1, 85, 3),
(2, 'Al Emmo and the Lost Dutchman Mine', 'Adventure', 1, 2006, 6, 1, 53, 2),
(3, 'Alien Earth', 'Action Adventure', 0, 1998, 5, 1, 36, 2),
(4, 'Alien Incident', 'Adventure', 1, 1996, 6, 1, NULL, 3),
(5, 'Alien Virus', 'Adventure', 1, 1994, 5, 1, 89, 0),
(6, 'Alone in the Dark', 'Survival Horror', 1, 1992, 7, 1, NULL, 2),
(7, 'Alone in the Dark 2', 'Survival Horror', 0, 1994, 0, 1, 58, 0),
(8, 'Alone in the Dark 3', 'Survival Horror', 0, 1995, 6, 1, 76, 1),
(9, 'Alone in the Dark: The New Nightmare', 'Action Adventure', 1, 2001, 8, 3, 98, 1),
(10, 'Amerzone', 'Adventure', 1, 2001, 7, 4, NULL, 1),
(11, 'Angel Devoid: Face of the Enemy', 'Adventure', 1, 1995, 6, 4, 13, 2),
(12, 'Ankh', 'Adventure', 1, 2006, 9, 1, 67, 0),
(13, 'Anvil of Dawn', 'RPG', 1, 1995, 10, 1, 24, 2),
(14, 'Arcanum: Of Steamworks and Magick Obscura', 'RPG', 0, 2001, 0, 2, 70, 4),
(15, 'Are You Afraid of the Dark?', 'Adventure', 1, 1994, 6, 1, 82, 3),
(16, 'Area 51', 'FPS', 1, 2005, 8, 3, 67, 1),
(17, 'Armed and Dangerous', 'Action Adventure', 1, 2003, 9, 2, 71, 3),
(18, 'Arx Fatalis', 'RPG', 0, 2002, 0, 1, 29, 1),
(19, 'Asterix And Obelix XXL', 'Platform', 1, 2004, 7, 1, 18, 4),
(20, 'Atlantis II: Beyond Atlantis', 'Adventure', 1, 2000, 8, 4, NULL, 0),
(21, 'Atlantis III: The New World', 'Adventure', 1, 2001, 8, 3, 67, 3),
(22, 'Atlantis: The Lost Tales', 'Adventure', 1, 1999, 8, 4, 96, 0),
(23, 'Avencast: Rise of the Mage', 'RPG', 1, 2007, 8, 1, 95, 4),
(24, 'Azraels Tear', 'Adventure', 0, 1996, 0, 1, 29, 4),
(25, 'Aztec: The Curse in the Heart of the City of Gold', 'Adventure', 1, 1999, 6, 1, 64, 4),
(26, 'Backpacker: The Lost Florence Gold Mine', 'Adventure', 0, 1995, 0, 1, 75, 2),
(27, 'Bad Mojo', 'Adventure', 0, 1996, 0, 1, 45, 4),
(28, 'Baldurs Gate II: Throne of Bhaal', 'RPG', 0, 2001, 0, 1, 45, 3),
(29, 'Barrow Hill', 'Adventure', 1, 2006, 6, 1, 49, 3),
(30, 'Black Dahlia', 'Adventure', 1, 1997, 10, 8, NULL, 3),
(31, 'Blade Runner', 'Adventure', 1, 1997, 8, 4, 82, 3),
(32, 'Blair Witch Volume 1: Rustin Parr', 'Action Adventure', 1, 2000, 6, 1, 52, 2),
(33, 'Blair Witch Volume 2: Coffin Rock 1886', 'Action Adventure', 1, 2000, 5, 2, 30, 2),
(34, 'Blair Witch Volume 3: The Elly Kedward Tale', 'Action/Adventure', 1, 2001, 6, 2, 15, 1),
(35, 'BloodRayne', 'Action Adventure', 1, 2003, 8, 2, 59, 4),
(36, 'BloodRayne 2', 'Action Adventure', 1, 2005, 5, 1, 30, 4),
(37, 'Blue Force', 'Adventure', 1, 1993, 6, 1, 11, 1),
(38, 'Blue Ice', 'Adventure', 0, 1995, 0, 1, NULL, 0),
(39, 'Breath of Fire IV', 'RPG', 1, 2001, 7, 1, 97, 2),
(40, 'Breed', 'FPS', 0, 2004, 0, 1, NULL, 2),
(41, 'Broken Sword 2: The Smoking Mirror', 'Adventure', 1, 2001, 7, 2, 43, 4),
(42, 'Broken Sword 3: The Sleeping Dragon', 'Adventure', 1, 2005, 7, 2, 98, 0),
(43, 'Broken Sword 4: The Angel Of Death', 'Adventure', 1, 2007, 9, 1, 90, 1),
(44, 'Broken Sword: The Shadow of the Templars', 'Adventure', 1, 1997, 9, 2, 56, 1),
(45, 'Bud Tucker in Double Trouble', 'Adventure', 1, 1996, 6, 1, NULL, 0),
(46, 'Bureau 13', 'Adventure', 1, 1995, 7, 1, 63, 4),
(47, 'Burn: Cycle', 'Adventure', 0, 1995, 0, 1, 62, 0),
(48, 'Call of Cthulhu: Dark Corners of the Earth', 'FPS', 1, 2006, 7, 1, 63, 0),
(49, 'Call of Duty 2', 'FPS', 1, 2005, 8, 1, 23, 1),
(50, 'Call of Juarez', 'FPS', 1, 2007, 8, 1, NULL, 3),
(51, 'Call to Power II', 'Strategy', 0, 2000, 0, 1, 45, 1),
(52, 'Callahans Crosstime Saloon', 'Adventure', 1, 1997, 6, 1, 97, 2),
(53, 'Carmageddon 2: Carpocalypse 0w', 'Racing', 0, 2002, 7, 1, 47, 1),
(54, 'Carmageddon 3: The Death Race 2000', 'Racing', 0, 2000, 6, 1, 66, 1),
(55, 'Cars', 'Racing', 0, 2006, 4, 1, NULL, 3),
(56, 'Carte Blanche', 'Puzzle', 1, 2006, 8, 1, 70, 3),
(57, 'Celtica', 'Adventure', 0, 1998, 4, 2, 7, 1),
(58, 'Chewy: Esc from F5', 'Adventure', 1, 1995, 4, 1, 6, 0),
(59, 'China: The Forbidden City', 'Adventure', 1, 1999, 6, 1, 62, 1),
(60, 'Chro0master', 'Adventure', 1, 1994, 7, 1, NULL, 3),
(61, 'The City of Lost Children', 'Adventure', 0, 1997, 0, 1, NULL, 1),
(62, 'Civilization II', 'Strategy', 0, 1998, 0, 1, 30, 2),
(63, 'Clandestiny', 'Adventure', 1, 1996, 5, 2, 5, 0),
(64, 'Clive Barkers Undying', 'FPS', 1, 2001, 10, 1, 6, 4),
(65, 'Colin McRae Rally 2.0', 'Racing', 0, 2000, 0, 1, 1, 3),
(66, 'Commanche 4', 'Simulation', 0, 2001, 0, 1, 55, 1),
(67, 'Commandos Strike Force', 'FPS', 1, 2006, 8, 1, 78, 3),
(68, 'Commandos: Behind Enemy Lines', 'Strategy', 0, 1998, 0, 1, 63, 2),
(69, 'Condemned: Criminal Origins (Dvd)', 'FPS', 1, 2006, 9, 1, 92, 0),
(70, 'Congo: Descent Into Zinj', 'Adventure', 0, 1996, 5, 1, 14, 1),
(71, 'Conquest: Frontier Wars', 'Strategy', 0, 2001, 0, 1, 82, 4),
(72, 'Crazy Game Collection', 'Compilation', 0, 1994, 6, 1, 85, 1),
(73, 'Crime Stories : From The Files Of Martin Mystere', 'Adventure', 1, 2006, 7, 1, 82, 1),
(74, 'Critical Path', 'Adventure', 1, 1998, 5, 1, NULL, 2),
(75, 'Croc: Legend of Gobbos', 'Platform', 1, 1999, 7, 1, 98, 0),
(76, 'Crusader: 0 Regret', 'Action Adventure', 1, 1996, 8, 1, 56, 0),
(77, 'The Crystal Skull', 'Adventure', 1, 1996, 5, 3, 35, 3),
(78, 'CSI: 3 Dimensions of Murder', 'Adventure', 1, 2006, 7, 1, 6, 2),
(79, 'CSI: Crime Scene Investigation', 'Adventure', 1, 2003, 8, 3, 12, 1),
(80, 'CSI: Crime Scene Investigation Dark Motives', 'Adventure', 1, 2004, 8, 1, 90, 0),
(81, 'CSI: Crime Scene Investigation: Hard Evidence', 'Adventure', 1, 2007, 8, 1, 35, 0),
(82, 'CSI: Miami', 'Adventure', 1, 2004, 8, 3, 31, 2),
(83, 'CSI: New York', 'Adventure', 0, 2008, 0, 1, 75, 3),
(84, 'D.I.R.T.', 'Action', 0, 2006, 5, 1, 87, 4),
(85, 'The Dame Was Loaded', 'Adventure', 1, 1995, 6, 1, 9, 0),
(86, 'Dance Dance Revolution', 'Simulation', 0, 2002, 6, 1, 62, 0),
(87, 'Dark Earth', 'Adventure', 0, 1997, 0, 2, NULL, 2),
(88, 'Dark Eye', 'Adventure', 0, 1997, 6, 1, 43, 2),
(89, 'Dark Fall', 'Adventure', 1, 2003, 8, 1, 86, 3),
(90, 'Dark Fall: Lights Out', 'Adventure', 1, 2004, 8, 1, 36, 1),
(91, 'Dark Reign 2', 'Strategy', 0, 2000, 0, 1, 70, 0),
(92, 'Darkseed 2', 'Adventure', 1, 1995, 6, 1, NULL, 2),
(93, 'Days Of Oblivion', 'Adventure', 1, 1996, 6, 3, NULL, 3),
(94, 'Death Gate', 'Adventure', 1, 1994, 6, 1, 91, 3),
(95, 'Delta Force 3: Land Warrior', 'FPS', 1, 2000, 4, 1, NULL, 1),
(96, 'Desperados: Wanted Dead or Alive', 'Strategy', 0, 2001, 0, 1, 80, 0),
(97, 'Deus Ex', 'Action Adventure', 0, 2001, 0, 1, NULL, 4),
(98, 'Devil Inside', 'Action Adventure', 1, 2000, 8, 1, 24, 0),
(99, 'Discworld II: Mortality Bytes', 'Adventure', 1, 1996, 6, 2, 53, 0),
(100, 'Discworld 0ir', 'Adventure', 1, 1996, 8, 1, 68, 4),
(101, 'Divi-Dead', 'Adventure', 1, 1998, 6, 1, 22, 0),
(102, 'Dogday', 'Adventure', 0, 1999, 2, 1, 15, 4),
(103, 'Doom 3', 'FPS', 1, 2004, 8, 1, 7, 1),
(104, 'Doom 3: Resurrection of Evil', 'FPS', 1, 2005, 8, 1, 54, 1),
(105, 'Doushin Same Heart', 'Adventure', 1, 2000, 4, 2, NULL, 3),
(106, 'Dracula 2: The Last Sanctuary', 'Adventure', 1, 2001, 9, 2, NULL, 2),
(107, 'Dracula Unleashed', 'Adventure', 1, 1993, 7, 1, NULL, 3),
(108, 'Dracula X: 0cturne In The Moonlight', 'Action Adventure', 0, 1998, 0, 1, NULL, 1),
(109, 'Dracula: Resurrection', 'Adventure', 1, 2000, 9, 2, 64, 3),
(110, 'Dragon Lore', 'Adventure', 0, 1994, 0, 2, 49, 2),
(111, 'Dreamfall: The Longest Journey', 'Adventure', 1, 2006, 9, 6, 29, 0),
(112, 'Drug Wars', 'Shooter', 0, 1994, 0, 1, NULL, 4),
(113, 'Duke Nukem 3D: Plutonium Pak', 'FPS', 1, 1997, 8, 3, 73, 1),
(114, 'Dungeon Siege', 'RPG', 1, 2002, 8, 1, 80, 2),
(115, 'Dungeon Siege II', 'RPG', 1, 2005, 9, 4, NULL, 4),
(116, 'Dungeon Siege II: Broken World', 'RPG', 1, 2006, 8, 1, NULL, 2),
(117, 'Earthworm Jim', 'Platform', 0, 1995, 0, 1, 91, 4),
(118, 'Earthworm Jim 2', 'Platform', 0, 1998, 5, 1, 11, 2),
(119, 'Earthworm Jim 3D', 'Platform', 0, 2000, 5, 1, 39, 3),
(120, 'ECHO: Secrets of the Lost Cavern', 'Adventure', 1, 2005, 7, 2, 13, 0),
(121, 'EcoQuest: The Search for Cetus', 'Adventure', 1, 1991, 6, 1, 31, 0),
(122, 'Egypt II: The Heliopolis Prophecy', 'Adventure', 1, 2000, 8, 2, NULL, 1),
(123, 'Egypt III : The Fate Of Ramses', 'Adventure', 1, 2006, 8, 3, 84, 3),
(124, 'Egypt: Tomb of the Pharaoh', 'Adventure', 1, 2000, 6, 1, 100, 4),
(125, 'Enter the Matrix', 'Action Adventure', 1, 2003, 8, 4, 61, 1),
(126, 'Entombed', 'Adventure', 0, 1997, 0, 1, NULL, 1),
(127, 'Entomorph: Plague of the Darkfall', 'RPG', 1, 1996, 7, 1, 98, 4),
(128, 'Escape From Monkey Island', 'Adventure', 1, 2002, 10, 2, 67, 1),
(129, 'Euro 96', 'Sports', 1, 1996, 9, 1, 97, 0),
(130, 'Eurofighter Typhoon', 'Flight Simulation', 0, 2001, 0, 1, 93, 0),
(131, 'Evidence: The Last Ritual', 'Adventure', 1, 2006, 8, 4, NULL, 2),
(132, 'Evil Dead Regeneration', 'Action Adventure', 1, 2005, 8, 1, 48, 2),
(133, 'Evil Islands: Curse of the Lost Soul', 'RPG', 0, 2001, 5, 1, 64, 0),
(134, 'F.E.A.R.', 'FPS', 1, 2005, 9, 1, 5, 0),
(135, 'F.E.A.R. Extraction Point', 'FPS', 1, 2006, 8, 1, 64, 4),
(136, 'F.E.A.R. Perseus Mandate', 'FPS', 1, 2007, 8, 1, 95, 3),
(137, 'Fable: The Lost Chapters', 'RPG', 1, 2005, 8, 1, 52, 1),
(138, 'Fahrenheit', 'Action Adventure', 1, 2005, 9, 1, 73, 0),
(139, 'Fallout 2', 'RPG', 1, 1998, 7, 1, 55, 3),
(140, 'Faust: The Seven Games Of The Soul', 'Adventure', 1, 2001, 8, 4, 78, 2),
(141, 'Fighting Force', 'Fighting', 0, 1997, 5, 1, 2, 1),
(142, 'Final Fantasy VII', 'RPG', 0, 1998, 9, 4, 13, 4),
(143, 'Final Fantasy VIII', 'RPG', 0, 2000, 0, 5, NULL, 4),
(144, 'Finding Nemo', 'Educational', 1, 2003, 5, 1, 74, 0),
(145, 'Flashback: The Quest for Identity', 'Action Adventure', 0, 1993, 0, 1, 21, 1),
(146, 'Football World Manager 2000', 'Simulation', 1, 2000, 7, 1, 8, 2),
(147, 'Fork in the Tale', 'Adventure', 1, 1999, 5, 5, NULL, 1),
(148, 'Forsaken', 'Shooter', 0, 1998, 0, 1, 37, 4),
(149, 'Frankenstein: Through the E1 of the Monster', 'Adventure', 0, 1995, 6, 1, 75, 0),
(150, 'Gabriel Knight II: The Beast Within', 'Adventure', 1, 1995, 10, 6, 43, 0),
(151, 'Gabriel Knight III: Blood of the Sacred; Blood of the Damned', 'Adventure', 1, 1999, 10, 3, 73, 2),
(152, 'Gabriel Knight: Sins of the Fathers', 'Adventure', 1, 1993, 10, 1, 33, 2),
(153, 'The Gene Machine', 'Adventure', 1, 1996, 5, 1, 23, 3),
(154, 'Get Medieval', 'Shooter', 1, 1999, 6, 1, 54, 3),
(155, 'Gift', 'Action Adventure', 0, 2000, 0, 1, NULL, 1),
(156, 'Gold and Glory: The Road to El Dorado', 'Adventure', 1, 2000, 5, 1, NULL, 4),
(157, 'Goosebumps: Attack of the Mutant', 'Adventure', 1, 1997, 5, 1, 5, 1),
(158, 'Goosebumps: Escape From Horrorland', 'Adventure', 1, 1996, 6, 1, 73, 1),
(159, 'Gord@k', 'Adventure', 0, 1997, 4, 1, 66, 3),
(160, 'Gore: Ultimate Soldier', 'FPS', 0, 2002, 0, 1, 7, 1),
(161, 'Gothic', 'RPG', 0, 2001, 0, 1, NULL, 3),
(162, 'Grand Theft Auto: Vice City', 'Action Adventure', 1, 2003, 9, 2, 53, 2),
(163, 'Grim Fandango', 'Adventure', 1, 1998, 9, 2, 86, 4),
(164, 'Half-Life', 'FPS', 1, 1998, 9, 1, 78, 3),
(165, 'Half-Life 2: Aftermath', 'FPS', 1, 2006, 9, 1, NULL, 4),
(166, 'Half-Life: Blue Shift', 'FPS', 1, 2001, 6, 1, NULL, 1),
(167, 'Half-Life: Opposing Force', 'FPS', 1, 1999, 8, 1, NULL, 1),
(168, 'Harbinger', 'RPG', 1, 2003, 6, 1, 61, 1),
(169, 'Harry Potter And The Chamber Of Secrets', 'Action Adventure', 1, 2002, 6, 1, 19, 4),
(170, 'Harry Potter And The Goblet Of Fire', 'Action Adventure', 1, 2005, 8, 1, 75, 1),
(171, 'Hell: A Cyberpunk Thriller', 'Adventure', 1, 1995, 8, 1, 33, 0),
(172, 'Heretic II', 'Action Adventure', 1, 1998, 7, 1, 58, 1),
(173, 'Heroes of Might & Magic III: Complete', 'Strategy', 0, 2000, 9, 1, NULL, 0),
(174, 'Heroes of Might and Magic IV', 'Strategy', 0, 2002, 0, 2, 84, 3),
(175, 'Heroes of Might and Magic V', 'Strategy', 0, 2006, 0, 1, 85, 0),
(176, 'Hitchcock: The Final Cut', 'Adventure', 1, 2002, 8, 2, NULL, 3),
(177, 'Hitman: Blood Money', 'Action Adventure', 1, 2006, 8, 1, NULL, 4),
(178, 'Hitman: Codename 47', 'Action Adventure', 0, 2000, 6, 1, 85, 0),
(179, 'Hitman: Contracts', 'Action Adventure', 1, 2004, 7, 2, NULL, 3),
(180, 'Hopkins FBI', 'Adventure', 0, 1998, 3, 1, 42, 0),
(181, 'Hostile Waters: Antaeus Rising', 'Strategy', 0, 2001, 0, 1, 6, 3),
(182, 'House of the Dead', 'Shooter', 1, 1998, 4, 1, 19, 4),
(183, 'I Have 0 Mouth and I Must Scream', 'Adventure', 1, 1995, 8, 1, 26, 2),
(184, 'I Of The Dragon', 'RPG', 0, 2002, 0, 1, 34, 0),
(185, 'Ice Age 2: The Meltdown', 'Platform', 1, 2006, 8, 2, 48, 4),
(186, 'Icewind Dale', 'RPG', 0, 2000, 0, 2, NULL, 0),
(187, 'In Memoriam', 'Adventure', 1, 2003, 8, 2, 86, 3),
(188, 'In the 1st Degree', 'Adventure', 1, 1995, 6, 2, 31, 1),
(189, 'Inca', 'Adventure', 0, 1992, 5, 1, NULL, 4),
(190, 'Inca II', 'Adventure', 1, 1994, 5, 1, NULL, 2),
(191, 'Incoming Forces', 'Strategy', 0, 2000, 0, 1, 84, 0),
(192, 'Inquisition', 'Action Adventure', 1, 2004, 6, 2, 56, 2),
(193, 'Iron Helix', 'Adventure', 0, 1993, 0, 1, 84, 2),
(194, 'Jack Orlando: A Cinematic Adventure', 'Adventure', 1, 2002, 6, 1, NULL, 1),
(195, 'Jagged Alliance 2', 'Strategy', 0, 1999, 0, 1, NULL, 0),
(196, 'Journey to the Center of the Earth', 'Adventure', 1, 2003, 5, 1, 25, 4),
(197, 'Jules Verne: Journey to the moon', 'Adventure', 1, 2005, 7, 2, 58, 0),
(198, 'Just Cause', 'Action Adventure', 0, 2006, 7, 1, 36, 1),
(199, 'Keepsake', 'Adventure', 1, 2006, 7, 1, NULL, 4),
(200, 'Kick Off 2002', 'Sports', 0, 2002, 0, 1, 15, 1),
(201, 'Kingdom 2: Shadoan', 'Adventure', 0, 1996, 0, 2, 96, 0),
(202, 'KISS Psycho Circus: The Nightmare Child', 'FPS', 1, 2000, 9, 1, 53, 3),
(203, 'Knight Shift', 'RPG; Strategy', 0, 2007, 0, 1, 66, 0),
(204, 'Lands of Lore III', 'RPG', 0, 1999, 0, 4, NULL, 4),
(205, 'The Last Express', 'Adventure', 1, 1997, 6, 3, 13, 4),
(206, 'Laura Bow: The Dagger of Amon Ra', 'Adventure', 1, 1992, 7, 1, 30, 4),
(207, 'Legacy of Kain: Blood Omen', 'Action Adventure', 0, 1996, 0, 1, 73, 4),
(208, 'Legacy of Kain: Defiance', 'Action Adventure', 1, 2003, 8, 2, 43, 3),
(209, 'Legacy of Kain: Soul Reaver', 'Action Adventure', 0, 1999, 6, 1, 35, 2),
(210, 'Legacy of Kain: Soul Reaver 2', 'Action Adventure', 1, 2001, 6, 1, 43, 0),
(211, 'Lego Star Wars II: The Original Trilogy', 'Action Adventure', 1, 2006, 9, 1, 75, 4),
(212, 'Lego Star Wars: The Video Game', 'Action Adventure', 1, 2005, 9, 1, NULL, 4),
(213, 'Leisure Suit Larry Love for Sail', 'Adventure', 1, 1997, 8, 1, 59, 2),
(214, 'Liath', 'Adventure', 0, 1998, 5, 2, 43, 4),
(215, 'Lighthouse: The Dark Being', 'Adventure', 1, 1996, 3, 2, 74, 1),
(216, 'Lionheart: Legacy of the Crusader', 'RPG', 0, 2003, 0, 1, 29, 0),
(217, 'The Lord of the Rings: The Fellowship of the Ring', 'Action Adventure', 1, 2002, 6, 2, 9, 1),
(218, 'Lost Eden', 'Adventure', 1, 1996, 7, 1, 5, 4),
(219, 'Lost Files of Sherlock Holmes', 'Adventure', 0, 1994, 0, 1, 15, 4),
(220, 'Lost in Time', 'Adventure', 1, 1993, 5, 1, 1, 1),
(221, 'Louvre: The Final Curse', 'Adventure', 1, 2001, 7, 1, 2, 1),
(222, 'Lucasarts Classic Adventures', 'Adventure', 1, 2000, 10, 1, 85, 2),
(223, 'Mad Dog McCree', 'Shooter', 1, 1993, 7, 1, 76, 3),
(224, 'Mad Dog McCree 2', 'Shooter', 1, 1992, 7, 1, 43, 1),
(225, 'Madagascar', 'Platform', 1, 2005, 7, 1, 63, 4),
(226, 'Made Man', 'Action Adventure', 0, 2007, 5, 1, 45, 1),
(227, 'Magic & Mayhem: The Art of Magic', 'Strategy', 0, 2001, 0, 1, 96, 2),
(228, 'MAME Collection', 'Platform', 1, 1997, 9, 3, NULL, 1),
(229, 'Manhunt', 'Action Adventure', 1, 2004, 5, 1, 100, 3),
(230, 'Mars To Earth', 'NULL', 1, 2006, 3, 1, 30, 1),
(231, 'Martian Gothic: Unification', 'Action Adventure', 0, 2000, 4, 1, 58, 3),
(232, 'Martin Mystere: Operation Dorian Grey', 'Adventure', 1, 2005, 8, 1, 21, 0),
(233, 'Master of Dimensions', 'Adventure', 0, 1997, 6, 1, 18, 1),
(234, 'Max Payne', 'Action Adventure', 1, 2001, 9, 1, NULL, 3),
(235, 'Max Payne 2: The Fall of Max Payne', 'Action Adventure', 1, 2003, 8, 2, 23, 0),
(236, 'MDK 2', 'Action Adventure', 1, 2000, 8, 1, 75, 4),
(237, 'Medal of Ho0r: Allied Assault', 'FPS', 1, 2002, 8, 1, NULL, 2),
(238, 'Medal of Ho0r: Allied Assault Breakthrough', 'FPS', 1, 2003, 8, 1, 25, 2),
(239, 'Medal of Ho0r: Allied Assault Spearhead', 'FPS', 1, 2002, 8, 1, 52, 4),
(240, 'Medal of Ho0r: Pacific Assault', 'FPS', 1, 2004, 6, 1, 35, 2),
(241, 'Metal Gear Solid', 'Action Adventure', 1, 2000, 6, 2, 97, 0),
(242, 'Metal Gear Solid 2: Substance', 'Action Adventure', 1, 2003, 8, 1, NULL, 2),
(243, 'Micro Machines v4', 'Racing', 0, 2006, 8, 1, 7, 2),
(244, 'Midnight 0where', 'Adventure', 1, 2004, 6, 2, 44, 0),
(245, 'Might and Magic VIII: Day of the Destroyer', 'RPG', 0, 2000, 5, 2, NULL, 1),
(246, 'Missing the 13th Victim (Game of the Year)', 'Adventure', 1, 2005, 6, 1, 54, 2),
(247, 'Mission Critical', 'Adventure', 1, 1995, 8, 3, 5, 2),
(248, 'Mode', 'Adventure', 0, 0000, 0, 3, 7, 0),
(249, 'Monty Pythons and the Quest for the Holy Grail', 'Adventure', 0, 1996, 0, 1, 25, 4),
(250, 'Morpheus', 'Adventure', 1, 1998, 9, 1, 45, 3),
(251, 'Mortal Kombat 3', 'Fighting', 1, 1998, 8, 1, 73, 2),
(252, 'Mortal Kombat Trilogy', 'Fighting', 0, 1997, 0, 1, 25, 3),
(253, 'Moto Racer 2', 'Racing', 0, 1998, 6, 1, 18, 0),
(254, 'Myst III: Exile', 'Adventure', 1, 2001, 8, 1, 1, 4),
(255, 'Myst IV Revelation', 'Adventure', 1, 2004, 9, 2, 2, 3),
(256, 'Myst Masterpiece Edition', 'Adventure', 1, 1999, 10, 1, 1, 1),
(257, 'Myst V: End of Ages', 'Adventure', 1, 2005, 9, 1, NULL, 1),
(258, 'Nancy Drew: Danger by Design', 'Adventure', 1, 2006, 8, 2, 61, 4),
(259, 'Nancy Drew: Last Train to Blue Moon Canyon', 'Adventure', 1, 2005, 9, 2, 33, 1),
(260, 'Nancy Drew: Message in a Haunted Mansion', 'Adventure', 1, 2000, 5, 1, 18, 3),
(261, 'Nancy Drew: Secret of the Old Clock', 'Adventure', 1, 2005, 7, 1, 35, 4),
(262, 'Nancy Drew: Secrets Can Kill', 'Adventure', 1, 1998, 7, 1, 63, 1),
(263, 'Nancy Drew: Stay Tuned for Danger', 'Adventure', 1, 1999, 4, 1, 96, 3),
(264, 'Nancy Drew: The Creature of Kapu Cave', 'Adventure', 1, 2006, 6, 1, 19, 4),
(265, 'Nancy Drew: Treasure In The Royal Tower', 'Adventure', 1, 2001, 5, 1, 74, 4),
(266, 'NBA Live 06', 'Sports', 0, 2005, 8, 2, 17, 4),
(267, 'Necro0micon: The Dawning of Darkness', 'Adventure', 1, 2001, 4, 1, 66, 4),
(268, 'Neighbors from Hell', 'Puzzle', 0, 2003, 6, 1, 83, 4),
(269, 'Neverwinter Nights', 'RPG', 1, 2002, 9, 3, 73, 0),
(270, 'Neverwinter Nights 2', 'RPG', 1, 2006, 10, 1, 19, 0),
(271, 'Neverwinter Nights: Hordes of the Underdark', 'RPG', 1, 2003, 9, 1, 87, 3),
(272, 'Neverwinter Nights: Shadow of Undrentide', 'RPG', 1, 2003, 9, 1, 67, 1),
(273, 'Nightlong: Union City Conspiracy', 'Adventure', 1, 1999, 8, 3, 95, 0),
(274, '0 One Lives Forever', 'FPS', 1, 2000, 7, 1, NULL, 4),
(275, '0ctropolis', 'Adventure', 1, 1994, 8, 1, 35, 3),
(276, '0cturne', 'Action Adventure', 0, 1999, 0, 2, NULL, 1),
(277, '0ir: A Shadowy Thriller', 'Adventure', 0, 1998, 0, 2, 1, 0),
(278, '0rmality', 'Adventure', 0, 1996, 7, 1, 98, 0),
(279, 'Obsidian', 'Adventure', 1, 1997, 8, 5, 92, 3),
(280, 'Of Light and Darkness: The Prophecy', 'Adventure', 0, 1998, 7, 3, NULL, 3),
(281, 'Omikron: The 0mad Soul', 'Action Adventure', 1, 1999, 9, 3, 97, 2),
(282, 'Onimusha 3: Demon Siege', 'Action Adventure', 1, 2006, 7, 2, 70, 0),
(283, 'Outlaws', 'FPS', 1, 1997, 6, 2, 29, 4),
(284, 'Painkiller', 'FPS', 1, 2004, 7, 3, 91, 2),
(285, 'Panzer Dragoon', 'Shooter', 0, 1997, 0, 1, NULL, 0),
(286, 'Paradise', 'Adventure', 1, 2006, 6, 3, NULL, 4),
(287, 'Parasite Eve II', 'Survival Horror', 0, 2000, 0, 2, NULL, 3),
(288, 'Pathologic', 'Adventure', 0, 2006, 2, 2, 27, 2),
(289, 'Penumbra: Black Plague', 'Adventure; Survival Horror', 0, 2008, 8, 1, 8, 1),
(290, 'Penumbra: Overture', 'Adventure; Survival Horror', 0, 2007, 8, 1, 44, 3),
(291, 'Penumbra: Requiem', 'Action Adventure', 0, 2008, 0, 1, NULL, 2),
(292, 'Phantasmagoria', 'Adventure', 1, 1995, 7, 7, 46, 3),
(293, 'Phantasmagoria 2: A Puzzle Of Flesh', 'Adventure', 1, 1996, 8, 5, 82, 2),
(294, 'Pirates of the Caribbean: The Legend of Jack Sparrow', 'Action Adventure', 1, 2006, 7, 1, NULL, 1),
(295, 'Planescape: Torment', 'RPG', 0, 1999, 0, 2, 47, 2),
(296, 'Planet Of The Apes', 'Action Adventure', 0, 2001, 5, 2, 22, 1),
(297, 'Police Quest Collection Series', 'Adventure', 1, 1997, 7, 5, 34, 0),
(298, 'Pompeii : The Legent Of Vesuvius', 'Adventure', 1, 2001, 6, 2, NULL, 4),
(299, 'Post Mortem', 'Adventure', 1, 2003, 9, 2, 10, 1),
(300, 'Postal', 'Shooter', 0, 2003, 0, 1, NULL, 3),
(301, 'Prey', 'FPS', 1, 2006, 9, 1, 31, 0),
(302, 'Primitive Wars', 'Strategy', 0, 1999, 0, 1, 6, 0),
(303, 'Prince of Persia 3D', 'Action Adventure', 0, 1999, 7, 2, 83, 2),
(304, 'Prince of Persia: The Sands of Time', 'Action Adventure', 1, 2003, 8, 1, 27, 0),
(305, 'Prince of Persia: The Two Thrones', 'Action Adventure', 1, 2005, 10, 1, 90, 3),
(306, 'Prince of Persia: Warrior Within', 'Action Adventure', 1, 2004, 9, 1, 39, 1),
(307, 'Prisoner of Ice', 'Adventure', 1, 1995, 7, 1, 54, 1),
(308, 'Private Eye', 'Adventure', 1, 1996, 6, 1, 76, 2),
(309, 'Pro Evolution Soccer 4', 'Sports', 1, 2004, 8, 1, 91, 2),
(310, 'Pro Evolution Soccer 5', 'Sports', 1, 2005, 9, 1, 30, 1),
(311, 'Pro Evolution Soccer 6', 'Sports', 1, 2006, 9, 1, 72, 1),
(312, 'Psi-Ops The Mindgate Conspiracy', 'Action Adventure', 1, 2008, 8, 1, 42, 2),
(313, 'Psychonauts', 'Action Adventure', 1, 2005, 10, 1, 22, 1),
(314, 'The Psychotron', 'Adventure', 0, 1994, 0, 1, 80, 4),
(315, 'Qin: Tomb of the Middle Kingdom', 'Adventure', 0, 1995, 5, 1, NULL, 1),
(316, 'Quake 4', 'FPS', 1, 2005, 9, 1, 49, 2),
(317, 'Quake II', 'FPS', 1, 1997, 8, 1, 72, 3),
(318, 'Queen The Eye', 'Action Adventure', 0, 1998, 0, 5, NULL, 3),
(319, 'Quest for Glory Anthology', 'Adventure; RPG', 0, 2000, 0, 1, 74, 2),
(320, 'Quest for Glory V: Dragon Fire', 'RPG', 0, 1998, 0, 1, 45, 3),
(321, 'Ragnarok Online', 'RPG', 0, 2005, 0, 1, 47, 2),
(322, 'Rama', 'Adventure', 1, 1997, 7, 3, 73, 3),
(323, 'Real Myst', 'Adventure', 1, 2000, 9, 1, 21, 1),
(324, 'Realms of the Haunting', 'Adventure; Survival Horror', 1, 1996, 10, 4, 1, 1),
(325, 'Red Faction', 'FPS', 1, 2001, 7, 1, 12, 0),
(326, 'Red Faction II', 'FPS', 1, 2003, 8, 1, 89, 1),
(327, 'Red Ocean', 'FPS', 1, 2007, 4, 1, 45, 0),
(328, 'Redguard', 'Action Adventure', 0, 1999, 0, 2, 90, 3),
(329, 'Rent A Hero', 'Adventure', 1, 2000, 6, 2, NULL, 3),
(330, 'Resident Evil', 'Survival Horror', 0, 1997, 5, 1, 56, 4),
(331, 'Resident Evil 2', 'Survival Horror', 0, 1999, 0, 2, 30, 3),
(332, 'Resident Evil 3: Nemesis', 'Survival Horror', 0, 2001, 0, 1, 78, 2),
(333, 'The Residents: Bad Day on the Midway', 'Adventure', 0, 1995, 0, 1, 16, 4),
(334, 'Return to Castle Wolfenstein', 'FPS', 1, 2001, 7, 1, 30, 3),
(335, 'Return to Castle Wolfenstein: Enemy Territory', 'FPS', 0, 2003, 8, 1, 15, 0),
(336, 'Return to Krondor', 'RPG', 0, 1998, 0, 2, NULL, 1),
(337, 'Return to Ringworld', 'Adventure', 1, 1994, 7, 1, NULL, 2),
(338, 'Ringworld: Revenge of the Patriarch', 'Adventure', 1, 1992, 6, 1, 59, 0),
(339, 'Ripper', 'Adventure', 1, 1996, 10, 6, 93, 1),
(340, 'Riven', 'Adventure', 1, 2001, 9, 5, 61, 2),
(341, 'Runaway 2: The Dream of the Turtle', 'Adventure', 1, 2007, 8, 1, 59, 4),
(342, 'Runaway: A Road Adventure', 'Adventure', 1, 2003, 8, 1, 49, 3),
(343, 'S.T.A.L.K.E.R.: Shadow of Cher0byl', 'FPS', 1, 2007, 5, 1, 96, 4),
(344, 'Sacred Mirror of Kofun', 'Adventure', 0, 1996, 5, 3, 91, 2),
(345, 'Sacrifice', 'Strategy', 0, 2000, 0, 1, 31, 2),
(346, 'Safecracker', 'Adventure', 1, 2006, 8, 1, NULL, 0),
(347, 'Sam & Max Hit The Road', 'Adventure', 0, 1993, 7, 1, 55, 0),
(348, 'Sam & Max: Season One', 'Adventure', 0, 2007, 8, 1, 33, 0),
(349, 'Sanitarium', 'Adventure', 1, 1998, 10, 3, 53, 2),
(350, 'Scarface: The World Is Yours', 'Action Adventure', 0, 2006, 0, 1, 2, 1),
(351, 'Scooby Doo Case File #1: The Glowing Bug Man', 'Adventure', 0, 2002, 0, 1, 98, 4),
(352, 'Scratches', 'Adventure', 1, 2006, 7, 1, 46, 0),
(353, 'Second Sight', 'Action Adventure', 1, 2005, 7, 1, 6, 1),
(354, 'Secret Files: Tunguska', 'Adventure', 1, 2006, 8, 1, 76, 0),
(355, 'Sensible Soccer 2006', 'Sports', 0, 2007, 6, 1, NULL, 0),
(356, 'Sentient', 'Adventure', 0, 1997, 0, 1, 42, 3),
(357, 'Sentinel: Descendants in Time', 'Adventure', 1, 2004, 8, 2, 60, 3),
(358, 'Septerra Core: Legacy of the Creator', 'RPG', 1, 1999, 7, 1, NULL, 4),
(359, 'Serious Sam II', 'FPS', 1, 2005, 7, 1, 90, 1),
(360, 'Shadow of Destiny', 'Action Adventure', 1, 2002, 7, 1, 19, 4),
(361, 'Shadow Warrior', 'FPS', 0, 1994, 0, 1, NULL, 2),
(362, 'Shadowman', 'Action Adventure', 1, 2003, 9, 1, 92, 1),
(363, 'Sherlock Holmes Consulting Detective ', 'Adventure', 0, 1991, 0, 3, 75, 0),
(364, 'Sherlock Holmes The Mystery of the Mummy', 'Adventure', 1, 2006, 6, 1, 60, 3),
(365, 'Sherlock Holmes: The Awakened', 'Adventure', 1, 2007, 8, 1, NULL, 4),
(366, 'Sherlock Holmes: The Case of the Rose Tattoo', 'Adventure', 1, 1996, 9, 1, 42, 3),
(367, 'Sherlock Holmes: The Case of the Silver Earring', 'Adventure', 1, 2004, 8, 2, 71, 4),
(368, 'Shivers', 'Adventure', 0, 1995, 0, 1, 91, 4),
(369, 'Shivers 2', 'Adventure', 1, 2002, 8, 2, NULL, 3),
(370, 'Silent Hill', 'Survival Horror', 1, 2001, 7, 1, 70, 4),
(371, 'Silent Hill 2', 'Survival Horror', 1, 2003, 9, 3, NULL, 4),
(372, 'Silent Hill 3', 'Survival Horror', 1, 2004, 8, 5, 84, 4),
(373, 'Silent Hill 4: The Room', 'Survival Horror', 1, 2004, 8, 1, NULL, 4),
(374, 'Silver', 'RPG', 0, 1999, 0, 1, 15, 2),
(375, 'Silverload', 'Adventure', 0, 1995, 0, 1, 70, 0),
(376, 'Simon the Sorcerer 3D', 'Adventure', 1, 2001, 6, 1, 12, 0),
(377, 'Simon the Sorcerer II: The Lion; the Wizard and the Wardrobe', 'Adventure', 1, 1995, 8, 1, 80, 4),
(378, 'SiN', 'FPS', 1, 1998, 6, 1, NULL, 2),
(379, 'SIN Episodes: Emergence', 'FPS', 1, 2006, 8, 1, 6, 1),
(380, 'Soldier of Fortune', 'FPS', 1, 2000, 7, 1, 78, 3),
(381, 'Soldier of Fortune II: Double Helix', 'FPS', 1, 2002, 8, 2, 5, 0),
(382, 'Soulbringer', 'RPG', 0, 2000, 0, 2, 85, 0),
(383, 'Space Ace', 'Action Adventure', 1, 2001, 5, 1, 31, 3),
(384, 'Space Bar', 'Adventure', 0, 1997, 4, 3, 78, 4),
(385, 'Space Pirates', 'Shooter', 0, 1994, 0, 1, 72, 0),
(386, 'Space Quest 6 : The Spinal Frontier', 'Adventure', 1, 1997, 7, 1, 34, 1),
(387, 'Space Quest Collection', 'Adventure', 1, 1992, 7, 1, 59, 3),
(388, 'Spaceship Warlock', 'Adventure', 0, 1994, 0, 1, 22, 3),
(389, 'Spongebob Squarepants: Nighty Nigtmare', 'Platform', 1, 2006, 3, 1, NULL, 3),
(390, 'SpongeBob Squarepants: Operation Krabby Patty', 'Platform', 1, 2001, 3, 1, 67, 1),
(391, 'Spycraft: The Great Game', 'Adventure', 1, 1996, 7, 3, 29, 4),
(392, 'Star Trek BORG', 'Adventure', 1, 1996, 5, 3, 15, 0),
(393, 'Star Trek Deep Space Nine: Harbringer', 'Action Adventure', 1, 2000, 6, 2, 78, 3),
(394, 'Star Trek: 25th Anniversary', 'Adventure', 1, 1993, 7, 1, 49, 3),
(395, 'Star Trek: Hidden Evil', 'Adventure', 0, 1999, 7, 1, 46, 2),
(396, 'Star Trek: The Next Generation: A Final Unity', 'Adventure', 0, 1995, 6, 1, 61, 1),
(397, 'Star Wars Jedi Knight II: Jedi Outcast', 'FPS', 1, 2002, 6, 1, NULL, 3),
(398, 'Star Wars: Dark Forces', 'FPS', 0, 1994, 6, 1, 89, 2),
(399, 'Star Wars: Episode I The Phantom Menace', 'Action Adventure', 1, 1999, 4, 1, 35, 4),
(400, 'Star Wars: Knights of the Old Republic', 'RPG', 1, 2003, 9, 4, 63, 3),
(401, 'Star Wars: Knights of the Old Republic II: The Sith Lords', 'RPG', 1, 2005, 9, 1, 59, 3),
(402, 'Star Wars: Rebel Assault II', 'Shooter', 0, 1995, 6, 2, 22, 1),
(403, 'Starship Titanic', 'Adventure', 0, 1998, 7, 3, NULL, 4),
(404, 'Still Life', 'Adventure', 1, 2005, 9, 2, NULL, 4),
(405, 'Stonekeep', 'RPG', 0, 1995, 7, 1, 25, 3),
(406, 'Stubbs the Zombie in: Rebel without a Pulse', 'Action Adventure', 0, 2005, 0, 1, 19, 2),
(407, 'Stupid Invaders', 'Adventure', 1, 2001, 7, 4, NULL, 3),
(408, 'Sudeki', 'RPG', 1, 2005, 7, 1, 87, 0),
(409, 'Summoner', 'RPG', 0, 2001, 6, 2, 100, 1),
(410, 'SWAT 3: Elite Edition', 'FPS', 1, 2000, 7, 1, NULL, 3),
(411, 'SWAT 4: Special Weapons and Tactics', 'FPS', 1, 2005, 7, 1, 44, 2),
(412, 'SWAT 4: The Stetchkov Syndicate', 'FPS', 1, 2005, 8, 1, 56, 1),
(413, 'Syberia', 'Adventure', 1, 2002, 10, 2, 83, 4),
(414, 'Syberia II', 'Adventure', 1, 2004, 9, 2, 42, 1),
(415, 'Synnergist', 'Adventure', 0, 1996, 6, 1, NULL, 1),
(416, 'Temujin', 'Adventure', 1, 1997, 8, 6, 18, 1),
(417, 'Tender Loving Care', 'Adventure', 1, 1998, 7, 1, 87, 3),
(418, 'Tex Murphy : The Pandora Directive', 'Adventure', 1, 1996, 9, 6, 16, 0),
(419, 'Tex Murphy : Under a Killing Moon', 'Adventure', 1, 1994, 10, 4, NULL, 0),
(420, 'Tex Murphy: Overseer', 'Adventure', 1, 1997, 9, 1, 42, 2),
(421, 'The 7th Guest', 'Adventure', 1, 1993, 6, 2, 60, 4),
(422, 'The Adventures of Down Under Dan', 'Adventure', 0, 1995, 2, 1, 90, 3),
(423, 'The Curse of Monkey Island', 'Adventure', 1, 1997, 10, 2, 25, 1),
(424, 'The Da Vinci Code', 'Action Adventure', 1, 2006, 8, 1, 27, 0),
(425, 'The Daedalus Encounter', 'Adventure', 1, 1995, 7, 3, NULL, 4),
(426, 'The F.A. Premier League Football Manager 99', 'Simulation', 0, 1999, 7, 1, NULL, 1),
(427, 'The Feeble Files', 'Adventure', 0, 2003, 0, 2, NULL, 2),
(428, 'The Godfather', 'Action Adventure', 1, 2006, 7, 1, 53, 1),
(429, 'The Journeyman Project', 'Adventure', 1, 1994, 4, 1, 2, 2),
(430, 'The Journeyman Project 2: Buried in Time', 'Adventure', 1, 1995, 6, 3, 17, 1),
(431, 'The Journeyman Project 3: Legacy of Time', 'Adventure', 1, 1998, 8, 4, NULL, 4),
(432, 'The Last Bounty Hunter', 'Shooter', 0, 2003, 0, 1, 37, 4),
(433, 'The Legend of Kyrandia The Series Collection', 'Adventure', 1, 1994, 7, 1, 82, 0),
(434, 'The Legend of the Prophet and the Assassin', 'Adventure', 1, 2000, 8, 2, 35, 2),
(435, 'The Longest Journey', 'Adventure', 1, 2002, 9, 4, 8, 4),
(436, 'The Matrix: Path of Neo', 'Action Adventure', 1, 2005, 7, 1, 35, 3),
(437, 'The Mystery Of The Nautilus', 'Adventure', 1, 2003, 6, 1, 42, 2),
(438, 'The New Adventures of the Time Machine', 'Action Adventure', 1, 2000, 6, 2, 53, 0),
(439, 'The Secrets of Atlantis', 'Adventure', 0, 2007, 8, 1, 52, 1),
(440, 'The Secrets of Da Vinci: The Forbidden Manuscript', 'Adventure', 1, 2006, 7, 2, NULL, 2),
(441, 'The Sims 2', 'Simulation', 0, 2004, 0, 4, 56, 2),
(442, 'The Sims 2: Family Fun Stuff', 'Simulation', 0, 2006, 0, 1, 63, 2),
(443, 'The Sims 2: Nightlife', 'Simulation', 0, 2005, 0, 2, 63, 0),
(444, 'The Sims 2: Open for Business', 'Simulation', 0, 2006, 0, 2, 75, 2),
(445, 'The Sims 2: University', 'Strategy', 0, 2005, 0, 2, 44, 4),
(446, 'The Suffering', 'Action Adventure', 1, 2004, 8, 1, 87, 4),
(447, 'The Suffering: Ties That Bind', 'Action Adventure', 1, 2005, 9, 3, 82, 0),
(448, 'The Temple of Elemental Evil: A Classic Greyhawk Adventure', 'RPG', 0, 2003, 7, 2, 25, 2),
(449, 'The Ward', 'Adventure', 0, 2001, 0, 2, 31, 0),
(450, 'The Watchmaker', 'Adventure', 1, 2002, 6, 1, NULL, 1),
(451, 'The X-Files: The Game', 'Adventure', 1, 1998, 7, 6, 67, 4),
(452, 'Theme Hospital', 'Simulation', 0, 2003, 8, 1, 44, 2),
(453, 'Thief: The Dark Project', 'FPS', 0, 1998, 6, 1, 24, 4),
(454, 'The Thing', 'Survival Horror', 1, 2002, 6, 1, 45, 4),
(455, 'Timelapse: Ancient Civilizations', 'Adventure', 1, 1996, 6, 4, 36, 1),
(456, 'Titan Quest', 'RPG', 1, 2006, 7, 1, 54, 4),
(457, 'Titan Quest: Immortal Throne', 'RPG', 1, 2007, 7, 1, NULL, 3),
(458, 'Titanic: Adventure Out of Time', 'Adventure', 1, 1998, 8, 2, 2, 1),
(459, 'Tlon: A Misty Story', 'Adventure', 0, 2000, 0, 1, NULL, 3),
(460, 'Tomb Raider III: Adventures of Lara Croft', 'Action Adventure', 0, 1998, 0, 1, NULL, 4),
(461, 'Tomb Raider: Anniversary', 'Action Adventure', 1, 2007, 8, 1, 11, 2),
(462, 'Tomb Raider: The Last Revelation', 'Action Adventure', 0, 1999, 0, 1, NULL, 4),
(463, 'Tony Tough and the Night of the Roasted Moths', 'Adventure', 1, 2002, 4, 1, NULL, 4),
(464, 'Toonstruck', 'Adventure', 1, 1996, 7, 2, 27, 1),
(465, '1 Crime: New York City', 'Action Adventure', 1, 2006, 9, 3, 46, 3),
(466, '1 Crime: Streets of L.A.', 'Action Adventure', 0, 2004, 8, 3, 97, 2),
(467, 'Turok 2: Seeds of Evil', 'FPS', 0, 1999, 0, 1, 61, 0),
(468, 'Typing of the Dead', 'Simulation', 0, 2001, 6, 1, 11, 2),
(469, 'U.F.O.s', 'Adventure', 0, 1997, 6, 1, NULL, 2),
(470, 'UberSoldier', 'FPS', 1, 2006, 7, 1, NULL, 3),
(471, 'Ultima IX: Ascension', 'RPG', 0, 1999, 5, 2, 54, 1),
(472, 'Ultimate Soccer Manager 98', 'Simulation', 1, 1998, 6, 1, 91, 0),
(473, 'Ultra Vixen 2: Demonseed', 'Virtual Pet', 0, 2002, 0, 1, 83, 1),
(474, 'Ultra Vixen: Super Climax', 'Virtual Pet', 0, 2001, 0, 1, NULL, 3),
(475, 'Unreal', 'FPS', 1, 1998, 8, 1, 72, 1),
(476, 'Unreal Tournament', 'FPS', 1, 1999, 8, 1, 10, 2),
(477, 'Urban Runner', 'Adventure', 0, 1996, 0, 4, 1, 2),
(478, 'Vampire The Masquerade: Redemption', 'RPG', 1, 2000, 10, 1, 96, 2),
(479, 'Versailles 1685', 'Adventure', 1, 1997, 6, 2, 89, 4),
(480, 'Versailles II: Testament of the King', 'Adventure', 0, 2002, 0, 2, 55, 3),
(481, 'Virtual Murder 1-2-3-4', 'Adventure', 1, 1993, 6, 1, 63, 0),
(482, 'Voodoo Kid', 'Adventure', 1, 1997, 6, 1, 62, 1),
(483, 'Voyeur', 'Adventure', 1, 1994, 5, 1, 59, 1),
(484, 'Voyeur II', 'Adventure', 0, 1996, 3, 2, 59, 1),
(485, 'Warcraft III: Reign of Chaos', 'Strategy', 0, 2002, 6, 1, 76, 2),
(486, 'Welcome To The Future', 'Adventure', 0, 1995, 0, 1, 46, 3),
(487, 'Woodruff and the Schnibble', 'Adventure', 0, 1995, 0, 1, 61, 3),
(488, 'World Championship Pool', 'Sports', 0, 2004, 0, 1, 19, 3),
(489, 'World Soccer Winning Eleven 9 International', 'Sports', 1, 2006, 8, 1, 21, 1),
(490, 'Worms', 'Shooter', 0, 1995, 7, 1, 60, 4),
(491, 'Worms 2', 'Shooter', 0, 1998, 8, 1, 2, 0),
(492, 'Worms Armageddon', 'Shooter', 0, 1999, 0, 1, 13, 0),
(493, 'Worms World Party', 'Shooter', 0, 2001, 8, 1, 43, 3),
(494, 'Wrath Of Gods', 'Adventure', 1, 1994, 6, 1, NULL, 0),
(495, 'X-Men Legends II: Rise of Apocalypse', 'Fighting', 1, 2005, 7, 1, 23, 3),
(496, 'X-Men: Children of the Atom', 'Fighting', 0, 1997, 0, 1, 46, 2),
(497, 'X-Men: The Official Game', 'Action Adventure', 1, 2006, 7, 4, 25, 1),
(498, 'Ys I & II Complete', 'RPG', 0, 2005, 4, 1, 46, 0),
(499, 'Zelenhgorm Episode I: Land of the Blue Moon', 'Adventure', 1, 2002, 2, 3, 43, 1);

-- --------------------------------------------------------

--
-- Table structure for table `storage`
--

CREATE TABLE IF NOT EXISTS `storage` (
  `storageid` int(11) NOT NULL AUTO_INCREMENT,
  `storage_description` varchar(300) NOT NULL,
  `available` tinyint(1) NOT NULL,
  PRIMARY KEY (`storageid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `storage`
--

INSERT INTO `storage` (`storageid`, `storage_description`, `available`) VALUES
(1, 'Hard Disk', 1),
(2, 'PC Master', 1),
(3, 'DVDs', 0),
(4, 'External Hard Drive', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
