Code: Alles auswählen
--
-- Tabellenstruktur für Tabelle `phpbb_formel_drivers`
--
CREATE TABLE IF NOT EXISTS `phpbb_formel_drivers` (
`driver_id` mediumint(8) unsigned NOT NULL auto_increment,
`driver_name` varchar(255) collate utf8_bin NOT NULL default '',
`driver_img` varchar(255) collate utf8_bin NOT NULL default '',
`driver_team` mediumint(8) unsigned NOT NULL default '0',
`driver_penalty` decimal(5,2) NOT NULL default '0.00',
`driver_disabled` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`driver_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=25 ;
--
-- Daten für Tabelle `phpbb_formel_drivers`
--
INSERT INTO `phpbb_formel_drivers` (`driver_id`, `driver_name`, `driver_img`, `driver_team`, `driver_penalty`, `driver_disabled`) VALUES
(1, 'Vettel, Sebastian', 'sebastian_vettel.jpg', 1, 0.00, 0),
(2, 'Webber, Mark', 'markwebber.jpg', 1, 0.00, 0),
(3, 'Hamilton, Lewis', 'lewis_hamilton.jpg', 2, 0.00, 0),
(4, 'Button, Jenson', 'jensonbutton.jpg', 2, 0.00, 0),
(5, 'Alonso, Fernando', 'fernandoalonso.jpg', 3, 0.00, 0),
(6, 'Massa, Felipe', 'felipemassa.jpg', 3, 0.00, 0),
(7, 'Schumacher, Michael', 'michaelschumacher.jpg', 4, 0.00, 0),
(8, 'Rosberg, Nico', 'nico_rosberg.jpg', 4, 0.00, 0),
(9, 'Kubica, Robert', 'robert_kubica.jpg', 5, 0.00, 0),
(10, 'Petrow, Witali', 'witali_petrow.jpg', 5, 0.00, 0),
(11, 'Barrichello, Rubens', 'rubensbarrichello.jpg', 6, 0.00, 0),
(12, 'Maldonado, Pastor', 'pastormaldonado.jpg', 6, 0.00, 0),
(13, 'Sutil, Adrian', 'adriansutil.jpg', 7, 0.00, 0),
(14, 'Di Resta, Paul', 'pauldiresta.jpg', 7, 0.00, 0),
(15, 'Kobayashi, Kamui', 'kamuikobayashi.jpg', 8, 0.00, 0),
(16, 'Pérez Mendoza, Sergio', '', 8, 0.00, 0),
(17, 'Alguersuari, Jaime', 'jaimealguersuari.jpg', 9, 0.00, 0),
(18, 'Buemi, Sébastien', 'sebastienbuemi.jpg', 9, 0.00, 0),
(19, 'Trulli, Jarno', 'jarnotrulli.jpg', 10, 0.00, 0),
(20, 'Kovalainen, Heikki', 'heikki_kovalainen.jpg', 10, 0.00, 0),
(21, 'Karthikeyan, Narain', 'narainkarthikeyan.jpg', 11, 0.00, 0),
(22, 'noname, noname', '', 11, 0.00, 0),
(23, 'D''Ambrosio, Jérôme', 'jeromedambrosio.jpg', 12, 0.00, 0),
(24, 'Glock, Timo', 'timoglock.jpg', 12, 0.00, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpbb_formel_races`
--
CREATE TABLE IF NOT EXISTS `phpbb_formel_races` (
`race_id` mediumint(8) unsigned NOT NULL auto_increment,
`race_name` varchar(255) collate utf8_bin NOT NULL default '',
`race_img` varchar(255) collate utf8_bin NOT NULL default '',
`race_quali` varchar(255) collate utf8_bin NOT NULL default '',
`race_result` varchar(255) collate utf8_bin NOT NULL default '',
`race_time` int(11) unsigned NOT NULL default '0',
`race_length` varchar(8) collate utf8_bin NOT NULL default '',
`race_laps` mediumint(8) unsigned NOT NULL default '0',
`race_distance` varchar(8) collate utf8_bin NOT NULL default '',
`race_debut` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`race_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=21 ;
--
-- 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, 'Bahrain / Manama', 'bahrain.gif', '0', '0', 1300021200, '6,299', 49, '308,405', 2004),
(2, 'Australien / Melbourne', 'australien.gif', '0', '0', 1301216400, '5,303', 58, '307,574', 1996),
(3, 'Malaysia / Kuala Lumpur', 'malaysia.gif', '0', '0', 1302422400, '5,543', 56, '310,408', 1999),
(4, 'China / Shanghai', 'china.gif', '0', '0', 1303023600, '5,451', 56, '305,066', 2004),
(5, 'Spanien / Barcelona', 'spanien.gif', '0', '0', 1306069200, '4,655', 66, '307,104', 1991),
(6, 'Monaco / Monte Carlo', 'monaco.gif', '0', '0', 1306674000, '3,340', 78, '260,520', 1950),
(7, 'Türkei / Istanbul', 'tuerkei .gif', '0', '0', 1304859600, '5,338', 58, '309,356', 2005),
(8, 'Kanada / Montreal', 'kanada.gif', '0', '0', 1307898000, '4,361', 70, '305,270', 1967),
(9, 'Europa / Valencia', 'europa.gif', '0', '0', 1309096800, '5,419', 57, '308,883', 2008),
(10, 'Großbritannien / Silverstone', 'grossbritannien.gif', '0', '0', 1310306400, '5,901', 52, '306,747', 1950),
(11, 'Deutschland / Nürburgring', 'deutschland.gif', '0', '0', 1311512400, '5,148', 60, '308,863', 1984),
(12, 'Ungarn / Budapest', 'ungarn.gif', '0', '0', 1312117200, '4,381', 70, '306,630', 1986),
(13, 'Belgien / Spa-Francorchamps', 'belgien.gif', '0', '0', 1314536400, '7,004', 44, '308,052', 1950),
(14, 'Italien / Monza', 'italien.gif', '0', '0', 1315746000, '5,793', 53, '306,720', 1950),
(15, 'Singapur / Singapur', 'singapur.gif', '0', '0', 1316955600, '5,073', 61, '309,316', 2008),
(16, 'Japan / Suzuka', 'japan.gif', '0', '0', 1318143600, '5,807', 53, '307,471', 1987),
(17, 'Südkorea / Yeongum', 'korea.gif', '0', '0', 1318748400, '5,600', 55, '309,155', 2010),
(18, 'Indien / Greater Noida', 'indien.gif', '0', '0', 1319979600, '5.326', 61, '324.886', 2011),
(19, 'Arabische Emirate / Abu Dhabi', 'abu_dhabi.gif', '0', '0', 1321189200, '5,550', 55, '305,361', 2009),
(20, 'Brasilien / São Paulo', 'brasilien.gif', '0', '0', 1322413200, '4,309', 71, '305,909', 1973);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpbb_formel_teams`
--
CREATE TABLE IF NOT EXISTS `phpbb_formel_teams` (
`team_id` mediumint(8) unsigned NOT NULL auto_increment,
`team_name` varchar(255) collate utf8_bin NOT NULL default '',
`team_img` varchar(255) collate utf8_bin NOT NULL default '',
`team_car` varchar(255) collate utf8_bin NOT NULL default '',
`team_penalty` decimal(5,2) NOT NULL default '0.00',
PRIMARY KEY (`team_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=13 ;
--
-- Daten für Tabelle `phpbb_formel_teams`
--
INSERT INTO `phpbb_formel_teams` (`team_id`, `team_name`, `team_img`, `team_car`, `team_penalty`) VALUES
(1, 'Red Bull Racing', 'redbull.gif', 'car_redbull.jpg', 0.00),
(2, 'McLaren Mercedes', 'mclaren.gif', 'car_mclaren.jpg', 0.00),
(3, 'Scuderia Ferrari', 'ferrari.gif', 'car_ferrari.jpg', 0.00),
(4, 'Mercedes GP', 'mercedes_gp.gif', 'car_mercedes.jpg', 0.00),
(5, 'Lotus Renault GP', 'renault.gif', 'car_lotus_renault.jpg', 0.00),
(6, 'Williams', 'williams.gif', 'car_williams_crosw.jpg', 0.00),
(7, 'Force India F1 Team', 'forceindia.gif', 'car_force_india.jpg', 0.00),
(8, 'Sauber Motorsport', 'sauber.gif', 'car_sauber_ferrari.jpg', 0.00),
(9, 'Scuderia Toro Rosso', 'tororosso.gif', 'car_toro_rosso.jpg', 0.00),
(10, 'Team Lotus-Cosworth', 'lotus.gif', 'car_lotus_crosw.jpg', 0.00),
(11, 'HRT F1 Team', 'hrt1.gif', 'car_hrt_f1.jpg', 0.00),
(12, 'Virgin Racing', 'virgin.gif', 'car_virgin.jpg', 0.00);
-- --------------------------------------------------------