CREATE TABLE `games` (
`id` int(10) NOT NULL auto_increment,
`nameid` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
`time` int(10) NOT NULL default '0',
`width` int(10) NOT NULL default '0',
`height` int(10) NOT NULL default '0',
`cat` varchar(255) NOT NULL default '',
`rating` decimal(3,2) NOT NULL default '0.00',
`type` enum('SWF','extlink','DCR','CustomCode') NOT NULL default 'SWF',
`authorsite` varchar(255) NOT NULL default '',
`authorname` varchar(255) NOT NULL default '',
`gameurl` varchar(255) NOT NULL default '',
`code` text NOT NULL,
`playcount` int(10) NOT NULL default '0',
`weeklyplays` int(10) NOT NULL default '0',
`flags` varchar(255) NOT NULL default '',
`instructions` text NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`disphtml` enum('Config','No','Yes') NOT NULL default 'Config',
`disphtmlcode` text NOT NULL,
`order` int(10) NOT NULL default '0',
`active` enum('Yes','No') NOT NULL default 'Yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1698 ;

INSERT INTO `games` VALUES (10, 'RT3Game', 'Railroad Tycoon 3', 'Get your choo-choo train across the screen in the time given by using drag and drop pieces to complete your train track.', 1169236825, 680, 430, 'Other', 0.00, 'SWF', '', '', '', '', 2, 2, '', 'Drag and drop pieces from the left hand side of the screen onto the map to complete a train track that goes from the start to the station. You have 3 bombs to take care of tracks that do not align with the rest of the track.', '', 'Config', '', 10, 'Yes');