Code: Alles auswählen
# MySQL-Front 3.2 (Build 2.10)
#
# Table structure for table phpbb_wm_games
#
CREATE TABLE `phpbb_wm_games` (
`game_id` mediumint(8) NOT NULL auto_increment,
`game_time` int(11) NOT NULL default '0',
`game_home` mediumint(8) NOT NULL default '0',
`game_away` mediumint(8) NOT NULL default '0',
`game_loc` varchar(255) NOT NULL default '',
`game_loclink` varchar(255) NOT NULL default '',
PRIMARY KEY (`game_id`)
) TYPE=MyISAM;
#
# Dumping data for table phpbb_wm_games
#
INSERT INTO `phpbb_wm_games` VALUES (1,1149868800,1,2,'München','http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` VALUES (2,1149879600,3,4,'Gelsenkirchen','http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` VALUES (3,1150311600,1,3,'Dortmund','http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` VALUES (4,1150376400,4,2,'Hamburg','http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` VALUES (5,1150812000,4,1,'Berlin','http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` VALUES (6,1150812000,2,3,'Hannover','http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` VALUES (7,1149944400,5,6,'Frankfurt','http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` VALUES (8,1149955200,7,8,'Dortmund','http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` VALUES (9,1150387200,5,7,'Nürnberg','http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` VALUES (10,1150398000,8,6,'Berlin','http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` VALUES (11,1150830000,8,5,'Köln','http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` VALUES (12,1150830000,6,7,'Kaiserslautern','http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` VALUES (13,1149966000,9,10,'Hamburg','http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` VALUES (14,1150030800,11,12,'Leipzig','http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` VALUES (15,1150462800,9,11,'Gelsenkirchen','http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` VALUES (16,1150473600,12,10,'Stuttgart','http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` VALUES (17,1150916400,12,9,'Frankfurt','http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` VALUES (18,1150916400,10,11,'München','http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` VALUES (19,1150041600,13,14,'Nürnberg','http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` VALUES (20,1150052400,15,16,'Köln','http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` VALUES (21,1150484400,13,15,'Hannover','http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` VALUES (22,1150549200,16,14,'Frankfurt','http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` VALUES (23,1150898400,16,13,'Gelsenkirchen','http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` VALUES (24,1150898400,14,15,'Leipzig','http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` VALUES (25,1150138800,17,18,'Hannover','http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` VALUES (26,1150128000,19,20,'Gelsenkirchen','http://fifaworldcup.yahoo.com/06/de/d/c/gelsenkirchen.html');
INSERT INTO `phpbb_wm_games` VALUES (27,1150570800,17,19,'Kaiserslautern','http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` VALUES (28,1150560000,20,18,'Köln','http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` VALUES (29,1150984800,20,17,'Hamburg','http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` VALUES (30,1150984800,18,19,'Nürnberg','http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` VALUES (31,1150225200,21,22,'Berlin','http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
INSERT INTO `phpbb_wm_games` VALUES (32,1150117200,23,24,'Kaiserslautern','http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` VALUES (33,1150646400,21,23,'München','http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` VALUES (34,1150635600,24,22,'Nürnberg','http://fifaworldcup.yahoo.com/06/de/d/c/nurnberg.html');
INSERT INTO `phpbb_wm_games` VALUES (35,1151002800,24,21,'Dortmund','http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` VALUES (36,1151002800,22,23,'Stuttgart','http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` VALUES (37,1150214400,25,26,'Stuttgart','http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` VALUES (38,1150203600,27,28,'Frankfurt','http://fifaworldcup.yahoo.com/06/de/d/c/frankfurt.html');
INSERT INTO `phpbb_wm_games` VALUES (39,1150657200,25,27,'Leipzig','http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` VALUES (40,1150722000,28,26,'Dortmund','http://fifaworldcup.yahoo.com/06/de/d/c/dortmund.html');
INSERT INTO `phpbb_wm_games` VALUES (41,1151089200,28,25,'Köln','http://fifaworldcup.yahoo.com/06/de/d/c/koln.html');
INSERT INTO `phpbb_wm_games` VALUES (42,1151089200,26,27,'Hannover','http://fifaworldcup.yahoo.com/06/de/d/c/hannover.html');
INSERT INTO `phpbb_wm_games` VALUES (43,1150290000,29,30,'Leipzig','http://fifaworldcup.yahoo.com/06/de/d/c/leipzig.html');
INSERT INTO `phpbb_wm_games` VALUES (44,1150300800,31,32,'München','http://fifaworldcup.yahoo.com/06/de/d/c/munchen.html');
INSERT INTO `phpbb_wm_games` VALUES (45,1150743600,29,31,'Stuttgart','http://fifaworldcup.yahoo.com/06/de/d/c/stuttgart.html');
INSERT INTO `phpbb_wm_games` VALUES (46,1150732800,32,30,'Hamburg','http://fifaworldcup.yahoo.com/06/de/d/c/hamburg.html');
INSERT INTO `phpbb_wm_games` VALUES (47,1151071200,32,29,'Kaiserslautern','http://fifaworldcup.yahoo.com/06/de/d/c/kaiserslautern.html');
INSERT INTO `phpbb_wm_games` VALUES (48,1151071200,30,31,'Berlin','http://fifaworldcup.yahoo.com/06/de/d/c/berlin.html');
Änderung für den Tipp eine Stunde vor dem Anpfiff hätte ich gern. Bitte raussuchen