-- phpMyAdmin SQL Dump -- version 2.6.1-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 30. Dezember 2010 um 17:14 -- Server Version: 4.1.18 -- PHP-Version: 4.4.2 -- -- Datenbank: `niki` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `alldrivers` -- DROP TABLE IF EXISTS `alldrivers`; CREATE TABLE IF NOT EXISTS `alldrivers` ( `a_id` int(11) NOT NULL auto_increment, `a_lname` varchar(20) NOT NULL default '', `a_fname` varchar(20) NOT NULL default '', PRIMARY KEY (`a_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=814 ; -- -- Daten für Tabelle `alldrivers` -- INSERT INTO `alldrivers` (`a_id`, `a_lname`, `a_fname`) VALUES (1, 'ABATE', 'Carlo'), (2, 'ABECASSIS', 'George'), (3, 'ACHESON', 'Kenny'), (4, 'ADAMS', 'Philippe'), (5, 'ADER', 'Walt'), (6, 'ADOLFF', 'Kurt'), (7, 'AGABASHIAN', 'Fred'), (8, 'AHRENS', 'Kurt Jr.'), (9, 'ALBERS', 'Christijan'), (10, 'ALBORETO', 'Michele'), (11, 'ALESI', 'Jean'), (12, 'ALGUERSUARI', 'Jaime'), (13, 'ALLIOT', 'Philippe'), (14, 'ALLISON', 'Cliff'), (15, 'ALONSO', 'Fernando'), (16, 'AMATI', 'Giovanna'), (17, 'AMICK', 'George'), (18, 'AMICK', 'Red'), (19, 'AMON', 'Chris'), (20, 'ANDERSON', 'Bob'), (21, 'ANDERSSON', 'Conny'), (22, 'ANDRETTI', 'Mario'), (23, 'ANDRETTI', 'Michael'), (24, 'ANDREWS', 'Keith'), (25, 'APICELLA', 'Marco'), (26, 'ARMI', 'Frank'), (27, 'ARNOLD', 'Chuck'), (28, 'ARNOUX', 'Rene'), (29, 'ARUNDELL', 'Peter'), (30, 'ASCARI', 'Alberto'), (31, 'ASHDOWN', 'Peter'), (32, 'ASHLEY', 'Ian'), (33, 'ASHMORE', 'Gerry'), (34, 'ASTON', 'Bill'), (35, 'ATTWOOD', 'Richard'), (36, 'AYULO', 'Manny'), (37, 'BADOER', 'Luca'), (38, 'BAGHETTI', 'Giancarlo'), (39, 'BAILEY', 'Julian'), (40, 'BALDI', 'Mauro'), (41, 'BALL', 'Bobby'), (42, 'BALSA', 'Marcel'), (43, 'BANDINI', 'Lorenzo'), (44, 'BANKS', 'Henry'), (45, 'BARBAZZA', 'Fabrizio'), (46, 'BARBER', 'John'), (47, 'BARBER', 'Skip'), (48, 'BARILLA', 'Paolo'), (49, 'BARRICHELLO', 'Rubens'), (50, 'BARTELS', 'Michael'), (51, 'BARTH', 'Edgar'), (52, 'BASSI', 'Giorgio'), (53, 'BAUER', 'Erwin'), (54, 'BAUMGARTNER', 'Zsolt'), (55, 'BAYOL', 'Elie'), (56, 'BEAUMAN', 'Don'), (57, 'BECHEM', 'Karl–Guenther'), (58, 'BEHRA', 'Jean'), (59, 'BELL', 'Derek'), (60, 'BELLOF', 'Stefan'), (61, 'BELMONDO', 'Paul'), (62, 'BELSO', 'Tom'), (63, 'BELTOISE', 'Jean-Pierre'), (64, 'BERETTA', 'Olivier'), (65, 'BERG', 'Allen'), (66, 'BERGER', 'Georges'), (67, 'BERGER', 'Gerhard'), (68, 'BERNARD', 'Eric'), (69, 'BERNOLDI', 'Enrique'), (70, 'BERTAGGIA', 'Enrico'), (71, 'BETTENHAUSEN', 'Tony'), (72, 'BEUTTLER', 'Mike'), (73, 'BHANUBANDH', 'Birabongse'), (74, 'BIANCHI', 'Lucien'), (75, 'BIANCO', 'Gino'), (76, 'BINDER', 'Hans'), (77, 'BIONDETTI', 'Clemente'), (78, 'BIRGER', 'Pablo'), (79, 'BISCH', 'Art'), (80, 'BLANCHARD', 'Harry'), (81, 'BLEEKEMOLEN', 'Michael'), (82, 'BLIGNAUT', 'Alex'), (83, 'BLOKDYK', 'Trevor'), (84, 'BLUNDELL', 'Mark'), (85, 'BOESEL', 'Raul'), (86, 'BOFFA', 'Menato'), (87, 'BONDURANT', 'Bob'), (88, 'BONETTO', 'Felice'), (89, 'BONNIER', 'Jo'), (90, 'BONOMI', 'Roberto'), (91, 'BORDEU', 'Juan Manuel'), (92, 'BORGUDD', 'Slim'), (93, 'BOTHA', 'Luki'), (94, 'BOULLION', 'Jean-Christophe'), (95, 'BOURDAIS', 'Sebastien'), (96, 'BOUTSEN', 'Thierry'), (97, 'BOYD', 'Johnny'), (98, 'BRABHAM', 'David'), (99, 'BRABHAM', 'Gary'), (100, 'BRABHAM', 'Jack'), (101, 'BRACK', 'Bill'), (102, 'BRAMBILLA', 'Ernesto'), (103, 'BRAMBILLA', 'Vittorio'), (104, 'BRANCA', 'Toni'), (105, 'BRANCATELLI', 'Gianfranco'), (106, 'BRANDON', 'Eric'), (107, 'BRANSON', 'Don'), (108, 'BRIDGER', 'Tom'), (109, 'BRISE', 'Tony'), (110, 'BRISTOW', 'Chris'), (111, 'BROEKER', 'Peter'), (112, 'BROOKS', 'Tony'), (113, 'BROWN', 'Alan'), (114, 'BROWN', 'Walt'), (115, 'BROWN', 'Warwick'), (116, 'BRUDES', 'Adolf'), (117, 'BRUNDLE', 'Martin'), (118, 'BRUNI', 'Gianmaria'), (119, 'BRYAN', 'Jimmy'), (120, 'BUCCI', 'Clemar'), (121, 'BUCKNUM', 'Ronnie'), (122, 'BUEB', 'Ivor'), (123, 'BUEMI', 'Sebastien'), (124, 'BUENO', 'Luiz'), (125, 'BURGESS', 'Ian'), (126, 'BURTI', 'Luciano'), (127, 'BUSSINELLO', 'Roberto'), (128, 'BUTTON', 'Jenson'), (129, 'BYRNE', 'Tommy'), (130, 'CABIANCA', 'Giulio'), (131, 'CADE', 'Phil'), (132, 'CAFFI', 'Alex'), (133, 'CAMPBELL-JONES', 'John'), (134, 'CAMPOS', 'Adrian'), (135, 'CANNON', 'John'), (136, 'CANTONI', 'Eitel'), (137, 'CANTRELL', 'Bill'), (138, 'CAPELLI', 'Ivan'), (139, 'CARINI', 'Piero'), (140, 'CARTER', 'Duane'), (141, 'CASTELLOTTI', 'Eugenio'), (142, 'CECOTTO', 'Johnny'), (143, 'CEVERT', 'Francois'), (144, 'CHABOUD', 'Eugène'), (145, 'CHAMBERLAIN', 'Jay'), (146, 'CHAPMAN', 'Colin'), (147, 'CHARLTON', 'Dave'), (148, 'CHAVES', 'Pedro Matos'), (149, 'CHEESBOURG', 'Bill'), (150, 'CHEEVER', 'Eddie'), (151, 'CHIESA', 'Andrea'), (152, 'CHIMERI', 'Ettore'), (153, 'CHIRON', 'Louis'), (154, 'CHITWOOD', 'Joie'), (155, 'CHRISTIE', 'Bob'), (156, 'CLAES', 'Johnny'), (157, 'CLAPHAM', 'David'), (158, 'CLARK', 'Jim'), (159, 'COGAN', 'Kevin'), (160, 'COLLINS', 'Peter'), (161, 'COLLOMB', 'Bernard'), (162, 'COLOMBO', 'Alberto'), (163, 'COMAS', 'Erik'), (164, 'COMOTTI', 'Franco'), (165, 'CONNOR', 'George'), (166, 'CONSTANTINE', 'George'), (167, 'CORDTS', 'John'), (168, 'COULTHARD', 'David'), (169, 'COURAGE', 'Piers'), (170, 'CRAFT', 'Chris'), (171, 'CRAWFORD', 'Jim'), (172, 'CRAWFORD', 'Ray'), (173, 'CRESPO', 'Alberto'), (174, 'CREUS', 'Antonio'), (175, 'CROCKETT', 'Larry'), (176, 'CROOK', 'Tony'), (177, 'CROSS', 'Art'), (178, 'CROSSLEY', 'Geoff'), (179, 'DA MATTA', 'Cristiano'), (180, 'DA SLIVA RAMOS', 'Hernando'), (181, 'DAIGH', 'Chuck'), (182, 'DALMAS', 'Yannick'), (183, 'DALY', 'Derek'), (184, 'DANNER', 'Christian'), (185, 'DAPONTE', 'Jorge'), (186, 'DAVIDSON', 'Anthony'), (187, 'DAVIES', 'Jimmy'), (188, 'DAVIS', 'Colin'), (189, 'DAYWALT', 'Jimmy'), (190, 'DE ADAMICH', 'Andrea'), (191, 'DE ANGELIS', 'Elio'), (192, 'DE ARAUJO CABRAL', 'Mario'), (193, 'DE CESARIS', 'Andrea'), (194, 'DE CHANGY', 'Alain'), (195, 'DE DRYVER', 'Bernard'), (196, 'DE FILIPPIS', 'Maria Teresa'), (197, 'DE GRAFFENRIED', 'Emmanuel'), (198, 'DE KLERK', 'Peter'), (199, 'DE LA ROSA', 'Pedro'), (200, 'DE PORTAGO', 'Alfonso'), (201, 'DE RIU', 'Giovanni'), (202, 'DE TOMASO', 'Alejandro'), (203, 'DE TORNACO', 'Charles'), (204, 'DE VILLOTA', 'Emilio'), (205, 'DE VOS', 'Ernie'), (206, 'DELETRAZ', 'Jean-Denis'), (207, 'DEPAILLER', 'Patrick'), (208, 'DINIZ', 'Pedro'), (209, 'DINSMORE', 'Duke'), (210, 'DOCHNAL', 'Frank'), (211, 'DOLHEM', 'Jose'), (212, 'DONNELLY', 'Martin'), (213, 'DONOHUE', 'Mark'), (214, 'DOORNBOS', 'Robert'), (215, 'D''OREY', 'Fritz'), (216, 'DOWNING', 'Ken'), (217, 'DRAKE', 'Bob'), (218, 'DRIVER', 'Paddy'), (219, 'DROGO', 'Piero'), (220, 'DUKE', 'Geoff'), (221, 'DUMFRIES', 'Johnny'), (222, 'DUNCAN', 'Len'), (223, 'DUSIO', 'Piero'), (224, 'EATON', 'George'), (225, 'ECCLESTONE', 'Bernie'), (226, 'EDMUNDS', 'Don'), (227, 'EDWARDS', 'Guy'), (228, 'ELFORD', 'Vic'), (229, 'ELISIAN', 'Ed'), (230, 'EMERY', 'Paul'), (231, 'ENGE', 'Tomas'), (232, 'ENGLAND', 'Paul'), (233, 'ERTL', 'Harald'), (234, 'ESTEFANO', 'Nasif'), (235, 'ETANCELIN', 'Philippe'), (236, 'EVANS', 'Bob'), (237, 'FABI', 'Corrado'), (238, 'FABI', 'Teo'), (239, 'FABRE', 'Pascal'), (240, 'FACETTI', 'Carlo'), (241, 'FAGIOLI', 'Luigi'), (242, 'FAIRMAN', 'Jack'), (243, 'FANGIO', 'Juan Manuel'), (244, 'FARINA', 'Nino'), (245, 'FAULKNER', 'Walt'), (246, 'FERGUSON', 'William'), (247, 'FIRMAN', 'Ralph'), (248, 'FISCHER', 'Ludwig'), (249, 'FISCHER', 'Rudi'), (250, 'FISHER', 'Mike'), (251, 'FISICHELLA', 'Giancarlo'), (252, 'FITCH', 'John'), (253, 'FITTIPALDI', 'Christian'), (254, 'FITTIPALDI', 'Emerson'), (255, 'FITTIPALDI', 'Wilson'), (256, 'FITZAU', 'Theo'), (257, 'FLAHERTY', 'Pat'), (258, 'FLINTERMAN', 'Jan'), (259, 'FLOCKHART', 'Ron'), (260, 'FOHR', 'Myron'), (261, 'FOITEK', 'Gregor'), (262, 'FOLLMER', 'George'), (263, 'FONDER', 'George'), (264, 'FONTANA', 'Norberto'), (265, 'FONTES BAYARDO', 'Azdrubal'), (266, 'FORBERG', 'Carl'), (267, 'FORCE', 'Gene'), (268, 'FORINI', 'Franco'), (269, 'FOTHERINGHAM-PARKER', 'Philip'), (270, 'FOYT', 'A.J.'), (271, 'FRANCIA', 'Giorgio'), (272, 'FREELAND', 'Don'), (273, 'FRENTZEN', 'Heinz-Harald'), (274, 'FRERE', 'Paul'), (275, 'FRIESACHER', 'Patrick'), (276, 'FRY', 'Joe'), (277, 'FUSHIDA', 'Hiroshi'), (278, 'GABBIANI', 'Beppe'), (279, 'GACHOT', 'Bertrand'), (280, 'GAILLARD', 'Patrick'), (281, 'GALICA', 'Divina'), (282, 'GALLI', 'Nanni'), (283, 'GALVEZ', 'Oscar Alfredo'), (284, 'GAMBLE', 'Fred'), (285, 'GANLEY', 'Howden'), (286, 'GARDNER', 'Frank'), (287, 'GARRETT', 'Billy'), (288, 'GARTNER', 'Jo'), (289, 'GAZE', 'Tony'), (290, 'GEKI', 'NN'), (291, 'GENDEBIEN', 'Olivier'), (292, 'GENE', 'Marc'), (293, 'GEORGE', 'Elmer'), (294, 'GERARD', 'Bob'), (295, 'GERINI', 'Gerino'), (296, 'GETHIN', 'Peter'), (297, 'GHINZANI', 'Piercarlo'), (298, 'GIACOMELLI', 'Bruno'), (299, 'GIBSON', 'Dick'), (300, 'GINTHER', 'Richie'), (301, 'GIRAUD-CABANTOUS', 'Yves'), (302, 'GIUNTI', 'Ignazio'), (303, 'GLOCK', 'Timo'), (304, 'GLOECKLER', 'Helm'), (305, 'GODIA', 'Paco'), (306, 'GODIN DE BEAUFORT', 'Carel'), (307, 'GOETHALS', 'Christian'), (308, 'GOLDSMITH', 'Paul'), (309, 'GONZALEZ', 'Jose Froilan'), (310, 'GONZALEZ', 'Oscar'), (311, 'GORDINI', 'Aldo'), (312, 'GOULD', 'Horace'), (313, 'GOUNON', 'Jean-Marc'), (314, 'GREEN', 'Cecil'), (315, 'GREENE', 'Keith'), (316, 'GREGORY', 'Masten'), (317, 'GRIFFITH', 'Cliff'), (318, 'GRIGNARD', 'Georges'), (319, 'GRIM', 'Bobby'), (320, 'GROSJEAN', 'Romain'), (321, 'GROUILLARD', 'Olivier'), (322, 'GUBBY', 'Brian'), (323, 'GUELFI', 'Andre'), (324, 'GUERRA', 'Miguel Angel'), (325, 'GUERRERO', 'Roberto'), (326, 'GUGELMIN', 'Mauricio'), (327, 'GURNEY', 'Dan'), (328, 'HAHNE', 'Hubert'), (329, 'HAILWOOD', 'Mike'), (330, 'HAKKINEN', 'Mika'), (331, 'HALFORD', 'Bruce'), (332, 'HALL', 'Jim'), (333, 'HAMILTON', 'Duncan'), (334, 'HAMILTON', 'Lewis'), (335, 'HAMPSHIRE', 'David'), (336, 'HANKS', 'Sam'), (337, 'HANSGEN', 'Walt'), (338, 'HARRIS', 'Mike'), (339, 'HARRISON', 'Cuth'), (340, 'HART', 'Brian'), (341, 'HARTLEY', 'Gene'), (342, 'HASEMI', 'Masahiro'), (343, 'HATTORI', 'Naoki'), (344, 'HAWKINS', 'Paul'), (345, 'HAWTHORN', 'Mike'), (346, 'HAYJE', 'Boy'), (347, 'HEEKS', 'Willi'), (348, 'HEIDFELD', 'Nick'), (349, 'HELFRICH', 'Theo'), (350, 'HELLINGS', 'Mack'), (351, 'HENTON', 'Brian'), (352, 'HERBERT', 'Johnny'), (353, 'HERMAN', 'Al'), (354, 'HERRMANN', 'Hans'), (355, 'HESNAULT', 'Francois'), (356, 'HEYER', 'Hans'), (357, 'HILL', 'Damon'), (358, 'HILL', 'Graham'), (359, 'HILL', 'Phil'), (360, 'HIRT', 'Peter'), (361, 'HOBBS', 'David'), (362, 'HOCKING', 'Gary'), (363, 'HOFFMANN', 'Ingo'), (364, 'HOLLAND', 'Bill'), (365, 'HOLMES', 'Jackie'), (366, 'HOMEIER', 'Bill'), (367, 'HOSHINO', 'Kazuyoshi'), (368, 'HOYT', 'Jerry'), (369, 'HULME', 'Denny'), (370, 'HUNT', 'James'), (371, 'HURTUBISE', 'Jim'), (372, 'HUTCHISON', 'Gus'), (373, 'ICKX', 'Jacky'), (374, 'IDE', 'Yuji'), (375, 'IGLESIAS', 'Jesus'), (376, 'INOUE', 'Taki'), (377, 'IRELAND', 'Innes'), (378, 'IRVINE', 'Eddie'), (379, 'IRWIN', 'Chris'), (380, 'JABOUILLE', 'Jean-Pierre'), (381, 'JACKSON', 'Jimmy'), (382, 'JAMES', 'Joe'), (383, 'JAMES', 'John'), (384, 'JARIER', 'Jean-Pierre'), (385, 'JEAN', 'Max'), (386, 'JOHANSSON', 'Stefan'), (387, 'JOHNSON', 'Eddie'), (388, 'JOHNSON', 'Leslie'), (389, 'JOHNSTONE', 'Bruce'), (390, 'JONES', 'Alan'), (391, 'JONES', 'Tom'), (392, 'JOVER', 'Juan'), (393, 'KARCH', 'Oswald'), (394, 'KARTHIKEYAN', 'Narain'), (395, 'KATAYAMA', 'Ukyo'), (396, 'KAVANAGH', 'Ken'), (397, 'KEEGAN', 'Rupert'), (398, 'KEIZAN', 'Eddie'), (399, 'KELLER', 'Al'), (400, 'KELLY', 'Joe'), (401, 'KENNEDY', 'Dave'), (402, 'KESSEL', 'Loris'), (403, 'KESSLER', 'Bruce'), (404, 'KIESA', 'Nicolas'), (405, 'KINNUNEN', 'Leo'), (406, 'KLADIS', 'Danny'), (407, 'KLENK', 'Hans'), (408, 'KLIEN', 'Christian'), (409, 'KLING', 'Karl'), (410, 'KLODWIG', 'Ernst'), (411, 'KOBAYASHI', 'Kamui'), (412, 'KOINIGG', 'Helmuth'), (413, 'KOVALAINEN', 'Heikki'), (414, 'KOZAROWITZKY', 'Mikko'), (415, 'KRAKAU', 'Willi'), (416, 'KRAUSE', 'Rudolf'), (417, 'KUBICA', 'Robert'), (418, 'KUHNKE', 'Kurt'), (419, 'KUWASHIMA', 'Masami'), (420, 'LA CAZE', 'Robert'), (421, 'LAFFITE', 'Jacques'), (422, 'LAGORCE', 'Franck'), (423, 'LAMMERS', 'Jan'), (424, 'LAMY', 'Pedro'), (425, 'LANDI', 'Chico'), (426, 'LANG', 'Hermann'), (427, 'LANGES', 'Claudio'), (428, 'LARINI', 'Nicola'), (429, 'LARRAURI', 'Oscar'), (430, 'LARROUSSE', 'Gerard'), (431, 'LARSON', 'Jud'), (432, 'LAUDA', 'Niki'), (433, 'LAURENT', 'Roger'), (434, 'LAVAGGI', 'Giovanni'), (435, 'LAWRENCE', 'Chris'), (436, 'LECLERE', 'Michel'), (437, 'LEDERLE', 'Neville'), (438, 'LEES', 'Geoff'), (439, 'LEGAT', 'Arthur'), (440, 'LEHTO', 'JJ'), (441, 'LEONI', 'Lamberto'), (442, 'LESTON', 'Les'), (443, 'LEVEGH', 'Pierre'), (444, 'LEVRETT', 'Bayliss'), (445, 'LEWIS', 'Jackie'), (446, 'LEWIS-EVANS', 'Stuart'), (447, 'LIGIER', 'Guy'), (448, 'LINDEN', 'Andy'), (449, 'LIPPI', 'Roberto'), (450, 'LIUZZI', 'Vitantonio'), (451, 'LOMBARDI', 'Lella'), (452, 'LONDONO', 'Ricardo'), (453, 'LOOF', 'Ernst'), (454, 'LOUVEAU', 'Henri'), (455, 'LOVE', 'John'), (456, 'LOVELY', 'Pete'), (457, 'LOYER', 'Roger'), (458, 'LUCAS', 'Jean'), (459, 'LUCIENBONNET', 'Jean'), (460, 'LUNGER', 'Brett'), (461, 'MACDOWEL', 'Mike'), (462, 'MACKAY-FRASER', 'Herbert'), (463, 'MACKEY', 'Bill'), (464, 'MACKLIN', 'Lance'), (465, 'MAGEE', 'Damien'), (466, 'MAGGS', 'Tony'), (467, 'MAGILL', 'Mike'), (468, 'MAGLIOLI', 'Umberto'), (469, 'MAGNUSSEN', 'Jan'), (470, 'MAIRESSE', 'Guy'), (471, 'MAIRESSE', 'Willy'), (472, 'MANSELL', 'Nigel'), (473, 'MANTOVANI', 'Sergio'), (474, 'MANTZ', 'Johnny'), (475, 'MANZON', 'Robert'), (476, 'MARIMON', 'Onofre'), (477, 'MARKO', 'Helmut'), (478, 'MARQUES', 'Tarso'), (479, 'MARR', 'Leslie'), (480, 'MARSH', 'Tony'), (481, 'MARTIN', 'Eugene'), (482, 'MARTINI', 'Pierluigi'), (483, 'MASS', 'Jochen'), (484, 'MASSA', 'Felipe'), (485, 'MAY', 'Michael'), (486, 'MAYER', 'Timmy'), (487, 'MAZET', 'Francois'), (488, 'MAZZACANE', 'Gaston'), (489, 'MCALPINE', 'Kenneth'), (490, 'MCCARTHY', 'Perry'), (491, 'MCCOY', 'Ernie'), (492, 'MCDOWELL', 'Johnny'), (493, 'MCGRATH', 'Jack'), (494, 'MCGUIRE', 'Brian'), (495, 'MCLAREN', 'Bruce'), (496, 'MCNISH', 'Allan'), (497, 'MCRAE', 'Graham'), (498, 'MCWITHEY', 'Jim'), (499, 'MENDITEGUY', 'Carlos'), (500, 'MERKEL', 'Harry'), (501, 'MERZARIO', 'Arturo'), (502, 'MIERES', 'Roberto'), (503, 'MIGAULT', 'Francois'), (504, 'MILES', 'John'), (505, 'MILES', 'Ken'), (506, 'MILHOUX', 'Andre'), (507, 'MILLER', 'Chet'), (508, 'MITTER', 'Gerhard'), (509, 'MODENA', 'Stefano'), (510, 'MONARCH', 'Thomas'), (511, 'MONTAGNY', 'Franck'), (512, 'MONTEIRO', 'Tiago'), (513, 'MONTERMINI', 'Andrea'), (514, 'MONTEVERDI', 'Peter'), (515, 'MONTGOMERIE-CHARRING', 'Robin'), (516, 'MONTOYA', 'Juan Pablo'), (517, 'MORBIDELLI', 'Gianni'), (518, 'MORENO', 'Roberto'), (519, 'MORGAN', 'Dave'), (520, 'MOSER', 'Silvio'), (521, 'MOSS', 'Bill'), (522, 'MOSS', 'Stirling'), (523, 'MUNARON', 'Gino'), (524, 'MURRAY', 'David'), (525, 'MUSSO', 'Luigi'), (526, 'NAKAJIMA', 'Kazuki'), (527, 'NAKAJIMA', 'Satoru'), (528, 'NAKANO', 'Shinji'), (529, 'NALON', 'Duke'), (530, 'NANNINI', 'Alessandro'), (531, 'NASPETTI', 'Emanuele'), (532, 'NATILI', 'Massimo'), (533, 'NAYLOR', 'Brian'), (534, 'NAZARUK', 'Mike'), (535, 'NEEDELL', 'Tiff'), (536, 'NELLEMAN', 'Jac'), (537, 'NEVE', 'Patrick'), (538, 'NICHOLSON', 'John'), (539, 'NIDAY', 'Cal'), (540, 'NIEDERMAYR', 'Helmut'), (541, 'NIEMANN', 'Brausch'), (542, 'NILSSON', 'Gunnar'), (543, 'NODA', 'Hideki'), (544, 'NUCKEY', 'Rodney'), (545, 'O''BRIEN', 'Robert'), (546, 'O''CONNOR', 'Pat'), (547, 'OLIVER', 'Jackie'), (548, 'ONGAIS', 'Danny'), (549, 'OPPITZHAUSER', 'Karl'), (550, 'OWEN', 'Arthur'), (551, 'PACE', 'Carlos'), (552, 'PAGANI', 'Nello'), (553, 'PALETTI', 'Riccardo'), (554, 'PALM', 'Torsten'), (555, 'PALMER', 'Jonathan'), (556, 'PANIS', 'Olivier'), (557, 'PANTANO', 'Giorgio'), (558, 'PAPIS', 'Massimiliano'), (559, 'PARKES', 'Mike'), (560, 'PARNELL', 'Reg'), (561, 'PARNELL', 'Tim'), (562, 'PARSONS', 'Johnnie'), (563, 'PATRESE', 'Riccardo'), (564, 'PEASE', 'Al'), (565, 'PENSKE', 'Roger'), (566, 'PERDISA', 'Cesare'), (567, 'PEREZ-SALA', 'Luis'), (568, 'PERKINS', 'Larry'), (569, 'PESCAROLO', 'Henri'), (570, 'PESENTI-ROSSI', 'Alessandro'), (571, 'PETERS', 'Josef'), (572, 'PETERSON', 'Ronnie'), (573, 'PIAN', 'Alfredo'), (574, 'PICARD', 'Francois'), (575, 'PIETERSE', 'Ernie'), (576, 'PIETSCH', 'Paul'), (577, 'PILETTE', 'Andre'), (578, 'PILETTE', 'Teddy'), (579, 'PIOTTI', 'Luigi'), (580, 'PIPER', 'David'), (581, 'PIQUET', 'Nelson'), (582, 'PIQUET', 'Nelson Jr.'), (583, 'PIROCCHI', 'Renato'), (584, 'PIRONI', 'Didier'), (585, 'PIRRO', 'Emanuele'), (586, 'PIZZONIA', 'Antonio'), (587, 'POLLET', 'Jacques'), (588, 'PON', 'Ben'), (589, 'POORE', 'Dennis'), (590, 'POSEY', 'Sam'), (591, 'POZZI', 'Charles'), (592, 'PRETORIUS', 'Jackie'), (593, 'PRINOTH', 'Ernesto'), (594, 'PROPHET', 'David'), (595, 'PROST', 'Alain'), (596, 'PRYCE', 'Tom'), (597, 'PURLEY', 'David'), (598, 'PUZEY', 'Clive'), (599, 'QUESTER', 'Dieter'), (600, 'RABY', 'Ian'), (601, 'RAHAL', 'Bobby'), (602, 'RAIKKONEN', 'Kimi'), (603, 'RAPHANEL', 'Pierre-Henri'), (604, 'RATHMANN', 'Dick'), (605, 'RATHMANN', 'Jim'), (606, 'RATZENBERGER', 'Roland'), (607, 'REBAQUE', 'Hector'), (608, 'REDMAN', 'Brian'), (609, 'REECE', 'Jimmy'), (610, 'REED', 'Ray'), (611, 'REES', 'Alan'), (612, 'REGAZZONI', 'Clay'), (613, 'REUTEMANN', 'Carlos'), (614, 'REVENTLOW', 'Lance'), (615, 'REVSON', 'Peter'), (616, 'RHODES', 'John'), (617, 'RIBEIRO', 'Alex'), (618, 'RICHARDSON', 'Ken'), (619, 'RIESS', 'Fritz'), (620, 'RIGSBY', 'Jim'), (621, 'RINDT', 'Jochen'), (622, 'RISELEY-PRICHARD', 'John'), (623, 'ROBARTS', 'Richard'), (624, 'RODRIGUEZ', 'Pedro'), (625, 'RODRIGUEZ', 'Ricardo'), (626, 'RODRIGUEZ LARRETA', 'Alberto'), (627, 'ROL', 'Franco'), (628, 'ROLLINSON', 'Alan'), (629, 'ROLT', 'Tony'), (630, 'ROOS', 'Bertil'), (631, 'ROSBERG', 'Keke'), (632, 'ROSBERG', 'Nico'), (633, 'ROSE', 'Mauri'), (634, 'ROSIER', 'Louis'), (635, 'ROSSET', 'Ricardo'), (636, 'ROTHENGATTER', 'Huub'), (637, 'RUBY', 'Lloyd'), (638, 'RUDAZ', 'Jean-Claude'), (639, 'RUSSO', 'Eddie'), (640, 'RUSSO', 'Paul'), (641, 'RUTTMAN', 'Troy'), (642, 'RYAN', 'Peter'), (643, 'SACHS', 'Eddie'), (644, 'SAID', 'Bob'), (645, 'SALAZAR', 'Eliseo'), (646, 'SALO', 'Mika'), (647, 'SALVADORI', 'Roy'), (648, 'SANESI', 'Consalvo'), (649, 'SARRAZIN', 'Stephane'), (650, 'SATO', 'Takuma'), (651, 'SCARBOROUGH', 'Carl'), (652, 'SCARFIOTTI', 'Ludovico'), (653, 'SCARLATTI', 'Giorgio'), (654, 'SCHECKTER', 'Ian'), (655, 'SCHECKTER', 'Jody'), (656, 'SCHELL', 'Harry'), (657, 'SCHENKEN', 'Tim'), (658, 'SCHERRER', 'Albert'), (659, 'SCHIATTARELLA', 'Domenico'), (660, 'SCHILLER', 'Heinz'), (661, 'SCHINDLER', 'Bill'), (662, 'SCHLESSER', 'Jean-Louis'), (663, 'SCHLESSER', 'Jo'), (664, 'SCHNEIDER', 'Bernd'), (665, 'SCHOELLER', 'Rudolf'), (666, 'SCHROEDER', 'Rob'), (667, 'SCHUMACHER', 'Michael'), (668, 'SCHUMACHER', 'Ralf'), (669, 'SCHUPPAN', 'Vern'), (670, 'SCHWELM CRUZ', 'Adolfo'), (671, 'SCOTT', 'Bob'), (672, 'SCOTT BROWN', 'Archie'), (673, 'SCOTTI', 'Piero'), (674, 'SEIDEL', 'Wolfgang'), (675, 'SEIFFERT', 'Guenther'), (676, 'SENNA', 'Ayrton'), (677, 'SERAFINI', 'Dorino'), (678, 'SERRA', 'Chico'), (679, 'SERRURIER', 'Doug'), (680, 'SERVOZ-GAVIN', 'Johnny'), (681, 'SETTEMBER', 'Tony'), (682, 'SHARP', 'Hap'), (683, 'SHAWE-TAYLOR', 'Brian'), (684, 'SHELBY', 'Carroll'), (685, 'SHELLY', 'Tony'), (686, 'SIFFERT', 'Jo'), (687, 'SIMON', 'Andre'), (688, 'SLOTEMAKER', 'Rob'), (689, 'SOLANA', 'Moises'), (690, 'SOLER-ROIG', 'Alex'), (691, 'SOMMER', 'Raymond'), (692, 'SOSPIRI', 'Vincenzo'), (693, 'SOUTH', 'Stephen'), (694, 'SPARKEN', 'Mike'), (695, 'SPEED', 'Scott'), (696, 'SPENCE', 'Mike'), (697, 'STACEY', 'Alan'), (698, 'STARRABBA', 'Gaetano'), (699, 'STEVENSON', 'Chuck'), (700, 'STEWART', 'Ian'), (701, 'STEWART', 'Jackie'), (702, 'STEWART', 'Jimmy'), (703, 'STOHR', 'Siegfried'), (704, 'STOMMELEN', 'Rolf'), (705, 'STREIFF', 'Philippe'), (706, 'STUCK', 'Hans'), (707, 'STUCK', 'Hans Joachim'), (708, 'STUPPACHER', 'Otto'), (709, 'SULLIVAN', 'Danny'), (710, 'SURER', 'Marc'), (711, 'SURTEES', 'John'), (712, 'SUTCLIFFE', 'Andy'), (713, 'SUTIL', 'Adrian'), (714, 'SUTTON', 'Len'), (715, 'SUZUKI', 'Aguri'), (716, 'SUZUKI', 'Toshio'), (717, 'SWATERS', 'Jacques'), (718, 'SWEIKERT', 'Bob'), (719, 'TAKAGI', 'Toranosuke'), (720, 'TAKAHARA', 'Noritake'), (721, 'TAKAHASHI', 'Kunimitsu'), (722, 'TAMBAY', 'Patrick'), (723, 'TARAMAZZO', 'Luigi'), (724, 'TARQUINI', 'Gabriele'), (725, 'TARUFFI', 'Piero'), (726, 'TAYLOR', 'Dennis'), (727, 'TAYLOR', 'Henry'), (728, 'TAYLOR', 'John'), (729, 'TAYLOR', 'Mike'), (730, 'TAYLOR', 'Trevor'), (731, 'TEAGUE', 'Marshall'), (732, 'TEMPLEMAN', 'Shorty'), (733, 'TERRA', 'Max de'), (734, 'TESTUT', 'Andre'), (735, 'THACKWELL', 'Mike'), (736, 'THIELE', 'Alfonso'), (737, 'THOMPSON', 'Eric'), (738, 'THOMSON', 'Johnny'), (739, 'THORNE', 'Leslie'), (740, 'TINGELSTAD', 'Bud'), (741, 'TINGLE', 'Sam'), (742, 'TITTERINGTON', 'Desmond'), (743, 'TOLAN', 'Johnnie'), (744, 'TRIMMER', 'Tony'), (745, 'TRINTIGNANT', 'Maurice'), (746, 'TRULLI', 'Jarno'), (747, 'TUERO', 'Esteban'), (748, 'TUNMER', 'Guy'), (749, 'TURNER', 'Jack'), (750, 'ULMEN', 'Toni'), (751, 'UNSER', 'Bobby'), (752, 'UNSER', 'Jerry'), (753, 'URIA', 'Alberto'), (754, 'VACCARELLA', 'Nino'), (755, 'VAN DE POELE', 'Eric'), (756, 'VAN DER LOF', 'Dries'), (757, 'VAN DER VYVER', 'Syd'), (758, 'VAN LENNEP', 'Gijs'), (759, 'VAN ROOYEN', 'Basil'), (760, 'VEITH', 'Bob'), (761, 'VERSTAPPEN', 'Jos'), (762, 'VETTEL', 'Sebastian'), (763, 'VILLENEUVE', 'Gilles'), (764, 'VILLENEUVE', 'Jacques'), (765, 'VILLENEUVE SR.', 'Jacques'), (766, 'VILLORESI', 'Luigi'), (767, 'VOLONTERIO', 'Ottorino'), (768, 'VON OPEL', 'Rikky'), (769, 'VON TRIPS', 'Wolfgang'), (770, 'VONLANTHEN', 'Jo'), (771, 'VUKOVICH', 'Bill'), (772, 'WACKER', 'Fred'), (773, 'WALKER', 'David'), (774, 'WALKER', 'Peter'), (775, 'WALLARD', 'Lee'), (776, 'WALTER', 'Heini'), (777, 'WARD', 'Rodger'), (778, 'WARWICK', 'Derek'), (779, 'WATSON', 'John'), (780, 'WEBB', 'Spider'), (781, 'WEBBER', 'Mark'), (782, 'WEIDLER', 'Volker'), (783, 'WEILER', 'Wayne'), (784, 'WENDLINGER', 'Karl'), (785, 'WESTBURY', 'Peter'), (786, 'WEYANT', 'Chuck'), (787, 'WHARTON', 'Ken'), (788, 'WHITEAWAY', 'Ted'), (789, 'WHITEHEAD', 'Graham'), (790, 'WHITEHEAD', 'Peter'), (791, 'WHITEHOUSE', 'Bill'), (792, 'WIDDOWS', 'Robin'), (793, 'WIETZES', 'Eppie'), (794, 'WILDS', 'Mike'), (795, 'WILLIAMS', 'Jonathan'), (796, 'WILLIAMSON', 'Roger'), (797, 'WILSON', 'Dempsey'), (798, 'WILSON', 'Desire'), (799, 'WILSON', 'Justin'), (800, 'WILSON', 'Vic'), (801, 'WINKELHOCK', 'Joachim'), (802, 'WINKELHOCK', 'Manfred'), (803, 'WINKELHOCK', 'Markus'), (804, 'WISELL', 'Reine'), (805, 'WUNDERINK', 'Roelof'), (806, 'WURZ', 'Alexander'), (807, 'YAMAMOTO', 'Sakon'), (808, 'YOONG', 'Alex'), (809, 'ZANARDI', 'Alex'), (810, 'ZAPICO', 'Emilio'), (811, 'ZONTA', 'Ricardo'), (812, 'ZORZI', 'Renzo'), (813, 'ZUNINO', 'Ricardo'); -- -------------------------------------------------------- -- -- 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=43 ; -- -- Daten für Tabelle `drivers` -- INSERT INTO `drivers` (`d_id`, `d_lname`, `d_fname`) VALUES (1, 'BUTTON', 'Jenson'), (2, 'HAMILTON', 'Lewis'), (3, 'SCHUMACHER', 'Michael'), (4, 'ROSBERG', 'Nico'), (5, 'VETTEL', 'Sebastian'), (6, 'WEBBER', 'Mark'), (7, 'MASSA', 'Felipe'), (8, 'ALONSO', 'Fernando'), (9, 'BARRICHELLO', 'Rubens'), (10, 'HUELKENBERG', 'Nico'), (11, 'KUBICA', 'Robert'), (12, 'PETROV', 'Vitaly'), (14, 'SUTIL', 'Adrian'), (15, 'LIUZZI', 'Vitantonio'), (16, 'BUEMI', 'Sebastien'), (17, 'ALGUERSUARI', 'Jaime'), (18, 'TRULLI', 'Jarno'), (19, 'KOVALAINEN', 'Heikki'), (20, 'CHANDHOK', 'Karun'), (21, 'SENNA', 'Bruno'), (22, 'DE LA ROSA', 'Pedro'), (23, 'KOBAYASHI', 'Kamui'), (24, 'GLOCK', 'Timo'), (25, 'DI GRASSI', 'Lucas'), (26, 'PAFFETT', 'Gary'), (27, 'KLIEN', 'Christian'), (28, 'HEIDFELD', 'Nick'), (29, 'HARTLEY', 'Brendon'), (30, 'RICCIARDO', 'Daniel'), (31, 'FISICHELLA', 'Giancarlo'), (32, 'BADOER', 'Luca'), (33, 'GENE', 'Marc'), (34, 'BOTTAS', 'Valtteri'), (35, 'TUNG', 'Ho-Pin'), (36, 'DI RESTA', 'Paul'), (37, 'FAUZY', 'Fairuz'), (38, 'SOUCEK', 'Andy'), (39, 'RAZIA', 'Luiz'); -- -------------------------------------------------------- -- -- 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=34 ; -- -- Daten für Tabelle `gps` -- INSERT INTO `gps` (`g_id`, `g_name`, `g_datetime_q`, `g_datetime_r`, `g_flag`, `g_circuit`) VALUES (1, 'BAHRAIN (Sakhir)', '2010-03-13 12:00:00', '2010-03-14 13:00:00', 'flag_BAHRAIN.gif', 'circuit_BAHRAIN.gif'), (2, 'AUSTRALIA (Melbourne)', '2010-03-27 07:00:00', '2010-03-28 08:00:00', 'flag_AUSTRALIA.gif', 'circuit_AUSTRALIA.gif'), (3, 'MALAYSIA (Sepang)', '2010-04-03 10:00:00', '2010-04-04 10:00:00', 'flag_MALAYSIA.gif', 'circuit_MALAYSIA.gif'), (4, 'CHINA (Shanghai)', '2010-04-17 08:00:00', '2010-04-18 09:00:00', 'flag_CHINA.gif', 'circuit_CHINA.gif'), (5, 'SPAIN (Barcelona)', '2010-05-08 14:00:00', '2010-05-09 14:00:00', 'flag_SPAIN.gif', 'circuit_SPAIN_(Barcelona).gif'), (6, 'MONACO (Monte Carlo)', '2010-05-15 14:00:00', '2010-05-16 14:00:00', 'flag_MONACO.gif', 'circuit_MONACO.gif'), (7, 'TURKEY (Istanbul)', '2010-05-29 13:00:00', '2010-05-30 14:00:00', 'flag_TURKEY.gif', 'circuit_TURKEY.gif'), (8, 'CANADA (Montreal)', '2010-06-12 19:00:00', '2010-06-13 18:00:00', 'flag_CANADA.gif', 'circuit_CANADA.gif'), (9, 'EUROPE (Valencia)', '2010-06-26 14:00:00', '2010-06-27 14:00:00', 'flag_EUROPE.gif', 'circuit_EUROPE_(Valencia).gif'), (10, 'GREAT BRITAIN (Silverstone)', '2010-07-10 14:00:00', '2010-07-11 14:00:00', 'flag_UK.gif', 'circuit_UK.gif'), (11, 'GERMANY (Hockenheim)', '2010-07-24 14:00:00', '2010-07-25 14:00:00', 'flag_GERMANY.gif', 'circuit_GERMANY_(Hockenheim).gif'), (12, 'HUNGARY (Budapest)', '2010-07-31 14:00:00', '2010-08-01 14:00:00', 'flag_HUNGARY.gif', 'circuit_HUNGARY.gif'), (13, 'BELGIUM (Spa)', '2010-08-28 14:00:00', '2010-08-29 14:00:00', 'flag_BELGIUM.gif', 'circuit_BELGIUM.gif'), (14, 'ITALY (Monza)', '2010-09-11 14:00:00', '2010-09-12 14:00:00', 'flag_ITALY.gif', 'circuit_ITALY.gif'), (15, 'SINGAPORE (Singapore)', '2010-09-25 16:00:00', '2010-09-26 14:00:00', 'flag_SINGAPORE.gif', 'circuit_SINGAPORE.gif'), (16, 'JAPAN (Suzuka)', '2010-10-09 07:00:00', '2010-10-10 08:00:00', 'flag_JAPAN.gif', 'circuit_JAPAN_(Suzuka).gif'), (17, 'SOUTH KOREA (Yeongam)', '2010-10-23 07:00:00', '2010-10-24 08:00:00', 'flag_SKOREA.gif', 'circuit_SKOREA.gif'), (18, 'BRAZIL (Sao Paulo)', '2010-11-06 17:00:00', '2010-11-07 17:00:00', 'flag_BRAZIL.gif', 'circuit_BRAZIL.gif'), (19, 'UNITED ARAB EMIRATES (Abu Dhabi)', '2010-11-13 14:00:00', '2010-11-14 14:00:00', 'flag_UAE.gif', 'circuit_UAE.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, 5, 7, 8, 0, -1), (1, 2, 8, 7, 2, 8, 0), (2, 1, 5, 6, 8, 0, -1), (2, 2, 1, 11, 7, 6, 1), (3, 1, 6, 4, 5, 0, -1), (3, 2, 5, 6, 4, 6, 0), (4, 1, 5, 6, 8, 0, -1), (4, 2, 1, 2, 4, 2, 1), (5, 1, 6, 5, 2, 0, -1), (5, 2, 6, 8, 5, 2, 0), (6, 1, 6, 11, 5, 0, -1), (6, 2, 6, 5, 11, 5, 1), (7, 1, 6, 2, 5, 0, -1), (7, 2, 2, 1, 6, 12, 0), (8, 1, 2, 6, 5, 0, -1), (8, 2, 2, 1, 8, 11, 0), (9, 1, 5, 6, 2, 0, -1), (9, 2, 5, 2, 1, 1, 1), (10, 1, 5, 6, 8, 0, -1), (10, 2, 6, 2, 4, 8, 1), (11, 1, 5, 8, 7, 0, -1), (11, 2, 8, 7, 5, 5, 0), (12, 1, 5, 6, 8, 0, -1), (12, 2, 6, 8, 5, 5, 1), (13, 1, 6, 2, 11, 0, -1), (13, 2, 2, 6, 11, 2, 1), (14, 1, 8, 1, 7, 0, -1), (14, 2, 8, 1, 7, 8, 0), (15, 1, 8, 5, 2, 0, -1), (15, 2, 8, 5, 6, 8, 1), (16, 1, 5, 6, 2, 0, -1), (16, 2, 5, 6, 8, 6, 1), (17, 1, 5, 6, 8, 0, -1), (17, 2, 8, 2, 7, 8, 1), (18, 1, 10, 5, 6, 0, -1), (18, 2, 5, 6, 8, 2, 1), (19, 1, 5, 2, 8, 0, -1), (19, 2, 5, 2, 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 (16, 1, 1, 6, 3, 1, 0, 0, '2010-03-12 09:45:29', 0), (16, 1, 2, 1, 5, 3, 6, 0, '2010-03-12 09:46:11', 1), (7, 1, 1, 4, 2, 14, 0, 0, '2010-03-12 14:24:11', 0), (7, 1, 2, 5, 8, 7, 5, -1, '2010-03-13 21:46:22', 2), (14, 1, 2, 5, 1, 2, 5, -1, '2010-03-12 14:32:27', 2), (14, 1, 1, 5, 6, 1, 0, 0, '2010-03-12 14:32:56', 2), (13, 1, 1, 8, 4, 5, 0, 0, '2010-03-12 21:21:34', 2), (4, 1, 1, 5, 4, 2, 0, 0, '2010-03-12 22:41:24', 2), (3, 1, 1, 8, 2, 7, 0, 0, '2010-03-13 10:30:30', 2), (11, 1, 1, 2, 3, 5, 0, 0, '2010-03-13 10:38:15', 1), (12, 1, 1, 8, 5, 7, 0, 0, '2010-03-13 11:20:30', 3), (10, 1, 1, 8, 2, 3, 0, 0, '2010-03-13 11:23:16', 1), (1, 1, 1, 2, 8, 4, 0, 0, '2010-03-13 11:42:36', 1), (17, 1, 2, 2, 8, 3, 9999, -1, '2010-03-13 12:44:44', 2), (3, 1, 2, 5, 8, 7, 2, -1, '2010-03-13 14:56:39', 2), (13, 1, 2, 8, 7, 5, 5, 0, '2010-03-13 16:56:08', 5), (4, 1, 2, 2, 5, 7, 2, 1, '2010-03-14 07:59:37', 1), (9, 1, 2, 7, 5, 6, 8, 0, '2010-03-14 10:42:54', 3), (18, 1, 2, 5, 7, 1, 5, -1, '2010-03-14 10:51:33', 2), (8, 1, 2, 7, 5, 3, 5, 0, '2010-03-14 10:55:37', 2), (1, 1, 2, 5, 8, 2, 8, 0, '2010-03-14 12:05:29', 5), (11, 1, 2, 5, 2, 4, 5, 0, '2010-03-14 12:06:17', 2), (12, 1, 2, 7, 5, 8, 8, -1, '2010-03-14 12:22:03', 3), (10, 1, 2, 8, 5, 7, 4, -1, '2010-03-14 12:26:59', 3), (16, 2, 1, 5, 7, 8, 0, 0, '2010-03-26 08:32:44', 4), (16, 2, 2, 8, 7, 2, 8, 0, '2010-03-26 08:33:24', 0), (13, 2, 1, 5, 7, 4, 0, 0, '2010-03-26 09:19:57', 2), (7, 2, 1, 5, 8, 7, 0, 0, '2010-03-26 16:25:26', 3), (3, 2, 1, 5, 8, 6, 0, 0, '2010-03-26 17:22:20', 4), (9, 2, 1, 5, 6, 4, 0, 0, '2010-03-26 21:59:58', 4), (18, 2, 1, 4, 3, 7, 0, 0, '2010-03-26 22:00:54', 0), (8, 2, 1, 4, 6, 8, 0, 0, '2010-03-26 22:01:31', 4), (11, 2, 1, 5, 7, 2, 0, 0, '2010-03-26 22:49:02', 2), (10, 2, 1, 6, 8, 3, 0, 0, '2010-03-27 05:55:35', 2), (12, 2, 1, 6, 8, 3, 0, 0, '2010-03-27 06:43:23', 2), (1, 2, 1, 6, 8, 5, 0, 0, '2010-03-27 06:43:59', 3), (17, 2, 2, 2, 8, 3, 2, 1, '2010-03-27 11:58:30', 1), (3, 2, 2, 5, 6, 8, 8, 1, '2010-03-27 15:06:22', 1), (13, 2, 2, 5, 6, 8, 5, -1, '2010-03-27 15:44:40', 0), (7, 2, 2, 5, 8, 6, 8, -1, '2010-03-27 16:08:18', 0), (9, 2, 2, 5, 6, 7, 8, -1, '2010-03-27 20:07:59', 2), (18, 2, 2, 5, 6, 1, 4, -1, '2010-03-27 20:12:47', 1), (8, 2, 2, 6, 5, 4, 6, 1, '2010-03-27 20:13:36', 2), (11, 2, 2, 5, 6, 1, 5, 0, '2010-03-27 21:02:13', 0), (1, 2, 2, 5, 8, 6, 5, 1, '2010-03-27 23:05:13', 1), (4, 2, 2, 5, 8, 6, 5, 1, '2010-03-28 07:21:11', 1), (10, 2, 2, 5, 6, 8, 5, 1, '2010-03-28 07:30:00', 1), (12, 2, 2, 5, 6, 8, 5, 1, '2010-03-28 07:31:11', 1), (16, 3, 1, 5, 6, 8, 0, 0, '2010-03-29 07:56:38', 2), (16, 3, 2, 1, 11, 7, 6, 0, '2010-03-29 07:57:11', 2), (7, 3, 1, 5, 2, 8, 0, 0, '2010-04-02 15:27:44', 1), (3, 3, 1, 5, 8, 2, 0, 0, '2010-04-02 16:29:25', 1), (13, 3, 1, 5, 1, 2, 0, 0, '2010-04-02 17:57:08', 1), (4, 3, 1, 5, 2, 4, 0, 0, '2010-04-03 07:32:40', 2), (10, 3, 1, 6, 5, 2, 0, 0, '2010-04-03 09:24:28', 3), (12, 3, 1, 5, 8, 6, 0, 0, '2010-04-03 09:25:29', 2), (1, 3, 1, 5, 2, 8, 0, 0, '2010-04-03 09:39:44', 1), (11, 3, 1, 2, 6, 5, 0, 0, '2010-04-03 09:47:22', 3), (9, 3, 1, 2, 6, 5, 0, 0, '2010-04-03 09:50:34', 3), (18, 3, 1, 5, 2, 4, 0, 0, '2010-04-03 09:51:25', 2), (8, 3, 1, 5, 2, 6, 0, 0, '2010-04-03 09:52:21', 2), (17, 3, 2, 2, 8, 3, 1, 1, '2010-04-03 10:23:17', -1), (3, 3, 2, 5, 6, 4, 5, 1, '2010-04-03 15:22:47', 5), (7, 3, 2, 5, 6, 11, 8, 1, '2010-04-03 18:28:05', 3), (9, 3, 2, 6, 5, 11, 2, 1, '2010-04-03 20:21:10', 1), (8, 3, 2, 6, 5, 8, 6, 1, '2010-04-03 20:22:17', 2), (18, 3, 2, 5, 6, 1, 4, 1, '2010-04-03 20:23:38', 3), (13, 3, 2, 6, 5, 4, 5, 1, '2010-04-03 20:53:12', 3), (4, 3, 2, 4, 5, 9, 4, 1, '2010-04-04 08:24:02', 1), (1, 3, 2, 5, 6, 4, 2, 1, '2010-04-04 09:13:17', 5), (11, 3, 2, 5, 6, 4, 6, 1, '2010-04-04 09:16:06', 6), (12, 3, 2, 6, 5, 4, 6, -1, '2010-04-04 09:38:34', 5), (10, 3, 2, 6, 4, 11, 6, 1, '2010-04-04 09:44:32', 2), (16, 4, 1, 6, 4, 5, 0, 0, '2010-04-09 16:07:52', 2), (16, 4, 2, 5, 6, 4, 6, 1, '2010-04-09 16:09:07', 3), (7, 4, 1, 1, 5, 2, 0, 0, '2010-04-16 15:09:01', 1), (3, 4, 1, 5, 2, 6, 0, 0, '2010-04-16 16:15:31', 3), (8, 4, 1, 1, 2, 4, 0, 0, '2010-04-16 19:00:19', 0), (18, 4, 1, 2, 4, 1, 0, 0, '2010-04-16 19:01:31', 0), (9, 4, 1, 2, 1, 5, 0, 0, '2010-04-16 19:02:36', 1), (13, 4, 1, 2, 1, 4, 0, 0, '2010-04-16 20:31:22', 0), (11, 4, 1, 1, 5, 2, 0, 0, '2010-04-16 21:14:15', 1), (10, 4, 1, 6, 5, 2, 0, 0, '2010-04-17 06:41:04', 2), (12, 4, 1, 6, 5, 2, 0, 0, '2010-04-17 06:41:35', 2), (1, 4, 1, 2, 5, 6, 0, 0, '2010-04-17 07:44:32', 2), (7, 4, 2, 5, 8, 1, 5, 0, '2010-04-17 12:37:15', 0), (3, 4, 2, 5, 8, 6, 6, -1, '2010-04-17 17:55:42', 0), (13, 4, 2, 5, 6, 8, 5, -1, '2010-04-17 20:10:53', 0), (8, 4, 2, 5, 6, 1, 6, -1, '2010-04-17 21:00:19', 1), (9, 4, 2, 5, 6, 1, 2, 1, '2010-04-17 21:01:18', 3), (18, 4, 2, 6, 5, 2, 5, 0, '2010-04-17 21:02:25', 0), (1, 4, 2, 5, 6, 2, 6, 1, '2010-04-17 23:34:32', 2), (11, 4, 2, 5, 6, 2, 5, 1, '2010-04-17 23:35:18', 2), (4, 4, 2, 5, 8, 6, 5, 1, '2010-04-18 07:55:13', 1), (12, 4, 2, 6, 8, 5, 6, -1, '2010-04-18 08:39:29', 0), (10, 4, 2, 5, 6, 8, 6, -1, '2010-04-18 08:40:53', 0), (16, 5, 1, 5, 6, 8, 0, 0, '2010-04-19 10:23:43', 2), (16, 5, 2, 1, 2, 4, 2, 0, '2010-04-19 10:24:28', 2), (7, 5, 1, 5, 6, 8, 0, 0, '2010-05-07 14:53:20', 2), (7, 5, 2, 5, 2, 6, 5, 1, '2010-05-07 12:59:36', 1), (14, 5, 1, 2, 5, 6, 0, 0, '2010-05-07 15:57:10', 4), (14, 5, 2, 5, 1, 2, 5, 0, '2010-05-07 15:58:36', 2), (13, 5, 1, 5, 6, 8, 0, 0, '2010-05-07 20:40:17', 2), (3, 5, 1, 5, 6, 8, 0, 0, '2010-05-08 09:13:43', 2), (4, 5, 1, 5, 1, 8, 0, 0, '2010-05-08 09:28:11', 1), (1, 5, 1, 5, 6, 2, 0, 0, '2010-05-08 12:21:12', 4), (11, 5, 1, 5, 6, 2, 0, 0, '2010-05-08 12:22:44', 4), (9, 5, 1, 5, 6, 1, 0, 0, '2010-05-08 12:50:25', 2), (18, 5, 1, 5, 6, 3, 0, 0, '2010-05-08 12:57:43', 2), (8, 5, 1, 6, 5, 1, 0, 0, '2010-05-08 12:58:51', 4), (12, 5, 1, 5, 6, 8, 0, 0, '2010-05-08 13:06:39', 2), (10, 5, 1, 5, 6, 3, 0, 0, '2010-05-08 13:07:56', 2), (11, 5, 2, 6, 5, 2, 6, -1, '2010-05-08 15:57:26', 3), (13, 5, 2, 5, 6, 1, 5, 0, '2010-05-09 08:29:55', 3), (3, 5, 2, 5, 6, 8, 5, 0, '2010-05-09 10:09:44', 4), (18, 5, 2, 5, 2, 1, 6, -1, '2010-05-09 11:14:07', 1), (9, 5, 2, 6, 5, 1, 5, 0, '2010-05-09 11:15:20', 4), (8, 5, 2, 5, 6, 8, 5, 0, '2010-05-09 11:27:40', 4), (4, 5, 2, 5, 6, 8, 5, 0, '2010-05-09 12:49:27', 4), (1, 5, 2, 5, 6, 2, 6, 0, '2010-05-09 13:19:46', 3), (10, 5, 2, 6, 5, 1, 6, -1, '2010-05-09 13:26:35', 3), (12, 5, 2, 6, 8, 5, 6, -1, '2010-05-09 13:43:35', 6), (2, 5, 2, 6, 5, 8, 5, 0, '2010-05-09 13:59:17', 5), (16, 6, 1, 6, 5, 2, 0, 0, '2010-05-12 16:39:02', 3), (16, 6, 2, 6, 8, 5, 2, 1, '2010-05-12 16:40:29', 4), (11, 6, 1, 8, 5, 6, 0, 0, '2010-05-13 19:05:42', 2), (11, 6, 2, 6, 5, 2, 6, 1, '2010-05-15 17:29:30', 5), (14, 6, 1, 8, 5, 6, 0, 0, '2010-05-14 09:15:32', 2), (14, 6, 2, 8, 6, 5, 8, 0, '2010-05-14 09:21:23', 1), (7, 6, 1, 11, 6, 7, 0, 0, '2010-05-15 13:42:43', 2), (7, 6, 2, 6, 5, 11, 6, -1, '2010-05-15 15:11:29', 6), (13, 6, 1, 5, 3, 8, 0, 0, '2010-05-14 10:23:31', 1), (3, 6, 1, 8, 5, 4, 0, 0, '2010-05-15 12:07:06', 1), (1, 6, 1, 8, 5, 11, 0, 0, '2010-05-15 13:34:32', 2), (12, 6, 1, 6, 5, 2, 0, 0, '2010-05-15 13:40:04', 3), (10, 6, 1, 6, 5, 3, 0, 0, '2010-05-15 13:41:15', 3), (2, 6, 1, 6, 11, 5, 0, 0, '2010-05-15 13:49:07', 6), (13, 6, 2, 6, 7, 2, 6, 1, '2010-05-15 17:36:30', 3), (3, 6, 2, 6, 5, 7, 6, 1, '2010-05-15 17:58:57', 5), (1, 6, 2, 6, 5, 11, 11, 1, '2010-05-15 19:31:23', 7), (9, 6, 2, 6, 5, 11, 6, 1, '2010-05-16 10:59:43', 7), (8, 6, 2, 6, 5, 2, 6, 1, '2010-05-16 11:04:22', 5), (18, 6, 2, 11, 6, 5, 6, 0, '2010-05-16 11:05:35', 2), (10, 6, 2, 6, 5, 2, 6, 1, '2010-05-16 13:35:53', 5), (12, 6, 2, 6, 11, 7, 4, -1, '2010-05-16 13:37:20', 3), (2, 6, 2, 6, 11, 2, 0, -1, '2010-05-16 13:57:23', 3), (16, 7, 1, 6, 11, 5, 0, 0, '2010-05-16 16:56:56', 4), (16, 7, 2, 6, 5, 11, 5, 0, '2010-05-16 16:58:05', 2), (13, 7, 1, 5, 6, 2, 0, 0, '2010-05-28 09:18:26', 3), (14, 7, 1, 5, 7, 6, 0, 0, '2010-05-28 10:38:40', 2), (14, 7, 2, 6, 5, 8, 6, 0, '2010-05-28 10:39:14', 2), (7, 7, 1, 6, 5, 2, 0, 0, '2010-05-28 16:57:17', 4), (11, 7, 1, 5, 6, 8, 0, 0, '2010-05-29 11:14:05', 2), (3, 7, 1, 5, 2, 6, 0, 0, '2010-05-29 11:25:27', 4), (9, 7, 1, 5, 6, 2, 0, 0, '2010-05-29 11:51:28', 3), (8, 7, 1, 5, 6, 1, 0, 0, '2010-05-29 12:01:44', 2), (1, 7, 1, 5, 2, 6, 0, 0, '2010-05-29 12:31:47', 4), (18, 7, 1, 6, 2, 5, 0, 0, '2010-05-29 12:40:10', 6), (3, 7, 2, 6, 5, 2, 5, 0, '2010-05-29 15:43:50', 3), (1, 7, 2, 6, 5, 2, 5, 0, '2010-05-29 22:30:04', 3), (11, 7, 2, 6, 5, 2, 2, -1, '2010-05-29 22:31:14', 2), (13, 7, 2, 5, 6, 2, 5, 0, '2010-05-30 11:28:08', 3), (7, 7, 2, 6, 2, 5, 6, -1, '2010-05-30 11:44:10', 2), (8, 7, 2, 6, 1, 2, 6, 1, '2010-05-30 11:47:05', 3), (9, 7, 2, 6, 2, 1, 6, -1, '2010-05-30 11:53:05', 3), (18, 7, 2, 6, 5, 3, 6, 0, '2010-05-30 11:55:04', 2), (10, 7, 2, 6, 2, 5, 6, 0, '2010-05-30 12:57:14', 3), (4, 7, 2, 2, 6, 5, 2, 1, '2010-05-30 13:18:34', 2), (12, 7, 2, 6, 5, 1, 6, -1, '2010-05-30 13:27:06', 2), (16, 8, 1, 6, 2, 5, 0, 0, '2010-05-31 13:14:37', 4), (16, 8, 2, 2, 1, 6, 5, 1, '2010-05-31 13:15:54', 3), (7, 8, 1, 1, 6, 5, 0, 0, '2010-06-11 19:29:55', 4), (1, 8, 1, 5, 2, 6, 0, 0, '2010-06-11 22:00:34', 3), (14, 8, 2, 5, 6, 2, 5, 0, '2010-06-11 23:33:03', 2), (14, 8, 1, 5, 8, 6, 0, 0, '2010-06-11 23:33:47', 2), (3, 8, 1, 5, 6, 2, 0, 0, '2010-06-12 12:16:05', 4), (11, 8, 1, 5, 2, 6, 0, 0, '2010-06-12 13:38:09', 3), (13, 8, 1, 8, 5, 6, 0, 0, '2010-06-12 14:44:47', 2), (9, 8, 1, 6, 2, 3, 0, 0, '2010-06-12 18:11:11', 2), (18, 8, 1, 2, 1, 6, 0, 0, '2010-06-12 18:12:04', 3), (8, 8, 1, 2, 8, 6, 0, 0, '2010-06-12 18:13:11', 3), (10, 8, 1, 6, 2, 3, 0, 0, '2010-06-12 18:16:52', 2), (12, 8, 1, 6, 2, 5, 0, 0, '2010-06-12 18:20:54', 4), (2, 8, 1, 2, 6, 5, 0, 0, '2010-06-12 18:57:32', 6), (11, 8, 2, 5, 2, 8, 2, 1, '2010-06-13 17:58:55', 2), (1, 8, 2, 5, 8, 2, 2, 1, '2010-06-13 17:59:16', 1), (3, 8, 2, 2, 6, 5, 2, 1, '2010-06-13 10:45:10', 1), (7, 8, 2, 2, 6, 5, 2, 0, '2010-06-13 11:50:37', 3), (13, 8, 2, 6, 5, 8, 6, 1, '2010-06-13 12:16:15', 1), (18, 8, 2, 6, 2, 1, 6, -1, '2010-06-13 17:16:44', 2), (9, 8, 2, 6, 2, 5, 6, 1, '2010-06-13 17:18:00', 0), (8, 8, 2, 2, 8, 6, 2, 1, '2010-06-13 17:20:48', 2), (10, 8, 2, 6, 5, 2, 6, 0, '2010-06-13 17:46:54', 2), (12, 8, 2, 6, 5, 2, 6, -1, '2010-06-13 17:48:36', 1), (2, 8, 2, 2, 5, 8, 2, 1, '2010-06-13 17:52:28', 3), (16, 9, 1, 2, 6, 5, 0, 0, '2010-06-14 09:16:24', 4), (16, 9, 2, 2, 1, 8, 11, 0, '2010-06-14 09:17:20', 1), (13, 9, 1, 2, 5, 8, 0, 0, '2010-06-25 12:51:17', 2), (13, 9, 2, 2, 1, 8, 2, 0, '2010-06-25 12:52:07', 1), (7, 9, 1, 2, 6, 8, 0, 0, '2010-06-25 17:03:07', 3), (7, 9, 2, 5, 2, 8, 5, -1, '2010-06-26 15:15:07', 4), (10, 9, 1, 6, 5, 8, 0, 0, '2010-06-26 08:40:53', 2), (11, 9, 1, 8, 2, 5, 0, 0, '2010-06-26 08:42:33', 2), (1, 9, 1, 5, 6, 8, 0, 0, '2010-06-26 12:40:54', 4), (18, 9, 1, 6, 11, 5, 0, 0, '2010-06-26 12:51:29', 2), (9, 9, 1, 5, 6, 8, 0, 0, '2010-06-26 12:54:13', 4), (8, 9, 1, 5, 6, 8, 0, 0, '2010-06-26 13:03:39', 4), (3, 9, 1, 5, 6, 8, 0, 0, '2010-06-26 13:21:31', 4), (2, 9, 1, 5, 11, 8, 0, 0, '2010-06-26 13:48:34', 2), (3, 9, 2, 5, 2, 6, 2, 1, '2010-06-26 16:23:13', 5), (14, 9, 2, 5, 6, 2, 6, 0, '2010-06-26 19:49:14', 2), (9, 9, 2, 6, 5, 8, 8, -1, '2010-06-27 11:37:27', 1), (18, 9, 2, 6, 2, 8, 6, 1, '2010-06-27 11:40:00', 3), (11, 9, 2, 5, 6, 2, 6, 0, '2010-06-27 11:58:52', 2), (1, 9, 2, 5, 6, 2, 2, 0, '2010-06-27 12:52:37', 2), (8, 9, 2, 6, 2, 5, 6, 0, '2010-06-27 13:19:48', 2), (2, 9, 2, 5, 2, 6, 5, 1, '2010-06-27 13:55:17', 5), (10, 9, 2, 6, 2, 8, 6, 0, '2010-06-27 12:43:46', 1), (12, 9, 2, 5, 6, 8, 8, -1, '2010-06-27 12:43:47', 2), (16, 10, 1, 5, 6, 2, 0, 0, '2010-06-28 11:14:50', 4), (16, 10, 2, 5, 2, 1, 1, 0, '2010-06-28 11:15:32', 1), (13, 10, 1, 5, 6, 2, 0, 0, '2010-07-09 09:31:50', 4), (10, 10, 1, 6, 5, 8, 0, 0, '2010-07-10 09:27:22', 4), (12, 10, 1, 6, 5, 8, 0, 0, '2010-07-10 09:30:30', 4), (7, 10, 1, 5, 2, 6, 0, 0, '2010-07-10 10:15:35', 3), (3, 10, 1, 5, 6, 7, 0, 0, '2010-07-10 12:59:53', 4), (18, 10, 1, 6, 5, 2, 0, 0, '2010-07-10 13:04:22', 2), (9, 10, 1, 5, 6, 8, 0, 0, '2010-07-10 13:06:00', 6), (8, 10, 1, 6, 5, 8, 0, 0, '2010-07-10 13:08:16', 4), (1, 10, 1, 5, 2, 6, 0, 0, '2010-07-10 13:31:57', 3), (11, 10, 1, 5, 8, 6, 0, 0, '2010-07-10 13:34:06', 4), (2, 10, 1, 5, 6, 8, 0, 0, '2010-07-10 13:45:42', 6), (7, 10, 2, 5, 2, 6, 5, -1, '2010-07-10 16:44:48', 3), (4, 10, 2, 6, 5, 2, 2, 1, '2010-07-11 10:11:40', 4), (3, 10, 2, 5, 6, 8, 1, 0, '2010-07-11 10:20:00', 0), (13, 10, 2, 5, 6, 8, 5, -1, '2010-07-11 10:23:00', 1), (8, 10, 2, 5, 6, 7, 5, 0, '2010-07-11 11:29:23', 0), (9, 10, 2, 5, 6, 2, 2, -1, '2010-07-11 11:30:54', 2), (18, 10, 2, 6, 5, 2, 6, 1, '2010-07-11 11:32:36', 4), (1, 10, 2, 5, 6, 2, 6, 0, '2010-07-11 11:50:36', 1), (11, 10, 2, 5, 6, 2, 2, 1, '2010-07-11 11:52:26', 3), (10, 10, 2, 5, 6, 8, 6, -1, '2010-07-11 13:38:00', 1), (12, 10, 2, 5, 6, 8, 6, -1, '2010-07-11 13:40:09', 1), (2, 10, 2, 5, 6, 8, 5, 0, '2010-07-11 13:55:25', 0), (16, 11, 1, 5, 6, 8, 0, 0, '2010-07-13 14:11:22', 3), (16, 11, 2, 6, 2, 4, 8, 1, '2010-07-13 14:12:22', -1), (13, 11, 1, 5, 6, 2, 0, 0, '2010-07-16 10:06:01', 2), (13, 11, 2, 2, 1, 8, 8, -1, '2010-07-16 10:06:54', 1), (13, 12, 1, 5, 6, 2, 0, 0, '2010-07-16 10:07:59', 4), (13, 12, 2, 2, 1, 8, 8, -1, '2010-07-16 10:08:39', 1), (10, 11, 1, 5, 6, 8, 0, 0, '2010-07-24 10:50:27', 3), (12, 11, 1, 6, 5, 8, 0, 0, '2010-07-24 10:52:17', 2), (3, 11, 1, 6, 5, 7, 0, 0, '2010-07-24 12:20:16', 3), (8, 11, 1, 5, 8, 6, 0, 0, '2010-07-24 12:42:07', 4), (9, 11, 1, 5, 6, 8, 0, 0, '2010-07-24 12:52:13', 3), (18, 11, 1, 5, 6, 8, 0, 0, '2010-07-24 12:53:37', 3), (11, 11, 1, 5, 8, 6, 0, 0, '2010-07-24 13:00:28', 4), (1, 11, 1, 5, 6, 2, 0, 0, '2010-07-24 13:31:59', 2), (2, 11, 1, 5, 8, 6, 0, 0, '2010-07-24 13:52:28', 4), (7, 11, 2, 5, 8, 6, 8, -1, '2010-07-24 20:09:17', 2), (9, 11, 2, 5, 7, 6, 8, 1, '2010-07-25 10:29:55', 2), (18, 11, 2, 5, 7, 8, 6, -1, '2010-07-25 10:31:50', 4), (8, 11, 2, 8, 7, 6, 5, 1, '2010-07-25 10:34:33', 4), (3, 11, 2, 5, 8, 6, 8, 1, '2010-07-25 12:20:21', 1), (11, 11, 2, 5, 8, 6, 8, -1, '2010-07-25 13:29:20', 2), (1, 11, 2, 5, 8, 6, 8, 0, '2010-07-25 13:36:11', 3), (4, 11, 2, 8, 5, 7, 5, 1, '2010-07-25 13:37:55', 4), (10, 11, 2, 6, 2, 8, 6, 1, '2010-07-25 13:41:40', 0), (12, 11, 2, 8, 6, 7, 5, 1, '2010-07-25 13:48:12', 3), (2, 11, 2, 8, 5, 6, 8, 0, '2010-07-25 13:55:09', 4), (16, 12, 1, 5, 8, 7, 0, 0, '2010-07-26 15:57:11', 3), (16, 12, 2, 8, 7, 5, 5, 1, '2010-07-26 15:58:04', 5), (7, 12, 1, 5, 6, 2, 0, 0, '2010-07-30 12:17:11', 4), (7, 12, 2, 5, 2, 8, 5, 0, '2010-07-30 12:18:09', 2), (11, 12, 1, 5, 6, 8, 0, 0, '2010-07-31 09:08:27', 6), (1, 12, 1, 5, 8, 6, 0, 0, '2010-07-31 09:25:21', 4), (3, 12, 1, 5, 6, 8, 0, 0, '2010-07-31 12:04:24', 6), (18, 12, 1, 6, 8, 5, 0, 0, '2010-07-31 12:58:08', 3), (9, 12, 1, 6, 5, 8, 0, 0, '2010-07-31 12:59:33', 4), (8, 12, 1, 6, 5, 8, 0, 0, '2010-07-31 13:02:31', 4), (10, 12, 1, 6, 5, 8, 0, 0, '2010-07-31 13:16:41', 4), (12, 12, 1, 6, 5, 8, 0, 0, '2010-07-31 13:31:30', 4), (2, 12, 1, 6, 5, 8, 0, 0, '2010-07-31 13:59:03', 4), (11, 12, 2, 5, 6, 8, 6, 0, '2010-08-01 09:45:20', 2), (1, 12, 2, 5, 6, 8, 6, 0, '2010-08-01 09:55:34', 2), (9, 12, 2, 5, 6, 7, 5, -1, '2010-08-01 11:59:47', 3), (18, 12, 2, 6, 5, 7, 6, -1, '2010-08-01 12:02:39', 3), (8, 12, 2, 6, 7, 8, 5, -1, '2010-08-01 13:00:30', 4), (2, 12, 2, 5, 6, 8, 5, 0, '2010-08-01 13:27:53', 3), (12, 12, 2, 5, 6, 8, 5, -1, '2010-08-01 13:45:34', 4), (10, 12, 2, 5, 6, 8, 5, -1, '2010-08-01 13:47:11', 4), (16, 13, 1, 5, 6, 8, 0, 0, '2010-08-02 11:57:57', 1), (16, 13, 2, 6, 8, 5, 5, 0, '2010-08-02 11:58:49', 0), (13, 13, 1, 5, 6, 8, 0, 0, '2010-08-28 09:59:53', 1), (8, 13, 1, 2, 5, 8, 0, 0, '2010-08-28 12:13:39', 1), (9, 13, 1, 6, 2, 8, 0, 0, '2010-08-28 12:19:21', 4), (18, 13, 1, 6, 8, 5, 0, 0, '2010-08-28 12:20:06', 2), (7, 13, 1, 8, 5, 14, 0, 0, '2010-08-28 12:40:38', 0), (1, 13, 1, 8, 2, 5, 0, 0, '2010-08-28 12:48:11', 2), (11, 13, 1, 8, 2, 6, 0, 0, '2010-08-28 12:48:56', 3), (3, 13, 1, 6, 2, 1, 0, 0, '2010-08-28 13:27:51', 4), (2, 13, 1, 8, 2, 6, 0, 0, '2010-08-28 13:53:57', 3), (3, 13, 2, 6, 2, 5, 2, 0, '2010-08-28 18:19:59', 2), (7, 13, 2, 6, 2, 5, 6, -1, '2010-08-28 20:06:13', 2), (11, 13, 2, 6, 2, 5, 5, 1, '2010-08-29 09:05:46', 3), (13, 13, 2, 2, 11, 6, 2, 1, '2010-08-29 09:34:50', 6), (9, 13, 2, 6, 5, 2, 5, 1, '2010-08-29 11:56:37', 3), (18, 13, 2, 6, 5, 2, 5, 1, '2010-08-29 11:58:25', 3), (8, 13, 2, 6, 5, 8, 5, 1, '2010-08-29 13:17:59', 2), (1, 13, 2, 2, 6, 1, 5, 1, '2010-08-29 13:33:07', 5), (2, 13, 2, 2, 6, 5, 8, 0, '2010-08-29 13:45:50', 3), (16, 14, 1, 6, 2, 11, 0, 0, '2010-08-29 23:47:48', 0), (16, 14, 2, 2, 6, 11, 2, 1, '2010-08-29 23:48:28', -1), (2, 14, 1, 8, 5, 7, 0, 0, '2010-09-11 09:21:46', 4), (7, 14, 1, 2, 5, 1, 0, 0, '2010-09-11 11:47:33', 1), (7, 14, 2, 2, 5, 6, 6, -1, '2010-09-11 11:48:12', 0), (13, 14, 1, 6, 8, 5, 0, 0, '2010-09-11 11:49:40', 1), (9, 14, 1, 5, 2, 8, 0, 0, '2010-09-11 12:30:12', 1), (18, 14, 1, 5, 2, 7, 0, 0, '2010-09-11 12:31:06', 2), (8, 14, 1, 2, 8, 1, 0, 0, '2010-09-11 12:32:24', 2), (3, 14, 1, 2, 8, 7, 0, 0, '2010-09-11 13:25:01', 3), (11, 14, 1, 2, 5, 6, 0, 0, '2010-09-11 13:30:07', 0), (1, 14, 1, 2, 5, 8, 0, 0, '2010-09-11 13:35:19', 1), (9, 14, 2, 8, 7, 6, 7, -1, '2010-09-12 10:03:32', 3), (18, 14, 2, 1, 8, 6, 2, -1, '2010-09-12 10:05:16', 2), (13, 14, 2, 8, 7, 2, 8, -1, '2010-09-12 10:14:23', 4), (8, 14, 2, 8, 7, 1, 8, -1, '2010-09-12 10:31:02', 5), (1, 14, 2, 8, 1, 2, 2, 1, '2010-09-12 10:54:19', 3), (11, 14, 2, 8, 1, 6, 8, -1, '2010-09-12 10:58:10', 5), (3, 14, 2, 8, 1, 2, 2, 0, '2010-09-12 12:31:13', 5), (16, 15, 1, 8, 1, 7, 0, 0, '2010-09-12 19:19:19', 2), (16, 15, 2, 8, 1, 7, 8, 1, '2010-09-12 19:21:22', 4), (19, 15, 2, 8, 6, 1, 5, 1, '2010-09-24 16:58:50', 4), (19, 15, 1, 5, 8, 6, 0, 0, '2010-09-24 16:59:11', 2), (13, 15, 1, 5, 6, 2, 0, 0, '2010-09-25 09:50:02', 3), (11, 15, 1, 5, 6, 2, 0, 0, '2010-09-25 11:15:01', 3), (9, 15, 1, 5, 6, 1, 0, 0, '2010-09-25 11:26:16', 1), (18, 15, 1, 6, 1, 5, 0, 0, '2010-09-25 11:26:43', 1), (8, 15, 1, 6, 5, 8, 0, 0, '2010-09-25 11:27:17', 3), (7, 15, 1, 5, 6, 1, 0, 0, '2010-09-25 12:17:22', 1), (7, 15, 2, 8, 2, 5, 8, 1, '2010-09-26 13:30:56', 5), (2, 15, 1, 5, 8, 2, 0, 0, '2010-09-25 14:35:30', 4), (3, 15, 1, 5, 6, 8, 0, 0, '2010-09-25 14:44:21', 2), (1, 15, 1, 5, 6, 8, 0, 0, '2010-09-25 15:12:02', 2), (13, 15, 2, 5, 6, 8, 5, 1, '2010-09-25 20:08:19', 4), (9, 15, 2, 5, 8, 1, 5, 1, '2010-09-26 11:48:56', 3), (18, 15, 2, 5, 2, 1, 2, 1, '2010-09-26 11:50:09', 2), (8, 15, 2, 5, 2, 1, 8, 1, '2010-09-26 11:51:38', 3), (3, 15, 2, 8, 5, 2, 5, 1, '2010-09-26 12:38:35', 5), (1, 15, 2, 8, 2, 5, 8, 1, '2010-09-26 12:55:14', 5), (11, 15, 2, 5, 8, 2, 8, 1, '2010-09-26 12:57:13', 4), (2, 15, 2, 8, 2, 5, 8, 1, '2010-09-26 13:59:47', 5), (16, 16, 1, 8, 5, 2, 0, 0, '2010-09-27 10:38:42', 3), (16, 16, 2, 8, 5, 6, 8, 0, '2010-09-27 10:39:12', 2), (19, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 11:51:17', 4), (19, 16, 2, 5, 8, 6, 9999, -1, '2010-10-08 11:51:35', 4), (13, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 17:58:08', 4), (3, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 18:13:12', 4), (7, 16, 1, 5, 8, 6, 0, 0, '2010-10-08 18:51:06', 3), (7, 16, 2, 5, 8, 6, 5, -1, '2010-10-08 18:51:53', 4), (11, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 21:16:31', 4), (2, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 21:17:48', 4), (8, 16, 1, 5, 6, 8, 0, 0, '2010-10-08 22:24:27', 4), (9, 16, 1, 6, 5, 8, 0, 0, '2010-10-08 22:25:44', 2), (18, 16, 1, 6, 11, 8, 0, 0, '2010-10-08 22:28:02', 1), (1, 16, 1, 5, 6, 8, 0, 0, '2010-10-09 01:03:51', 4), (3, 16, 2, 5, 6, 8, 5, 1, '2010-10-09 13:28:59', 7), (13, 16, 2, 5, 6, 8, 5, 1, '2010-10-09 13:36:09', 7), (1, 16, 2, 5, 6, 8, 5, 0, '2010-10-10 04:24:10', 5), (8, 16, 2, 5, 6, 11, 5, 1, '2010-10-10 04:36:04', 5), (11, 16, 2, 6, 5, 8, 6, 1, '2010-10-10 07:46:59', 6), (16, 17, 1, 5, 6, 2, 0, 0, '2010-10-10 10:53:52', 4), (16, 17, 2, 5, 6, 8, 6, 1, '2010-10-10 10:54:27', 2), (11, 17, 1, 6, 2, 8, 0, 0, '2010-10-22 21:53:16', 3), (13, 17, 1, 5, 6, 2, 0, 0, '2010-10-22 22:05:29', 4), (3, 17, 1, 5, 6, 2, 0, 0, '2010-10-22 22:23:36', 4), (18, 17, 1, 8, 2, 6, 0, 0, '2010-10-22 23:17:46', 2), (7, 17, 1, 5, 6, 2, 0, 0, '2010-10-23 00:18:28', 4), (1, 17, 1, 2, 8, 6, 0, 0, '2010-10-23 06:21:51', 2), (19, 17, 2, 8, 2, 5, 8, 0, '2010-10-23 07:22:27', 4), (7, 17, 2, 5, 6, 8, 6, 1, '2010-10-23 10:43:30', 2), (3, 17, 2, 5, 8, 6, 5, 1, '2010-10-23 18:34:15', 2), (13, 17, 2, 6, 2, 1, 6, 1, '2010-10-23 19:25:39', 3), (11, 17, 2, 5, 8, 6, 8, 1, '2010-10-23 21:30:50', 3), (18, 17, 2, 6, 5, 2, 6, 1, '2010-10-23 23:12:33', 2), (8, 17, 2, 6, 8, 5, 5, 1, '2010-10-23 23:35:15', 2), (1, 17, 2, 5, 8, 6, 8, 1, '2010-10-24 00:28:49', 3), (2, 17, 2, 5, 8, 6, 8, 1, '2010-10-24 07:36:33', 3), (16, 18, 1, 5, 6, 8, 0, 0, '2010-10-24 19:38:18', 2), (16, 18, 2, 8, 2, 7, 8, 1, '2010-10-24 19:38:59', 2), (7, 18, 1, 5, 6, 8, 0, 0, '2010-11-05 21:02:06', 2), (11, 18, 1, 5, 6, 8, 0, 0, '2010-11-06 12:08:00', 2), (13, 18, 1, 5, 6, 2, 0, 0, '2010-11-06 13:36:46', 2), (8, 18, 1, 5, 6, 8, 0, 0, '2010-11-06 15:53:15', 2), (1, 18, 1, 5, 6, 8, 0, 0, '2010-11-06 15:54:02', 2), (3, 18, 1, 5, 6, 2, 0, 0, '2010-11-06 16:39:56', 2), (19, 18, 2, 5, 8, 6, 7, 0, '2010-11-06 17:03:33', 3), (19, 18, 1, 8, 5, 6, 0, 0, '2010-11-06 16:52:00', 4), (13, 18, 2, 6, 5, 8, 5, 0, '2010-11-06 23:35:28', 3), (7, 18, 2, 6, 2, 8, 6, -1, '2010-11-07 00:39:42', 3), (3, 18, 2, 5, 6, 8, 5, 1, '2010-11-07 10:35:11', 7), (8, 18, 2, 6, 8, 2, 10, -1, '2010-11-07 14:03:44', 2), (1, 18, 2, 5, 6, 8, 8, 0, '2010-11-07 16:21:01', 5), (11, 18, 2, 5, 6, 2, 5, 1, '2010-11-07 16:39:33', 5), (16, 19, 1, 10, 5, 6, 0, 0, '2010-11-07 22:32:09', 1), (16, 19, 2, 5, 6, 8, 2, 1, '2010-11-07 22:32:43', 4), (7, 19, 1, 5, 8, 2, 0, 0, '2010-11-12 18:22:19', 4), (11, 19, 1, 5, 6, 2, 0, 0, '2010-11-12 21:49:17', 3), (13, 19, 1, 5, 2, 6, 0, 0, '2010-11-13 10:02:17', 4), (3, 19, 1, 5, 6, 2, 0, 0, '2010-11-13 12:50:31', 3), (8, 19, 1, 5, 8, 6, 0, 0, '2010-11-13 13:17:10', 3), (1, 19, 1, 5, 6, 2, 0, 0, '2010-11-13 13:32:11', 3), (2, 19, 1, 6, 5, 8, 0, 0, '2010-11-13 13:50:36', 3), (19, 19, 2, 5, 8, 2, 8, 0, '2010-11-13 18:03:50', 2), (7, 19, 2, 5, 2, 8, 5, -1, '2010-11-13 20:09:29', 4), (3, 19, 2, 5, 2, 8, 5, 0, '2010-11-14 11:23:08', 3), (8, 19, 2, 5, 2, 8, 5, 1, '2010-11-14 11:56:39', 5), (13, 19, 2, 5, 2, 8, 5, 1, '2010-11-14 12:22:24', 5), (1, 19, 2, 5, 2, 8, 2, 0, '2010-11-14 12:54:45', 4), (11, 19, 2, 5, 2, 6, 5, 0, '2010-11-14 12:58:12', 3), (2, 19, 2, 2, 5, 8, 5, 0, '2010-11-14 13:26:55', 1); -- -------------------------------------------------------- -- -- 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', `u_gtwins` int(3) NOT NULL default '0', PRIMARY KEY (`u_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ; -- -- 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`, `u_gtwins`) VALUES (1, 'MAM', 0x3138643032323130333932306531323062326661616266346265363861613866, 'pic_MAM.gif', 'Markus A. Mascelli', 'MAM', 'mam@heimam.at', 0, 'italian', 602, 2006, 1), (2, 'GUE', 0x3738393138636563663839323664306361646134633562633331616638376133, 'pic_GUE.gif', 'Guenther Schmidt', 'GueStar', 'guenther.schmidt@gmail.com', 0, 'austrian', 15, 2006, 2), (3, 'ZEI', 0x3864616437636162636539633531316264343938336538646339366561356461, 'pic_ZEI.gif', 'Christian Zeichmann', 'Zeichi', 'christian.zeichmann@atosorigin.com', 0, 'austrian', 0, 2007, 1), (4, 'AFG', 0x3833333834343331333930613134383839633939353539333862623536303466, 'pic_AFG.gif', 'Andrea F. Grohmann', '', 'andrea.grohmann@chello.at', 0, 'austrian', 0, 2007, 0), (6, 'JIR', 0x3835323263326363666436666335643234326564313664313638343031666164, 'avatar.jpg', 'Juergen Iser', '', 'j.iser@gmx.at', 0, 'austrian', 602, 2008, 0), (7, 'KAI', 0x6535663464393761343936316465613131383462626265383437623539316633, 'avatar.jpg', 'Roman Kailbach', 'Kailo', 'kailo@gmx.at', 0, 'austrian', 334, 2008, 0), (8, 'WOB', 0x3737366164306566323761636330363032633333376463323733366633613937, 'imagesca63vc0b.jpg', 'Wolfgang Boehm', 'WoB', 'wboehm@gmail.com', 0, 'austrian', 0, 2008, 0), (9, 'REG', 0x3737366164306566323761636330363032633333376463323733366633613937, 'yoshi1.jpg', 'Regina Boehm', '', 'wboehm@gmail.com', 0, 'austrian', 0, 2008, 0), (10, 'ISA', 0x3363346462393536316161326238353330643563363030313464626662653836, 'isa_grid_kl_hp_3.jpg', 'Ildiko Samu-Puehringer', 'sam', 'ildiko.samu@aon.at', 0, 'hungarian', 667, 2008, 0), (11, 'MRO', 0x6364613066643239313864313965323061633837316564373961386432626230, 'pic_MRO.jpg', 'Martha Rossa', 'RoMa', 'rossama@yahoo.com', 0, 'austrian', 334, 2008, 1), (12, 'MPU', 0x3438643534663433633330613237313337656462333833646532363035613836, 'mpu_grid_tip_blaukl.', 'Michael Puehringer', '', 'michael.puehringer@atosorigin.com', 0, 'austrian', 621, 2008, 0), (13, 'RHA', 0x3963656438326330353135646636396434653333313166363364343066666130, 'avatar.jpg', 'Robert Haller', '', 'robert.haller@kabsi.at', 0, 'austrian', 0, 2008, 0), (14, 'FAN', 0x3333633265323064333162336165386634353634643735313737333865623764, 'extremeevil.gif', 'Georg Juren', 'Schurl', 'georg.juren@atosorigin.com', 0, 'austrian', 49, 2009, 0), (15, 'MBR', 0x3037623961363565396130613838636634656265643536373266323039323737, 'avatar.jpg', 'Markus Brenner', '', 'm.brenn@gmx.net', 0, 'austrian', 0, 2009, 0), (16, 'RSC', 0x6436376565306236613931363936313538343431313030626132653561396230, 'schicht_roman.jpg', 'Roman Schicht', '', 'rschicht@yahoo.com', 0, 'austrian', 0, 2009, 0), (17, 'FAB', 0x6639633137313137623562386462663863666138336438303537656531613062, 'avatar.jpg', 'Alexander Fabozzi', '', 'a.fabozzi@gmx.at', 0, 'austrian', 0, 2010, 0), (18, 'MAR', 0x3737366164306566323761636330363032633333376463323733366633613937, 'avatar.jpg', 'Marina Boehm', '', 'wboehm@gmail.com', 0, 'austrian', 0, 2010, 0), (19, 'IRS', 0x3839313862373464353731343231626363343766633539383136626638666332, 'foto_ivan.png', 'Ivan Rodriguez', '', 'irodriguezs@hotmail.com', 0, 'spanish', 15, 2010, 0);