-- MySQL dump 10.16 Distrib 10.2.8-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 10.2.8-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 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 `asd_calc` -- DROP TABLE IF EXISTS `asd_calc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_calc` ( `id` int(11) NOT NULL AUTO_INCREMENT, `diff` int(11) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_calc` -- LOCK TABLES `asd_calc` WRITE; /*!40000 ALTER TABLE `asd_calc` DISABLE KEYS */; INSERT INTO `asd_calc` VALUES (1,0,25); /*!40000 ALTER TABLE `asd_calc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_driver` -- DROP TABLE IF EXISTS `asd_driver`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_driver` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `abv` varchar(3) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_driver` -- LOCK TABLES `asd_driver` WRITE; /*!40000 ALTER TABLE `asd_driver` DISABLE KEYS */; INSERT INTO `asd_driver` VALUES (1,'sdfsfdsf','XXX'); /*!40000 ALTER TABLE `asd_driver` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_prediction` -- DROP TABLE IF EXISTS `asd_prediction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_prediction` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `gp_id` int(11) NOT NULL, `driver_id` int(11) NOT NULL, `result` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=623 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_prediction` -- LOCK TABLES `asd_prediction` WRITE; /*!40000 ALTER TABLE `asd_prediction` DISABLE KEYS */; INSERT INTO `asd_prediction` VALUES (11,1,1,1,1),(12,1,1,1,1),(13,1,1,1,1),(14,1,1,1,1),(15,1,1,1,1),(16,1,1,1,1),(17,1,1,1,1),(18,1,1,1,1),(19,1,1,1,1),(20,1,1,1,1),(31,1,1,1,1),(32,1,1,1,1),(33,1,1,1,1),(34,1,1,1,1),(35,1,1,1,1),(36,1,1,1,1),(37,1,1,1,1),(38,1,1,1,1),(39,1,1,1,1),(40,1,1,1,1),(41,1,1,1,1),(42,1,1,1,1),(43,1,1,1,1),(44,1,1,1,1),(45,1,1,1,1),(46,1,1,1,1),(47,1,1,1,1),(48,1,1,1,1),(49,1,1,1,1),(50,1,1,1,1),(51,1,1,1,1),(52,1,1,1,1),(53,1,1,1,1),(54,1,1,1,1),(55,1,1,1,1),(56,1,1,1,1),(57,1,1,1,1),(58,1,1,1,1),(59,1,1,1,1),(60,1,1,1,1),(71,1,1,1,1),(72,1,1,1,1),(73,1,1,1,1),(74,1,1,1,1),(75,1,1,1,1),(76,1,1,1,1),(77,1,1,1,1),(78,1,1,1,1),(79,1,1,1,1),(80,1,1,1,1),(93,1,2,1,1),(94,1,2,1,1),(95,1,2,1,1),(96,1,2,1,1),(97,1,2,1,1),(98,1,2,1,1),(99,1,2,1,1),(100,1,2,1,1),(101,1,2,1,1),(102,1,2,1,1),(103,1,2,1,1),(104,1,2,1,1),(105,1,2,1,1),(106,1,2,1,1),(107,1,2,1,1),(108,1,2,1,1),(109,1,2,1,1),(110,1,2,1,1),(111,1,2,1,1),(112,1,2,1,1),(113,1,2,1,1),(114,1,2,1,1),(115,1,2,1,1),(116,1,2,1,1),(117,1,2,1,1),(118,1,2,1,1),(119,1,2,1,1),(120,1,2,1,1),(121,1,2,1,1),(122,1,2,1,1),(123,1,2,1,1),(124,1,2,1,1),(125,1,2,1,1),(126,1,2,1,1),(127,1,2,1,1),(128,1,2,1,1),(129,1,2,1,1),(130,1,2,1,1),(131,1,2,1,1),(132,1,2,1,1),(133,1,2,1,1),(134,1,2,1,1),(135,1,2,1,1),(136,1,2,1,1),(137,1,2,1,1),(138,1,2,1,1),(139,1,2,1,1),(140,1,2,1,1),(141,1,2,1,1),(142,1,2,1,1),(153,1,3,1,1),(154,1,3,1,1),(155,1,3,1,1),(156,1,3,1,1),(157,1,3,1,1),(158,1,3,1,1),(159,1,3,1,1),(160,1,3,1,1),(161,1,3,1,1),(162,1,3,1,1),(173,1,3,1,1),(174,1,3,1,1),(175,1,3,1,1),(176,1,3,1,1),(177,1,3,1,1),(178,1,3,1,1),(179,1,3,1,1),(180,1,3,1,1),(181,1,3,1,1),(182,1,3,1,1),(183,1,3,1,1),(184,1,3,1,1),(185,1,3,1,1),(186,1,3,1,1),(187,1,3,1,1),(188,1,3,1,1),(189,1,3,1,1),(190,1,3,1,1),(191,1,3,1,1),(192,1,3,1,1),(193,1,3,1,1),(194,1,3,1,1),(195,1,3,1,1),(196,1,3,1,1),(197,1,3,1,1),(198,1,3,1,1),(199,1,3,1,1),(200,1,3,1,1),(201,1,3,1,1),(202,1,3,1,1),(203,1,3,1,1),(204,1,3,1,1),(205,1,3,1,1),(206,1,3,1,1),(207,1,3,1,1),(208,1,3,1,1),(209,1,3,1,1),(210,1,3,1,1),(211,1,3,1,1),(212,1,3,1,1),(213,1,4,1,1),(214,1,4,1,1),(215,1,4,1,1),(216,1,4,1,1),(217,1,4,1,1),(218,1,4,1,1),(219,1,4,1,1),(220,1,4,1,1),(221,1,4,1,1),(222,1,4,1,1),(233,1,4,1,1),(234,1,4,1,1),(235,1,4,1,1),(236,1,4,1,1),(237,1,4,1,1),(238,1,4,1,1),(239,1,4,1,1),(240,1,4,1,1),(241,1,4,1,1),(242,1,4,1,1),(243,1,4,1,1),(244,1,4,1,1),(245,1,4,1,1),(246,1,4,1,1),(247,1,4,1,1),(248,1,4,1,1),(249,1,4,1,1),(250,1,4,1,1),(251,1,4,1,1),(252,1,4,1,1),(253,1,4,1,1),(254,1,4,1,1),(255,1,4,1,1),(256,1,4,1,1),(257,1,4,1,1),(258,1,4,1,1),(259,1,4,1,1),(260,1,4,1,1),(261,1,4,1,1),(262,1,4,1,1),(263,1,4,1,1),(264,1,4,1,1),(265,1,4,1,1),(266,1,4,1,1),(267,1,4,1,1),(268,1,4,1,1),(269,1,4,1,1),(270,1,4,1,1),(271,1,4,1,1),(272,1,4,1,1),(273,1,5,1,1),(274,1,5,1,1),(275,1,5,1,1),(276,1,5,1,1),(277,1,5,1,1),(278,1,5,1,1),(279,1,5,1,1),(280,1,5,1,1),(281,1,5,1,1),(282,1,5,1,1),(283,1,5,1,1),(284,1,5,1,1),(285,1,5,1,1),(286,1,5,1,1),(287,1,5,1,1),(288,1,5,1,1),(289,1,5,1,1),(290,1,5,1,1),(291,1,5,1,1),(292,1,5,1,1),(293,1,5,1,1),(294,1,5,1,1),(295,1,5,1,1),(296,1,5,1,1),(297,1,5,1,1),(298,1,5,1,1),(299,1,5,1,1),(300,1,5,1,1),(301,1,5,1,1),(302,1,5,1,1),(303,1,5,1,1),(304,1,5,1,1),(305,1,5,1,1),(306,1,5,1,1),(307,1,5,1,1),(308,1,5,1,1),(309,1,5,1,1),(310,1,5,1,1),(311,1,5,1,1),(312,1,5,1,1),(313,1,5,1,1),(314,1,5,1,1),(315,1,5,1,1),(316,1,5,1,1),(317,1,5,1,1),(318,1,5,1,1),(319,1,5,1,1),(320,1,5,1,1),(321,1,5,1,1),(322,1,5,1,1),(323,1,6,1,1),(324,1,6,1,1),(325,1,6,1,1),(326,1,6,1,1),(327,1,6,1,1),(328,1,6,1,1),(329,1,6,1,1),(330,1,6,1,1),(331,1,6,1,1),(332,1,6,1,1),(333,1,6,1,1),(334,1,6,1,1),(335,1,6,1,1),(336,1,6,1,1),(337,1,6,1,1),(338,1,6,1,1),(339,1,6,1,1),(340,1,6,1,1),(341,1,6,1,1),(342,1,6,1,1),(343,1,6,1,1),(344,1,6,1,1),(345,1,6,1,1),(346,1,6,1,1),(347,1,6,1,1),(348,1,6,1,1),(349,1,6,1,1),(350,1,6,1,1),(351,1,6,1,1),(352,1,6,1,1),(353,1,6,1,1),(354,1,6,1,1),(355,1,6,1,1),(356,1,6,1,1),(357,1,6,1,1),(358,1,6,1,1),(359,1,6,1,1),(360,1,6,1,1),(361,1,6,1,1),(362,1,6,1,1),(363,1,6,1,1),(364,1,6,1,1),(365,1,6,1,1),(366,1,6,1,1),(367,1,6,1,1),(368,1,6,1,1),(369,1,6,1,1),(370,1,6,1,1),(371,1,6,1,1),(372,1,6,1,1),(373,1,7,1,1),(374,1,7,1,1),(375,1,7,1,1),(376,1,7,1,1),(377,1,7,1,1),(378,1,7,1,1),(379,1,7,1,1),(380,1,7,1,1),(381,1,7,1,1),(382,1,7,1,1),(383,1,7,1,1),(384,1,7,1,1),(385,1,7,1,1),(386,1,7,1,1),(387,1,7,1,1),(388,1,7,1,1),(389,1,7,1,1),(390,1,7,1,1),(391,1,7,1,1),(392,1,7,1,1),(393,1,7,1,1),(394,1,7,1,1),(395,1,7,1,1),(396,1,7,1,1),(397,1,7,1,1),(398,1,7,1,1),(399,1,7,1,1),(400,1,7,1,1),(401,1,7,1,1),(402,1,7,1,1),(403,1,7,1,1),(404,1,7,1,1),(405,1,7,1,1),(406,1,7,1,1),(407,1,7,1,1),(408,1,7,1,1),(409,1,7,1,1),(410,1,7,1,1),(411,1,7,1,1),(412,1,7,1,1),(413,1,7,1,1),(414,1,7,1,1),(415,1,7,1,1),(416,1,7,1,1),(417,1,7,1,1),(418,1,7,1,1),(419,1,7,1,1),(420,1,7,1,1),(421,1,7,1,1),(422,1,7,1,1),(423,1,8,1,1),(424,1,8,1,1),(425,1,8,1,1),(426,1,8,1,1),(427,1,8,1,1),(428,1,8,1,1),(429,1,8,1,1),(430,1,8,1,1),(431,1,8,1,1),(432,1,8,1,1),(433,1,8,1,1),(434,1,8,1,1),(435,1,8,1,1),(436,1,8,1,1),(437,1,8,1,1),(438,1,8,1,1),(439,1,8,1,1),(440,1,8,1,1),(441,1,8,1,1),(442,1,8,1,1),(443,1,8,1,1),(444,1,8,1,1),(445,1,8,1,1),(446,1,8,1,1),(447,1,8,1,1),(448,1,8,1,1),(449,1,8,1,1),(450,1,8,1,1),(451,1,8,1,1),(452,1,8,1,1),(453,1,8,1,1),(454,1,8,1,1),(455,1,8,1,1),(456,1,8,1,1),(457,1,8,1,1),(458,1,8,1,1),(459,1,8,1,1),(460,1,8,1,1),(461,1,8,1,1),(462,1,8,1,1),(463,1,8,1,1),(464,1,8,1,1),(465,1,8,1,1),(466,1,8,1,1),(467,1,8,1,1),(468,1,8,1,1),(469,1,8,1,1),(470,1,8,1,1),(471,1,8,1,1),(472,1,8,1,1),(473,1,9,1,1),(474,1,9,1,1),(475,1,9,1,1),(476,1,9,1,1),(477,1,9,1,1),(478,1,9,1,1),(479,1,9,1,1),(480,1,9,1,1),(481,1,9,1,1),(482,1,9,1,1),(483,1,9,1,1),(484,1,9,1,1),(485,1,9,1,1),(486,1,9,1,1),(487,1,9,1,1),(488,1,9,1,1),(489,1,9,1,1),(490,1,9,1,1),(491,1,9,1,1),(492,1,9,1,1),(493,1,9,1,1),(494,1,9,1,1),(495,1,9,1,1),(496,1,9,1,1),(497,1,9,1,1),(498,1,9,1,1),(499,1,9,1,1),(500,1,9,1,1),(501,1,9,1,1),(502,1,9,1,1),(503,1,9,1,1),(504,1,9,1,1),(505,1,9,1,1),(506,1,9,1,1),(507,1,9,1,1),(508,1,9,1,1),(509,1,9,1,1),(510,1,9,1,1),(511,1,9,1,1),(512,1,9,1,1),(513,1,9,1,1),(514,1,9,1,1),(515,1,9,1,1),(516,1,9,1,1),(517,1,9,1,1),(518,1,9,1,1),(519,1,9,1,1),(520,1,9,1,1),(521,1,9,1,1),(522,1,9,1,1),(523,1,10,1,1),(524,1,10,1,1),(525,1,10,1,1),(526,1,10,1,1),(527,1,10,1,1),(528,1,10,1,1),(529,1,10,1,1),(530,1,10,1,1),(531,1,10,1,1),(532,1,10,1,1),(533,1,10,1,1),(534,1,10,1,1),(535,1,10,1,1),(536,1,10,1,1),(537,1,10,1,1),(538,1,10,1,1),(539,1,10,1,1),(540,1,10,1,1),(541,1,10,1,1),(542,1,10,1,1),(543,1,10,1,1),(544,1,10,1,1),(545,1,10,1,1),(546,1,10,1,1),(547,1,10,1,1),(548,1,10,1,1),(549,1,10,1,1),(550,1,10,1,1),(551,1,10,1,1),(552,1,10,1,1),(553,1,10,1,1),(554,1,10,1,1),(555,1,10,1,1),(556,1,10,1,1),(557,1,10,1,1),(558,1,10,1,1),(559,1,10,1,1),(560,1,10,1,1),(561,1,10,1,1),(562,1,10,1,1),(563,1,10,1,1),(564,1,10,1,1),(565,1,10,1,1),(566,1,10,1,1),(567,1,10,1,1),(568,1,10,1,1),(569,1,10,1,1),(570,1,10,1,1),(571,1,10,1,1),(572,1,10,1,1),(573,1,11,1,1),(574,1,11,1,1),(575,1,11,1,1),(576,1,11,1,1),(577,1,11,1,1),(578,1,11,1,1),(579,1,11,1,1),(580,1,11,1,1),(581,1,11,1,1),(582,1,11,1,1),(583,1,11,1,1),(584,1,11,1,1),(585,1,11,1,1),(586,1,11,1,1),(587,1,11,1,1),(588,1,11,1,1),(589,1,11,1,1),(590,1,11,1,1),(591,1,11,1,1),(592,1,11,1,1),(593,1,11,1,1),(594,1,11,1,1),(595,1,11,1,1),(596,1,11,1,1),(597,1,11,1,1),(598,1,11,1,1),(599,1,11,1,1),(600,1,11,1,1),(601,1,11,1,1),(602,1,11,1,1),(603,1,11,1,1),(604,1,11,1,1),(605,1,11,1,1),(606,1,11,1,1),(607,1,11,1,1),(608,1,11,1,1),(609,1,11,1,1),(610,1,11,1,1),(611,1,11,1,1),(612,1,11,1,1),(613,1,11,1,1),(614,1,11,1,1),(615,1,11,1,1),(616,1,11,1,1),(617,1,11,1,1),(618,1,11,1,1),(619,1,11,1,1),(620,1,11,1,1),(621,1,11,1,1),(622,1,11,1,1); /*!40000 ALTER TABLE `asd_prediction` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_result` -- DROP TABLE IF EXISTS `asd_result`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_result` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gp_id` int(11) NOT NULL, `driver_id` int(11) NOT NULL, `result` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1708 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_result` -- LOCK TABLES `asd_result` WRITE; /*!40000 ALTER TABLE `asd_result` DISABLE KEYS */; INSERT INTO `asd_result` VALUES (1,1,1,1); /*!40000 ALTER TABLE `asd_result` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_user` -- DROP TABLE IF EXISTS `asd_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_user` -- LOCK TABLES `asd_user` WRITE; /*!40000 ALTER TABLE `asd_user` DISABLE KEYS */; INSERT INTO `asd_user` VALUES (1,'XXX'); /*!40000 ALTER TABLE `asd_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_xx` -- DROP TABLE IF EXISTS `asd_xx`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_xx` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_bin NOT NULL, `start` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_xx` -- LOCK TABLES `asd_xx` WRITE; /*!40000 ALTER TABLE `asd_xx` DISABLE KEYS */; INSERT INTO `asd_xx` VALUES (1,'adasdasdad','2015-08-04 08:00:00'); /*!40000 ALTER TABLE `asd_xx` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `asd_xx_result` -- DROP TABLE IF EXISTS `asd_xx_result`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `asd_xx_result` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gp_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `score` int(11) NOT NULL, `tt0` int(11) NOT NULL, `tt1` int(11) NOT NULL, `tt2` int(11) NOT NULL, `tt3` int(11) NOT NULL, `tt4` int(11) NOT NULL, `tt5` int(11) NOT NULL, `tt6` int(11) NOT NULL, `tt7` int(11) NOT NULL, `tt8` int(11) NOT NULL, `tt9` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `asd_xx_result` -- LOCK TABLES `asd_xx_result` WRITE; /*!40000 ALTER TABLE `asd_xx_result` DISABLE KEYS */; INSERT INTO `asd_xx_result` VALUES (1,1,1,1,1,1,1,0,0,0,0,0,0,0); /*!40000 ALTER TABLE `asd_xx_result` 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-08-21 19:11:09