-- -- Table structure for table `games` -- CREATE TABLE `games` ( `id` mediumint(9) NOT NULL auto_increment, `folder` varchar(25) default NULL, `reverse` varchar(6) NOT NULL default '0', `played` int(10) NOT NULL default '0', `stamp` int(20) NOT NULL default '0', `name` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=536 ; -- -- Dumping data for table `games` -- INSERT INTO `games` VALUES (532, 'cat_bat', '', 57, 1145956796, 'Cat Bat'); INSERT INTO `games` VALUES (531, 'cat_vac', '', 9, 1145954801, 'Cat Vcume'); INSERT INTO `games` VALUES (533, 'circles', '', 18, 1146183312, 'Circles'); INSERT INTO `games` VALUES (534, 'skidwrx', 'on', 22, 1146183367, 'Skid WRX'); -- -------------------------------------------------------- -- -- Table structure for table `scores` -- CREATE TABLE `scores` ( `id` int(11) NOT NULL auto_increment, `game_id` int(11) NOT NULL default '0', `score` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=138 ; -- -- Dumping data for table `scores` -- INSERT INTO `scores` VALUES (137, 534, 56, 29); INSERT INTO `scores` VALUES (136, 533, 125, 29); INSERT INTO `scores` VALUES (135, 534, 57, 27); INSERT INTO `scores` VALUES (134, 534, 43, 1); INSERT INTO `scores` VALUES (133, 533, 70, 1); INSERT INTO `scores` VALUES (132, 532, 2052, 25); INSERT INTO `scores` VALUES (131, 532, 11025, 1); INSERT INTO `scores` VALUES (130, 531, 1931, 1); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(20) NOT NULL default '', `password` varchar(20) NOT NULL default '', `email` varchar(30) NOT NULL default '', `join_stamp` varchar(30) NOT NULL default '', `realname` varchar(30) NOT NULL default '', `last_page` varchar(100) NOT NULL default '', `last_stamp` varchar(20) NOT NULL default '', `games_on_page` int(11) NOT NULL default '30', `games_page_sort` varchar(10) NOT NULL default 'played', `games_page_order` varchar(10) NOT NULL default 'ASC', `pm_popup` varchar(5) NOT NULL default 'yes', `pm_popped` varchar(5) NOT NULL default 'no', `pm_popped_reply` varchar(5) NOT NULL default 'no', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=32 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, 'Jim', '*****', 'jimeagle@gmail.com', '1121040876', 'James Eagle', 'Playing Skid WRX', '1146601012', 20, 'played', 'ASC', 'yes', 'yes', 'yes');