-- MySQL dump 10.13 Distrib 5.6.25, for Win32 (x86) -- -- Host: localhost Database: niki_2009 -- ------------------------------------------------------ -- Server version 5.6.36 /*!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 utf8 */; /*!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 `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(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 AUTO_INCREMENT=39 DEFAULT CHARSET=latin1; /*!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,'HAMILTON','Lewis'),(2,'KOVALAINEN','Heikki'),(3,'MASSA','Felipe'),(4,'RAIKKONEN','Kimi'),(5,'KUBICA','Robert'),(6,'HEIDFELD','Nick'),(7,'ALONSO','Fernando'),(8,'PIQUET','Nelson Jr.'),(9,'TRULLI','Jarno'),(10,'GLOCK','Timo'),(11,'BOURDAIS','Sebastien'),(12,'BUEMI','Sebastien'),(14,'WEBBER','Mark'),(15,'VETTEL','Sebastian'),(16,'ROSBERG','Nico'),(17,'NAKAJIMA','Kazuki'),(18,'SUTIL','Adrian'),(19,'FISICHELLA','Giancarlo'),(20,'BUTTON','Jenson'),(21,'BARRICHELLO','Rubens'),(22,'DE LA ROSA','Pedro'),(23,'PAFFETT','Gary'),(24,'BADOER','Luca'),(25,'GENE','Marc'),(26,'KLIEN','Christian'),(27,'GROSJEAN','Romain'),(28,'KOBAYASHI','Kamui'),(29,'HUELKENBERG','Nico'),(30,'LIUZZI','Vitantonio'),(31,'DAVIDSON','Anthony'),(32,'HARTLEY','Brendon'),(33,'ALGUERSUARI','Jaime'),(34,'SCHUMACHER','Michael'); /*!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(11) NOT NULL AUTO_INCREMENT, `e_type` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`e_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!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'); /*!40000 ALTER TABLE `events` 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(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 AUTO_INCREMENT=34 DEFAULT CHARSET=latin1; /*!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 (1,'AUSTRALIA (Melbourne)','2009-03-28 07:00:00','2009-03-29 08:00:00','flag_AUSTRALIA.gif','circuit_AUSTRALIA.gif'),(2,'MALAYSIA (Sepang)','2009-04-04 11:00:00','2009-04-05 11:00:00','flag_MALAYSIA.gif','circuit_MALAYSIA.gif'),(3,'CHINA (Shanghai)','2009-04-18 08:00:00','2009-04-19 09:00:00','flag_CHINA.gif','circuit_CHINA.gif'),(4,'BAHRAIN (Sakhir)','2009-04-25 13:00:00','2009-04-26 14:00:00','flag_BAHRAIN.gif','circuit_BAHRAIN.gif'),(5,'SPAIN (Barcelona)','2009-05-09 14:00:00','2009-05-10 14:00:00','flag_SPAIN.gif','circuit_SPAIN_(Barcelona).gif'),(6,'MONACO (Monte Carlo)','2009-05-23 14:00:00','2009-05-24 14:00:00','flag_MONACO.gif','circuit_MONACO.gif'),(7,'TURKEY (Istanbul)','2009-06-06 13:00:00','2009-06-07 14:00:00','flag_TURKEY.gif','circuit_TURKEY.gif'),(8,'GREAT BRITAIN (Silverstone)','2009-06-20 14:00:00','2009-06-21 14:00:00','flag_UK.gif','circuit_UK.gif'),(9,'GERMANY (Nuerburgring)','2009-07-11 14:00:00','2009-07-12 14:00:00','flag_GERMANY.gif','circuit_GERMANY_(Nuerburgring).gif'),(10,'HUNGARY (Budapest)','2009-07-25 14:00:00','2009-07-26 14:00:00','flag_HUNGARY.gif','circuit_HUNGARY.gif'),(11,'EUROPE (Valencia)','2009-08-22 14:00:00','2009-08-23 14:00:00','flag_EUROPE.gif','circuit_EUROPE_(Valencia).gif'),(12,'BELGIUM (Spa)','2009-08-29 14:00:00','2009-08-30 14:00:00','flag_BELGIUM.gif','circuit_BELGIUM.gif'),(13,'ITALY (Monza)','2009-09-12 14:00:00','2009-09-13 14:00:00','flag_ITALY.gif','circuit_ITALY.gif'),(14,'SINGAPORE (Singapore)','2009-09-26 16:00:00','2009-09-27 14:00:00','flag_SINGAPORE.gif','circuit_SINGAPORE.gif'),(15,'JAPAN (Suzuka)','2009-10-03 07:00:00','2009-10-04 07:00:00','flag_JAPAN.gif','circuit_JAPAN_(Suzuka).gif'),(16,'BRAZIL (Sao Paulo)','2009-10-17 19:00:00','2009-10-18 18:00:00','flag_BRAZIL.gif','circuit_BRAZIL.gif'),(17,'UNITED ARAB EMIRATES (Abu Dhabi)','2009-10-31 14:00:00','2009-11-01 14:00:00','flag_UAE.gif','circuit_UAE.gif'); /*!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(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; /*!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 (1,1,20,21,15,0,-1),(1,2,20,21,9,16,1),(2,1,20,9,15,0,-1),(2,2,20,6,10,20,1),(3,1,15,7,14,0,-1),(3,2,15,14,20,21,1),(4,1,9,10,15,0,-1),(4,2,20,15,9,9,0),(5,1,20,15,21,0,-1),(5,2,20,21,14,21,1),(6,1,20,4,21,0,-1),(6,2,20,21,4,3,0),(7,1,15,20,21,0,-1),(7,2,20,14,15,20,0),(8,1,15,21,14,0,-1),(8,2,15,14,21,15,0),(9,1,14,21,20,0,-1),(9,2,14,15,3,7,0),(10,1,7,15,14,0,-1),(10,2,1,4,14,14,0),(11,1,1,2,21,0,-1),(11,2,21,1,4,10,0),(12,1,19,9,6,0,-1),(12,2,4,19,15,15,1),(13,1,1,18,4,0,-1),(13,2,21,20,4,18,1),(14,1,1,15,16,0,-1),(14,2,1,10,7,7,1),(15,1,15,9,1,0,-1),(15,2,15,9,1,14,1),(16,1,21,14,18,0,-1),(16,2,14,5,1,14,1),(17,1,1,15,14,0,-1),(17,2,15,14,20,15,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(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; /*!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 (9,1,1,16,21,17,0,0,'2009-03-27 12:12:15',2),(8,1,1,16,21,4,0,0,'2009-03-27 12:29:24',2),(13,1,1,20,4,21,0,0,'2009-03-27 14:50:53',3),(3,1,1,20,16,21,0,0,'2009-03-27 17:14:11',3),(7,1,1,4,16,21,0,0,'2009-03-27 18:37:55',1),(1,1,1,4,21,3,0,0,'2009-03-27 19:37:59',2),(10,1,1,4,3,21,0,0,'2009-03-27 21:42:18',1),(11,1,1,4,1,2,0,0,'2009-03-27 21:53:49',0),(12,1,1,4,1,3,0,0,'2009-03-27 22:27:49',0),(3,1,2,21,20,15,21,-1,'2009-03-28 09:30:16',2),(1,1,2,21,20,15,21,1,'2009-03-28 15:03:03',3),(7,1,2,20,15,21,20,-1,'2009-03-28 17:13:40',3),(9,1,2,21,20,16,10,-1,'2009-03-28 19:23:36',2),(8,1,2,16,20,5,16,1,'2009-03-28 19:26:54',3),(13,1,2,20,21,5,20,-1,'2009-03-28 22:10:28',4),(11,1,2,21,15,5,21,0,'2009-03-28 22:15:28',0),(12,1,2,20,9,5,20,-1,'2009-03-28 22:21:07',3),(10,1,2,20,15,3,20,-1,'2009-03-28 22:26:16',2),(2,1,2,20,21,15,21,0,'2009-03-29 07:50:37',3),(14,2,2,21,20,4,20,0,'2009-04-03 09:44:06',1),(14,2,1,20,21,4,0,0,'2009-04-03 09:44:37',2),(12,2,1,20,5,1,0,0,'2009-04-03 11:47:03',2),(13,2,1,20,4,16,0,0,'2009-04-03 13:01:42',2),(3,2,1,20,21,4,0,0,'2009-04-03 16:39:07',2),(9,2,1,3,20,4,0,0,'2009-04-03 20:08:48',1),(8,2,1,3,16,20,0,0,'2009-04-03 20:11:15',1),(4,2,1,20,16,3,0,0,'2009-04-03 22:03:55',2),(7,2,1,4,3,15,0,0,'2009-04-03 23:39:28',2),(1,2,1,4,21,3,0,0,'2009-04-04 10:34:03',0),(11,2,1,3,14,9,0,0,'2009-04-04 10:34:36',1),(2,2,1,3,20,16,0,0,'2009-04-04 10:35:59',1),(10,2,1,4,15,3,0,0,'2009-04-04 10:37:26',1),(3,2,2,20,9,4,20,-1,'2009-04-04 14:27:34',3),(9,2,2,20,5,16,21,-1,'2009-04-04 18:33:21',2),(8,2,2,9,20,16,20,1,'2009-04-04 21:24:20',3),(7,2,2,20,15,21,20,-1,'2009-04-04 22:31:08',3),(4,2,2,9,20,16,20,1,'2009-04-05 07:32:20',3),(13,2,2,20,9,5,15,-1,'2009-04-05 08:06:45',2),(2,2,2,20,9,21,21,1,'2009-04-05 10:20:57',3),(1,2,2,20,9,5,21,0,'2009-04-05 10:31:11',1),(11,2,2,20,9,16,20,1,'2009-04-05 10:33:32',4),(12,2,2,20,9,5,9999,-1,'2009-04-05 10:34:59',2),(10,2,2,20,5,9,16,-1,'2009-04-05 10:36:56',2),(13,3,1,20,21,9,0,0,'2009-04-17 14:16:27',0),(3,3,1,20,21,9,0,0,'2009-04-17 16:26:12',0),(1,3,1,20,21,15,0,0,'2009-04-17 22:43:44',1),(11,3,1,20,21,16,0,0,'2009-04-17 22:44:24',0),(8,3,1,20,15,16,0,0,'2009-04-17 22:49:07',1),(9,3,1,20,21,14,0,0,'2009-04-17 22:49:40',2),(7,3,1,20,16,21,0,0,'2009-04-17 23:47:26',0),(10,3,1,15,20,9,0,0,'2009-04-18 00:24:17',2),(12,3,1,20,9,21,0,0,'2009-04-18 00:25:22',0),(2,3,1,20,9,21,0,0,'2009-04-18 07:52:47',0),(3,3,2,14,20,21,20,-1,'2009-04-18 10:10:30',2),(1,3,2,15,20,21,16,0,'2009-04-18 12:38:36',2),(8,3,2,15,16,20,4,-1,'2009-04-18 18:13:19',4),(9,3,2,21,20,16,15,-1,'2009-04-18 18:15:23',1),(7,3,2,15,7,20,15,-1,'2009-04-18 18:39:31',4),(13,3,2,7,9,20,16,1,'2009-04-18 18:54:24',3),(11,3,2,15,20,21,7,0,'2009-04-18 23:10:34',2),(4,3,2,7,15,20,7,1,'2009-04-19 07:20:39',4),(2,3,2,20,15,21,20,1,'2009-04-19 08:50:15',3),(10,3,2,15,20,21,15,1,'2009-04-19 08:53:59',4),(12,3,2,20,15,21,14,1,'2009-04-19 08:54:49',3),(14,4,1,21,15,20,0,0,'2009-04-24 17:45:12',1),(14,4,2,21,10,15,20,1,'2009-04-24 17:45:45',0),(7,4,1,15,20,14,0,0,'2009-04-24 19:15:56',1),(13,4,1,20,15,9,0,0,'2009-04-24 21:38:14',2),(3,4,1,20,15,9,0,0,'2009-04-25 08:49:52',2),(9,4,1,15,14,20,0,0,'2009-04-25 10:02:13',1),(8,4,1,15,16,21,0,0,'2009-04-25 10:02:40',1),(4,4,1,16,20,1,0,0,'2009-04-25 10:56:38',0),(1,4,1,20,21,15,0,0,'2009-04-25 12:15:11',2),(2,4,1,9,20,3,0,0,'2009-04-25 12:42:30',2),(12,4,1,20,14,21,0,0,'2009-04-25 12:44:04',0),(11,4,1,15,20,1,0,0,'2009-04-25 12:47:02',1),(10,4,1,15,20,21,0,0,'2009-04-25 12:48:38',1),(3,4,2,15,9,20,15,-1,'2009-04-25 16:18:19',3),(9,4,2,15,20,9,16,-1,'2009-04-25 18:11:24',4),(8,4,2,1,21,10,9,0,'2009-04-25 18:12:05',2),(7,4,2,15,9,1,15,-1,'2009-04-26 04:04:48',2),(1,4,2,15,20,9,10,0,'2009-04-26 07:11:00',5),(4,4,2,9,21,15,15,1,'2009-04-26 07:59:04',1),(13,4,2,15,20,10,15,-1,'2009-04-26 08:46:27',2),(2,4,2,15,9,20,15,0,'2009-04-26 12:42:55',4),(11,4,2,15,20,9,9,0,'2009-04-26 13:09:55',6),(12,4,2,15,10,20,14,-1,'2009-04-26 13:37:30',2),(10,4,2,15,20,9,15,-1,'2009-04-26 13:39:03',4),(9,5,1,20,14,16,0,0,'2009-05-08 19:56:33',2),(8,5,1,20,7,17,0,0,'2009-05-08 19:57:25',2),(4,5,1,5,20,15,0,0,'2009-05-08 22:31:29',2),(7,5,1,20,21,10,0,0,'2009-05-08 22:55:23',3),(13,5,1,20,21,16,0,0,'2009-05-09 10:19:36',3),(3,5,1,20,15,9,0,0,'2009-05-09 10:29:56',4),(11,5,1,20,4,1,0,0,'2009-05-09 13:23:51',2),(10,5,1,20,4,3,0,0,'2009-05-09 13:35:53',2),(12,5,1,20,4,3,0,0,'2009-05-09 13:36:15',2),(1,5,1,20,9,15,0,0,'2009-05-09 13:39:20',3),(2,5,1,20,3,9,0,0,'2009-05-09 13:56:19',2),(7,5,2,20,15,21,20,-1,'2009-05-09 15:30:16',3),(3,5,2,20,15,21,15,-1,'2009-05-09 17:24:27',3),(9,5,2,20,15,14,15,0,'2009-05-09 20:01:02',3),(8,5,2,20,21,15,21,-1,'2009-05-09 20:01:30',5),(1,5,2,20,15,3,20,0,'2009-05-10 00:03:01',1),(11,5,2,20,15,21,20,0,'2009-05-10 00:34:30',2),(4,5,2,20,3,15,20,0,'2009-05-10 06:28:29',1),(13,5,2,15,20,3,15,-1,'2009-05-10 09:01:09',1),(10,5,2,15,20,3,3,-1,'2009-05-10 11:42:39',1),(12,5,2,20,15,21,15,-1,'2009-05-10 11:43:37',3),(2,5,2,15,20,21,9999,-1,'2009-05-10 12:52:18',2),(15,6,2,15,20,14,15,1,'2009-05-11 15:39:10',0),(15,6,1,20,14,15,0,0,'2009-05-11 15:39:35',2),(13,6,1,15,20,3,0,0,'2009-05-22 09:32:50',1),(7,6,1,20,21,1,0,0,'2009-05-22 22:14:12',3),(4,6,1,3,21,20,0,0,'2009-05-23 07:37:10',2),(8,6,1,16,21,1,0,0,'2009-05-23 07:49:12',1),(9,6,1,20,3,21,0,0,'2009-05-23 07:50:15',4),(3,6,1,20,21,15,0,0,'2009-05-23 12:49:43',3),(12,6,1,9,15,3,0,0,'2009-05-23 13:17:46',0),(10,6,1,15,14,3,0,0,'2009-05-23 13:24:45',0),(1,6,1,21,15,20,0,0,'2009-05-23 13:33:09',2),(11,6,1,21,3,20,0,0,'2009-05-23 13:33:59',2),(2,6,1,20,21,16,0,0,'2009-05-23 13:55:06',3),(9,6,2,20,21,15,15,-1,'2009-05-23 16:16:15',4),(8,6,2,20,21,4,4,1,'2009-05-23 16:16:53',5),(3,6,2,20,4,21,15,-1,'2009-05-23 18:08:01',4),(13,6,2,20,4,21,20,-1,'2009-05-24 11:16:34',4),(1,6,2,20,21,4,20,1,'2009-05-24 12:57:07',5),(11,6,2,20,21,4,4,1,'2009-05-24 12:57:48',5),(10,6,2,21,20,4,21,1,'2009-05-24 13:15:49',3),(4,6,2,20,15,3,20,1,'2009-05-24 13:39:43',1),(12,6,2,20,15,21,9999,-1,'2009-05-24 13:44:08',3),(2,6,2,20,21,4,20,1,'2009-05-24 13:48:42',5),(14,7,2,15,20,6,20,0,'2009-06-05 09:21:10',4),(14,7,1,20,21,15,0,0,'2009-06-05 09:21:57',3),(15,7,1,20,4,15,0,0,'2009-06-05 16:13:26',2),(7,7,1,20,21,4,0,0,'2009-06-05 16:49:21',2),(13,7,1,15,20,21,0,0,'2009-06-05 22:09:11',6),(3,7,1,20,3,15,0,0,'2009-06-06 11:37:17',2),(10,7,1,3,9,20,0,0,'2009-06-06 12:21:21',1),(2,7,1,3,21,20,0,0,'2009-06-06 12:39:18',2),(12,7,1,20,3,15,0,0,'2009-06-06 12:55:29',2),(9,7,1,20,15,21,0,0,'2009-06-06 09:00:00',4),(3,7,2,20,15,21,15,-1,'2009-06-06 17:15:58',3),(9,7,2,20,21,15,20,-1,'2009-06-06 19:12:00',5),(7,7,2,20,15,14,20,-1,'2009-06-06 22:55:35',5),(8,7,2,20,9,15,3,-1,'2009-06-07 09:40:37',4),(13,7,2,15,20,21,15,0,'2009-06-07 10:06:38',3),(11,7,2,15,20,4,3,-1,'2009-06-07 12:22:18',2),(12,7,2,15,20,21,14,-1,'2009-06-07 12:48:40',2),(10,7,2,20,15,14,14,0,'2009-06-07 12:50:45',5),(1,7,2,15,20,14,4,0,'2009-06-07 13:26:51',4),(2,7,2,20,15,21,21,0,'2009-06-07 13:57:22',4),(14,8,1,4,20,21,0,0,'2009-06-19 10:55:12',1),(14,8,2,20,15,1,20,0,'2009-06-19 10:56:16',2),(9,8,1,15,20,14,0,0,'2009-06-19 21:00:01',4),(7,8,1,15,20,14,0,0,'2009-06-19 21:04:19',4),(13,8,1,20,15,14,0,0,'2009-06-20 06:37:20',3),(4,8,1,15,20,14,0,0,'2009-06-20 08:51:13',4),(11,8,1,20,15,14,0,0,'2009-06-20 09:24:15',3),(1,8,1,15,20,14,0,0,'2009-06-20 09:25:00',4),(3,8,1,15,20,14,0,0,'2009-06-20 09:36:53',4),(8,8,1,16,15,9,0,0,'2009-06-20 12:30:16',1),(10,8,1,15,20,14,0,0,'2009-06-20 13:44:49',4),(12,8,1,15,20,14,0,0,'2009-06-20 13:45:54',4),(2,8,1,15,20,9,0,0,'2009-06-20 13:57:23',2),(15,8,1,15,20,4,0,0,'2009-06-20 13:59:58',2),(7,8,2,15,14,20,15,0,'2009-06-20 15:57:12',6),(3,8,2,15,14,21,21,0,'2009-06-20 17:17:26',7),(1,8,2,15,14,21,15,0,'2009-06-20 18:29:17',8),(9,8,2,14,20,15,20,-1,'2009-06-20 20:19:03',2),(11,8,2,15,14,20,15,0,'2009-06-20 23:17:35',6),(10,8,2,15,14,20,14,-1,'2009-06-21 10:48:05',4),(4,8,2,15,14,21,15,1,'2009-06-21 10:54:09',6),(12,8,2,15,21,20,20,-1,'2009-06-21 10:58:54',3),(13,8,2,15,14,20,15,-1,'2009-06-21 11:14:25',5),(15,8,2,15,14,9,20,1,'2009-06-21 12:47:25',3),(8,8,2,14,15,9,14,1,'2009-06-21 12:59:53',1),(2,8,2,15,14,21,15,0,'2009-06-21 13:38:31',8),(16,9,1,20,15,21,0,0,'2009-06-22 12:11:54',2),(7,9,1,15,14,20,0,0,'2009-07-10 17:10:17',3),(8,9,1,15,20,14,0,0,'2009-07-11 09:45:27',2),(9,9,1,15,14,20,0,0,'2009-07-11 09:46:25',3),(12,9,1,15,3,14,0,0,'2009-07-11 12:14:10',1),(10,9,1,15,14,3,0,0,'2009-07-11 12:17:26',1),(3,9,1,15,20,14,0,0,'2009-07-11 12:20:39',2),(13,9,1,15,14,20,0,0,'2009-07-11 11:49:21',3),(1,9,1,15,20,14,0,0,'2009-07-11 12:56:26',2),(11,9,1,20,15,1,0,0,'2009-07-11 12:57:32',1),(3,9,2,14,20,15,15,-1,'2009-07-11 17:14:32',3),(9,9,2,20,21,15,20,0,'2009-07-11 20:26:08',2),(7,9,2,14,20,15,14,1,'2009-07-11 22:10:59',2),(1,9,2,14,20,15,14,1,'2009-07-11 22:58:49',2),(8,9,2,14,15,20,1,-1,'2009-07-12 08:37:05',4),(13,9,2,14,15,20,15,-1,'2009-07-12 09:14:50',4),(4,9,2,20,21,14,20,1,'2009-07-12 11:24:31',0),(10,9,2,14,15,20,14,-1,'2009-07-12 12:23:17',4),(12,9,2,14,15,20,14,-1,'2009-07-12 12:24:16',4),(11,9,2,15,14,20,14,0,'2009-07-12 13:26:03',3),(2,9,2,14,15,21,15,0,'2009-07-12 13:50:19',5),(16,10,1,14,15,21,0,0,'2009-07-13 11:22:16',3),(16,10,2,15,20,9,20,0,'2009-07-13 11:23:20',1),(7,10,1,14,20,2,0,0,'2009-07-24 18:07:27',1),(13,10,1,20,16,15,0,0,'2009-07-24 19:10:50',1),(3,10,1,20,15,14,0,0,'2009-07-25 09:29:30',4),(10,10,1,14,15,21,0,0,'2009-07-25 10:45:00',3),(12,10,1,14,3,15,0,0,'2009-07-25 10:45:49',2),(8,10,1,1,2,16,0,0,'2009-07-25 12:15:04',0),(9,10,1,14,1,9,0,0,'2009-07-25 12:16:02',1),(1,10,1,14,15,1,0,0,'2009-07-25 12:24:04',3),(11,10,1,1,16,20,0,0,'2009-07-25 13:28:50',0),(2,10,1,1,14,15,0,0,'2009-07-25 13:52:00',2),(3,10,2,15,14,7,20,0,'2009-07-25 16:22:49',2),(9,10,2,14,15,1,1,-1,'2009-07-25 17:39:23',2),(7,10,2,15,14,1,15,0,'2009-07-25 17:41:14',3),(1,10,2,15,14,1,15,0,'2009-07-26 07:52:08',3),(13,10,2,15,14,7,0,-1,'2009-07-26 10:51:49',1),(10,10,2,15,14,20,14,-1,'2009-07-26 12:43:49',2),(12,10,2,15,14,1,7,-1,'2009-07-26 12:46:04',2),(4,10,2,7,15,14,15,1,'2009-07-26 13:05:49',1),(8,10,2,14,15,16,7,0,'2009-07-26 13:35:24',2),(11,10,2,15,14,1,7,1,'2009-07-26 13:44:42',1),(2,10,2,15,14,7,15,0,'2009-07-26 13:53:21',2),(16,11,2,14,4,34,21,1,'2009-07-30 10:36:51',0),(16,11,1,20,14,15,0,0,'2009-07-30 10:37:03',0),(14,11,1,14,20,15,0,0,'2009-08-21 15:36:32',0),(14,11,2,15,14,21,15,0,'2009-08-21 15:37:31',2),(7,11,1,15,14,20,0,0,'2009-08-21 15:40:59',0),(9,11,1,21,20,7,0,0,'2009-08-22 08:29:45',1),(13,11,1,7,20,15,0,0,'2009-08-22 10:04:49',0),(3,11,1,7,1,20,0,0,'2009-08-22 12:52:10',1),(8,11,1,17,5,2,0,0,'2009-08-22 13:02:56',1),(1,11,1,1,14,20,0,0,'2009-08-22 13:34:57',2),(11,11,1,20,21,1,0,0,'2009-08-22 13:43:52',2),(2,11,1,7,20,1,0,0,'2009-08-22 13:57:13',1),(3,11,2,1,2,20,14,-1,'2009-08-22 15:57:36',1),(7,11,2,1,2,15,1,0,'2009-08-22 20:20:26',2),(9,11,2,1,20,2,1,-1,'2009-08-22 20:44:45',1),(13,11,2,1,2,15,1,1,'2009-08-22 20:47:39',0),(1,11,2,1,21,4,1,0,'2009-08-23 12:07:20',5),(8,11,2,1,21,20,2,0,'2009-08-23 12:24:44',3),(11,11,2,1,15,21,1,-1,'2009-08-23 12:29:07',2),(4,11,2,1,21,15,21,0,'2009-08-23 12:35:18',3),(12,11,2,1,21,20,1,-1,'2009-08-23 13:50:43',2),(10,11,2,21,1,4,16,-1,'2009-08-23 13:53:29',6),(2,11,2,1,21,20,21,1,'2009-08-23 13:58:31',1),(16,12,1,21,1,14,0,0,'2009-08-24 11:09:04',0),(16,12,2,1,21,20,21,1,'2009-08-24 11:09:44',1),(14,12,2,15,21,4,15,0,'2009-08-26 15:17:46',2),(14,12,1,21,15,14,0,0,'2009-08-26 15:18:16',0),(13,12,1,4,15,1,0,0,'2009-08-28 21:11:46',0),(3,12,1,15,14,1,0,0,'2009-08-29 09:36:50',0),(9,12,1,9,1,10,0,0,'2009-08-29 12:24:53',1),(2,12,1,15,1,14,0,0,'2009-08-29 12:35:20',0),(8,12,1,1,20,4,0,0,'2009-08-29 12:38:13',0),(1,12,1,1,20,4,0,0,'2009-08-29 13:01:34',0),(11,12,1,1,20,15,0,0,'2009-08-29 13:04:57',0),(10,12,1,15,4,1,0,0,'2009-08-29 13:49:37',0),(12,12,1,15,4,1,0,0,'2009-08-29 13:50:15',0),(3,12,2,21,4,9,14,-1,'2009-08-29 18:37:13',1),(7,12,2,21,6,4,21,-1,'2009-08-29 21:19:06',1),(1,12,2,6,9,4,10,0,'2009-08-30 07:05:45',0),(13,12,2,9,6,4,15,-1,'2009-08-30 10:41:04',2),(9,12,2,9,21,4,4,-1,'2009-08-30 10:48:57',1),(8,12,2,9,5,21,19,0,'2009-08-30 12:19:14',-1),(11,12,2,6,5,4,4,0,'2009-08-30 13:31:20',0),(12,12,2,21,4,9,4,-1,'2009-08-30 13:32:06',1),(10,12,2,4,1,15,21,-1,'2009-08-30 13:34:22',4),(2,12,2,4,9,6,19,0,'2009-08-30 13:49:04',1),(16,13,1,4,14,15,0,0,'2009-08-31 11:11:42',1),(16,13,2,4,15,14,15,1,'2009-08-31 11:12:14',2),(3,13,1,1,15,4,0,0,'2009-09-12 09:56:30',4),(9,13,1,1,15,10,0,0,'2009-09-12 10:57:25',2),(7,13,1,1,2,18,0,0,'2009-09-12 11:26:13',3),(14,13,1,21,19,1,0,0,'2009-09-12 12:24:56',1),(14,13,2,4,15,21,15,0,'2009-09-12 12:25:33',1),(13,13,1,4,7,1,0,0,'2009-09-12 12:31:19',2),(8,13,1,6,20,1,0,0,'2009-09-12 12:40:20',1),(11,13,1,1,20,21,0,0,'2009-09-12 13:19:58',2),(1,13,1,1,18,20,0,0,'2009-09-12 13:33:53',4),(2,13,1,18,20,1,0,0,'2009-09-12 13:57:50',2),(7,13,2,1,4,18,1,-1,'2009-09-12 16:10:03',1),(13,13,2,1,4,2,4,-1,'2009-09-12 20:24:34',1),(11,13,2,1,4,2,4,-1,'2009-09-12 22:28:30',1),(1,13,2,1,4,2,4,1,'2009-09-13 08:50:48',2),(9,13,2,1,2,21,18,-1,'2009-09-13 09:33:22',2),(3,13,2,1,4,20,21,0,'2009-09-13 10:37:31',1),(4,13,2,1,4,21,4,1,'2009-09-13 13:09:08',3),(8,13,2,1,4,20,1,1,'2009-09-13 13:53:51',3),(13,14,1,1,15,20,0,0,'2009-09-26 10:07:27',4),(4,14,1,15,7,6,0,0,'2009-09-26 10:40:43',1),(9,14,1,15,20,2,0,0,'2009-09-26 12:24:46',1),(1,14,1,15,1,21,0,0,'2009-09-26 14:20:41',2),(11,14,1,1,15,5,0,0,'2009-09-26 14:22:12',4),(8,14,1,1,15,2,0,0,'2009-09-26 14:28:24',4),(3,14,1,1,15,2,0,0,'2009-09-26 14:44:06',4),(10,14,1,1,15,21,0,0,'2009-09-26 15:35:39',4),(12,14,1,1,15,21,0,0,'2009-09-26 15:55:52',4),(7,14,2,1,15,14,1,1,'2009-09-26 17:41:47',3),(3,14,2,1,15,14,14,1,'2009-09-26 18:50:16',3),(9,14,2,1,15,14,16,1,'2009-09-26 20:07:49',3),(4,14,2,1,16,15,1,1,'2009-09-27 08:21:37',3),(1,14,2,1,14,15,7,1,'2009-09-27 08:38:18',4),(13,14,2,1,15,16,15,-1,'2009-09-27 08:42:22',2),(11,14,2,1,15,14,1,-1,'2009-09-27 11:35:23',2),(8,14,2,1,15,21,1,1,'2009-09-27 13:37:40',3),(10,14,2,1,16,4,16,-1,'2009-09-27 13:51:56',2),(12,14,2,1,15,16,16,1,'2009-09-27 13:54:04',3),(16,15,1,20,15,7,0,0,'2009-10-02 14:14:17',1),(16,15,2,14,1,6,14,0,'2009-10-02 14:15:19',1),(13,15,1,1,15,16,0,0,'2009-10-02 14:41:49',2),(14,15,2,20,1,15,20,0,'2009-10-02 16:30:25',1),(14,15,1,20,15,4,0,0,'2009-10-02 16:30:51',1),(9,15,1,15,1,18,0,0,'2009-10-02 20:29:48',3),(11,15,1,1,21,15,0,0,'2009-10-02 21:18:19',2),(3,15,1,1,14,15,0,0,'2009-10-02 22:02:35',2),(12,15,1,15,21,9,0,0,'2009-10-03 06:18:41',3),(10,15,1,15,21,9,0,0,'2009-10-03 06:19:24',3),(1,15,1,15,4,16,0,0,'2009-10-03 06:38:09',2),(8,15,1,15,1,12,0,0,'2009-10-03 06:59:08',3),(3,15,2,15,1,9,20,-1,'2009-10-03 11:14:16',4),(7,15,2,15,1,18,15,-1,'2009-10-03 11:45:05',3),(11,15,2,15,1,21,15,1,'2009-10-03 19:10:26',4),(9,15,2,15,1,4,18,1,'2009-10-03 19:13:12',4),(1,15,2,15,1,4,15,1,'2009-10-03 19:25:11',4),(13,15,2,15,1,4,15,1,'2009-10-03 19:52:28',4),(8,15,2,9,15,21,9,1,'2009-10-03 21:25:08',3),(12,15,2,15,1,4,15,-1,'2009-10-04 06:46:34',3),(10,15,2,15,1,4,15,-1,'2009-10-04 06:48:09',3),(16,16,1,15,1,14,0,0,'2009-10-05 09:32:49',1),(16,16,2,15,1,20,15,0,'2009-10-05 09:33:20',0),(11,16,1,1,21,15,0,0,'2009-10-16 16:30:14',1),(13,16,1,14,15,1,0,0,'2009-10-16 20:55:52',1),(7,16,1,21,15,1,0,0,'2009-10-16 23:08:59',2),(7,16,2,21,14,9,15,-1,'2009-10-16 23:09:40',1),(9,16,1,21,14,15,0,0,'2009-10-17 14:56:32',4),(3,16,1,15,1,14,0,0,'2009-10-17 17:54:04',1),(4,16,1,14,15,21,0,0,'2009-10-17 18:41:32',2),(10,16,1,15,21,16,0,0,'2009-10-17 18:44:46',1),(12,16,1,15,21,16,0,0,'2009-10-17 18:45:53',1),(1,16,1,15,16,18,0,0,'2009-10-17 18:48:03',2),(4,16,2,21,14,4,14,1,'2009-10-18 09:11:46',3),(3,16,2,21,14,4,15,1,'2009-10-18 10:37:41',2),(13,16,2,21,14,18,15,-1,'2009-10-18 16:21:06',1),(10,16,2,14,21,4,14,-1,'2009-10-18 16:35:25',3),(12,16,2,21,14,4,14,-1,'2009-10-18 16:40:01',2),(9,16,2,21,14,5,15,1,'2009-10-18 16:50:35',3),(8,16,2,21,14,12,21,1,'2009-10-18 16:52:09',2),(1,16,2,21,4,9,14,1,'2009-10-18 17:02:01',2),(7,17,1,34,3,20,0,0,'2009-10-30 12:13:05',0),(7,17,2,34,20,3,34,-1,'2009-10-30 12:14:28',1),(13,17,1,14,2,16,0,0,'2009-10-30 19:40:06',1),(9,17,1,1,21,2,0,0,'2009-10-31 08:32:47',2),(8,17,1,21,18,14,0,0,'2009-10-31 08:33:24',2),(11,17,1,1,20,15,0,0,'2009-10-31 11:56:23',3),(3,17,1,1,20,2,0,0,'2009-10-31 12:47:54',2),(1,17,1,1,20,15,0,0,'2009-10-31 13:18:42',3),(10,17,1,1,20,21,0,0,'2009-10-31 13:54:16',2),(12,17,1,1,20,21,0,0,'2009-10-31 13:55:08',2),(3,17,2,1,14,21,1,0,'2009-10-31 18:54:27',3),(9,17,2,1,21,14,1,-1,'2009-10-31 19:32:04',1),(11,17,2,1,15,14,14,-1,'2009-10-31 22:40:07',2),(1,17,2,1,15,14,14,-1,'2009-11-01 08:17:21',2),(13,17,2,1,15,14,1,0,'2009-11-01 08:32:02',3),(8,17,2,1,14,21,1,-1,'2009-11-01 11:55:30',2),(10,17,2,15,1,14,14,-1,'2009-11-01 13:47:08',3),(12,17,2,15,1,14,14,-1,'2009-11-01 13:48:11',3),(4,17,2,1,14,15,1,1,'2009-11-01 13:54:32',2); /*!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 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 AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /*!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','5a9361b28ee51795f1e82d9054919034','pic_MAM.gif','Markus \r\n\r\nA. Mascelli','MAM','mam@heimam.at',0,'italian',4,2006,1),(2,'GUE','78918cecf8926d0cada4c5bc31af87a3','pic_GUE.gif','Guenther Schmidt','GueStar','guenther.schmidt@gmail.com',0,'austrian',0,2006,2),(3,'ZEI','8dad7cabce9c511bd4983e8dc96ea5da','pic_ZEI.gif','Christian Zeichmann','Zeichi','christian.zeichmann@inode.at',0,'austrian',0,2007,0),(4,'AFG','83384431390a14889c9955938bb5604f','pic_AFG.gif','Andrea F. Grohmann','','andrea.grohmann@chello.at',0,'austrian',0,2007,0),(6,'JIR','8522c2ccfd6fc5d242ed16d168401fad','avatar.jpg','Juergen Iser','','j.iser@gmx.at',0,'austrian',4,2008,0),(7,'KAI','e5f4d97a4961dea1184bbbe847b591f3','avatar.jpg','Roman Kailbach','Kailo','kailo@gmx.at',0,'austrian',1,2008,0),(8,'WOB','776ad0ef27acc0602c337dc2736f3a97','avatar.jpg','Wolfgang Boehm','WoB','wboehm@gmail.com',0,'austrian',0,2008,0),(9,'REG','776ad0ef27acc0602c337dc2736f3a97','avatar.jpg','Regina Boehm','','wboehm@gmail.com',0,'austrian',0,2008,0),(10,'ISA','3c4db9561aa2b8530d5c60014dbfbe86','pic_ISA.jpg','Ildiko K. Samu','sam','ildiko.samu@aon.at',0,'hungarian',4,2008,0),(11,'MRO','cda0fd2918d19e20ac871ed79a8d2bb0','pic_MRO.jpg','Martha Rossa','RoMa','rossama@yahoo.com',0,'austrian',1,2008,1),(12,'MPU','48d54f43c30a27137edb383de2605a86','avatar.jpg','Michael Puehringer','','michael.puehringer@atosorigin.com',0,'austrian',8,2008,0),(13,'RHA','9ced82c0515df69d4e3311f63d40ffa0','avatar.jpg','Robert Haller','','robert.haller@kabsi.at',0,'austrian',0,2008,0),(14,'FAN','33c2e20d31b3ae8f4564d7517738eb7d','extremeevil.gif','Georg Juren','Schurl','georg.juren@atosorigin.com',0,'austrian',21,2009,0),(15,'MBR','07b9a65e9a0a88cf4ebed5672f209277','avatar.jpg','Markus Brenner','','m.brenn@gmx.net',0,'austrian',0,2009,0),(16,'RSC','f9c17117b5b8dbf8cfa83d8057ee1a0b','schicht_roman.jpg','Roman Schicht','','rschicht@yahoo.com',0,'austrian',0,2009,0); /*!40000 ALTER TABLE `users` 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 2024-02-01 2:00:09