-- phpMyAdmin SQL Dump-- version 2.10.1-- http://www.phpmyadmin.net-- -- Host: localhost-- Generation Time: Jun 28, 2007 at 12:15 AM-- Server version: 5.0.41-- PHP Version: 5.2.2SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";-- -- Database: `gamingcrazy`-- -- ---------------------------------------------------------- -- Table structure for table `comments`-- CREATE TABLE `comments` ( `id` int(11) NOT NULL auto_increment, `story_id` int(11) NOT NULL, `text` text collate latin1_general_ci NOT NULL, `author_id` int(11) NOT NULL, `created` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;-- -- Dumping data for table `comments`-- INSERT INTO `comments` VALUES (1, 1, 'cool news dude thanks for the new site', 1, '2007-06-26 20:14:25');INSERT INTO `comments` VALUES (2, 1, 'yea this is really cool', 3, '2007-06-26 20:14:25');INSERT INTO `comments` VALUES (3, 2, 'intro, complete with revamped character sprites for Firion, Maria and Guy - FF II''s main cast. Also up for grabs is a Forest Ambush gameplay vid - where frolicking in the woodlands is anything but safe. Enjoy these clips, and make sure to wait up for FF II''s June 24 release.', 2, '2007-06-27 21:43:34');INSERT INTO `comments` VALUES (4, 2, 'intro, complete with revamped character sprites for Firion, Maria and Guy - FF II''s main cast. Also up for grabs is a Forest Ambush gameplay vid - where frolicking in the woodlands is anything but safe. Enjoy these clips, and make sure to wait up for FF II''s June 24 release.', 2, '2007-06-27 21:43:34');-- ---------------------------------------------------------- -- Table structure for table `consoles`-- CREATE TABLE `consoles` ( `id` int(11) NOT NULL auto_increment, `name` varchar(32) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;-- -- Dumping data for table `consoles`-- INSERT INTO `consoles` VALUES (1, 'pc');INSERT INTO `consoles` VALUES (2, 'ps3');INSERT INTO `consoles` VALUES (3, 'wii');INSERT INTO `consoles` VALUES (4, 'xbox 360');INSERT INTO `consoles` VALUES (5, 'psp');INSERT INTO `consoles` VALUES (6, 'ds');INSERT INTO `consoles` VALUES (7, 'mobile');-- ---------------------------------------------------------- -- Table structure for table `games`-- CREATE TABLE `games` ( `id` int(11) NOT NULL auto_increment, `title` tinytext collate latin1_general_ci NOT NULL, `genre` tinytext collate latin1_general_ci NOT NULL, `console_ids` varchar(128) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `games`-- -- ---------------------------------------------------------- -- Table structure for table `news`-- CREATE TABLE `news` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) collate latin1_general_ci NOT NULL, `description` text collate latin1_general_ci NOT NULL, `text` text collate latin1_general_ci NOT NULL, `image` varchar(32) collate latin1_general_ci NOT NULL, `degree` int(11) NOT NULL, `author_id` int(11) NOT NULL, `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `category_id` int(11) NOT NULL, `console_id` int(11) NOT NULL, `game_id` int(11) NOT NULL, `status` tinyint(4) NOT NULL default '0', `views` int(11) NOT NULL default '1', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;-- -- Dumping data for table `news`-- INSERT INTO `news` VALUES (1, 'Final Fantasy: "Forest Ambush"', 'With preparations well underway for Final Fantasy I come its Square-Enix launch party this June 26, we''ll be taking another looks at its sister game, Final Fantasy II, before it gets primed for its July release.', 'With preparations well underway for Final Fantasy I come its Square-Enix launch party this June 26, we''ll be taking another looks at its sister game, Final Fantasy II, before it gets primed for its July release. This latest video we''ve got features the game intro intro, complete with revamped character sprites for Firion, Maria and Guy - FF II''s main cast.\r\n\r\nAlso up for grabs is a Forest Ambush gameplay vid - where frolicking in the woodlands is anything but safe. Enjoy these clips, and make sure to wait up for FF II''s June 24 release. \r\n\r\n', '', 1219, 2, '2007-06-27 14:54:24', 5, 1, 89, 0, 10);INSERT INTO `news` VALUES (2, 'Virtua Fighter 5 Screenshots', 'The screenshots continue from Sega today, with them releasing a new series taken from Virtua Fighter 5.', 'The screenshots continue from Sega today, with them releasing a new series taken from Virtua Fighter 5.\r\n\r\nVirtua Fighter 5 features beautifully detailed stages from around the world where players face off in fast-moving martial arts battles against one of 17 characters. Two lively new characters join the elite group of fighters, adding two new unique fighting styles for players to try and master. With more skill and strategy than ever before, players are also given the opportunity to learn and employ the new “Offensive Move” technique to take down their opponents from different angles, adding a new dimension to the game and something for both new and old fans to master. Virtua Fighter 5 also includes the ability to customize characters by selecting from four base costumes and a wide range of unlockable accessories and earnable items. As players win more tournaments they will not only earn costumes and accessories, but also prizes and in-game money that will allow them to buy items from the in-game shop.\r\n<img src="http://www.planetxbox360.com/app/webroot/files/2007/june/vf5-screens.jpg" alt="" />', '', 80, 2, '2007-06-27 13:51:44', 4, 1, 98, 2, 14);INSERT INTO `news` VALUES (3, 'The Darkness High Definition Multiplayer Trailer', 'Following up on the release of the game today, 2K Games have released a multiplayer trailer, which we have for you in high definition.', 'Following up on the release of the game today, 2K Games have released a multiplayer trailer, which we have for you in high definition.\r\n\r\nBased on the best-selling Top Cow comic book, The Darkness features a seamless and unique blend of modern crime drama and supernatural horror through first- and third-person, non-linear gameplay.\r\n\r\nYou are Jackie Estacado, a fearless Mafia hitman for the Franchetti crime family who is suddenly possessed by the terrifying and spectacular powers of The Darkness. Playing in single mode or in the online multiplayer environment, you must learn to control and harness The Darkness power in order to overthrow the vicious mob boss and fulfill your destiny.\r\n', '', 20, 2, '2007-06-27 00:16:35', 4, 1, 99, 0, 1);