-- MariaDB dump 10.19-11.4.0-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: niki_dev -- ------------------------------------------------------ -- Server version 11.4.0-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `alldrivers` -- DROP TABLE IF EXISTS `alldrivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alldrivers` ( `a_id` int(4) NOT NULL AUTO_INCREMENT, `a_lname` varchar(20) NOT NULL DEFAULT '', `a_fname` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`a_id`) ) ENGINE=MyISAM AUTO_INCREMENT=869 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `alldrivers` -- LOCK TABLES `alldrivers` WRITE; /*!40000 ALTER TABLE `alldrivers` DISABLE KEYS */; INSERT INTO `alldrivers` VALUES (868,'(none)','(none)'), (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'), (814,'CHANDHOK','Karun'), (815,'DI GRASSI','Lucas'), (816,'HUELKENBERG','Nico'), (817,'PETROV','Vitaly'), (818,'SENNA','Bruno'), (819,'D\'AMBROSIO','Jerome'), (820,'DI RESTA','Paul'), (821,'MALDONADO','Pastor'), (822,'PEREZ','Sergio'), (823,'PIC','Charles'), (824,'RICCIARDO','Daniel'), (825,'VERGNE','Jean-Eric'), (826,'BIANCHI','Jules'), (827,'BOTTAS','Valtteri'), (828,'CHILTON','Max'), (829,'GUTIERREZ','Esteban'), (830,'VAN DER GARDE','Giedo'), (831,'ERICSSON','Marcus'), (832,'KVYAT','Daniil'), (833,'LOTTERER','Andre'), (834,'MAGNUSSEN','Kevin'), (835,'STEVENS','Will'), (836,'MERHI','Roberto'), (837,'NASR','Felipe'), (838,'ROSSI','Alexander'), (839,'SAINZ','Carlos Jr.'), (840,'VERSTAPPEN','Max'), (841,'HARYANTO','Rio'), (842,'OCON','Esteban'), (843,'PALMER','Jolyon'), (844,'VANDOORNE','Stoffel'), (845,'WEHRLEIN','Pascal'), (846,'GASLY','Pierre'), (847,'GIOVINAZZI','Antonio'), (848,'HARTLEY','Brendon'), (849,'STROLL','Lance'), (850,'LECLERC','Charles'), (851,'SIROTKIN','Sergey'), (852,'ALBON','Alexander'), (853,'NORRIS','Lando'), (854,'RUSSELL','George'), (855,'AITKEN','Jack'), (856,'FITTIPALDI','Pietro'), (857,'LATIFI','Nicholas'), (860,'MAZEPIN','Nikita'), (861,'SCHUMACHER','Mick'), (862,'TSUNODA','Yuki'), (863,'DE VRIES','Nyck'), (864,'ZHOU','Guanyu'), (865,'LAWSON','Liam'), (866,'PIASTRI','Oscar'), (867,'SARGEANT','Logan'); /*!40000 ALTER TABLE `alldrivers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betsy` -- DROP TABLE IF EXISTS `betsy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `betsy` ( `b_id` int(4) NOT NULL AUTO_INCREMENT, `b_bet` varchar(40) DEFAULT NULL, `b_desc` varchar(80) DEFAULT NULL, PRIMARY KEY (`b_id`) ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betsy` -- LOCK TABLES `betsy` WRITE; /*!40000 ALTER TABLE `betsy` DISABLE KEYS */; INSERT INTO `betsy` VALUES (1,'Champion','Winner Drivers Championship'), (2,'Constructor','Winner Constructors Championship'), (3,'Smallest team mate gap','Team mates with the smallest gap of scored point during the season'), (4,'Biggest team mate gap','Team mates with the biggest gap of scored point during the season'), (5,'GP wins','Driver with the most GP wins of the season'), (6,'Consecutive GP wins','Driver with the most consecutive GP wins of the season'), (7,'Double GP wins','Team with the most P1+P2 GP wins of the season'), (8,'Consecutive double GP wins','Team with the most consecutive P1+P2 GP wins of the season'), (9,'GP wins from pole','Driver with the most GP wins of the season starting from Pole'), (10,'GP wins from behinde Pole','Driver with the most GP wins of the season starting from behind the Pole'), (11,'GP win from worst grid position','Driver winning a GP from the worst grid position of the season'), (12,'Highest positions gain','Driver with the highest amount of gained race postions during the season'), (13,'Most gained Positions','Driver with the most gained positions overall during the season'), (14,'Team most gained positions','Team with the most gained positions overall during the season'), (15,'Points finishes','Driver with the most finishes in the points of the season'), (16,'Team points finishes','Team with the most points finishes of the season'), (17,'Leading laps','Driver with the most leading laps of the season'), (18,'GP leading','Driver leading in the most number of GP during the season'), (19,'Team leading laps','Team with the most leading laps of the season'), (20,'Team GP leading','Team leading in the most number of GP during the season'), (21,'Podiums','Driver with the most podium finishes of the season'), (22,'Team podiums','Team with the most podium positions of the season'), (23,'Worst qualifying ratio','Team with the worst Qualifying result ratio between team mates'), (24,'Worst race result ratio','Team with the worst Race result ratio between team mates'), (25,'Fastest laps','Driver with the most Fastest Laps of the season'), (26,'Pole positions','Driver with the most Pole Positions of the season'), (27,'Hattricks','Driver with the most Hattricks of the season (Pole+Win+Fastest Lap)'), (28,'Grand Slams','Driver with the most Grand Slams of the season (Hattrick+leading each lap)'), (29,'Front row','Driver with the most front row grid positions of the season'), (30,'Front row lockout','Team with the most front row lockouts of the season'), (31,'Driver of the day','Driver with the most Driver of the Day awards of the season'), (32,'Pit stop time','Team with the fastest pit stop time of the season'), (33,'DNF','Driver with the most DNF of the season'), (34,'Team DNF','Team with the most DNF of the season'), (35,'Team double DNF','Team with the most double DNF of the season'), (36,'DNF ratio','Team with the worst DNF ratio between the team colleagues during the season'), (37,'Biggest qualifying gap','Team with the biggest gap in positions between team mates in a Qualifying'), (38,'Biggest race result gap','Team with the biggest gap in positions between team mates in a Race'), (39,'Smallest qualifying gap','Team with the smallest gap in positions between team mates in a Qualifying'), (40,'Smallest race result gap','Team with the smallest gap in positions between team mates in a Race'); /*!40000 ALTER TABLE `betsy` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betsyresults` -- DROP TABLE IF EXISTS `betsyresults`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `betsyresults` ( `br_b_id` int(4) NOT NULL DEFAULT 0, `br_result` int(4) NOT NULL DEFAULT 0, PRIMARY KEY (`br_b_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betsyresults` -- LOCK TABLES `betsyresults` WRITE; /*!40000 ALTER TABLE `betsyresults` DISABLE KEYS */; INSERT INTO `betsyresults` VALUES (1,1), (2,2), (3,37); /*!40000 ALTER TABLE `betsyresults` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betsyscores` -- DROP TABLE IF EXISTS `betsyscores`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `betsyscores` ( `bs_u_id` int(4) NOT NULL DEFAULT 0, `bs_year` int(4) NOT NULL DEFAULT 0, `bs_b_id` int(4) NOT NULL DEFAULT 0, `bs_scores` int(7) NOT NULL DEFAULT 0, PRIMARY KEY (`bs_u_id`,`bs_year`,`bs_b_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betsyscores` -- LOCK TABLES `betsyscores` WRITE; /*!40000 ALTER TABLE `betsyscores` DISABLE KEYS */; INSERT INTO `betsyscores` VALUES (1,2026,1,213), (10,2026,1,184), (81,2026,1,185), (82,2026,1,0), (80,2026,1,185), (1,2026,2,187), (10,2026,2,0), (81,2026,2,0), (82,2026,2,182), (80,2026,2,0), (80,2025,1,125), (10,2026,3,0), (1,2026,3,0); /*!40000 ALTER TABLE `betsyscores` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `betsytips` -- DROP TABLE IF EXISTS `betsytips`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `betsytips` ( `bt_u_id` int(4) NOT NULL DEFAULT 0, `bt_b_id` int(4) NOT NULL DEFAULT 0, `bt_tip` int(4) NOT NULL DEFAULT 0, `bt_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`bt_u_id`,`bt_b_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `betsytips` -- LOCK TABLES `betsytips` WRITE; /*!40000 ALTER TABLE `betsytips` DISABLE KEYS */; INSERT INTO `betsytips` VALUES (1,1,8,'2026-04-15 16:28:07'), (1,2,11,'2026-04-07 16:28:04'), (10,1,1,'2026-03-30 08:27:55'), (10,2,1,'2026-03-30 08:28:00'), (10,3,3,'2026-03-30 08:28:05'), (1,6,7,'2026-03-30 09:29:52'), (1,7,23,'2026-03-30 09:29:57'), (1,3,2,'2026-03-31 00:29:24'), (1,12,17,'2026-03-31 00:34:08'), (81,1,1,'2026-03-29 19:42:52'), (81,2,1,'2026-03-31 19:42:52'), (82,1,2,'2026-03-30 19:42:52'), (82,2,2,'2026-04-01 19:42:52'), (80,1,1,'2026-03-29 19:42:52'), (80,2,1,'2026-04-02 19:42:52'), (1,4,1,'2026-04-02 17:08:22'), (1,8,29,'2026-04-07 16:28:13'), (1,5,7,'2026-05-02 19:39:24'), (1,9,20,'2026-05-06 15:35:00'), (1,10,8,'2026-05-07 10:45:02'); /*!40000 ALTER TABLE `betsytips` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `drivers` -- DROP TABLE IF EXISTS `drivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `drivers` ( `d_id` int(4) NOT NULL AUTO_INCREMENT, `d_lname` varchar(20) NOT NULL DEFAULT '', `d_fname` varchar(20) NOT NULL DEFAULT '', `d_currseason` int(1) NOT NULL DEFAULT 0, `d_miod` int(3) NOT NULL DEFAULT 0, `d_fa_id` int(3) NOT NULL DEFAULT 0, PRIMARY KEY (`d_id`) ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `drivers` -- LOCK TABLES `drivers` WRITE; /*!40000 ALTER TABLE `drivers` DISABLE KEYS */; INSERT INTO `drivers` VALUES (1,'PIASTRI','Oscar',1,27,2), (2,'NORRIS','Lando',1,29,2), (3,'LECLERC','Charles',1,28,1), (4,'HAMILTON','Lewis',1,24,1), (5,'VERSTAPPEN','Max',1,30,42), (6,'LAWSON','Liam',1,15,42), (7,'RUSSELL','George',1,25,11), (8,'ANTONELLI','Andrea Kimi',1,11,11), (9,'STROLL','Lance',1,19,36), (10,'ALONSO','Fernando',1,23,36), (11,'GASLY','Pierre',1,22,37), (12,'DOOHAN','Jack',1,14,37), (13,'OCON','Esteban',1,18,29), (14,'BEARMAN','Oliver',1,16,29), (15,'HADJAR','Isack',1,12,43), (16,'TSUNODA','Yuki',1,20,43), (17,'ALBON','Alexander',1,17,23), (18,'SAINZ','Carlos Jr.',1,26,23), (19,'HUELKENBERG','Nico',1,21,12), (20,'BORTOLETO','Gabriel',1,13,12), (100,' none','',1,0,0); /*!40000 ALTER TABLE `drivers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events` ( `e_id` int(2) NOT NULL AUTO_INCREMENT, `e_type` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`e_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'QUALIFYING'), (2,'RACE'), (3,'SPRINT'), (4,'SPRINT SHOOTOUT'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fflassets` -- DROP TABLE IF EXISTS `fflassets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fflassets` ( `fa_id` int(4) NOT NULL AUTO_INCREMENT, `fa_currseason` int(1) NOT NULL DEFAULT 0, `fa_chassis` varchar(30) NOT NULL DEFAULT '', `fa_mioc` int(3) NOT NULL DEFAULT 0, `fa_engine` varchar(30) NOT NULL DEFAULT '', `fa_mioe` int(3) NOT NULL DEFAULT 0, PRIMARY KEY (`fa_id`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fflassets` -- LOCK TABLES `fflassets` WRITE; /*!40000 ALTER TABLE `fflassets` DISABLE KEYS */; INSERT INTO `fflassets` VALUES (1,1,'Ferrari',29,'Ferrari (Ferrari)',26), (2,1,'McLaren',30,'Mercedes (McLaren)',30), (3,0,'BMW Sauber',0,'BMW (BMW Sauber)',0), (4,0,'Renault',0,'Renault (Renault)',0), (5,0,'Toyota',0,'Toyota (Toyota)',0), (6,0,'Toro Rosso',0,'Ferrari (Toro Rosso)',0), (7,0,'Red Bull',0,'Renault (Red Bull)',0), (8,0,'Williams',0,'Toyota (Williams)',0), (9,0,'Brawn',0,'Mercedes (Brawn)',0), (10,0,'Force India',0,'Ferrari (Force India)',0), (11,1,'Mercedes',27,'Mercedes (Mercedes)',29), (12,1,'Sauber',21,'Ferrari (Sauber)',24), (13,0,'Williams',0,'Cosworth (Williams)',0), (14,0,'Force India',0,'Mercedes (Force India)',0), (15,0,'Lotus',0,'Cosworth (Lotus)',0), (16,0,'HRT',0,'Cosworth (HRT)',0), (17,0,'Virgin',0,'Cosworth (Virgin)',0), (18,0,'Lotus',0,'Renault (Lotus)',0), (19,0,'Williams',0,'Renault (Williams)',0), (20,0,'Caterham',0,'Renault (Caterham)',0), (21,0,'Marussia',0,'Cosworth (Marussia)',0), (22,0,'Toro Rosso',0,'Renault (Toro Rosso)',0), (23,1,'Williams',22,'Mercedes (Williams)',27), (24,0,'Marussia',0,'Ferrari (Marussia)',0), (25,0,'McLaren',0,'Honda (McLaren)',0), (26,0,'Lotus',0,'Mercedes (Lotus)',0), (27,0,'Manor',0,'Ferrari (Manor)',0), (28,0,'Red Bull',0,'TAG Heuer (Red Bull)',0), (29,1,'Haas',24,'Ferrari (Haas)',25), (30,0,'Toro Rosso',0,'Honda (Toro Rosso)',0), (31,0,'McLaren',0,'Renault (McLaren)',0), (32,0,'Alfa Romeo',0,'Ferrari (Alfa Romeo)',0), (33,0,'Racing Point',0,'Mercedes (Racing Point)',0), (34,0,'Red Bull',0,'Honda (Red Bull)',0), (35,0,'AlphaTauri',0,'Honda (AlphaTauri)',0), (36,1,'Aston Martin',26,'Mercedes (Aston Martin)',28), (37,1,'Alpine',25,'Renault (Alpine)',21), (38,0,'Red Bull',0,'Red Bull PT (Red Bull)',0), (39,0,'AlphaTauri',0,'Red Bull PT (AlphaTauri)',0), (40,0,'Stake F1',0,'Ferrari (Stake F1)',0), (41,0,'Visa Cash App RB',0,'Red Bull PT (Visa Cash App RB)',0), (42,1,'Red Bull',28,'Honda RBPT (Red Bull)',23), (43,1,'Racing Bulls',23,'Honda RBPT (Racing Bulls)',22); /*!40000 ALTER TABLE `fflassets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fflpoints` -- DROP TABLE IF EXISTS `fflpoints`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fflpoints` ( `fp_u_id` int(4) NOT NULL DEFAULT 0, `fp_g_id` int(4) NOT NULL DEFAULT 0, `fp_points` decimal(4,1) NOT NULL DEFAULT 0.0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fflpoints` -- LOCK TABLES `fflpoints` WRITE; /*!40000 ALTER TABLE `fflpoints` DISABLE KEYS */; INSERT INTO `fflpoints` VALUES (36,1,82.0), (1,1,82.0), (12,1,81.0), (37,1,82.0), (21,1,71.0), (39,1,54.0), (18,1,60.0), (36,3,0.0), (1,3,0.0), (12,3,0.0), (37,3,0.0), (21,3,0.0), (39,3,0.0), (18,3,0.0), (10,3,0.0), (36,3,30.0), (1,3,55.0), (12,3,15.0), (37,3,30.0), (21,3,27.0), (39,3,14.0), (18,3,8.0), (10,3,12.0), (36,2,54.0), (1,2,62.0), (12,2,34.0), (37,2,54.0), (21,2,19.0), (39,2,32.0), (18,2,25.0), (10,2,8.0), (36,2,13.0), (1,2,19.0), (12,2,11.0), (37,2,13.0), (21,2,5.0), (39,2,8.0), (18,2,8.0), (10,2,2.0), (36,2,54.0), (1,2,62.0), (12,2,34.0), (37,2,54.0), (21,2,19.0), (39,2,32.0), (18,2,25.0), (10,2,8.0), (36,2,54.0), (1,2,62.0), (12,2,34.0), (37,2,54.0), (21,2,19.0), (39,2,32.0), (18,2,25.0), (10,2,8.0), (36,3,53.0), (1,3,65.0), (12,3,37.0), (37,3,53.0), (21,3,19.0), (39,3,30.0), (18,3,28.0), (10,3,8.0); /*!40000 ALTER TABLE `fflpoints` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fflresults` -- DROP TABLE IF EXISTS `fflresults`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fflresults` ( `fr_season` int(4) NOT NULL DEFAULT 0, `fr_u_id` int(4) NOT NULL DEFAULT 0, `fr_ft_a_id_d1` int(4) NOT NULL DEFAULT 0, `fr_ft_a_id_d2` int(4) NOT NULL DEFAULT 0, `fr_fa_id_chassis` int(4) NOT NULL DEFAULT 0, `fr_fa_id_engine` int(4) NOT NULL DEFAULT 0, `fr_totalpoints` decimal(5,1) DEFAULT 0.0, PRIMARY KEY (`fr_season`,`fr_u_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fflresults` -- LOCK TABLES `fflresults` WRITE; /*!40000 ALTER TABLE `fflresults` DISABLE KEYS */; INSERT INTO `fflresults` VALUES (2009,0,128,762,9,9,523.0), (2009,1,746,762,8,7,304.5), (2009,2,15,251,9,1,276.0), (2009,3,49,303,9,1,343.0), (2009,6,484,128,9,6,297.0), (2009,9,602,128,5,7,356.0), (2009,10,334,128,8,9,350.5), (2009,11,746,128,7,1,351.0), (2009,12,762,128,9,1,421.0), (2010,0,15,713,7,7,1295.0), (2010,1,334,411,11,7,984.0), (2010,4,484,762,17,7,898.0), (2010,6,484,713,7,6,702.0), (2010,9,816,15,11,2,942.0), (2010,10,417,303,2,7,1088.0), (2010,11,818,15,1,1,1044.0), (2010,12,15,816,11,7,986.0), (2010,13,49,818,1,6,456.0), (2011,6,713,348,2,7,1223.0), (2011,1,632,822,1,7,1128.0), (2011,12,667,820,7,1,1128.0), (2011,10,484,820,7,2,1292.0), (2011,0,128,820,7,7,1597.0), (2012,1,602,816,2,7,1108.0), (2012,12,15,320,2,7,1212.0), (2012,6,411,816,7,1,983.0), (2012,9,667,825,7,2,903.0), (2012,10,762,825,2,7,1135.0), (2012,2,762,394,18,7,1044.0), (2012,7,762,818,18,18,918.0), (2012,0,15,320,7,7,1294.0), (2013,1,762,828,1,7,1347.0), (2013,20,602,829,1,7,1139.0), (2013,12,602,829,1,7,1139.0), (2013,10,762,830,2,7,1115.0), (2013,18,15,826,19,1,601.0), (2013,0,15,828,7,7,1434.0), (2014,1,762,834,1,7,843.0), (2014,20,762,834,11,7,1328.0), (2014,12,602,832,11,7,1169.0), (2014,10,334,821,2,7,972.0), (2014,9,632,834,11,1,1289.0), (2014,0,824,834,11,11,1695.0), (2015,1,832,840,11,11,1549.0), (2015,20,602,839,11,11,1574.0), (2015,21,831,602,11,25,889.0), (2015,9,484,839,11,1,1274.0), (2015,10,762,840,11,7,1216.0), (2015,0,602,839,11,11,1574.0), (2016,1,840,843,11,11,1735.0), (2016,12,762,834,11,28,1452.0), (2016,21,834,15,11,11,1591.0), (2016,10,334,845,1,4,787.0), (2016,9,824,841,11,1,1419.0), (2016,18,15,839,11,1,1263.0), (2016,20,840,843,11,11,1735.0), (2016,0,840,843,11,11,1735.0), (2017,1,844,842,11,11,1436.0), (2017,36,827,849,1,1,1389.0), (2017,12,827,842,11,28,1428.0), (2017,21,844,849,11,11,1389.0), (2017,10,762,849,11,25,1055.0), (2017,18,839,831,11,1,1244.0), (2017,0,842,849,11,11,1463.0), (2018,1,320,851,11,11,1348.0), (2018,36,844,846,11,11,1352.0), (2018,12,840,851,11,28,1324.0), (2018,21,15,320,11,28,1161.0), (2018,10,827,851,11,30,903.0), (2018,18,15,848,11,11,1364.0), (2018,37,840,851,11,28,1324.0), (2018,0,834,850,11,11,1405.0), (2019,1,846,853,11,11,1622.0), (2019,36,850,852,1,11,1599.0), (2019,12,850,849,11,34,1441.0), (2019,37,320,852,11,11,1578.0), (2019,21,850,853,11,1,1556.0), (2019,10,320,852,11,11,1578.0), (2019,18,846,853,11,11,1622.0), (2019,0,846,852,11,11,1665.0), (2020,1,842,832,11,11,1240.0), (2020,36,849,854,11,11,1224.0), (2020,12,832,842,11,11,1240.0), (2020,21,842,849,11,11,1283.0), (2020,37,832,842,11,11,1240.0), (2020,18,334,0,11,11,1493.0), (2020,0,842,849,11,11,1283.0), (2021,36,7,18,11,11,1568.0), (2021,1,9,17,11,11,2007.0), (2021,12,9,6,11,34,1958.5), (2021,37,7,18,11,11,1572.0), (2021,21,14,7,34,11,1189.0), (2021,39,6,14,34,1,1135.0), (2021,18,9,12,34,34,1507.0), (2025,36,7,18,11,11,258.0), (2025,1,9,17,11,11,325.0), (2025,12,9,6,11,34,165.0), (2025,37,7,18,11,11,258.0), (2025,21,14,7,34,11,108.0), (2025,39,6,14,34,1,148.0), (2025,18,9,12,34,34,119.0), (2025,10,21,16,29,2,46.0); /*!40000 ALTER TABLE `fflresults` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fflteams` -- DROP TABLE IF EXISTS `fflteams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fflteams` ( `ft_u_id` int(4) NOT NULL DEFAULT 0, `ft_d_id_d1` int(4) NOT NULL DEFAULT 0, `ft_d_id_d2` int(4) NOT NULL DEFAULT 0, `ft_fa_id_chassis` int(4) NOT NULL DEFAULT 0, `ft_fa_id_engine` int(4) NOT NULL DEFAULT 0, PRIMARY KEY (`ft_u_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fflteams` -- LOCK TABLES `fflteams` WRITE; /*!40000 ALTER TABLE `fflteams` DISABLE KEYS */; INSERT INTO `fflteams` VALUES (36,7,18,11,11), (1,9,17,11,11), (12,9,6,11,34), (37,7,18,11,11), (21,14,7,34,11), (39,6,14,34,1), (18,9,12,34,34), (10,21,16,29,2); /*!40000 ALTER TABLE `fflteams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gps` -- DROP TABLE IF EXISTS `gps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gps` ( `g_id` int(4) NOT NULL AUTO_INCREMENT, `g_name` varchar(40) NOT NULL DEFAULT '', `g_datetime_ss` datetime DEFAULT NULL, `g_datetime_q` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `g_datetime_s` datetime DEFAULT NULL, `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 AUTO_INCREMENT=101 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gps` -- LOCK TABLES `gps` WRITE; /*!40000 ALTER TABLE `gps` DISABLE KEYS */; INSERT INTO `gps` VALUES (100,'NOSTRADAMUS MODE (Whole Season)','2025-03-15 06:00:00','2025-03-15 06:00:00','2025-03-15 06:00:00','2025-03-15 06:00:00','flag_Checkered.gif','Nostradamus.jpg'), (1,'AUSTRALIA (Melbourne)',NULL,'2026-03-15 06:00:00',NULL,'2025-03-16 05:00:00','flag_AUSTRALIA.gif','circuit_AUSTRALIA_new.jpg'), (2,'CHINA (Shanghai)','2025-03-21 07:00:00','2025-03-22 10:00:00','2025-03-22 05:00:00','2025-03-23 07:00:00','flag_CHINA.gif','circuit_CHINA_new.jpg'), (3,'JAPAN (Suzuka)','2025-03-03 09:00:00','2025-03-05 09:00:00','2025-03-04 09:00:00','2025-03-06 08:00:00','flag_JAPAN.gif','circuit_JAPAN_new.jpg'), (4,'BAHRAIN (Sakhir)',NULL,'2025-04-12 15:00:00',NULL,'2025-04-13 14:00:00','flag_BAHRAIN.gif','circuit_BAHRAIN_new.jpg'), (5,'SAUDI ARABIA (Jeddah)',NULL,'2025-04-19 15:00:00',NULL,'2025-04-20 14:00:00','flag_SAUDIARABIA.gif','circuit_SAUDIARABIA.jpg'), (6,'MIAMI (Miami)','2025-05-02 20:00:00','2025-05-03 23:00:00','2025-05-03 18:00:00','2025-05-04 20:00:00','flag_USA.gif','circuit_USA_(Miami).jpg'), (7,'EMILIA ROMAGNA (Imola)',NULL,'2025-05-17 16:00:00',NULL,'2025-05-18 15:00:00','flag_ITALY.gif','circuit_SANMARINO.gif'), (8,'MONACO (Monte Carlo)',NULL,'2025-05-24 16:00:00',NULL,'2025-05-25 15:00:00','flag_MONACO.gif','circuit_MONACO_new.jpg'), (9,'SPAIN (Barcelona)',NULL,'2025-05-31 16:00:00',NULL,'2025-06-01 15:00:00','flag_SPAIN.gif','circuit_SPAIN_new.jpg'), (10,'CANADA (Montreal)',NULL,'2025-06-14 22:00:00',NULL,'2025-06-15 21:00:00','flag_CANADA.gif','circuit_CANADA_new.jpg'), (11,'AUSTRIA (Spielberg)',NULL,'2025-06-28 16:00:00',NULL,'2025-06-29 15:00:00','flag_AUSTRIA.gif','circuit_AUSTRIA_new.jpg'), (12,'GREAT BRITAIN (Silverstone)',NULL,'2025-07-05 17:00:00',NULL,'2025-07-06 16:00:00','flag_UK.gif','circuit_UK_new.jpg'), (13,'BELGIUM (Spa)','2025-07-25 14:00:00','2025-07-26 17:00:00','2025-07-26 12:00:00','2025-07-27 14:00:00','flag_BELGIUM.gif','circuit_BELGIUM_new.jpg'), (14,'HUNGARY (Budapest)',NULL,'2025-08-02 16:00:00',NULL,'2025-08-03 15:00:00','flag_HUNGARY.gif','circuit_HUNGARY_new.jpg'), (15,'NETHERLANDS (Zandvoort)',NULL,'2025-08-30 16:00:00',NULL,'2025-08-31 15:00:00','flag_NETHERLANDS.gif','circuit_NETHERLANDS.jpg'), (16,'ITALY (Monza)',NULL,'2025-09-06 16:00:00',NULL,'2025-09-07 15:00:00','flag_ITALY.gif','circuit_ITALY_new.jpg'), (17,'AZERBAIJAN (Baku)',NULL,'2025-09-20 14:00:00',NULL,'2025-09-21 13:00:00','flag_AZERBAIJAN.gif','circuit_AZERBAIJAN_new.jpg'), (18,'SINGAPORE (Singapore)',NULL,'2025-10-04 10:00:00',NULL,'2025-10-05 09:00:00','flag_SINGAPORE.gif','circuit_SINGAPORE.gif'), (19,'USA (Austin)','2025-10-17 19:00:00','2025-10-19 00:00:00','2025-10-18 19:00:00','2025-10-19 21:00:00','flag_USA.gif','circuit_USA_new.jpg'), (20,'MEXICO (Mexico City)',NULL,'2025-10-26 00:00:00',NULL,'2025-10-26 22:00:00','flag_MEXICO.gif','circuit_MEXICO_new.jpg'), (21,'BRAZIL (Sao Paulo)','2025-11-07 18:00:00','2025-11-08 21:00:00','2025-11-08 16:00:00','2025-11-09 18:00:00','flag_BRAZIL.gif','circuit_BRAZIL_new.jpg'), (22,'LAS VEGAS (Las Vegas)',NULL,'2025-11-22 01:00:00',NULL,'2025-11-23 00:00:00','flag_USA.gif','circuit_NEVADA.jpg'), (23,'QATAR (Doha)','2025-11-28 12:00:00','2025-11-29 15:00:00','2025-11-29 10:00:00','2025-11-30 12:00:00','flag_QATAR.gif','circuit_QATAR.jpg'), (24,'UNITED ARAB EMIRATES (Abu Dhabi)',NULL,'2025-12-06 13:00:00',NULL,'2025-12-07 12:00:00','flag_UAE.gif','circuit_UAE_new.jpg'); /*!40000 ALTER TABLE `gps` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `results` -- DROP TABLE IF EXISTS `results`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `results` ( `r_g_id` int(4) NOT NULL DEFAULT 0, `r_e_id` int(2) NOT NULL DEFAULT 0, `r_d_id_p1` int(4) NOT NULL DEFAULT 0, `r_d_id_p2` int(4) NOT NULL DEFAULT 0, `r_d_id_p3` int(4) NOT NULL DEFAULT 0, `r_d_id_p4` int(4) NOT NULL DEFAULT 0, `r_d_id_p5` int(4) NOT NULL DEFAULT 0, `r_d_id_p6` int(4) NOT NULL DEFAULT 0, `r_d_id_p7` int(4) NOT NULL DEFAULT 0, `r_d_id_p8` int(4) NOT NULL DEFAULT 0, `r_d_id_p9` int(4) NOT NULL DEFAULT 0, `r_d_id_p10` int(4) NOT NULL DEFAULT 0, `r_fl` int(4) NOT NULL DEFAULT 0, `r_firstout` varchar(20) NOT NULL DEFAULT '0', `r_bestcup` varchar(40) DEFAULT '0', `r_bestteam` varchar(20) DEFAULT '0', `r_sc` int(2) NOT NULL DEFAULT -1, `r_hp` int(1) NOT NULL DEFAULT 0, PRIMARY KEY (`r_g_id`,`r_e_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `results` -- LOCK TABLES `results` WRITE; /*!40000 ALTER TABLE `results` DISABLE KEYS */; INSERT INTO `results` VALUES (3,4,17,9,18,0,0,0,0,0,0,0,0,'0','0','0',-1,0), (3,3,9,4,18,17,10,8,14,20,0,0,7,'1','9','42',1,0), (3,1,7,4,3,0,0,0,0,0,0,0,0,'0','0','0',-1,0), (2,2,18,3,9,17,10,8,14,20,12,11,9,'13','12','42',0,0), (2,3,9,18,4,17,10,8,14,20,0,0,7,'1','9','42',1,0), (2,1,7,3,4,0,0,0,0,0,0,0,0,'0','0','0',-1,0), (2,4,17,18,9,0,0,0,0,0,0,0,0,'0','0','0',-1,0), (3,2,18,9,3,17,10,8,14,20,12,11,9,'13','12','42',0,0); /*!40000 ALTER TABLE `results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tips` -- DROP TABLE IF EXISTS `tips`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tips` ( `t_u_id` int(4) NOT NULL DEFAULT 0, `t_g_id` int(4) NOT NULL DEFAULT 0, `t_e_id` int(2) NOT NULL DEFAULT 0, `t_d_id_p1` int(4) NOT NULL DEFAULT 0, `t_d_id_p2` int(4) NOT NULL DEFAULT 0, `t_d_id_p3` int(4) NOT NULL DEFAULT 0, `t_fl` int(4) NOT NULL DEFAULT 0, `t_firstout` int(4) NOT NULL DEFAULT 0, `t_bestcup` int(4) NOT NULL DEFAULT 0, `t_bestteam` int(4) DEFAULT 0, `t_sc` int(2) NOT NULL DEFAULT 0, `t_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `t_score` int(4) NOT NULL DEFAULT 0, PRIMARY KEY (`t_u_id`,`t_g_id`,`t_e_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tips` -- LOCK TABLES `tips` WRITE; /*!40000 ALTER TABLE `tips` DISABLE KEYS */; INSERT INTO `tips` VALUES (1,100,1,8,1,2,0,0,0,0,0,'2021-03-26 22:39:00',0), (1,100,3,9,18,3,16,13,7,2,-1,'2025-03-14 21:40:27',0), (1,100,2,8,13,16,9,1,3,42,-1,'2025-03-14 21:10:22',0), (10,100,2,18,3,9,9,13,12,42,0,'2025-02-07 21:22:45',26), (1,1,2,8,1,2,3,18,10,11,1,'2021-03-28 05:59:08',0), (10,100,1,7,3,4,0,0,0,0,0,'2025-02-07 21:22:24',10), (10,100,3,9,18,4,7,1,9,42,1,'2025-02-07 21:22:16',26), (10,100,4,17,18,9,0,0,0,0,0,'2025-02-07 21:21:49',10), (1,100,4,8,2,3,0,0,0,0,0,'2025-01-14 00:00:00',0), (1,3,2,18,7,1,7,20,9,43,0,'2025-02-02 17:46:53',3), (10,3,1,17,10,11,0,0,0,0,0,'2025-02-02 17:43:16',0), (10,2,3,7,16,12,0,0,0,0,0,'2025-02-02 16:48:23',-1), (10,1,2,16,11,14,1,9999,9999,9999,-1,'2023-02-06 23:04:29',0), (10,1,1,9,2,20,0,0,0,0,0,'2025-02-01 21:26:56',0), (10,3,3,18,1,11,16,100,9,42,1,'2025-02-02 18:36:38',5), (10,3,4,3,18,2,0,0,0,0,0,'2025-02-02 17:40:44',1), (1,1,3,8,2,3,3,100,9,42,1,'2025-02-01 00:00:00',0); /*!40000 ALTER TABLE `tips` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `u_id` int(11) NOT NULL AUTO_INCREMENT, `u_name` char(3) NOT NULL DEFAULT '', `u_passcode` varchar(41) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL DEFAULT '', `u_pic` varchar(40) DEFAULT NULL, `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, `u_admin` int(1) NOT NULL DEFAULT 0, PRIMARY KEY (`u_id`) ) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'MAM','18d022103920e120b2faabf4be68aa8f','pic_MAM.gif','Markus A. Mascelli','MAM','mam@heimam.at',0,'italian',602,2006,7,1), (10,'MRO','cda0fd2918d19e20ac871ed79a8d2bb0','pic_MRO.jpg','Martha Rossa','RoMa','rossama@yahoo.com',0,'austrian',334,2008,1,1), (97,'OKI','931681a971adb816a5ee55a32e5e5e32','avatar.jpg','Oki Doki','','',0,'',0,2025,0,0), (96,'LAL','551b45c5a2e3acc57690b0469d26f1a3','avatar.jpg','Lalli','','',0,'',0,2025,0,0), (95,'SAS','a8a64cef262a04de4872b68b63ab7cd8','avatar.jpg','Sassi','','',0,'',0,2025,0,0), (94,'LUL','2c0b3d4664350f2ff5a2ac539aeacf0e','avatar.jpg','Lulli','','',0,'',0,2025,0,0), (93,'CRA','51f7b4150aece7d0f6d45d8f00b8184e','avatar.jpg','Krah Krah','','',0,'',0,2025,0,0), (92,'RAP','2e2d7fe5d75b602595df021c7841243b','avatar.jpg','Rappi','','',0,'',0,2025,0,0), (91,'ARC','909ba4ad2bda46b10aac3c5b7f01abd5','avatar.jpg','Mimi','','',0,'',0,2025,0,0), (90,'XXX','b59c67bf196a4758191e42f76670ceba','avatar.jpg','Tippitappi','','',0,'',0,2025,0,0), (89,'MMM','81dc9bdb52d04dc20036dbd8313ed055','avatar.jpg','Me Me','','',0,'',0,2025,0,0), (88,'MR6','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0), (87,'MR5','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0), (86,'MR4','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0), (85,'MR3','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0), (84,'MR2','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0), (83,'LAM','63025f4c12ddf046cedda090f5f9a16b','avatar.jpg','Lukas','Luki','lam@heimam.at',0,'',0,2024,0,0), (82,'MKS','2056d9f100427f8b63d97cac45eafd6b','avatar.jpg','MM','MM','markus.mascelli@outlook.com',0,'',0,2024,0,0), (81,'MSC','9f7c614ab986dbaa38039ab6788613ae','avatar.jpg','M','M','mascelli@gmail.com',0,'',0,2024,0,0), (80,'MAS','42cfb30b1843bc8b844f186abebd9fcd','avatar.jpg','M','MM','markus.mascelli@cancom.com',0,'',0,2024,0,0), (98,'MR7','cda0fd2918d19e20ac871ed79a8d2bb0','avatar.jpg','Martha','','',0,'',0,2025,0,0); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `winners` -- DROP TABLE IF EXISTS `winners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `winners` ( `w_season` int(4) NOT NULL DEFAULT 0, `w_u_id` int(4) NOT NULL DEFAULT 0, PRIMARY KEY (`w_season`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `winners` -- LOCK TABLES `winners` WRITE; /*!40000 ALTER TABLE `winners` DISABLE KEYS */; INSERT INTO `winners` VALUES (2006,2), (2007,2), (2008,10), (2009,1), (2010,3), (2011,1), (2012,18), (2013,2), (2014,1), (2015,7), (2016,1), (2017,18), (2018,1), (2019,1), (2020,1), (2021,1), (2022,1), (2023,37); /*!40000 ALTER TABLE `winners` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-08-01 2:00:28