phpBB.de

Code: Alles auswählen

DROP TABLE IF EXISTS `phpbb_formel_races`;
CREATE TABLE `phpbb_formel_races` (
  `race_id` mediumint(8) NOT NULL auto_increment,
  `race_name` varchar(64) NOT NULL default '',
  `race_img` varchar(255) NOT NULL default '',
  `race_quali` varchar(255) NOT NULL default '0',
  `race_result` varchar(255) NOT NULL default '0',
  `race_time` int(11) NOT NULL default '0',
  `race_length` varchar(8) NOT NULL default '',
  `race_laps` mediumint(8) NOT NULL default '0',
  `race_distance` varchar(8) NOT NULL default '',
  `race_debut` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`race_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Daten für Tabelle `phpbb_formel_races`
-- 

INSERT INTO `phpbb_formel_races` (`race_id`, `race_name`, `race_img`, `race_quali`, `race_result`, `race_time`, `race_length`, `race_laps`, `race_distance`, `race_debut`) VALUES (1, 'Manama, Bahrain', 'race_bahrein2.gif', '1,12,3,5,10,2,7,14,6,8,11,33,13,15,29,35,16,19,18,4,36,9', '5,1,9,3,10,7,33,14,33,4', 1142163008, '5,412', 57, '308,238', 2004),
(2, 'Kuala Lumpur, Malaysia', 'race_malaysia2.gif', '6,3,33,1,7,10,9,5,14,16,13,2,15,11,8,12,35,29,19,18,4,36', '6,5,3,10,12,1,11,16,5,8', 1142751608, '5,543', 56, '310,408', 1999),
(3, 'Imola, San Marino', 'race_sanmarino2.gif', '1,3,2,12,5,16,10,9,15,7,6,11,33,13,8,29,14,35,18,19,4,36', '1,5,10,12,9,7,3,6,5,6', 1145793608, '4,933', 62, '305,609', 1980),
(4, 'Melbourne, Australien', 'race_australia2.gif', '3,6,5,9,10,16,7,8,11,15,1,13,29,14,33,12,2,19,35,18,4,36', '5,9,16,8,6,11,2,35,9,9', 1143950408, '5,303', 58, '307,574', 1996),
(5, 'Barcelona, Spanien', 'race_spain2.gif', '5,6,1,12,2,16,15,3,9,8,7,10,33,11,14,29,35,18,19,4,44,13', '5,1,6,12,9,3,2,8,12,5', 1147608008, '4,627', 66, '305,256', 1991),
(6, 'Monte Carlo, Monaco', 'race_monaco2.gif', '5,7,9,6,10,2,15,13,33,16,14,29,3,11,8,19,18,35,4,44,12,1', '5,10,13,2,1,6,8,16,1,5', 1148817608, '3,340', 78, '260,520', 1950),
(7, 'Nürburgring, Europa', 'race_europe2.gif', '5,1,12,2,9,3,15,11,10,7,16,33,6,13,8,29,14,19,35,18,4,44', '1,5,12,9,2,6,33,11,1,9', 1147003208, '5,148', 60, '308,863', 1984),
(8, 'Montreal, Canada', 'race_canada2.gif', '5,6,9,15,1,33,10,3,2,12,11,14,8,16,29,13,7,35,18,19,4,44', '5,1,9,6,12,15,8,13,9,7', 1151254808, '4,361', 70, '305,270', 1978),
(9, 'Indianapolis, USA', 'race_usa2.gif', '1,12,6,2,5,11,3,16,9,8,10,7,35,19,18,14,13,4,33,15,29,44', '1,12,6,15,5,2,13,29,1,13', 1151863208, '4,192', 73, '306,016', 2000),
(10, 'Magny-Cours, Frankreich', 'race_france2.gif', '0', '0', 1153051208, '4,411', 70, '308,586', 1991),
(11, 'Silverstone, UK', 'race_uk2.gif', '5,9,1,12,6,2,16,10,8,11,13,33,29,14,35,18,7,19,3,4,44,15', '5,1,9,6,12,10,8,11,5,4', 1150023608, '5,141', 60, '308,586', 1950),
(12, 'Hockenheim, Deutschland', 'race_germany2.gif', '0', '0', 1154260808, '4,574', 67, '306,458', 1970),
(13, 'Budapest, Ungarn', 'race_hungary2.gif', '0', '0', 1154865608, '4,381', 70, '306,663', 1986),
(14, 'Istanbul, Türkei', 'race_turkey2.gif', '0', '0', 1156680008, '5,338', 58, '309,356', 2005),
(15, 'Monza, Italien', 'race_italy2.gif', '0', '0', 1157889608, '5,793', 53, '306,720', 1950),
(17, 'Sao Paulo, Brasilien', 'race_brazil2.gif', '0', '0', 1161536408, '4,309', 71, '305,909', 1973),
(18, 'Suzuka, Japan', 'race_japan2.gif', '0', '0', 1160283608, '5,807', 53, '307,573', 1987),
(19, 'Shanghai, China', 'race_china2.gif', '0', '0', 1159682408, '5,451', 56, '305,256', 2004);