-- phpMyAdmin SQL Dump -- version 2.6.1-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 04. April 2009 um 12:12 -- Server Version: 4.1.18 -- PHP-Version: 4.4.2 -- -- Datenbank: `niki_2008` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `drivers` -- DROP TABLE IF EXISTS `drivers`; CREATE TABLE IF NOT EXISTS `drivers` ( `d_id` int(11) NOT NULL auto_increment, `d_lname` varchar(20) NOT NULL default '', `d_fname` varchar(20) NOT NULL default '', PRIMARY KEY (`d_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; -- -- Daten für Tabelle `drivers` -- INSERT INTO `drivers` (`d_id`, `d_lname`, `d_fname`) VALUES (1, 'RAIKKONEN', 'Kimi'), (2, 'MASSA', 'Felipe'), (3, 'HEIDFELD', 'Nick'), (4, 'KUBICA', 'Robert'), (5, 'ALONSO', 'Fernando'), (6, 'PIQUET', 'Nelson Jr.'), (7, 'ROSBERG', 'Nico'), (8, 'NAKAJIMA', 'Kazuki'), (9, 'COULTHARD', 'David'), (10, 'WEBBER', 'Mark'), (11, 'TRULLI', 'Jarno'), (12, 'GLOCK', 'Timo'), (14, 'BOURDAIS', 'Sebastien'), (15, 'VETTEL', 'Sebastian'), (16, 'BUTTON', 'Jenson'), (17, 'BARRICHELLO', 'Rubens'), (18, 'SATO', 'Takuma'), (19, 'DAVIDSON', 'Anthony'), (20, 'SUTIL', 'Adrian'), (21, 'FISICHELLA', 'Giancarlo'), (22, 'HAMILTON', 'Lewis'), (23, 'KOVALAINEN', 'Heikki'), (24, 'BADOER', 'Luca'), (25, 'GENE', 'Marc'), (26, 'KLIEN', 'Christian'), (27, 'ASMER', 'Marko'), (28, 'GROSJEAN', 'Romain'), (29, 'DI GRASSI', 'Lucas'), (30, 'YAMAMOTO', 'Sakon'), (31, 'HUELKENBERG', 'Nico'), (32, 'BUEMI', 'Sebastien'), (33, 'KOBAYASHI', 'Kamui'), (34, 'WURZ', 'Alexander'), (35, 'ROSSITER', 'James'), (36, 'LIUZZI', 'Vitantonio'), (37, 'DE LA ROSA', 'Pedro'), (38, 'PAFFETT', 'Gary'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `events` -- DROP TABLE IF EXISTS `events`; CREATE TABLE IF NOT EXISTS `events` ( `e_id` int(11) NOT NULL auto_increment, `e_type` varchar(20) NOT NULL default '', PRIMARY KEY (`e_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Daten für Tabelle `events` -- INSERT INTO `events` (`e_id`, `e_type`) VALUES (1, 'QUALIFYING'), (2, 'RACE'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `gps` -- DROP TABLE IF EXISTS `gps`; CREATE TABLE IF NOT EXISTS `gps` ( `g_id` int(11) NOT NULL auto_increment, `g_name` varchar(40) NOT NULL default '', `g_datetime_q` datetime NOT NULL default '0000-00-00 00:00:00', `g_datetime_r` datetime NOT NULL default '0000-00-00 00:00:00', `g_flag` varchar(20) NOT NULL default '', `g_circuit` varchar(40) NOT NULL default '', PRIMARY KEY (`g_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ; -- -- Daten für Tabelle `gps` -- INSERT INTO `gps` (`g_id`, `g_name`, `g_datetime_q`, `g_datetime_r`, `g_flag`, `g_circuit`) VALUES (1, 'AUSTRALIA (Melbourne)', '2008-03-15 04:00:00', '2008-03-16 05:30:00', 'flag_AUSTRALIA.gif', 'circuit_AUSTRALIA.gif'), (2, 'MALAYSIA (Sepang)', '2008-03-22 07:00:00', '2008-03-23 08:00:00', 'flag_MALAYSIA.gif', 'circuit_MALAYSIA.gif'), (3, 'BAHRAIN (Sakhir)', '2008-04-05 13:00:00', '2008-04-06 13:30:00', 'flag_BAHRAIN.gif', 'circuit_BAHRAIN.gif'), (4, 'SPAIN (Barcelona)', '2008-04-26 14:00:00', '2008-04-27 14:00:00', 'flag_SPAIN.gif', 'circuit_SPAIN.gif'), (5, 'TURKEY (Istanbul)', '2008-05-10 13:00:00', '2008-05-11 14:00:00', 'flag_TURKEY.gif', 'circuit_TURKEY.gif'), (6, 'MONACO (Monte Carlo)', '2008-05-24 14:00:00', '2008-05-25 14:00:00', 'flag_MONACO.gif', 'circuit_MONACO.gif'), (7, 'CANADA (Montreal)', '2008-06-07 19:00:00', '2008-06-08 19:00:00', 'flag_CANADA.gif', 'circuit_CANADA.gif'), (8, 'FRANCE (Magny-Cours)', '2008-06-21 14:00:00', '2008-06-22 14:00:00', 'flag_FRANCE.gif', 'circuit_FRANCE.gif'), (9, 'GREAT BRITAIN (Silverstone)', '2008-07-05 14:00:00', '2008-07-06 14:00:00', 'flag_UK.gif', 'circuit_UK.gif'), (10, 'GERMANY (Hockenheim)', '2008-07-19 14:00:00', '2008-07-20 14:00:00', 'flag_GERMANY.gif', 'circuit_GERMANY_(Hockenheim).gif'), (11, 'HUNGARY (Budapest)', '2008-08-02 14:00:00', '2008-08-03 14:00:00', 'flag_HUNGARY.gif', 'circuit_HUNGARY.gif'), (12, 'EUROPE (Valencia)', '2008-08-23 14:00:00', '2008-08-24 14:00:00', 'flag_EUROPE.gif', 'circuit_EUROPE_(Valencia).gif'), (13, 'BELGIUM (Spa)', '2008-09-06 14:00:00', '2008-09-07 14:00:00', 'flag_BELGIUM.gif', 'circuit_BELGIUM.gif'), (14, 'ITALY (Monza)', '2008-09-13 14:00:00', '2008-09-14 14:00:00', 'flag_ITALY.gif', 'circuit_ITALY.gif'), (15, 'SINGAPORE (Singapore)', '2008-09-27 16:00:00', '2008-09-28 14:00:00', 'flag_SINGAPORE.gif', 'circuit_SINGAPORE.gif'), (16, 'JAPAN (Fuji)', '2008-10-11 07:00:00', '2008-10-12 06:30:00', 'flag_JAPAN.gif', 'circuit_JAPAN_(Fuji).gif'), (17, 'CHINA (Shanghai)', '2008-10-18 08:00:00', '2008-10-19 09:00:00', 'flag_CHINA.gif', 'circuit_CHINA.gif'), (18, 'BRASIL (Sao Paolo)', '2008-11-01 17:00:00', '2008-11-02 18:00:00', 'flag_BRASIL.gif', 'circuit_BRASIL.gif'); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `results` -- DROP TABLE IF EXISTS `results`; CREATE TABLE IF NOT EXISTS `results` ( `r_g_id` int(11) NOT NULL default '0', `r_e_id` int(11) NOT NULL default '0', `r_d_id_p1` int(11) NOT NULL default '0', `r_d_id_p2` int(11) NOT NULL default '0', `r_d_id_p3` int(11) NOT NULL default '0', `r_fl` int(11) NOT NULL default '0', `r_sc` int(11) NOT NULL default '-1', PRIMARY KEY (`r_g_id`,`r_e_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten für Tabelle `results` -- INSERT INTO `results` (`r_g_id`, `r_e_id`, `r_d_id_p1`, `r_d_id_p2`, `r_d_id_p3`, `r_fl`, `r_sc`) VALUES (1, 1, 22, 4, 23, 0, -1), (1, 2, 22, 3, 7, 23, 1), (2, 1, 2, 1, 23, 0, -1), (2, 2, 1, 4, 23, 3, 0), (3, 1, 4, 2, 22, 0, -1), (3, 2, 2, 1, 4, 23, 0), (4, 1, 1, 5, 2, 0, -1), (4, 2, 1, 2, 22, 1, 1), (5, 1, 2, 23, 22, 0, -1), (5, 2, 2, 22, 1, 1, 1), (6, 1, 2, 1, 22, 0, -1), (6, 2, 22, 4, 2, 1, 1), (7, 1, 22, 4, 1, 0, -1), (7, 2, 4, 3, 9, 1, 1), (8, 1, 1, 2, 22, 0, -1), (8, 2, 2, 1, 11, 1, 0), (9, 1, 23, 10, 1, 0, -1), (9, 2, 22, 3, 17, 1, 0), (10, 1, 22, 2, 23, 0, -1), (10, 2, 22, 6, 2, 3, 1), (11, 1, 22, 23, 2, 0, -1), (11, 2, 23, 12, 1, 1, 0), (12, 1, 2, 22, 4, 0, -1), (12, 2, 2, 22, 4, 2, 0), (13, 1, 22, 2, 23, 0, -1), (13, 2, 2, 3, 22, 1, 0), (14, 1, 15, 23, 10, 0, -1), (14, 2, 15, 23, 4, 1, 1), (15, 1, 2, 22, 1, 0, -1), (15, 2, 5, 7, 22, 1, 1), (16, 1, 22, 1, 23, 0, -1), (16, 2, 5, 4, 1, 2, 0), (17, 1, 22, 1, 2, 0, -1), (17, 2, 22, 2, 1, 22, 0), (18, 1, 2, 11, 1, 0, -1), (18, 2, 2, 5, 1, 2, 1); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `tips` -- DROP TABLE IF EXISTS `tips`; CREATE TABLE IF NOT EXISTS `tips` ( `t_u_id` int(11) NOT NULL default '0', `t_g_id` int(11) NOT NULL default '0', `t_e_id` int(11) NOT NULL default '0', `t_d_id_p1` int(11) NOT NULL default '0', `t_d_id_p2` int(11) NOT NULL default '0', `t_d_id_p3` int(11) NOT NULL default '0', `t_fl` int(11) NOT NULL default '0', `t_sc` int(11) NOT NULL default '0', `t_timestamp` datetime NOT NULL default '0000-00-00 00:00:00', `t_score` int(11) NOT NULL default '0', PRIMARY KEY (`t_u_id`,`t_g_id`,`t_e_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Daten für Tabelle `tips` -- INSERT INTO `tips` (`t_u_id`, `t_g_id`, `t_e_id`, `t_d_id_p1`, `t_d_id_p2`, `t_d_id_p3`, `t_fl`, `t_sc`, `t_timestamp`, `t_score`) VALUES (7, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 11:25:18', 1), (3, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 16:46:45', 1), (8, 1, 1, 1, 22, 2, 0, 0, '2008-03-14 17:20:45', 1), (6, 1, 2, 22, 2, 23, 1, 0, '2008-03-15 12:47:15', 1), (9, 1, 1, 22, 2, 23, 0, 0, '2008-03-14 17:27:34', 4), (9, 1, 2, 22, 2, 23, 15, -1, '2008-03-15 12:38:04', 2), (10, 1, 1, 22, 1, 2, 0, 0, '2008-03-14 19:51:43', 2), (11, 1, 1, 22, 1, 2, 0, 0, '2008-03-14 21:11:04', 2), (1, 1, 1, 1, 22, 2, 0, 0, '2008-03-15 03:48:00', 1), (7, 1, 2, 22, 4, 2, 22, 0, '2008-03-15 13:36:31', 1), (8, 1, 2, 22, 2, 4, 1, -1, '2008-03-15 14:44:44', 2), (3, 1, 2, 22, 2, 4, 22, 0, '2008-03-15 14:48:53', 1), (1, 1, 2, 2, 22, 23, 1, 1, '2008-03-15 19:35:15', 2), (12, 1, 2, 22, 4, 2, 9999, -1, '2008-03-15 20:11:25', 2), (10, 1, 2, 22, 2, 4, 1, 0, '2008-03-15 20:22:24', 1), (11, 1, 2, 22, 2, 23, 22, -1, '2008-03-15 22:06:27', 2), (2, 1, 2, 22, 23, 2, 1, 0, '2008-03-16 04:49:25', 1), (9, 2, 1, 22, 23, 2, 0, 0, '2008-03-21 12:33:54', 2), (8, 2, 1, 2, 22, 1, 0, 0, '2008-03-21 14:39:44', 3), (10, 2, 1, 2, 22, 1, 0, 0, '2008-03-21 18:08:50', 3), (3, 2, 1, 22, 1, 2, 0, 0, '2008-03-21 18:18:08', 3), (12, 2, 1, 22, 1, 23, 0, 0, '2008-03-21 20:52:33', 4), (7, 2, 1, 22, 23, 1, 0, 0, '2008-03-21 21:04:24', 2), (11, 2, 1, 22, 2, 23, 0, 0, '2008-03-21 21:55:54', 3), (6, 2, 1, 22, 2, 1, 0, 0, '2008-03-22 00:22:21', 2), (1, 2, 1, 22, 1, 2, 0, 0, '2008-03-22 06:24:22', 3), (2, 2, 1, 2, 1, 3, 0, 0, '2008-03-22 06:56:56', 4), (3, 2, 2, 1, 22, 2, 22, -1, '2008-03-22 10:39:35', 2), (6, 2, 2, 2, 1, 22, 2, -1, '2008-03-22 11:30:36', 1), (1, 2, 2, 1, 2, 3, 1, 1, '2008-03-22 19:24:01', 1), (9, 2, 2, 2, 4, 3, 22, 1, '2008-03-22 19:30:22', 1), (8, 2, 2, 2, 3, 23, 2, 1, '2008-03-22 19:35:32', 1), (10, 2, 2, 1, 2, 22, 1, 1, '2008-03-22 20:31:47', 1), (7, 2, 2, 2, 1, 4, 2, -1, '2008-03-22 20:45:57', 2), (12, 2, 2, 1, 22, 23, 1, -1, '2008-03-22 21:51:38', 4), (11, 2, 2, 1, 2, 3, 22, -1, '2008-03-22 23:24:55', 2), (2, 2, 2, 1, 2, 3, 1, 1, '2008-03-23 07:48:45', 1), (3, 3, 1, 1, 2, 22, 0, 0, '2008-04-03 13:06:05', 4), (7, 3, 1, 1, 2, 22, 0, 0, '2008-04-04 23:26:28', 4), (9, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 09:05:49', 1), (8, 3, 1, 2, 1, 22, 0, 0, '2008-04-05 09:06:31', 3), (6, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 11:20:07', 1), (10, 3, 1, 2, 1, 4, 0, 0, '2008-04-05 11:45:31', 2), (12, 3, 1, 1, 22, 2, 0, 0, '2008-04-05 11:46:24', 2), (11, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 12:35:11', 1), (1, 3, 1, 2, 1, 23, 0, 0, '2008-04-05 12:35:45', 1), (2, 3, 1, 2, 1, 11, 0, 0, '2008-04-05 12:49:00', 1), (6, 3, 2, 2, 1, 4, 4, -1, '2008-04-05 14:11:56', 6), (9, 3, 2, 22, 4, 1, 2, -1, '2008-04-05 19:29:32', 2), (3, 3, 2, 2, 1, 22, 1, -1, '2008-04-05 19:33:50', 4), (8, 3, 2, 22, 1, 3, 23, -1, '2008-04-05 19:47:38', 3), (1, 3, 2, 2, 22, 1, 2, 0, '2008-04-05 23:14:09', 4), (11, 3, 2, 2, 22, 4, 4, 0, '2008-04-05 23:27:41', 5), (7, 3, 2, 1, 4, 22, 23, -1, '2008-04-06 10:36:15', 3), (10, 3, 2, 1, 4, 22, 23, 0, '2008-04-06 12:02:21', 4), (12, 3, 2, 2, 4, 22, 1, -1, '2008-04-06 12:23:17', 3), (2, 3, 2, 1, 2, 4, 2, 0, '2008-04-06 13:29:58', 5), (3, 4, 1, 1, 2, 4, 0, 0, '2008-04-25 18:29:02', 3), (7, 4, 1, 1, 2, 22, 0, 0, '2008-04-25 18:42:54', 3), (8, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 11:51:12', 3), (9, 4, 1, 1, 2, 4, 0, 0, '2008-04-26 11:55:43', 3), (12, 4, 1, 2, 1, 22, 0, 0, '2008-04-26 13:15:35', 2), (10, 4, 1, 1, 4, 2, 0, 0, '2008-04-26 13:15:36', 4), (6, 4, 1, 1, 4, 23, 0, 0, '2008-04-26 13:25:06', 2), (1, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 13:31:48', 3), (11, 4, 1, 1, 2, 22, 0, 0, '2008-04-26 13:33:53', 3), (2, 4, 1, 1, 2, 4, 0, 0, '2008-04-26 14:00:09', 3), (6, 4, 2, 1, 2, 5, 2, -1, '2008-04-26 15:16:54', 4), (3, 4, 2, 1, 2, 4, 4, -1, '2008-04-26 15:36:59', 4), (1, 4, 2, 1, 2, 4, 2, 0, '2008-04-26 16:05:35', 3), (7, 4, 2, 1, 2, 4, 1, -1, '2008-04-27 04:06:09', 5), (4, 4, 2, 1, 4, 5, 4, 0, '2008-04-27 09:14:01', 1), (9, 4, 2, 1, 2, 4, 3, 0, '2008-04-27 10:27:06', 3), (8, 4, 2, 1, 4, 5, 3, 1, '2008-04-27 10:28:31', 3), (11, 4, 2, 1, 2, 4, 4, 0, '2008-04-27 12:22:13', 3), (10, 4, 2, 1, 4, 5, 1, 0, '2008-04-27 13:29:03', 2), (12, 4, 2, 1, 4, 22, 2, -1, '2008-04-27 13:29:57', 4), (2, 4, 2, 1, 2, 4, 1, 0, '2008-04-27 13:54:40', 4), (7, 5, 1, 2, 23, 1, 0, 0, '2008-05-10 00:27:59', 4), (13, 5, 1, 2, 1, 23, 0, 0, '2008-05-10 09:43:40', 3), (3, 5, 1, 1, 22, 2, 0, 0, '2008-05-10 10:42:54', 2), (8, 5, 1, 2, 23, 1, 0, 0, '2008-05-10 11:19:02', 4), (9, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 11:20:42', 3), (2, 5, 1, 22, 1, 4, 0, 0, '2008-05-10 12:58:00', 1), (1, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 12:58:13', 3), (11, 5, 1, 1, 22, 2, 0, 0, '2008-05-10 12:59:26', 2), (10, 5, 1, 4, 2, 1, 0, 0, '2008-05-10 12:44:02', 1), (12, 5, 1, 1, 2, 22, 0, 0, '2008-05-10 12:44:18', 3), (3, 5, 2, 2, 22, 1, 2, 0, '2008-05-10 15:07:15', 5), (11, 5, 2, 2, 22, 1, 2, -1, '2008-05-10 22:31:57', 6), (7, 5, 2, 2, 23, 22, 2, -1, '2008-05-11 00:59:17', 3), (13, 5, 2, 1, 2, 22, 9999, -1, '2008-05-11 08:05:23', 3), (8, 5, 2, 2, 22, 1, 1, -1, '2008-05-11 08:44:42', 7), (9, 5, 2, 2, 23, 22, 1, 0, '2008-05-11 08:47:48', 3), (1, 5, 2, 2, 1, 22, 2, -1, '2008-05-11 12:08:58', 4), (12, 5, 2, 2, 1, 23, 1, -1, '2008-05-11 12:41:40', 4), (10, 5, 2, 2, 1, 22, 1, 0, '2008-05-11 12:42:51', 4), (2, 5, 2, 2, 1, 23, 2, 1, '2008-05-11 13:52:57', 4), (3, 6, 1, 1, 22, 2, 0, 0, '2008-05-22 18:16:53', 3), (7, 6, 1, 1, 22, 23, 0, 0, '2008-05-24 01:47:43', 2), (4, 6, 1, 1, 22, 2, 0, 0, '2008-05-24 06:53:43', 3), (1, 6, 1, 22, 1, 2, 0, 0, '2008-05-24 12:23:01', 4), (11, 6, 1, 22, 1, 2, 0, 0, '2008-05-24 12:35:38', 4), (8, 6, 1, 1, 22, 3, 0, 0, '2008-05-24 12:44:02', 2), (9, 6, 1, 22, 23, 7, 0, 0, '2008-05-24 12:45:08', 1), (6, 6, 1, 23, 1, 22, 0, 0, '2008-05-24 12:46:34', 4), (13, 6, 1, 22, 5, 1, 0, 0, '2008-05-24 12:50:39', 2), (10, 6, 1, 22, 7, 1, 0, 0, '2008-05-24 13:10:22', 2), (12, 6, 1, 23, 22, 1, 0, 0, '2008-05-24 13:12:03', 2), (2, 6, 1, 22, 1, 7, 0, 0, '2008-05-24 13:29:38', 3), (2, 6, 2, 22, 1, 23, 22, 1, '2008-05-24 13:30:10', 3), (3, 6, 2, 1, 2, 22, 1, 1, '2008-05-24 15:06:51', 4), (7, 6, 2, 1, 22, 2, 1, 1, '2008-05-25 03:27:23', 5), (13, 6, 2, 2, 1, 22, 7, 1, '2008-05-25 07:11:10', 3), (4, 6, 2, 1, 2, 22, 1, 0, '2008-05-25 10:55:47', 2), (1, 6, 2, 2, 22, 1, 22, 1, '2008-05-25 12:20:48', 3), (11, 6, 2, 2, 1, 22, 1, 1, '2008-05-25 12:30:48', 4), (12, 6, 2, 2, 1, 22, 2, -1, '2008-05-25 13:35:00', 2), (10, 6, 2, 2, 1, 22, 1, 1, '2008-05-25 13:40:57', 4), (9, 6, 2, 2, 22, 23, 2, -1, '2008-05-25 13:45:29', 2), (8, 6, 2, 1, 2, 4, 7, 1, '2008-05-25 13:47:05', 3), (3, 7, 1, 22, 1, 2, 0, 0, '2008-06-06 17:21:11', 3), (13, 7, 1, 22, 2, 1, 0, 0, '2008-06-07 14:36:36', 4), (7, 7, 1, 22, 4, 1, 0, 0, '2008-06-07 16:53:29', 6), (11, 7, 1, 22, 1, 2, 0, 0, '2008-06-07 17:34:22', 3), (1, 7, 1, 22, 1, 2, 0, 0, '2008-06-07 17:34:50', 3), (9, 7, 1, 1, 22, 2, 0, 0, '2008-06-07 17:59:04', 2), (8, 7, 1, 22, 1, 4, 0, 0, '2008-06-07 18:01:34', 4), (12, 7, 1, 2, 22, 1, 0, 0, '2008-06-07 18:22:00', 3), (10, 7, 1, 4, 2, 22, 0, 0, '2008-06-07 18:23:00', 2), (1, 7, 2, 22, 1, 4, 22, 1, '2008-06-07 20:25:02', 2), (3, 7, 2, 22, 1, 4, 1, -1, '2008-06-07 20:31:38', 2), (7, 7, 2, 22, 1, 4, 22, -1, '2008-06-07 23:11:17', 1), (13, 7, 2, 22, 1, 4, 9999, -1, '2008-06-08 10:40:06', 1), (2, 7, 2, 22, 4, 1, 22, 1, '2008-06-08 11:51:50', 2), (8, 7, 2, 4, 22, 2, 3, -1, '2008-06-08 16:32:20', 2), (9, 7, 2, 22, 1, 4, 7, -1, '2008-06-08 16:35:46', 1), (11, 7, 2, 22, 1, 4, 1, 1, '2008-06-08 17:45:01', 3), (10, 7, 2, 22, 1, 4, 4, 1, '2008-06-08 18:52:25', 2), (12, 7, 2, 22, 1, 4, 22, 1, '2008-06-08 18:56:59', 2), (7, 8, 1, 2, 22, 23, 0, 0, '2008-06-20 14:05:43', 2), (13, 8, 1, 4, 22, 2, 0, 0, '2008-06-20 15:32:21', 2), (11, 8, 1, 2, 1, 22, 0, 0, '2008-06-20 19:47:20', 4), (1, 8, 1, 1, 2, 4, 0, 0, '2008-06-20 19:47:50', 4), (3, 8, 1, 2, 1, 23, 0, 0, '2008-06-21 12:17:38', 2), (8, 8, 1, 2, 5, 23, 0, 0, '2008-06-21 13:02:58', 1), (9, 8, 1, 1, 2, 4, 0, 0, '2008-06-21 13:03:31', 4), (10, 8, 1, 2, 22, 1, 0, 0, '2008-06-21 13:34:49', 3), (2, 8, 1, 1, 22, 5, 0, 0, '2008-06-21 13:51:51', 3), (3, 8, 2, 1, 2, 22, 1, -1, '2008-06-21 15:27:18', 3), (13, 8, 2, 1, 2, 4, 9999, -1, '2008-06-22 08:02:13', 2), (1, 8, 2, 1, 2, 4, 1, 1, '2008-06-22 09:58:57', 2), (12, 8, 2, 1, 2, 23, 1, -1, '2008-06-22 12:09:18', 3), (10, 8, 2, 1, 2, 4, 1, -1, '2008-06-22 12:12:49', 3), (9, 8, 2, 2, 1, 23, 22, 0, '2008-06-22 12:24:42', 5), (8, 8, 2, 2, 5, 23, 22, -1, '2008-06-22 12:52:48', 2), (11, 8, 2, 1, 2, 4, 1, 0, '2008-06-22 13:03:09', 4), (2, 8, 2, 1, 2, 5, 1, 0, '2008-06-22 13:38:18', 4), (7, 8, 2, 1, 2, 4, 1, 0, '2008-06-22 13:43:26', 4), (7, 9, 1, 2, 22, 1, 0, 0, '2008-07-04 16:26:26', 2), (3, 9, 1, 2, 22, 1, 0, 0, '2008-07-04 18:53:06', 2), (9, 9, 1, 23, 2, 22, 0, 0, '2008-07-05 08:57:20', 2), (8, 9, 1, 2, 22, 23, 0, 0, '2008-07-05 09:13:12', 1), (13, 9, 1, 1, 23, 22, 0, 0, '2008-07-05 10:13:20', 2), (10, 9, 1, 2, 1, 22, 0, 0, '2008-07-05 10:20:53', 1), (12, 9, 1, 22, 1, 4, 0, 0, '2008-07-05 10:21:30', 1), (11, 9, 1, 22, 2, 23, 0, 0, '2008-07-05 12:22:26', 1), (1, 9, 1, 22, 2, 1, 0, 0, '2008-07-05 12:40:10', 2), (2, 9, 1, 2, 22, 1, 0, 0, '2008-07-05 12:43:09', 2), (7, 9, 2, 1, 22, 23, 23, -1, '2008-07-05 15:41:22', 1), (1, 9, 2, 23, 22, 1, 22, 1, '2008-07-05 17:25:34', 0), (3, 9, 2, 23, 1, 22, 23, -1, '2008-07-05 17:28:36', 1), (13, 9, 2, 1, 23, 22, 4, -1, '2008-07-05 22:14:26', 1), (11, 9, 2, 1, 23, 22, 23, 1, '2008-07-06 10:31:17', 0), (8, 9, 2, 1, 22, 3, 2, 1, '2008-07-06 11:23:17', 1), (9, 9, 2, 23, 1, 10, 1, 1, '2008-07-06 11:23:37', 0), (10, 9, 2, 1, 22, 23, 1, -1, '2008-07-06 12:22:21', 2), (12, 9, 2, 1, 22, 23, 1, 1, '2008-07-06 12:22:31', 1), (2, 9, 2, 1, 23, 15, 1, 1, '2008-07-06 13:32:17', 0), (13, 10, 2, 22, 2, 23, 4, 1, '2008-07-13 08:09:19', 4), (13, 10, 1, 22, 2, 23, 0, 0, '2008-07-13 08:09:45', 6), (3, 10, 1, 22, 2, 1, 0, 0, '2008-07-18 19:49:43', 4), (9, 10, 1, 22, 23, 2, 0, 0, '2008-07-19 11:48:56', 4), (8, 10, 1, 22, 1, 23, 0, 0, '2008-07-19 11:50:37', 4), (1, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 12:12:43', 6), (11, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 12:13:29', 6), (12, 10, 1, 1, 22, 2, 0, 0, '2008-07-19 12:25:24', 2), (10, 10, 1, 2, 22, 1, 0, 0, '2008-07-19 12:25:25', 2), (7, 10, 1, 22, 23, 2, 0, 0, '2008-07-19 13:00:01', 4), (2, 10, 1, 22, 2, 23, 0, 0, '2008-07-19 13:56:56', 6), (7, 10, 2, 22, 2, 23, 22, -1, '2008-07-19 16:01:35', 3), (3, 10, 2, 22, 2, 1, 22, 0, '2008-07-19 17:59:36', 2), (1, 10, 2, 22, 2, 1, 2, 0, '2008-07-20 11:08:40', 2), (11, 10, 2, 22, 23, 2, 22, -1, '2008-07-20 11:52:52', 4), (10, 10, 2, 22, 2, 1, 1, -1, '2008-07-20 12:59:19', 3), (8, 10, 2, 22, 23, 2, 5, 1, '2008-07-20 13:11:38', 5), (9, 10, 2, 23, 2, 1, 1, -1, '2008-07-20 13:15:52', 1), (2, 10, 2, 22, 2, 1, 2, 0, '2008-07-20 13:57:34', 2), (7, 11, 1, 22, 2, 1, 0, 0, '2008-08-01 15:17:56', 3), (3, 11, 1, 22, 2, 1, 0, 0, '2008-08-02 09:49:24', 3), (13, 11, 1, 22, 23, 5, 0, 0, '2008-08-02 12:42:37', 4), (9, 11, 1, 22, 23, 3, 0, 0, '2008-08-02 12:45:51', 4), (8, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 12:46:24', 4), (1, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 13:26:52', 4), (10, 11, 1, 2, 22, 1, 0, 0, '2008-08-02 13:28:18', 2), (11, 11, 1, 22, 23, 2, 0, 0, '2008-08-02 13:30:10', 6), (2, 11, 1, 22, 2, 23, 0, 0, '2008-08-02 13:50:23', 4), (1, 11, 2, 22, 2, 23, 22, 0, '2008-08-02 15:17:11', 2), (3, 11, 2, 22, 2, 23, 22, 0, '2008-08-02 19:04:00', 2), (7, 11, 2, 22, 2, 4, 22, 0, '2008-08-03 05:49:49', 1), (9, 11, 2, 22, 23, 4, 1, -1, '2008-08-03 10:08:12', 2), (13, 11, 2, 22, 2, 23, 22, 0, '2008-08-03 10:21:54', 2), (8, 11, 2, 22, 4, 23, 2, -1, '2008-08-03 10:30:55', 1), (10, 11, 2, 22, 2, 4, 1, -1, '2008-08-03 12:00:10', 1), (11, 11, 2, 22, 23, 2, 22, 0, '2008-08-03 13:00:32', 2), (2, 11, 2, 22, 2, 23, 22, 1, '2008-08-03 13:52:27', 0), (3, 12, 1, 1, 22, 2, 0, 0, '2008-08-22 21:18:30', 3), (7, 12, 1, 2, 22, 15, 0, 0, '2008-08-23 00:39:58', 4), (13, 12, 2, 22, 2, 5, 2, 1, '2008-08-23 08:01:42', 2), (13, 12, 1, 2, 1, 22, 0, 0, '2008-08-23 08:02:21', 3), (8, 12, 1, 4, 1, 2, 0, 0, '2008-08-23 12:38:44', 2), (9, 12, 1, 1, 4, 2, 0, 0, '2008-08-23 12:45:02', 2), (1, 12, 1, 2, 22, 1, 0, 0, '2008-08-23 13:10:05', 4), (11, 12, 1, 2, 22, 4, 0, 0, '2008-08-23 13:30:25', 6), (2, 12, 1, 1, 22, 2, 0, 0, '2008-08-23 13:38:45', 3), (7, 12, 2, 22, 1, 2, 22, -1, '2008-08-23 15:09:43', 2), (3, 12, 2, 2, 22, 1, 2, 1, '2008-08-23 16:51:28', 4), (9, 12, 2, 2, 4, 23, 1, 1, '2008-08-24 10:45:44', 2), (8, 12, 2, 2, 23, 22, 22, 1, '2008-08-24 10:49:22', 2), (1, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 11:55:50', 3), (10, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 12:39:37', 3), (12, 12, 2, 2, 22, 1, 1, -1, '2008-08-24 12:40:45', 4), (2, 12, 2, 2, 22, 1, 1, 1, '2008-08-24 13:45:38', 3), (11, 12, 2, 22, 2, 1, 22, 1, '2008-08-24 13:49:37', 1), (7, 13, 1, 2, 1, 22, 0, 0, '2008-09-05 15:24:44', 2), (3, 13, 1, 2, 22, 23, 0, 0, '2008-09-06 09:59:36', 4), (10, 13, 1, 1, 2, 22, 0, 0, '2008-09-06 11:21:15', 3), (12, 13, 1, 1, 2, 22, 0, 0, '2008-09-06 11:21:50', 3), (11, 13, 1, 2, 22, 23, 0, 0, '2008-09-06 11:54:10', 4), (1, 13, 1, 2, 22, 1, 0, 0, '2008-09-06 12:02:08', 2), (9, 13, 1, 2, 23, 22, 0, 0, '2008-09-06 13:41:52', 3), (8, 13, 1, 1, 3, 22, 0, 0, '2008-09-06 13:42:24', 1), (2, 13, 1, 22, 2, 1, 0, 0, '2008-09-06 13:48:19', 4), (1, 13, 2, 22, 23, 1, 22, 0, '2008-09-06 15:16:37', 2), (7, 13, 2, 22, 2, 1, 22, 0, '2008-09-06 15:59:14', 3), (3, 13, 2, 22, 2, 1, 2, 0, '2008-09-07 10:24:57', 3), (9, 13, 2, 22, 23, 1, 1, -1, '2008-09-07 10:39:47', 2), (10, 13, 2, 2, 22, 1, 1, 0, '2008-09-07 11:00:29', 5), (12, 13, 2, 22, 2, 23, 1, -1, '2008-09-07 11:01:10', 3), (8, 13, 2, 1, 2, 23, 22, 1, '2008-09-07 11:23:34', 0), (11, 13, 2, 22, 2, 23, 22, 1, '2008-09-07 13:29:07', 1), (13, 13, 2, 1, 22, 4, 2, -1, '2008-09-07 13:34:05', 1), (2, 13, 2, 22, 2, 1, 22, 0, '2008-09-07 13:49:53', 3), (13, 14, 1, 1, 22, 2, 0, 0, '2008-09-12 09:59:43', 0), (13, 14, 2, 22, 2, 23, 1, 1, '2008-09-12 10:00:41', 3), (7, 14, 1, 1, 22, 2, 0, 0, '2008-09-12 15:50:31', 0), (3, 14, 1, 1, 2, 22, 0, 0, '2008-09-13 08:24:16', 0), (10, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 11:38:17', 0), (12, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 11:38:42', 0), (9, 14, 1, 2, 1, 22, 0, 0, '2008-09-13 12:42:26', 0), (8, 14, 1, 1, 22, 3, 0, 0, '2008-09-13 12:43:27', 0), (2, 14, 1, 22, 1, 15, 0, 0, '2008-09-13 13:30:58', 1), (1, 14, 1, 22, 1, 2, 0, 0, '2008-09-13 13:38:18', 0), (11, 14, 1, 22, 2, 4, 0, 0, '2008-09-13 13:44:31', 0), (3, 14, 2, 23, 2, 15, 23, 1, '2008-09-13 16:41:29', 3), (7, 14, 2, 15, 23, 2, 2, 1, '2008-09-14 08:29:51', 5), (8, 14, 2, 23, 2, 7, 1, 1, '2008-09-14 12:55:53', 3), (9, 14, 2, 23, 2, 15, 2, -1, '2008-09-14 12:56:58', 2), (1, 14, 2, 23, 2, 3, 22, 1, '2008-09-14 13:02:28', 2), (12, 14, 2, 23, 2, 10, 22, -1, '2008-09-14 13:35:18', 1), (10, 14, 2, 2, 23, 15, 23, 1, '2008-09-14 13:38:33', 4), (11, 14, 2, 23, 15, 2, 23, 1, '2008-09-14 13:42:54', 3), (2, 14, 2, 23, 15, 14, 22, 1, '2008-09-14 13:53:13', 3), (13, 15, 1, 22, 1, 2, 0, 0, '2008-09-26 13:22:15', 3), (7, 15, 1, 22, 2, 1, 0, 0, '2008-09-27 00:52:38', 4), (3, 15, 1, 22, 2, 1, 0, 0, '2008-09-27 09:57:15', 4), (2, 15, 1, 22, 2, 5, 0, 0, '2008-09-27 12:34:34', 2), (9, 15, 1, 2, 22, 23, 0, 0, '2008-09-27 13:59:57', 4), (12, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 14:41:01', 2), (10, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 14:41:34', 2), (11, 15, 1, 22, 2, 4, 0, 0, '2008-09-27 15:29:56', 2), (1, 15, 1, 22, 2, 23, 0, 0, '2008-09-27 15:35:22', 2), (3, 15, 2, 2, 22, 1, 2, -1, '2008-09-27 18:01:02', 1), (7, 15, 2, 2, 22, 1, 2, -1, '2008-09-27 23:14:29', 1), (1, 15, 2, 2, 22, 1, 1, 1, '2008-09-28 09:43:10', 3), (11, 15, 2, 22, 2, 1, 1, 1, '2008-09-28 11:36:30', 3), (9, 15, 2, 2, 1, 23, 1, -1, '2008-09-28 12:22:12', 1), (13, 15, 2, 22, 1, 4, 2, 1, '2008-09-28 12:28:01', 2), (8, 15, 2, 2, 22, 23, 5, -1, '2008-09-28 13:18:17', 1), (12, 15, 2, 2, 1, 22, 1, -1, '2008-09-28 13:47:00', 3), (10, 15, 2, 2, 1, 22, 1, 1, '2008-09-28 13:47:53', 4), (2, 15, 2, 2, 22, 1, 9999, -1, '2008-09-28 13:57:09', 1), (13, 16, 1, 22, 2, 5, 0, 0, '2008-10-10 15:11:02', 2), (13, 16, 2, 22, 2, 5, 1, 1, '2008-10-10 15:11:40', 0), (7, 16, 1, 22, 2, 23, 0, 0, '2008-10-10 15:13:27', 4), (3, 16, 1, 22, 2, 1, 0, 0, '2008-10-10 18:05:40', 3), (1, 16, 1, 22, 2, 1, 0, 0, '2008-10-10 23:54:32', 3), (11, 16, 1, 22, 2, 1, 0, 0, '2008-10-11 00:16:19', 3), (3, 16, 2, 22, 2, 1, 22, -1, '2008-10-11 09:59:43', 2), (7, 16, 2, 22, 2, 1, 22, 0, '2008-10-11 16:58:40', 3), (9, 16, 2, 22, 23, 1, 1, -1, '2008-10-11 20:04:07', 2), (8, 16, 2, 22, 2, 5, 12, 1, '2008-10-11 23:59:44', 0), (11, 16, 2, 22, 2, 1, 1, 0, '2008-10-12 00:24:14', 3), (1, 16, 2, 22, 2, 1, 1, 0, '2008-10-12 01:15:29', 3), (2, 16, 2, 22, 23, 2, 22, 0, '2008-10-12 06:25:26', 1), (13, 17, 1, 22, 1, 2, 0, 0, '2008-10-17 14:39:58', 6), (3, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 16:44:37', 4), (9, 17, 1, 22, 2, 5, 0, 0, '2008-10-17 19:49:45', 3), (8, 17, 1, 22, 5, 2, 0, 0, '2008-10-17 20:07:50', 4), (7, 17, 1, 22, 2, 5, 0, 0, '2008-10-17 18:26:39', 3), (1, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 20:33:56', 4), (11, 17, 1, 22, 2, 1, 0, 0, '2008-10-17 22:23:25', 4), (2, 17, 1, 22, 5, 23, 0, 0, '2008-10-18 07:58:06', 2), (3, 17, 2, 2, 1, 22, 2, -1, '2008-10-18 10:53:00', 3), (9, 17, 2, 22, 2, 23, 1, 0, '2008-10-18 17:03:50', 5), (7, 17, 2, 22, 2, 5, 22, -1, '2008-10-18 17:12:32', 5), (8, 17, 2, 2, 5, 22, 4, 0, '2008-10-18 17:23:18', 3), (13, 17, 2, 2, 1, 5, 1, -1, '2008-10-18 20:00:39', 2), (11, 17, 2, 22, 2, 1, 22, -1, '2008-10-18 21:47:55', 7), (1, 17, 2, 22, 2, 1, 1, 0, '2008-10-18 21:48:53', 7), (2, 17, 2, 22, 2, 1, 22, 0, '2008-10-19 08:49:19', 8), (13, 18, 1, 1, 2, 22, 0, 0, '2008-10-31 12:05:12', 2), (7, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 00:16:21', 2), (3, 18, 1, 2, 1, 22, 0, 0, '2008-11-01 08:04:45', 3), (8, 18, 1, 22, 2, 1, 0, 0, '2008-11-01 14:46:39', 3), (9, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 14:48:13', 2), (2, 18, 1, 2, 5, 22, 0, 0, '2008-11-01 15:27:01', 2), (11, 18, 1, 22, 2, 5, 0, 0, '2008-11-01 15:57:57', 1), (1, 18, 1, 2, 22, 5, 0, 0, '2008-11-01 16:29:12', 2), (3, 18, 2, 2, 11, 1, 2, 0, '2008-11-01 18:03:40', 4), (1, 18, 2, 2, 1, 22, 1, 0, '2008-11-02 07:05:19', 2), (11, 18, 2, 2, 1, 22, 2, 1, '2008-11-02 10:18:49', 5), (9, 18, 2, 2, 1, 5, 1, 0, '2008-11-02 12:23:25', 3), (13, 18, 2, 2, 1, 22, 1, -1, '2008-11-02 12:42:13', 3), (8, 18, 2, 2, 11, 1, 5, 1, '2008-11-02 12:44:40', 5), (7, 18, 2, 2, 1, 22, 2, -1, '2008-11-02 16:30:21', 4), (2, 18, 2, 2, 1, 22, 22, 1, '2008-11-02 17:57:13', 4); -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `u_id` int(11) NOT NULL auto_increment, `u_name` char(3) NOT NULL default '', `u_passcode` varchar(41) character set utf8 collate utf8_bin NOT NULL default '', `u_pic` varchar(20) NOT NULL default '', `u_realname` varchar(40) NOT NULL default '', `u_nickname` varchar(20) NOT NULL default 'not revealed', `u_email` varchar(50) NOT NULL default '', `u_emailreminder` int(1) NOT NULL default '0', `u_nationality` varchar(20) NOT NULL default 'not revealed', `u_favdriver` int(11) NOT NULL default '0', `u_since` year(4) NOT NULL default '0000', PRIMARY KEY (`u_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Daten für Tabelle `users` -- INSERT INTO `users` (`u_id`, `u_name`, `u_passcode`, `u_pic`, `u_realname`, `u_nickname`, `u_email`, `u_emailreminder`, `u_nationality`, `u_favdriver`, `u_since`) VALUES (1, 'MAM', 0x3561393336316232386565353137393566316538326439303534393139303334, 'pic_MAM.gif', 'Markus A. Mascelli', 'MAM', 'mam@heimam.at', 0, 'italian', 1, 2006), (2, 'GUE', 0x3738393138636563663839323664306361646134633562633331616638376133, 'pic_GUE.gif', 'Guenther Schmidt', 'GueStar', 'guenther.schmidt@gmail.com', 0, 'austrian', 0, 2006), (3, 'ZEI', 0x3864616437636162636539633531316264343938336538646339366561356461, 'pic_ZEI.gif', 'Christian Zeichmann', 'Zeichi', 'christian.zeichmann@inode.at', 0, 'austrian', 0, 2007), (4, 'AFG', 0x3833333834343331333930613134383839633939353539333862623536303466, 'pic_AFG.gif', 'Andrea F. Grohmann', '', 'andrea.grohmann@chello.at', 0, 'austrian', 0, 2007), (6, 'JIR', 0x3835323263326363666436666335643234326564313664313638343031666164, 'avatar.jpg', 'Jürgen Iser', '', 'j.iser@gmx.at', 0, '', 1, 2008), (7, 'KAI', 0x6535663464393761343936316465613131383462626265383437623539316633, 'avatar.jpg', 'Roman Kailbach', 'Kailo', 'kailo@gmx.at', 0, 'Austria', 22, 2008), (8, 'WOB', 0x3737366164306566323761636330363032633333376463323733366633613937, 'avatar.jpg', 'Wolfgang Boehm', 'WoB', 'wboehm@gmail.com', 0, 'Austria', 0, 2008), (9, 'REG', 0x3737366164306566323761636330363032633333376463323733366633613937, 'avatar.jpg', 'Regina Böhm', '', 'wboehm@gmail.com', 0, 'Österreich', 0, 2008), (10, 'ISA', 0x3363346462393536316161326238353330643563363030313464626662653836, 'pic_ISA.jpg', 'Ildiko K. Samu', 'sam', 'ildiko.samu@gmx.at', 0, 'hungarian', 1, 2008), (11, 'MRO', 0x6364613066643239313864313965323061633837316564373961386432626230, 'pic_MRO.jpg', 'Martha Rossa', 'RoMa', 'rossama@yahoo.com', 0, 'austrian', 22, 2008), (12, 'MPU', 0x3438643534663433633330613237313337656462333833646532363035613836, 'avatar.jpg', 'Michael Pühringer', '', 'michael.puehringer@atosorigin.com', 0, '', 6, 2008), (13, 'RHA', 0x3963656438326330353135646636396434653333313166363364343066666130, 'avatar.jpg', 'Robert Haller', '', 'Robert.Haller@kabsi.at', 0, '', 0, 2008);