-- MySQL dump 10.13  Distrib 5.1.48, for Win32 (ia32)
--
-- Host: localhost    Database: niki_2007
-- ------------------------------------------------------
-- 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=44 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,'ALONSO','Fernando'),(2,'HAMILTON','Lewis'),(3,'FISICHELLA','Giancarlo'),(4,'KOVALAINEN','Heikki'),(5,'MASSA','Felipe'),(6,'RAIKKONEN','Kimi'),(7,'BUTTON','Jenson'),(8,'BARRICHELLO','Rubens'),(9,'HEIDFELD','Nick'),(10,'KUBICA','Robert'),(11,'SCHUMACHER','Ralf'),(12,'TRULLI','Jarno'),(14,'COULTHARD','David'),(15,'WEBBER','Mark'),(16,'ROSBERG','Nico'),(17,'WURZ','Alexander'),(18,'LIUZZI','Vitantonio'),(19,'SPEED','Scott'),(20,'ALBERS','Christijan'),(21,'SUTIL','Adrian'),(22,'SATO','Takuma'),(23,'DAVIDSON','Anthony'),(24,'DE LA ROSA','Pedro'),(25,'PAFFETT','Gary'),(26,'PIQUET','Nelson Jr.'),(27,'ZONTA','Ricardo'),(28,'BADOER','Luca'),(29,'KLIEN','Christian'),(30,'ROSSITER','James'),(31,'VETTEL','Sebastian'),(32,'GLOCK','Timo'),(33,'MONTAGNY','Franck'),(34,'DOORNBOS','Robert'),(35,'AMMERMUELLER','Michael'),(36,'KARTHIKEYAN','Narain'),(37,'NAKAJIMA','Kazuki'),(38,'JANI','Neel'),(39,'WINKELHOCK','Markus'),(40,'FAUZY','Fairuz'),(41,'VAN DER GARDE','Giedo'),(42,'VALLES','Adrian'),(43,'YAMAMOTO','Sakon');
/*!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` 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=18 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)','2007-03-18 04:00:00','flag_AUSTRALIA.gif','circuit_AUSTRALIA.gif'),(2,'MALAYSIA (Sepang)','2007-04-08 08:00:00','flag_MALAYSIA.gif','circuit_MALAYSIA.gif'),(3,'BAHRAIN (Sakhir)','2007-04-15 13:30:00','flag_BAHRAIN.gif','circuit_BAHRAIN.gif'),(4,'SPAIN (Barcelona)','2007-05-13 14:00:00','flag_SPAIN.gif','circuit_SPAIN.gif'),(5,'MONACO (Monte Carlo)','2007-05-27 14:00:00','flag_MONACO.gif','circuit_MONACO.gif'),(6,'CANADA (Montreal)','2007-06-10 19:00:00','flag_CANADA.gif','circuit_CANADA.gif'),(7,'USA (Indianapolis)','2007-06-17 19:00:00','flag_USA.gif','circuit_USA.gif'),(8,'FRANCE (Magny-Cours)','2007-07-01 14:00:00','flag_FRANCE.gif','circuit_FRANCE.gif'),(9,'GREAT BRITAIN (Silverstone)','2007-07-08 14:00:00','flag_UK.gif','circuit_UK.gif'),(10,'GERMANY (Nuerburgring)','2007-07-22 14:00:00','flag_GERMANY.gif','circuit_GERMANY_(Nuerburgring).gif'),(11,'HUNGARY (Budapest)','2007-08-05 14:00:00','flag_HUNGARY.gif','circuit_HUNGARY.gif'),(12,'TURKEY (Istanbul)','2007-08-26 14:00:00','flag_TURKEY.gif','circuit_TURKEY.gif'),(13,'ITALY (Monza)','2007-09-09 14:00:00','flag_ITALY.gif','circuit_ITALY.gif'),(14,'BELGIUM (Spa)','2007-09-16 14:00:00','flag_BELGIUM.gif','circuit_BELGIUM.gif'),(15,'JAPAN (Fuji)','2007-09-30 06:30:00','flag_JAPAN.gif','circuit_JAPAN_(Fuji).gif'),(16,'CHINA (Shanghai)','2007-10-07 08:00:00','flag_CHINA.gif','circuit_CHINA.gif'),(17,'BRASIL (Sao Paolo)','2007-10-21 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_sc` int(11) NOT NULL DEFAULT '0',
  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,6,1,9,0),(1,2,6,1,2,0),(2,1,5,1,6,0),(2,2,1,2,6,0),(3,1,5,2,6,0),(3,2,5,2,6,1),(4,1,5,1,6,0),(4,2,5,2,1,0),(5,1,1,2,5,0),(5,2,1,2,5,0),(6,1,2,1,9,0),(6,2,2,9,17,1),(7,1,2,1,5,0),(7,2,2,1,5,0),(8,1,5,2,6,0),(8,2,6,5,2,0),(9,1,2,6,1,0),(9,2,6,1,2,0),(10,1,6,1,5,0),(10,2,1,5,15,1),(11,1,2,9,6,0),(11,2,2,6,9,0),(12,1,5,2,6,0),(12,2,5,6,1,0),(13,1,1,2,5,0),(13,2,1,2,6,1),(14,1,6,5,1,0),(14,2,6,5,1,0),(15,1,2,1,6,0),(15,2,2,4,6,1),(16,1,2,6,5,0),(16,2,6,1,5,0),(17,1,5,2,6,0),(17,2,6,5,1,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_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 (4,1,1,6,5,1,0,'2007-03-15 08:41:10',3),(4,1,2,5,1,6,0,'2007-03-15 08:41:31',4),(2,1,1,5,6,17,0,'2007-03-16 17:19:52',1),(2,1,2,5,6,1,1,'2007-03-16 17:20:12',1),(1,1,1,5,6,1,0,'2007-03-17 00:09:21',2),(1,1,2,6,1,2,0,'2007-03-17 14:29:09',7),(3,1,2,6,3,8,-1,'2007-03-18 01:32:01',2),(1,2,1,5,6,1,0,'2007-04-06 19:58:14',4),(4,2,1,5,6,3,0,'2007-04-06 21:15:10',3),(2,2,1,6,5,2,0,'2007-04-07 07:48:55',2),(2,2,2,5,6,1,0,'2007-04-07 08:59:42',3),(1,2,2,6,5,1,0,'2007-04-07 09:16:15',3),(4,2,2,5,1,6,0,'2007-04-07 09:31:37',4),(4,3,1,6,2,5,0,'2007-04-13 21:03:59',4),(1,3,1,6,1,2,0,'2007-04-14 12:10:54',2),(2,3,1,5,2,6,0,'2007-04-14 12:52:10',6),(2,3,2,5,2,6,0,'2007-04-14 13:58:25',5),(1,3,2,2,6,1,0,'2007-04-14 13:59:53',1),(4,3,2,5,6,1,0,'2007-04-15 10:10:44',2),(4,4,1,1,5,6,0,'2007-05-11 17:26:24',4),(1,4,1,1,5,2,0,'2007-05-12 10:42:58',2),(2,4,1,6,2,1,0,'2007-05-12 13:55:14',2),(2,4,2,5,6,1,0,'2007-05-12 15:03:58',5),(4,4,2,1,5,6,0,'2007-05-13 10:21:21',3),(1,4,2,5,1,6,0,'2007-05-13 10:53:43',4),(4,5,1,1,6,2,0,'2007-05-25 16:52:38',3),(1,5,1,6,2,1,0,'2007-05-26 12:13:58',3),(2,5,1,6,1,2,0,'2007-05-26 12:59:10',2),(1,5,2,1,2,5,1,'2007-05-26 15:05:17',5),(4,5,2,5,1,2,1,'2007-05-26 15:09:43',2),(2,5,2,2,1,5,1,'2007-05-27 13:46:34',3),(1,6,1,1,2,5,0,'2007-06-09 09:29:44',2),(4,6,1,1,6,5,0,'2007-06-09 17:08:55',1),(2,6,1,6,2,1,0,'2007-06-09 18:40:52',2),(2,6,2,2,1,6,1,'2007-06-09 20:05:48',3),(1,6,2,1,2,6,1,'2007-06-09 20:08:15',2),(4,6,2,6,5,1,0,'2007-06-10 12:18:17',-1),(4,7,1,1,2,5,0,'2007-06-16 08:52:35',4),(1,7,1,2,1,9,0,'2007-06-16 18:37:17',4),(2,7,1,1,2,9,0,'2007-06-16 18:46:57',2),(2,7,2,2,1,5,1,'2007-06-16 20:01:45',5),(4,7,2,1,2,6,0,'2007-06-17 11:57:41',3),(1,7,2,2,1,6,0,'2007-06-17 15:44:03',5),(4,8,1,1,5,2,0,'2007-06-30 10:58:13',2),(1,8,1,2,5,6,0,'2007-06-30 12:05:57',4),(2,8,1,5,2,6,0,'2007-06-30 14:03:24',6),(2,8,2,5,2,6,0,'2007-06-30 15:01:03',4),(1,8,2,2,5,6,0,'2007-06-30 15:13:27',5),(4,8,2,6,10,1,1,'2007-06-30 17:56:36',1),(4,9,1,6,2,5,0,'2007-07-07 08:29:24',2),(1,9,1,6,1,5,0,'2007-07-07 12:00:55',2),(2,9,1,6,1,2,0,'2007-07-07 12:01:50',3),(4,9,2,2,6,5,0,'2007-07-07 15:03:00',3),(1,9,2,2,1,6,0,'2007-07-07 15:03:04',5),(2,9,2,6,1,2,0,'2007-07-08 13:52:16',7),(1,10,1,6,2,1,0,'2007-07-21 11:24:13',3),(4,10,1,2,6,1,0,'2007-07-21 13:47:43',2),(2,10,1,6,2,5,0,'2007-07-21 13:53:35',4),(2,10,2,6,1,5,0,'2007-07-21 15:33:38',1),(4,10,2,6,1,5,0,'2007-07-21 15:34:50',1),(1,10,2,6,5,1,0,'2007-07-22 12:21:10',2),(4,11,1,1,2,6,0,'2007-08-03 21:26:49',3),(4,11,2,1,6,2,0,'2007-08-03 21:27:03',4),(1,11,1,2,1,6,0,'2007-08-04 11:10:00',4),(2,11,1,5,1,6,0,'2007-08-04 12:08:47',2),(1,11,2,1,2,6,0,'2007-08-04 15:01:27',3),(2,11,2,2,6,9,0,'2007-08-05 13:31:34',7),(4,12,1,6,2,1,0,'2007-08-25 09:38:55',3),(2,12,1,2,1,5,0,'2007-08-25 11:03:02',2),(1,12,1,2,5,1,0,'2007-08-25 11:04:26',2),(1,12,2,2,6,5,0,'2007-08-25 14:15:02',4),(4,12,2,5,2,6,0,'2007-08-25 16:50:49',4),(2,12,2,6,1,5,0,'2007-08-26 13:40:41',4),(4,13,1,6,1,5,0,'2007-09-07 18:17:47',3),(1,13,1,1,2,5,0,'2007-09-08 11:57:01',6),(2,13,1,1,2,6,0,'2007-09-08 12:47:38',4),(4,13,2,1,2,5,0,'2007-09-08 14:41:22',3),(1,13,2,1,2,5,1,'2007-09-08 15:01:06',5),(2,13,2,1,2,5,0,'2007-09-09 13:38:32',3),(4,14,1,1,2,6,0,'2007-09-15 11:16:52',2),(1,14,1,6,1,2,0,'2007-09-15 11:58:48',3),(2,14,1,6,1,5,0,'2007-09-15 12:02:52',4),(2,14,2,6,5,1,0,'2007-09-15 15:02:04',7),(1,14,2,6,1,5,0,'2007-09-15 15:10:38',5),(4,14,2,1,6,2,0,'2007-09-16 13:07:04',3),(4,15,1,1,2,6,0,'2007-09-28 19:34:26',4),(1,15,1,2,1,6,0,'2007-09-28 22:23:11',6),(2,15,1,6,1,2,0,'2007-09-29 06:55:29',4),(1,15,2,2,1,6,1,'2007-09-29 08:07:06',5),(4,15,2,2,6,1,0,'2007-09-29 15:02:09',2),(2,15,2,1,2,6,1,'2007-09-30 05:46:28',4),(4,16,1,6,1,5,0,'2007-10-05 17:43:04',3),(1,16,1,6,1,2,0,'2007-10-06 06:40:21',2),(1,16,2,2,6,1,1,'2007-10-06 09:01:42',1),(4,16,2,2,1,6,1,'2007-10-06 12:06:33',2),(2,16,1,1,6,2,0,'2007-10-06 05:10:13',3),(2,16,2,6,2,5,1,'2007-10-07 07:45:30',3),(4,17,1,6,5,2,0,'2007-10-20 16:03:45',3),(1,17,1,5,2,6,0,'2007-10-20 16:22:50',6),(2,17,1,5,6,2,0,'2007-10-20 17:15:48',4),(1,17,2,6,2,5,0,'2007-10-20 19:09:35',4),(4,17,2,5,2,6,0,'2007-10-21 13:43:07',3),(2,17,2,6,5,2,0,'2007-10-21 17:42:45',5);
/*!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` varchar(10) NOT NULL DEFAULT '',
  `u_passcode` varchar(20) NOT NULL DEFAULT '',
  `u_pic` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`u_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 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','mscmks','pic_MAM.gif'),(2,'GUE','guestar','pic_GUE.gif'),(3,'AFG','schoki','pic_AFG.gif'),(4,'ZEI','zeichi','pic_ZEI.gif');
/*!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