· 8 years ago · Jan 29, 2018, 05:34 PM
1-- MySQL dump 10.15 Distrib 10.0.31-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: rocketmapdb
4-- ------------------------------------------------------
5-- Server version 10.0.31-MariaDB-0ubuntu0.16.04.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `weather`
20--
21
22DROP TABLE IF EXISTS `weather`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `weather` (
26 `s2_cell_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
27 `latitude` double NOT NULL,
28 `longitude` double NOT NULL,
29 `cloud_level` smallint(6) DEFAULT NULL,
30 `rain_level` smallint(6) DEFAULT NULL,
31 `wind_level` smallint(6) DEFAULT NULL,
32 `snow_level` smallint(6) DEFAULT NULL,
33 `fog_level` smallint(6) DEFAULT NULL,
34 `wind_direction` smallint(6) DEFAULT NULL,
35 `gameplay_weather` smallint(6) DEFAULT NULL,
36 `severity` smallint(6) DEFAULT NULL,
37 `warn_weather` smallint(6) DEFAULT NULL,
38 `world_time` smallint(6) DEFAULT NULL,
39 `last_updated` datetime DEFAULT NULL,
40 PRIMARY KEY (`s2_cell_id`),
41 KEY `weather_cloud_level` (`cloud_level`),
42 KEY `weather_rain_level` (`rain_level`),
43 KEY `weather_wind_level` (`wind_level`),
44 KEY `weather_snow_level` (`snow_level`),
45 KEY `weather_fog_level` (`fog_level`),
46 KEY `weather_wind_direction` (`wind_direction`),
47 KEY `weather_gameplay_weather` (`gameplay_weather`),
48 KEY `weather_severity` (`severity`),
49 KEY `weather_warn_weather` (`warn_weather`),
50 KEY `weather_world_time` (`world_time`),
51 KEY `weather_last_updated` (`last_updated`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
53/*!40101 SET character_set_client = @saved_cs_client */;
54
55--
56-- Dumping data for table `weather`
57--
58
59LOCK TABLES `weather` WRITE;
60/*!40000 ALTER TABLE `weather` DISABLE KEYS */;
61INSERT INTO `weather` VALUES ('-8634351563227267072',43.29543096796,-79.7848422463066,3,0,0,0,0,62,4,1,1,1,'2018-01-29 17:21:15')
62'-8634353762250522624',43.3799342012864,-79.8744836637222,3,0,0,0,0,58,4,1,1,1,'2018-01-29 17:20:38')
63'-8634694610855133184',43.4482653363981,-79.7848422463066,3,0,0,0,0,58,4,1,1,1,'2018-01-29 17:23:05')
64'-8634699008901644288',43.371906617074,-79.7848421607746,3,0,0,0,0,62,4,1,1,1,'2018-01-29 17:22:08')
65'-8634701207924899840',43.371906617074,-79.7848421607746,3,0,0,0,0,62,4,1,1,1,'2018-01-29 17:23:01')
66'-8634703406948155392',43.3637985961365,-79.6951102123523,3,0,0,0,0,47,4,1,1,1,'2018-01-29 17:19:36')
67'-8634705605971410944',43.4401561767546,-79.6951102123523,3,0,0,0,0,58,4,1,1,1,'2018-01-29 17:22:41')
68'-8634707804994666496',43.5082058631014,-79.6052884555971,3,0,1,0,0,62,4,1,1,1,'2018-01-29 17:21:44')
69'-8634731994250477568',43.5082058631014,-79.6052884555971,3,0,1,0,0,62,4,1,1,1,'2018-01-29 17:19:53')
70'-8634734193273733120',43.5163968368942,-79.6951102979703,3,0,0,0,0,48,4,1,1,1,'2018-01-29 17:09:25');
71/*!40000 ALTER TABLE `weather` ENABLE KEYS */;
72UNLOCK TABLES;
73/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
74
75/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
76/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
77/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
78/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
79/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
80/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
81/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
82
83-- Dump completed on 2018-01-29 12:23:24