-- MySQL dump 10.13 Distrib 5.1.48, for Win32 (ia32) -- -- Host: localhost Database: niki_2008 -- ------------------------------------------------------ -- Server version 5.1.48-community /*!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,'RAIKKONEN','Kimi'),(2,'MASSA','Felipe'),(3,'HEIDFELD','Nick'),(4,'KUBICA','Robert'),(5,'ALONSO','Fernando'),(6,'PIQUET','Nelson Jr.'),(7,'ROSBERG','Nico'),(8,'NAKAJIMA','Kazuki'),(9,'COULTHARD','David'),(10,'WEBBER','Mark'),(11,'TRULLI','Jarno'),(12,'GLOCK','Timo'),(14,'BOURDAIS','Sebastien'),(15,'VETTEL','Sebastian'),(16,'BUTTON','Jenson'),(17,'BARRICHELLO','Rubens'),(18,'SATO','Takuma'),(19,'DAVIDSON','Anthony'),(20,'SUTIL','Adrian'),(21,'FISICHELLA','Giancarlo'),(22,'HAMILTON','Lewis'),(23,'KOVALAINEN','Heikki'),(24,'BADOER','Luca'),(25,'GENE','Marc'),(26,'KLIEN','Christian'),(27,'ASMER','Marko'),(28,'GROSJEAN','Romain'),(29,'DI GRASSI','Lucas'),(30,'YAMAMOTO','Sakon'),(31,'HUELKENBERG','Nico'),(32,'BUEMI','Sebastien'),(33,'KOBAYASHI','Kamui'),(34,'WURZ','Alexander'),(35,'ROSSITER','James'),(36,'LIUZZI','Vitantonio'),(37,'DE LA ROSA','Pedro'),(38,'PAFFETT','Gary'); /*!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=19 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)','2008-03-15 04:00:00','2008-03-16 05:30:00','flag_AUSTRALIA.gif','circuit_AUSTRALIA.gif'),(2,'MALAYSIA (Sepang)','2008-03-22 07:00:00','2008-03-23 08:00:00','flag_MALAYSIA.gif','circuit_MALAYSIA.gif'),(3,'BAHRAIN (Sakhir)','2008-04-05 13:00:00','2008-04-06 13:30:00','flag_BAHRAIN.gif','circuit_BAHRAIN.gif'),(4,'SPAIN (Barcelona)','2008-04-26 14:00:00','2008-04-27 14:00:00','flag_SPAIN.gif','circuit_SPAIN.gif'),(5,'TURKEY (Istanbul)','2008-05-10 13:00:00','2008-05-11 14:00:00','flag_TURKEY.gif','circuit_TURKEY.gif'),(6,'MONACO (Monte Carlo)','2008-05-24 14:00:00','2008-05-25 14:00:00','flag_MONACO.gif','circuit_MONACO.gif'),(7,'CANADA (Montreal)','2008-06-07 19:00:00','2008-06-08 19:00:00','flag_CANADA.gif','circuit_CANADA.gif'),(8,'FRANCE (Magny-Cours)','2008-06-21 14:00:00','2008-06-22 14:00:00','flag_FRANCE.gif','circuit_FRANCE.gif'),(9,'GREAT BRITAIN (Silverstone)','2008-07-05 14:00:00','2008-07-06 14:00:00','flag_UK.gif','circuit_UK.gif'),(10,'GERMANY (Hockenheim)','2008-07-19 14:00:00','2008-07-20 14:00:00','flag_GERMANY.gif','circuit_GERMANY_(Hockenheim).gif'),(11,'HUNGARY (Budapest)','2008-08-02 14:00:00','2008-08-03 14:00:00','flag_HUNGARY.gif','circuit_HUNGARY.gif'),(12,'EUROPE (Valencia)','2008-08-23 14:00:00','2008-08-24 14:00:00','flag_EUROPE.gif','circuit_EUROPE_(Valencia).gif'),(13,'BELGIUM (Spa)','2008-09-06 14:00:00','2008-09-07 14:00:00','flag_BELGIUM.gif','circuit_BELGIUM.gif'),(14,'ITALY (Monza)','2008-09-13 14:00:00','2008-09-14 14:00:00','flag_ITALY.gif','circuit_ITALY.gif'),(15,'SINGAPORE (Singapore)','2008-09-27 16:00:00','2008-09-28 14:00:00','flag_SINGAPORE.gif','circuit_SINGAPORE.gif'),(16,'JAPAN (Fuji)','2008-10-11 07:00:00','2008-10-12 06:30:00','flag_JAPAN.gif','circuit_JAPAN_(Fuji).gif'),(17,'CHINA (Shanghai)','2008-10-18 08:00:00','2008-10-19 09:00:00','flag_CHINA.gif','circuit_CHINA.gif'),(18,'BRASIL (Sao Paolo)','2008-11-01 17:00:00','2008-11-02 18:00:00','flag_BRASIL.gif','circuit_BRASIL.gif'); /*!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,22,4,23,0,-1),(1,2,22,3,7,23,1),(2,1,2,1,23,0,-1),(2,2,1,4,23,3,0),(3,1,4,2,22,0,-1),(3,2,2,1,4,23,0),(4,1,1,5,2,0,-1),(4,2,1,2,22,1,1),(5,1,2,23,22,0,-1),(5,2,2,22,1,1,1),(6,1,2,1,22,0,-1),(6,2,22,4,2,1,1),(7,1,22,4,1,0,-1),(7,2,4,3,9,1,1),(8,1,1,2,22,0,-1),(8,2,2,1,11,1,0),(9,1,23,10,1,0,-1),(9,2,22,3,17,1,0),(10,1,22,2,23,0,-1),(10,2,22,6,2,3,1),(11,1,22,23,2,0,-1),(11,2,23,12,1,1,0),(12,1,2,22,4,0,-1),(12,2,2,22,4,2,0),(13,1,22,2,23,0,-1),(13,2,2,3,22,1,0),(14,1,15,23,10,0,-1),(14,2,15,23,4,1,1),(15,1,2,22,1,0,-1),(15,2,5,7,22,1,1),(16,1,22,1,23,0,-1),(16,2,5,4,1,2,0),(17,1,22,1,2,0,-1),(17,2,22,2,1,22,0),(18,1,2,11,1,0,-1),(18,2,2,5,1,2,1); /*!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 (7,1,1,1,22,2,0,0,'2008-03-14 11:25:18',1),(3,1,1,1,22,2,0,0,'2008-03-14 16:46:45',1),(8,1,1,1,22,2,0,0,'2008-03-14 17:20:45',1),(6,1,2,22,2,23,1,0,'2008-03-15 12:47:15',1),(9,1,1,22,2,23,0,0,'2008-03-14 17:27:34',4),(9,1,2,22,2,23,15,-1,'2008-03-15 12:38:04',2),(10,1,1,22,1,2,0,0,'2008-03-14 19:51:43',2),(11,1,1,22,1,2,0,0,'2008-03-14 21:11:04',2),(1,1,1,1,22,2,0,0,'2008-03-15 03:48:00',1),(7,1,2,22,4,2,22,0,'2008-03-15 13:36:31',1),(8,1,2,22,2,4,1,-1,'2008-03-15 14:44:44',2),(3,1,2,22,2,4,22,0,'2008-03-15 14:48:53',1),(1,1,2,2,22,23,1,1,'2008-03-15 19:35:15',2),(12,1,2,22,4,2,9999,-1,'2008-03-15 20:11:25',2),(10,1,2,22,2,4,1,0,'2008-03-15 20:22:24',1),(11,1,2,22,2,23,22,-1,'2008-03-15 22:06:27',2),(2,1,2,22,23,2,1,0,'2008-03-16 04:49:25',1),(9,2,1,22,23,2,0,0,'2008-03-21 12:33:54',2),(8,2,1,2,22,1,0,0,'2008-03-21 14:39:44',3),(10,2,1,2,22,1,0,0,'2008-03-21 18:08:50',3),(3,2,1,22,1,2,0,0,'2008-03-21 18:18:08',3),(12,2,1,22,1,23,0,0,'2008-03-21 20:52:33',4),(7,2,1,22,23,1,0,0,'2008-03-21 21:04:24',2),(11,2,1,22,2,23,0,0,'2008-03-21 21:55:54',3),(6,2,1,22,2,1,0,0,'2008-03-22 00:22:21',2),(1,2,1,22,1,2,0,0,'2008-03-22 06:24:22',3),(2,2,1,2,1,3,0,0,'2008-03-22 06:56:56',4),(3,2,2,1,22,2,22,-1,'2008-03-22 10:39:35',2),(6,2,2,2,1,22,2,-1,'2008-03-22 11:30:36',1),(1,2,2,1,2,3,1,1,'2008-03-22 19:24:01',1),(9,2,2,2,4,3,22,1,'2008-03-22 19:30:22',1),(8,2,2,2,3,23,2,1,'2008-03-22 19:35:32',1),(10,2,2,1,2,22,1,1,'2008-03-22 20:31:47',1),(7,2,2,2,1,4,2,-1,'2008-03-22 20:45:57',2),(12,2,2,1,22,23,1,-1,'2008-03-22 21:51:38',4),(11,2,2,1,2,3,22,-1,'2008-03-22 23:24:55',2),(2,2,2,1,2,3,1,1,'2008-03-23 07:48:45',1),(3,3,1,1,2,22,0,0,'2008-04-03 13:06:05',4),(7,3,1,1,2,22,0,0,'2008-04-04 23:26:28',4),(9,3,1,2,1,23,0,0,'2008-04-05 09:05:49',1),(8,3,1,2,1,22,0,0,'2008-04-05 09:06:31',3),(6,3,1,2,1,23,0,0,'2008-04-05 11:20:07',1),(10,3,1,2,1,4,0,0,'2008-04-05 11:45:31',2),(12,3,1,1,22,2,0,0,'2008-04-05 11:46:24',2),(11,3,1,2,1,23,0,0,'2008-04-05 12:35:11',1),(1,3,1,2,1,23,0,0,'2008-04-05 12:35:45',1),(2,3,1,2,1,11,0,0,'2008-04-05 12:49:00',1),(6,3,2,2,1,4,4,-1,'2008-04-05 14:11:56',6),(9,3,2,22,4,1,2,-1,'2008-04-05 19:29:32',2),(3,3,2,2,1,22,1,-1,'2008-04-05 19:33:50',4),(8,3,2,22,1,3,23,-1,'2008-04-05 19:47:38',3),(1,3,2,2,22,1,2,0,'2008-04-05 23:14:09',4),(11,3,2,2,22,4,4,0,'2008-04-05 23:27:41',5),(7,3,2,1,4,22,23,-1,'2008-04-06 10:36:15',3),(10,3,2,1,4,22,23,0,'2008-04-06 12:02:21',4),(12,3,2,2,4,22,1,-1,'2008-04-06 12:23:17',3),(2,3,2,1,2,4,2,0,'2008-04-06 13:29:58',5),(3,4,1,1,2,4,0,0,'2008-04-25 18:29:02',3),(7,4,1,1,2,22,0,0,'2008-04-25 18:42:54',3),(8,4,1,1,2,22,0,0,'2008-04-26 11:51:12',3),(9,4,1,1,2,4,0,0,'2008-04-26 11:55:43',3),(12,4,1,2,1,22,0,0,'2008-04-26 13:15:35',2),(10,4,1,1,4,2,0,0,'2008-04-26 13:15:36',4),(6,4,1,1,4,23,0,0,'2008-04-26 13:25:06',2),(1,4,1,1,2,22,0,0,'2008-04-26 13:31:48',3),(11,4,1,1,2,22,0,0,'2008-04-26 13:33:53',3),(2,4,1,1,2,4,0,0,'2008-04-26 14:00:09',3),(6,4,2,1,2,5,2,-1,'2008-04-26 15:16:54',4),(3,4,2,1,2,4,4,-1,'2008-04-26 15:36:59',4),(1,4,2,1,2,4,2,0,'2008-04-26 16:05:35',3),(7,4,2,1,2,4,1,-1,'2008-04-27 04:06:09',5),(4,4,2,1,4,5,4,0,'2008-04-27 09:14:01',1),(9,4,2,1,2,4,3,0,'2008-04-27 10:27:06',3),(8,4,2,1,4,5,3,1,'2008-04-27 10:28:31',3),(11,4,2,1,2,4,4,0,'2008-04-27 12:22:13',3),(10,4,2,1,4,5,1,0,'2008-04-27 13:29:03',2),(12,4,2,1,4,22,2,-1,'2008-04-27 13:29:57',4),(2,4,2,1,2,4,1,0,'2008-04-27 13:54:40',4),(7,5,1,2,23,1,0,0,'2008-05-10 00:27:59',4),(13,5,1,2,1,23,0,0,'2008-05-10 09:43:40',3),(3,5,1,1,22,2,0,0,'2008-05-10 10:42:54',2),(8,5,1,2,23,1,0,0,'2008-05-10 11:19:02',4),(9,5,1,1,2,22,0,0,'2008-05-10 11:20:42',3),(2,5,1,22,1,4,0,0,'2008-05-10 12:58:00',1),(1,5,1,1,2,22,0,0,'2008-05-10 12:58:13',3),(11,5,1,1,22,2,0,0,'2008-05-10 12:59:26',2),(10,5,1,4,2,1,0,0,'2008-05-10 12:44:02',1),(12,5,1,1,2,22,0,0,'2008-05-10 12:44:18',3),(3,5,2,2,22,1,2,0,'2008-05-10 15:07:15',5),(11,5,2,2,22,1,2,-1,'2008-05-10 22:31:57',6),(7,5,2,2,23,22,2,-1,'2008-05-11 00:59:17',3),(13,5,2,1,2,22,9999,-1,'2008-05-11 08:05:23',3),(8,5,2,2,22,1,1,-1,'2008-05-11 08:44:42',7),(9,5,2,2,23,22,1,0,'2008-05-11 08:47:48',3),(1,5,2,2,1,22,2,-1,'2008-05-11 12:08:58',4),(12,5,2,2,1,23,1,-1,'2008-05-11 12:41:40',4),(10,5,2,2,1,22,1,0,'2008-05-11 12:42:51',4),(2,5,2,2,1,23,2,1,'2008-05-11 13:52:57',4),(3,6,1,1,22,2,0,0,'2008-05-22 18:16:53',3),(7,6,1,1,22,23,0,0,'2008-05-24 01:47:43',2),(4,6,1,1,22,2,0,0,'2008-05-24 06:53:43',3),(1,6,1,22,1,2,0,0,'2008-05-24 12:23:01',4),(11,6,1,22,1,2,0,0,'2008-05-24 12:35:38',4),(8,6,1,1,22,3,0,0,'2008-05-24 12:44:02',2),(9,6,1,22,23,7,0,0,'2008-05-24 12:45:08',1),(6,6,1,23,1,22,0,0,'2008-05-24 12:46:34',4),(13,6,1,22,5,1,0,0,'2008-05-24 12:50:39',2),(10,6,1,22,7,1,0,0,'2008-05-24 13:10:22',2),(12,6,1,23,22,1,0,0,'2008-05-24 13:12:03',2),(2,6,1,22,1,7,0,0,'2008-05-24 13:29:38',3),(2,6,2,22,1,23,22,1,'2008-05-24 13:30:10',3),(3,6,2,1,2,22,1,1,'2008-05-24 15:06:51',4),(7,6,2,1,22,2,1,1,'2008-05-25 03:27:23',5),(13,6,2,2,1,22,7,1,'2008-05-25 07:11:10',3),(4,6,2,1,2,22,1,0,'2008-05-25 10:55:47',2),(1,6,2,2,22,1,22,1,'2008-05-25 12:20:48',3),(11,6,2,2,1,22,1,1,'2008-05-25 12:30:48',4),(12,6,2,2,1,22,2,-1,'2008-05-25 13:35:00',2),(10,6,2,2,1,22,1,1,'2008-05-25 13:40:57',4),(9,6,2,2,22,23,2,-1,'2008-05-25 13:45:29',2),(8,6,2,1,2,4,7,1,'2008-05-25 13:47:05',3),(3,7,1,22,1,2,0,0,'2008-06-06 17:21:11',3),(13,7,1,22,2,1,0,0,'2008-06-07 14:36:36',4),(7,7,1,22,4,1,0,0,'2008-06-07 16:53:29',6),(11,7,1,22,1,2,0,0,'2008-06-07 17:34:22',3),(1,7,1,22,1,2,0,0,'2008-06-07 17:34:50',3),(9,7,1,1,22,2,0,0,'2008-06-07 17:59:04',2),(8,7,1,22,1,4,0,0,'2008-06-07 18:01:34',4),(12,7,1,2,22,1,0,0,'2008-06-07 18:22:00',3),(10,7,1,4,2,22,0,0,'2008-06-07 18:23:00',2),(1,7,2,22,1,4,22,1,'2008-06-07 20:25:02',2),(3,7,2,22,1,4,1,-1,'2008-06-07 20:31:38',2),(7,7,2,22,1,4,22,-1,'2008-06-07 23:11:17',1),(13,7,2,22,1,4,9999,-1,'2008-06-08 10:40:06',1),(2,7,2,22,4,1,22,1,'2008-06-08 11:51:50',2),(8,7,2,4,22,2,3,-1,'2008-06-08 16:32:20',2),(9,7,2,22,1,4,7,-1,'2008-06-08 16:35:46',1),(11,7,2,22,1,4,1,1,'2008-06-08 17:45:01',3),(10,7,2,22,1,4,4,1,'2008-06-08 18:52:25',2),(12,7,2,22,1,4,22,1,'2008-06-08 18:56:59',2),(7,8,1,2,22,23,0,0,'2008-06-20 14:05:43',2),(13,8,1,4,22,2,0,0,'2008-06-20 15:32:21',2),(11,8,1,2,1,22,0,0,'2008-06-20 19:47:20',4),(1,8,1,1,2,4,0,0,'2008-06-20 19:47:50',4),(3,8,1,2,1,23,0,0,'2008-06-21 12:17:38',2),(8,8,1,2,5,23,0,0,'2008-06-21 13:02:58',1),(9,8,1,1,2,4,0,0,'2008-06-21 13:03:31',4),(10,8,1,2,22,1,0,0,'2008-06-21 13:34:49',3),(2,8,1,1,22,5,0,0,'2008-06-21 13:51:51',3),(3,8,2,1,2,22,1,-1,'2008-06-21 15:27:18',3),(13,8,2,1,2,4,9999,-1,'2008-06-22 08:02:13',2),(1,8,2,1,2,4,1,1,'2008-06-22 09:58:57',2),(12,8,2,1,2,23,1,-1,'2008-06-22 12:09:18',3),(10,8,2,1,2,4,1,-1,'2008-06-22 12:12:49',3),(9,8,2,2,1,23,22,0,'2008-06-22 12:24:42',5),(8,8,2,2,5,23,22,-1,'2008-06-22 12:52:48',2),(11,8,2,1,2,4,1,0,'2008-06-22 13:03:09',4),(2,8,2,1,2,5,1,0,'2008-06-22 13:38:18',4),(7,8,2,1,2,4,1,0,'2008-06-22 13:43:26',4),(7,9,1,2,22,1,0,0,'2008-07-04 16:26:26',2),(3,9,1,2,22,1,0,0,'2008-07-04 18:53:06',2),(9,9,1,23,2,22,0,0,'2008-07-05 08:57:20',2),(8,9,1,2,22,23,0,0,'2008-07-05 09:13:12',1),(13,9,1,1,23,22,0,0,'2008-07-05 10:13:20',2),(10,9,1,2,1,22,0,0,'2008-07-05 10:20:53',1),(12,9,1,22,1,4,0,0,'2008-07-05 10:21:30',1),(11,9,1,22,2,23,0,0,'2008-07-05 12:22:26',1),(1,9,1,22,2,1,0,0,'2008-07-05 12:40:10',2),(2,9,1,2,22,1,0,0,'2008-07-05 12:43:09',2),(7,9,2,1,22,23,23,-1,'2008-07-05 15:41:22',1),(1,9,2,23,22,1,22,1,'2008-07-05 17:25:34',0),(3,9,2,23,1,22,23,-1,'2008-07-05 17:28:36',1),(13,9,2,1,23,22,4,-1,'2008-07-05 22:14:26',1),(11,9,2,1,23,22,23,1,'2008-07-06 10:31:17',0),(8,9,2,1,22,3,2,1,'2008-07-06 11:23:17',1),(9,9,2,23,1,10,1,1,'2008-07-06 11:23:37',0),(10,9,2,1,22,23,1,-1,'2008-07-06 12:22:21',2),(12,9,2,1,22,23,1,1,'2008-07-06 12:22:31',1),(2,9,2,1,23,15,1,1,'2008-07-06 13:32:17',0),(13,10,2,22,2,23,4,1,'2008-07-13 08:09:19',4),(13,10,1,22,2,23,0,0,'2008-07-13 08:09:45',6),(3,10,1,22,2,1,0,0,'2008-07-18 19:49:43',4),(9,10,1,22,23,2,0,0,'2008-07-19 11:48:56',4),(8,10,1,22,1,23,0,0,'2008-07-19 11:50:37',4),(1,10,1,22,2,23,0,0,'2008-07-19 12:12:43',6),(11,10,1,22,2,23,0,0,'2008-07-19 12:13:29',6),(12,10,1,1,22,2,0,0,'2008-07-19 12:25:24',2),(10,10,1,2,22,1,0,0,'2008-07-19 12:25:25',2),(7,10,1,22,23,2,0,0,'2008-07-19 13:00:01',4),(2,10,1,22,2,23,0,0,'2008-07-19 13:56:56',6),(7,10,2,22,2,23,22,-1,'2008-07-19 16:01:35',3),(3,10,2,22,2,1,22,0,'2008-07-19 17:59:36',2),(1,10,2,22,2,1,2,0,'2008-07-20 11:08:40',2),(11,10,2,22,23,2,22,-1,'2008-07-20 11:52:52',4),(10,10,2,22,2,1,1,-1,'2008-07-20 12:59:19',3),(8,10,2,22,23,2,5,1,'2008-07-20 13:11:38',5),(9,10,2,23,2,1,1,-1,'2008-07-20 13:15:52',1),(2,10,2,22,2,1,2,0,'2008-07-20 13:57:34',2),(7,11,1,22,2,1,0,0,'2008-08-01 15:17:56',3),(3,11,1,22,2,1,0,0,'2008-08-02 09:49:24',3),(13,11,1,22,23,5,0,0,'2008-08-02 12:42:37',4),(9,11,1,22,23,3,0,0,'2008-08-02 12:45:51',4),(8,11,1,22,2,23,0,0,'2008-08-02 12:46:24',4),(1,11,1,22,2,23,0,0,'2008-08-02 13:26:52',4),(10,11,1,2,22,1,0,0,'2008-08-02 13:28:18',2),(11,11,1,22,23,2,0,0,'2008-08-02 13:30:10',6),(2,11,1,22,2,23,0,0,'2008-08-02 13:50:23',4),(1,11,2,22,2,23,22,0,'2008-08-02 15:17:11',2),(3,11,2,22,2,23,22,0,'2008-08-02 19:04:00',2),(7,11,2,22,2,4,22,0,'2008-08-03 05:49:49',1),(9,11,2,22,23,4,1,-1,'2008-08-03 10:08:12',2),(13,11,2,22,2,23,22,0,'2008-08-03 10:21:54',2),(8,11,2,22,4,23,2,-1,'2008-08-03 10:30:55',1),(10,11,2,22,2,4,1,-1,'2008-08-03 12:00:10',1),(11,11,2,22,23,2,22,0,'2008-08-03 13:00:32',2),(2,11,2,22,2,23,22,1,'2008-08-03 13:52:27',0),(3,12,1,1,22,2,0,0,'2008-08-22 21:18:30',3),(7,12,1,2,22,15,0,0,'2008-08-23 00:39:58',4),(13,12,2,22,2,5,2,1,'2008-08-23 08:01:42',2),(13,12,1,2,1,22,0,0,'2008-08-23 08:02:21',3),(8,12,1,4,1,2,0,0,'2008-08-23 12:38:44',2),(9,12,1,1,4,2,0,0,'2008-08-23 12:45:02',2),(1,12,1,2,22,1,0,0,'2008-08-23 13:10:05',4),(11,12,1,2,22,4,0,0,'2008-08-23 13:30:25',6),(2,12,1,1,22,2,0,0,'2008-08-23 13:38:45',3),(7,12,2,22,1,2,22,-1,'2008-08-23 15:09:43',2),(3,12,2,2,22,1,2,1,'2008-08-23 16:51:28',4),(9,12,2,2,4,23,1,1,'2008-08-24 10:45:44',2),(8,12,2,2,23,22,22,1,'2008-08-24 10:49:22',2),(1,12,2,2,22,1,1,1,'2008-08-24 11:55:50',3),(10,12,2,2,22,1,1,1,'2008-08-24 12:39:37',3),(12,12,2,2,22,1,1,-1,'2008-08-24 12:40:45',4),(2,12,2,2,22,1,1,1,'2008-08-24 13:45:38',3),(11,12,2,22,2,1,22,1,'2008-08-24 13:49:37',1),(7,13,1,2,1,22,0,0,'2008-09-05 15:24:44',2),(3,13,1,2,22,23,0,0,'2008-09-06 09:59:36',4),(10,13,1,1,2,22,0,0,'2008-09-06 11:21:15',3),(12,13,1,1,2,22,0,0,'2008-09-06 11:21:50',3),(11,13,1,2,22,23,0,0,'2008-09-06 11:54:10',4),(1,13,1,2,22,1,0,0,'2008-09-06 12:02:08',2),(9,13,1,2,23,22,0,0,'2008-09-06 13:41:52',3),(8,13,1,1,3,22,0,0,'2008-09-06 13:42:24',1),(2,13,1,22,2,1,0,0,'2008-09-06 13:48:19',4),(1,13,2,22,23,1,22,0,'2008-09-06 15:16:37',2),(7,13,2,22,2,1,22,0,'2008-09-06 15:59:14',3),(3,13,2,22,2,1,2,0,'2008-09-07 10:24:57',3),(9,13,2,22,23,1,1,-1,'2008-09-07 10:39:47',2),(10,13,2,2,22,1,1,0,'2008-09-07 11:00:29',5),(12,13,2,22,2,23,1,-1,'2008-09-07 11:01:10',3),(8,13,2,1,2,23,22,1,'2008-09-07 11:23:34',0),(11,13,2,22,2,23,22,1,'2008-09-07 13:29:07',1),(13,13,2,1,22,4,2,-1,'2008-09-07 13:34:05',1),(2,13,2,22,2,1,22,0,'2008-09-07 13:49:53',3),(13,14,1,1,22,2,0,0,'2008-09-12 09:59:43',0),(13,14,2,22,2,23,1,1,'2008-09-12 10:00:41',3),(7,14,1,1,22,2,0,0,'2008-09-12 15:50:31',0),(3,14,1,1,2,22,0,0,'2008-09-13 08:24:16',0),(10,14,1,2,1,22,0,0,'2008-09-13 11:38:17',0),(12,14,1,2,1,22,0,0,'2008-09-13 11:38:42',0),(9,14,1,2,1,22,0,0,'2008-09-13 12:42:26',0),(8,14,1,1,22,3,0,0,'2008-09-13 12:43:27',0),(2,14,1,22,1,15,0,0,'2008-09-13 13:30:58',1),(1,14,1,22,1,2,0,0,'2008-09-13 13:38:18',0),(11,14,1,22,2,4,0,0,'2008-09-13 13:44:31',0),(3,14,2,23,2,15,23,1,'2008-09-13 16:41:29',3),(7,14,2,15,23,2,2,1,'2008-09-14 08:29:51',5),(8,14,2,23,2,7,1,1,'2008-09-14 12:55:53',3),(9,14,2,23,2,15,2,-1,'2008-09-14 12:56:58',2),(1,14,2,23,2,3,22,1,'2008-09-14 13:02:28',2),(12,14,2,23,2,10,22,-1,'2008-09-14 13:35:18',1),(10,14,2,2,23,15,23,1,'2008-09-14 13:38:33',4),(11,14,2,23,15,2,23,1,'2008-09-14 13:42:54',3),(2,14,2,23,15,14,22,1,'2008-09-14 13:53:13',3),(13,15,1,22,1,2,0,0,'2008-09-26 13:22:15',3),(7,15,1,22,2,1,0,0,'2008-09-27 00:52:38',4),(3,15,1,22,2,1,0,0,'2008-09-27 09:57:15',4),(2,15,1,22,2,5,0,0,'2008-09-27 12:34:34',2),(9,15,1,2,22,23,0,0,'2008-09-27 13:59:57',4),(12,15,1,22,2,4,0,0,'2008-09-27 14:41:01',2),(10,15,1,22,2,4,0,0,'2008-09-27 14:41:34',2),(11,15,1,22,2,4,0,0,'2008-09-27 15:29:56',2),(1,15,1,22,2,23,0,0,'2008-09-27 15:35:22',2),(3,15,2,2,22,1,2,-1,'2008-09-27 18:01:02',1),(7,15,2,2,22,1,2,-1,'2008-09-27 23:14:29',1),(1,15,2,2,22,1,1,1,'2008-09-28 09:43:10',3),(11,15,2,22,2,1,1,1,'2008-09-28 11:36:30',3),(9,15,2,2,1,23,1,-1,'2008-09-28 12:22:12',1),(13,15,2,22,1,4,2,1,'2008-09-28 12:28:01',2),(8,15,2,2,22,23,5,-1,'2008-09-28 13:18:17',1),(12,15,2,2,1,22,1,-1,'2008-09-28 13:47:00',3),(10,15,2,2,1,22,1,1,'2008-09-28 13:47:53',4),(2,15,2,2,22,1,9999,-1,'2008-09-28 13:57:09',1),(13,16,1,22,2,5,0,0,'2008-10-10 15:11:02',2),(13,16,2,22,2,5,1,1,'2008-10-10 15:11:40',0),(7,16,1,22,2,23,0,0,'2008-10-10 15:13:27',4),(3,16,1,22,2,1,0,0,'2008-10-10 18:05:40',3),(1,16,1,22,2,1,0,0,'2008-10-10 23:54:32',3),(11,16,1,22,2,1,0,0,'2008-10-11 00:16:19',3),(3,16,2,22,2,1,22,-1,'2008-10-11 09:59:43',2),(7,16,2,22,2,1,22,0,'2008-10-11 16:58:40',3),(9,16,2,22,23,1,1,-1,'2008-10-11 20:04:07',2),(8,16,2,22,2,5,12,1,'2008-10-11 23:59:44',0),(11,16,2,22,2,1,1,0,'2008-10-12 00:24:14',3),(1,16,2,22,2,1,1,0,'2008-10-12 01:15:29',3),(2,16,2,22,23,2,22,0,'2008-10-12 06:25:26',1),(13,17,1,22,1,2,0,0,'2008-10-17 14:39:58',6),(3,17,1,22,2,1,0,0,'2008-10-17 16:44:37',4),(9,17,1,22,2,5,0,0,'2008-10-17 19:49:45',3),(8,17,1,22,5,2,0,0,'2008-10-17 20:07:50',4),(7,17,1,22,2,5,0,0,'2008-10-17 18:26:39',3),(1,17,1,22,2,1,0,0,'2008-10-17 20:33:56',4),(11,17,1,22,2,1,0,0,'2008-10-17 22:23:25',4),(2,17,1,22,5,23,0,0,'2008-10-18 07:58:06',2),(3,17,2,2,1,22,2,-1,'2008-10-18 10:53:00',3),(9,17,2,22,2,23,1,0,'2008-10-18 17:03:50',5),(7,17,2,22,2,5,22,-1,'2008-10-18 17:12:32',5),(8,17,2,2,5,22,4,0,'2008-10-18 17:23:18',3),(13,17,2,2,1,5,1,-1,'2008-10-18 20:00:39',2),(11,17,2,22,2,1,22,-1,'2008-10-18 21:47:55',7),(1,17,2,22,2,1,1,0,'2008-10-18 21:48:53',7),(2,17,2,22,2,1,22,0,'2008-10-19 08:49:19',8),(13,18,1,1,2,22,0,0,'2008-10-31 12:05:12',2),(7,18,1,2,22,5,0,0,'2008-11-01 00:16:21',2),(3,18,1,2,1,22,0,0,'2008-11-01 08:04:45',3),(8,18,1,22,2,1,0,0,'2008-11-01 14:46:39',3),(9,18,1,2,22,5,0,0,'2008-11-01 14:48:13',2),(2,18,1,2,5,22,0,0,'2008-11-01 15:27:01',2),(11,18,1,22,2,5,0,0,'2008-11-01 15:57:57',1),(1,18,1,2,22,5,0,0,'2008-11-01 16:29:12',2),(3,18,2,2,11,1,2,0,'2008-11-01 18:03:40',4),(1,18,2,2,1,22,1,0,'2008-11-02 07:05:19',2),(11,18,2,2,1,22,2,1,'2008-11-02 10:18:49',5),(9,18,2,2,1,5,1,0,'2008-11-02 12:23:25',3),(13,18,2,2,1,22,1,-1,'2008-11-02 12:42:13',3),(8,18,2,2,11,1,5,1,'2008-11-02 12:44:40',5),(7,18,2,2,1,22,2,-1,'2008-11-02 16:30:21',4),(2,18,2,2,1,22,22,1,'2008-11-02 17:57:13',4); /*!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', PRIMARY KEY (`u_id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 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 A. Mascelli','MAM','mam@heimam.at',0,'italian',1,2006),(2,'GUE','78918cecf8926d0cada4c5bc31af87a3','pic_GUE.gif','Guenther Schmidt','GueStar','guenther.schmidt@gmail.com',0,'austrian',0,2006),(3,'ZEI','8dad7cabce9c511bd4983e8dc96ea5da','pic_ZEI.gif','Christian Zeichmann','Zeichi','christian.zeichmann@inode.at',0,'austrian',0,2007),(4,'AFG','83384431390a14889c9955938bb5604f','pic_AFG.gif','Andrea F. Grohmann','','andrea.grohmann@chello.at',0,'austrian',0,2007),(6,'JIR','8522c2ccfd6fc5d242ed16d168401fad','avatar.jpg','Juergen Iser','','j.iser@gmx.at',0,'',1,2008),(7,'KAI','e5f4d97a4961dea1184bbbe847b591f3','avatar.jpg','Roman Kailbach','Kailo','kailo@gmx.at',0,'austrian',22,2008),(8,'WOB','776ad0ef27acc0602c337dc2736f3a97','avatar.jpg','Wolfgang Boehm','WoB','wboehm@gmail.com',0,'austrian',0,2008),(9,'REG','776ad0ef27acc0602c337dc2736f3a97','avatar.jpg','Regina Boehm','','wboehm@gmail.com',0,'austrian',0,2008),(10,'ISA','3c4db9561aa2b8530d5c60014dbfbe86','pic_ISA.jpg','Ildiko K. Samu','sam','ildiko.samu@gmx.at',0,'hungarian',1,2008),(11,'MRO','cda0fd2918d19e20ac871ed79a8d2bb0','pic_MRO.jpg','Martha Rossa','RoMa','rossama@yahoo.com',0,'austrian',22,2008),(12,'MPU','48d54f43c30a27137edb383de2605a86','avatar.jpg','Michael Puehringer','','michael.puehringer@atosorigin.com',0,'',6,2008),(13,'RHA','9ced82c0515df69d4e3311f63d40ffa0','avatar.jpg','Robert Haller','','Robert.Haller@kabsi.at',0,'',0,2008); /*!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 2017-01-26 8:03:51