-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdump.sql
144 lines (125 loc) · 33.9 KB
/
dump.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
-- MySQL dump 10.13 Distrib 5.7.37, for Linux (x86_64)
--
-- Host: localhost Database: nexa-tracker
-- ------------------------------------------------------
-- Server version 5.7.37
/*!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 `measurements`
--
DROP TABLE IF EXISTS `measurements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `measurements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`node` int(11) NOT NULL,
`sensor` int(11) NOT NULL,
`timestamp` datetime NOT NULL,
`value` decimal(8,2) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `node` (`node`),
KEY `sensor` (`sensor`),
CONSTRAINT `measurements_ibfk_1` FOREIGN KEY (`node`) REFERENCES `nodes` (`id`),
CONSTRAINT `measurements_ibfk_2` FOREIGN KEY (`sensor`) REFERENCES `sensors` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `measurements`
--
LOCK TABLES `measurements` WRITE;
/*!40000 ALTER TABLE `measurements` DISABLE KEYS */;
INSERT INTO `measurements` VALUES (1,2,1,'2022-04-15 22:13:56',3.70,'2022-04-15 22:13:56','2022-04-15 22:13:56'),(2,3,2,'2022-04-15 22:14:00',71.00,'2022-04-15 22:14:00','2022-04-15 22:14:00'),(3,1,1,'2022-04-15 22:15:27',27.00,'2022-04-15 22:15:27','2022-04-15 22:15:27'),(4,1,1,'2022-04-15 22:16:27',28.10,'2022-04-15 22:16:27','2022-04-15 22:16:27'),(5,1,1,'2022-04-15 22:17:27',27.80,'2022-04-15 22:17:27','2022-04-15 22:17:27'),(6,1,1,'2022-04-15 22:18:27',27.00,'2022-04-15 22:18:27','2022-04-15 22:18:27'),(7,1,1,'2022-04-15 22:19:27',26.70,'2022-04-15 22:19:27','2022-04-15 22:19:27'),(8,2,1,'2022-04-15 22:19:40',3.50,'2022-04-15 22:19:40','2022-04-15 22:19:40'),(9,1,1,'2022-04-15 22:21:27',26.50,'2022-04-15 22:21:27','2022-04-15 22:21:27'),(10,2,2,'2022-04-15 22:23:15',38.00,'2022-04-15 22:23:15','2022-04-15 22:23:15'),(11,1,1,'2022-04-15 22:24:27',26.30,'2022-04-15 22:24:27','2022-04-15 22:24:27'),(12,2,1,'2022-04-15 22:26:07',3.30,'2022-04-15 22:26:07','2022-04-15 22:26:07'),(13,3,2,'2022-04-15 22:26:54',72.00,'2022-04-15 22:26:54','2022-04-15 22:26:54'),(14,3,1,'2022-04-15 22:28:20',-2.40,'2022-04-15 22:28:20','2022-04-15 22:28:20'),(15,1,1,'2022-04-15 22:30:27',27.80,'2022-04-15 22:30:27','2022-04-15 22:30:27'),(16,1,1,'2022-04-15 22:32:27',27.20,'2022-04-15 22:32:27','2022-04-15 22:32:27'),(17,2,1,'2022-04-15 22:32:34',3.10,'2022-04-15 22:32:34','2022-04-15 22:32:34'),(18,1,1,'2022-04-15 22:33:27',26.70,'2022-04-15 22:33:27','2022-04-15 22:33:27'),(19,1,1,'2022-04-15 22:34:27',26.50,'2022-04-15 22:34:27','2022-04-15 22:34:27'),(20,2,2,'2022-04-15 22:38:18',39.00,'2022-04-15 22:38:18','2022-04-15 22:38:18'),(21,1,1,'2022-04-15 22:38:27',26.30,'2022-04-15 22:38:27','2022-04-15 22:38:27'),(22,2,2,'2022-04-15 22:41:53',40.00,'2022-04-15 22:41:53','2022-04-15 22:41:53'),(23,2,1,'2022-04-15 22:42:36',2.80,'2022-04-15 22:42:36','2022-04-15 22:42:36'),(24,1,1,'2022-04-15 22:43:27',27.50,'2022-04-15 22:43:27','2022-04-15 22:43:27'),(25,1,1,'2022-04-15 22:44:27',28.00,'2022-04-15 22:44:27','2022-04-15 22:44:27'),(26,1,1,'2022-04-15 22:45:27',27.20,'2022-04-15 22:45:27','2022-04-15 22:45:27'),(27,1,1,'2022-04-15 22:46:27',26.80,'2022-04-15 22:46:27','2022-04-15 22:46:27'),(28,1,1,'2022-04-15 22:48:27',26.50,'2022-04-15 22:48:27','2022-04-15 22:48:27'),(29,2,1,'2022-04-15 22:49:03',2.60,'2022-04-15 22:49:03','2022-04-15 22:49:03'),(30,3,2,'2022-04-15 22:51:16',73.00,'2022-04-15 22:51:16','2022-04-15 22:51:16'),(31,1,1,'2022-04-15 22:51:27',26.20,'2022-04-15 22:51:27','2022-04-15 22:51:27'),(32,1,1,'2022-04-15 22:56:27',27.00,'2022-04-15 22:56:27','2022-04-15 22:56:27'),(33,1,1,'2022-04-15 22:57:27',27.90,'2022-04-15 22:57:27','2022-04-15 22:57:27'),(34,3,1,'2022-04-15 22:57:43',-2.70,'2022-04-15 22:57:43','2022-04-15 22:57:43'),(35,1,1,'2022-04-15 22:58:27',27.30,'2022-04-15 22:58:27','2022-04-15 22:58:27'),(36,1,1,'2022-04-15 22:59:27',26.90,'2022-04-15 22:59:27','2022-04-15 22:59:27'),(37,1,1,'2022-04-15 23:00:27',26.50,'2022-04-15 23:00:27','2022-04-15 23:00:27'),(38,2,1,'2022-04-15 23:01:14',2.30,'2022-04-15 23:01:14','2022-04-15 23:01:14'),(39,1,1,'2022-04-15 23:03:27',26.30,'2022-04-15 23:03:27','2022-04-15 23:03:27'),(40,2,2,'2022-04-15 23:08:24',41.00,'2022-04-15 23:08:24','2022-04-15 23:08:24'),(41,2,1,'2022-04-15 23:09:07',2.10,'2022-04-15 23:09:07','2022-04-15 23:09:07'),(42,1,1,'2022-04-15 23:09:27',27.30,'2022-04-15 23:09:27','2022-04-15 23:09:27'),(43,1,1,'2022-04-15 23:10:27',28.00,'2022-04-15 23:10:27','2022-04-15 23:10:27'),(44,1,1,'2022-04-15 23:11:27',27.30,'2022-04-15 23:11:27','2022-04-15 23:11:27'),(45,3,1,'2022-04-15 23:12:03',-2.90,'2022-04-15 23:12:03','2022-04-15 23:12:03'),(46,1,1,'2022-04-15 23:12:27',26.70,'2022-04-15 23:12:27','2022-04-15 23:12:27'),(47,1,1,'2022-04-15 23:13:27',26.50,'2022-04-15 23:13:27','2022-04-15 23:13:27'),(48,1,1,'2022-04-15 23:15:27',26.30,'2022-04-15 23:15:27','2022-04-15 23:15:27'),(49,3,2,'2022-04-15 23:17:47',72.00,'2022-04-15 23:17:47','2022-04-15 23:17:47'),(50,1,1,'2022-04-15 23:22:27',27.60,'2022-04-15 23:22:27','2022-04-15 23:22:27'),(51,2,1,'2022-04-15 23:23:27',1.80,'2022-04-15 23:23:27','2022-04-15 23:23:27'),(52,1,1,'2022-04-15 23:24:27',26.90,'2022-04-15 23:24:27','2022-04-15 23:24:27'),(53,1,1,'2022-04-15 23:26:27',26.60,'2022-04-15 23:26:27','2022-04-15 23:26:27'),(54,3,2,'2022-04-15 23:27:06',73.00,'2022-04-15 23:27:06','2022-04-15 23:27:06'),(55,1,1,'2022-04-15 23:28:27',26.40,'2022-04-15 23:28:27','2022-04-15 23:28:27'),(56,2,2,'2022-04-15 23:29:11',42.00,'2022-04-15 23:29:11','2022-04-15 23:29:11'),(57,1,1,'2022-04-15 23:30:27',26.10,'2022-04-15 23:30:27','2022-04-15 23:30:27'),(58,1,1,'2022-04-15 23:33:27',27.00,'2022-04-15 23:33:27','2022-04-15 23:33:27'),(59,3,2,'2022-04-15 23:34:16',74.00,'2022-04-15 23:34:16','2022-04-15 23:34:16'),(60,1,1,'2022-04-15 23:34:27',27.90,'2022-04-15 23:34:27','2022-04-15 23:34:27'),(61,3,1,'2022-04-15 23:34:59',-3.20,'2022-04-15 23:34:59','2022-04-15 23:34:59'),(62,1,1,'2022-04-15 23:35:27',27.60,'2022-04-15 23:35:27','2022-04-15 23:35:27'),(63,2,1,'2022-04-15 23:36:21',1.50,'2022-04-15 23:36:21','2022-04-15 23:36:21'),(64,1,1,'2022-04-15 23:36:27',26.70,'2022-04-15 23:36:27','2022-04-15 23:36:27'),(65,1,1,'2022-04-15 23:37:27',26.50,'2022-04-15 23:37:27','2022-04-15 23:37:27'),(66,1,1,'2022-04-15 23:39:27',26.30,'2022-04-15 23:39:27','2022-04-15 23:39:27'),(67,2,1,'2022-04-15 23:44:14',1.30,'2022-04-15 23:44:14','2022-04-15 23:44:14'),(68,1,1,'2022-04-15 23:44:27',27.30,'2022-04-15 23:44:27','2022-04-15 23:44:27'),(69,1,1,'2022-04-15 23:45:27',27.70,'2022-04-15 23:45:27','2022-04-15 23:45:27'),(70,1,1,'2022-04-15 23:46:27',27.10,'2022-04-15 23:46:27','2022-04-15 23:46:27'),(71,1,1,'2022-04-15 23:47:27',26.60,'2022-04-15 23:47:27','2022-04-15 23:47:27'),(72,1,1,'2022-04-15 23:48:27',26.40,'2022-04-15 23:48:27','2022-04-15 23:48:27'),(73,1,1,'2022-04-15 23:51:27',26.10,'2022-04-15 23:51:27','2022-04-15 23:51:27'),(74,3,1,'2022-04-15 23:53:37',-3.40,'2022-04-15 23:53:37','2022-04-15 23:53:37'),(75,1,1,'2022-04-15 23:54:27',27.70,'2022-04-15 23:54:27','2022-04-15 23:54:27'),(76,1,1,'2022-04-15 23:56:27',27.00,'2022-04-15 23:56:27','2022-04-15 23:56:27'),(77,1,1,'2022-04-15 23:57:27',26.50,'2022-04-15 23:57:27','2022-04-15 23:57:27'),(78,1,1,'2022-04-16 00:00:27',26.10,'2022-04-16 00:00:27','2022-04-16 00:00:27'),(79,2,1,'2022-04-16 00:00:43',1.00,'2022-04-16 00:00:43','2022-04-16 00:00:43'),(80,1,1,'2022-04-16 00:03:27',27.30,'2022-04-16 00:03:27','2022-04-16 00:03:27'),(81,2,2,'2022-04-16 00:03:35',43.00,'2022-04-16 00:03:35','2022-04-16 00:03:35'),(82,1,1,'2022-04-16 00:04:27',28.00,'2022-04-16 00:04:27','2022-04-16 00:04:27'),(83,1,1,'2022-04-16 00:05:27',27.30,'2022-04-16 00:05:27','2022-04-16 00:05:27'),(84,1,1,'2022-04-16 00:06:27',26.60,'2022-04-16 00:06:27','2022-04-16 00:06:27'),(85,1,1,'2022-04-16 00:07:27',26.40,'2022-04-16 00:07:27','2022-04-16 00:07:27'),(86,3,2,'2022-04-16 00:09:23',75.00,'2022-04-16 00:09:24','2022-04-16 00:09:24'),(87,1,1,'2022-04-16 00:10:27',26.10,'2022-04-16 00:10:27','2022-04-16 00:10:27'),(88,1,1,'2022-04-16 00:13:27',27.30,'2022-04-16 00:13:27','2022-04-16 00:13:27'),(89,1,1,'2022-04-16 00:14:27',27.90,'2022-04-16 00:14:27','2022-04-16 00:14:27'),(90,1,1,'2022-04-16 00:15:27',27.00,'2022-04-16 00:15:27','2022-04-16 00:15:27'),(91,1,1,'2022-04-16 00:16:27',26.70,'2022-04-16 00:16:27','2022-04-16 00:16:27'),(92,1,1,'2022-04-16 00:17:27',26.40,'2022-04-16 00:17:27','2022-04-16 00:17:27'),(93,2,1,'2022-04-16 00:17:55',0.70,'2022-04-16 00:17:55','2022-04-16 00:17:55'),(94,2,2,'2022-04-16 00:18:38',44.00,'2022-04-16 00:18:38','2022-04-16 00:18:38'),(95,1,1,'2022-04-16 00:20:27',26.10,'2022-04-16 00:20:27','2022-04-16 00:20:27'),(96,1,1,'2022-04-16 00:23:27',26.50,'2022-04-16 00:23:27','2022-04-16 00:23:27'),(97,1,1,'2022-04-16 00:24:27',28.00,'2022-04-16 00:24:27','2022-04-16 00:24:27'),(98,1,1,'2022-04-16 00:25:27',27.50,'2022-04-16 00:25:27','2022-04-16 00:25:27'),(99,1,1,'2022-04-16 00:26:27',27.00,'2022-04-16 00:26:27','2022-04-16 00:26:27'),(100,1,1,'2022-04-16 00:27:27',26.40,'2022-04-16 00:27:27','2022-04-16 00:27:27'),(101,1,1,'2022-04-16 00:30:27',26.10,'2022-04-16 00:30:27','2022-04-16 00:30:27'),(102,1,1,'2022-04-16 00:33:27',26.70,'2022-04-16 00:33:27','2022-04-16 00:33:27'),(103,1,1,'2022-04-16 00:34:27',27.60,'2022-04-16 00:34:27','2022-04-16 00:34:27'),(104,3,2,'2022-04-16 00:34:28',76.00,'2022-04-16 00:34:28','2022-04-16 00:34:28'),(105,2,1,'2022-04-16 00:35:50',0.40,'2022-04-16 00:35:50','2022-04-16 00:35:50'),(106,1,1,'2022-04-16 00:36:27',26.80,'2022-04-16 00:36:27','2022-04-16 00:36:27'),(107,1,1,'2022-04-16 00:37:27',26.50,'2022-04-16 00:37:27','2022-04-16 00:37:27'),(108,1,1,'2022-04-16 00:40:27',26.30,'2022-04-16 00:40:27','2022-04-16 00:40:27'),(109,1,1,'2022-04-16 00:42:27',26.00,'2022-04-16 00:42:27','2022-04-16 00:42:27'),(110,1,1,'2022-04-16 00:44:27',27.30,'2022-04-16 00:44:27','2022-04-16 00:44:27'),(111,1,1,'2022-04-16 00:45:27',27.80,'2022-04-16 00:45:27','2022-04-16 00:45:27'),(112,1,1,'2022-04-16 00:46:27',27.00,'2022-04-16 00:46:27','2022-04-16 00:46:27'),(113,1,1,'2022-04-16 00:47:27',26.60,'2022-04-16 00:47:27','2022-04-16 00:47:27'),(114,2,1,'2022-04-16 00:48:01',0.20,'2022-04-16 00:48:01','2022-04-16 00:48:01'),(115,2,2,'2022-04-16 00:48:01',45.00,'2022-04-16 00:48:01','2022-04-16 00:48:01'),(116,1,1,'2022-04-16 00:48:27',26.30,'2022-04-16 00:48:27','2022-04-16 00:48:27'),(117,1,1,'2022-04-16 00:52:27',26.00,'2022-04-16 00:52:27','2022-04-16 00:52:27'),(118,1,1,'2022-04-16 00:54:27',27.50,'2022-04-16 00:54:27','2022-04-16 00:54:27'),(119,1,1,'2022-04-16 00:55:27',27.80,'2022-04-16 00:55:27','2022-04-16 00:55:27'),(120,1,1,'2022-04-16 00:56:27',27.10,'2022-04-16 00:56:27','2022-04-16 00:56:27'),(121,1,1,'2022-04-16 00:57:27',26.50,'2022-04-16 00:57:27','2022-04-16 00:57:27'),(122,1,1,'2022-04-16 01:00:27',26.10,'2022-04-16 01:00:27','2022-04-16 01:00:27'),(123,2,1,'2022-04-16 01:00:55',0.00,'2022-04-16 01:00:55','2022-04-16 01:00:55'),(124,1,1,'2022-04-16 01:03:27',26.60,'2022-04-16 01:03:27','2022-04-16 01:03:27'),(125,1,1,'2022-04-16 01:04:27',27.70,'2022-04-16 01:04:27','2022-04-16 01:04:27'),(126,3,1,'2022-04-16 01:06:00',-3.70,'2022-04-16 01:06:00','2022-04-16 01:06:00'),(127,1,1,'2022-04-16 01:06:27',26.70,'2022-04-16 01:06:27','2022-04-16 01:06:27'),(128,1,1,'2022-04-16 01:07:27',26.50,'2022-04-16 01:07:27','2022-04-16 01:07:27'),(129,1,1,'2022-04-16 01:08:27',26.30,'2022-04-16 01:08:27','2022-04-16 01:08:27'),(130,1,1,'2022-04-16 01:11:27',26.00,'2022-04-16 01:11:27','2022-04-16 01:11:27'),(131,1,1,'2022-04-16 01:13:27',27.00,'2022-04-16 01:13:27','2022-04-16 01:13:27'),(132,1,1,'2022-04-16 01:14:27',27.80,'2022-04-16 01:14:27','2022-04-16 01:14:27'),(133,1,1,'2022-04-16 01:15:27',27.10,'2022-04-16 01:15:27','2022-04-16 01:15:27'),(134,1,1,'2022-04-16 01:16:27',26.60,'2022-04-16 01:16:27','2022-04-16 01:16:27'),(135,2,1,'2022-04-16 01:16:41',-0.20,'2022-04-16 01:16:41','2022-04-16 01:16:41'),(136,1,1,'2022-04-16 01:17:27',26.40,'2022-04-16 01:17:27','2022-04-16 01:17:27'),(137,1,1,'2022-04-16 01:20:27',26.10,'2022-04-16 01:20:27','2022-04-16 01:20:27'),(138,2,2,'2022-04-16 01:20:59',46.00,'2022-04-16 01:20:59','2022-04-16 01:20:59'),(139,1,1,'2022-04-16 01:23:27',27.00,'2022-04-16 01:23:27','2022-04-16 01:23:27'),(140,1,1,'2022-04-16 01:24:27',27.80,'2022-04-16 01:24:27','2022-04-16 01:24:27'),(141,1,1,'2022-04-16 01:25:27',27.00,'2022-04-16 01:25:27','2022-04-16 01:25:27'),(142,1,1,'2022-04-16 01:26:27',26.60,'2022-04-16 01:26:27','2022-04-16 01:26:27'),(143,1,1,'2022-04-16 01:27:27',26.30,'2022-04-16 01:27:27','2022-04-16 01:27:27'),(144,3,1,'2022-04-16 01:31:05',-3.90,'2022-04-16 01:31:06','2022-04-16 01:31:06'),(145,1,1,'2022-04-16 01:31:27',26.00,'2022-04-16 01:31:27','2022-04-16 01:31:27'),(146,1,1,'2022-04-16 01:32:27',26.20,'2022-04-16 01:32:27','2022-04-16 01:32:27'),(147,1,1,'2022-04-16 01:33:27',27.70,'2022-04-16 01:33:27','2022-04-16 01:33:27'),(148,1,1,'2022-04-16 01:35:27',26.90,'2022-04-16 01:35:27','2022-04-16 01:35:27'),(149,1,1,'2022-04-16 01:36:27',26.50,'2022-04-16 01:36:27','2022-04-16 01:36:27'),(150,2,1,'2022-04-16 01:36:45',-0.40,'2022-04-16 01:36:45','2022-04-16 01:36:45'),(151,1,1,'2022-04-16 01:37:27',26.30,'2022-04-16 01:37:27','2022-04-16 01:37:27'),(152,1,1,'2022-04-16 01:41:27',26.00,'2022-04-16 01:41:27','2022-04-16 01:41:27'),(153,1,1,'2022-04-16 01:42:27',26.70,'2022-04-16 01:42:27','2022-04-16 01:42:27'),(154,1,1,'2022-04-16 01:43:27',27.70,'2022-04-16 01:43:27','2022-04-16 01:43:27'),(155,1,1,'2022-04-16 01:45:27',26.70,'2022-04-16 01:45:27','2022-04-16 01:45:27'),(156,1,1,'2022-04-16 01:46:27',26.40,'2022-04-16 01:46:27','2022-04-16 01:46:27'),(157,1,1,'2022-04-16 01:49:27',26.10,'2022-04-16 01:49:27','2022-04-16 01:49:27'),(158,1,1,'2022-04-16 01:52:27',27.10,'2022-04-16 01:52:27','2022-04-16 01:52:27'),(159,1,1,'2022-04-16 01:53:27',27.90,'2022-04-16 01:53:27','2022-04-16 01:53:27'),(160,2,1,'2022-04-16 01:53:57',-0.60,'2022-04-16 01:53:57','2022-04-16 01:53:57'),(161,1,1,'2022-04-16 01:54:27',27.00,'2022-04-16 01:54:27','2022-04-16 01:54:27'),(162,1,1,'2022-04-16 01:55:27',26.60,'2022-04-16 01:55:27','2022-04-16 01:55:27'),(163,1,1,'2022-04-16 01:56:27',26.40,'2022-04-16 01:56:27','2022-04-16 01:56:27'),(164,1,1,'2022-04-16 01:58:27',26.10,'2022-04-16 01:58:27','2022-04-16 01:58:27'),(165,3,2,'2022-04-16 02:01:55',77.00,'2022-04-16 02:01:55','2022-04-16 02:01:55'),(166,1,1,'2022-04-16 02:02:27',27.50,'2022-04-16 02:02:27','2022-04-16 02:02:27'),(167,1,1,'2022-04-16 02:04:27',26.80,'2022-04-16 02:04:27','2022-04-16 02:04:27'),(168,1,1,'2022-04-16 02:05:27',26.50,'2022-04-16 02:05:27','2022-04-16 02:05:27'),(169,1,1,'2022-04-16 02:06:27',26.30,'2022-04-16 02:06:27','2022-04-16 02:06:27'),(170,2,2,'2022-04-16 02:06:51',47.00,'2022-04-16 02:06:51','2022-04-16 02:06:51'),(171,1,1,'2022-04-16 02:09:27',26.00,'2022-04-16 02:09:27','2022-04-16 02:09:27'),(172,1,1,'2022-04-16 02:11:27',26.90,'2022-04-16 02:11:27','2022-04-16 02:11:27'),(173,1,1,'2022-04-16 02:12:27',27.70,'2022-04-16 02:12:27','2022-04-16 02:12:27'),(174,1,1,'2022-04-16 02:13:27',27.10,'2022-04-16 02:13:27','2022-04-16 02:13:27'),(175,1,1,'2022-04-16 02:14:27',26.60,'2022-04-16 02:14:27','2022-04-16 02:14:27'),(176,1,1,'2022-04-16 02:15:27',26.30,'2022-04-16 02:15:27','2022-04-16 02:15:27'),(177,2,1,'2022-04-16 02:17:36',-0.90,'2022-04-16 02:17:36','2022-04-16 02:17:36'),(178,1,1,'2022-04-16 02:18:27',26.00,'2022-04-16 02:18:27','2022-04-16 02:18:27'),(179,1,1,'2022-04-16 02:20:27',26.30,'2022-04-16 02:20:27','2022-04-16 02:20:27'),(180,3,2,'2022-04-16 02:21:15',78.00,'2022-04-16 02:21:16','2022-04-16 02:21:16'),(181,1,1,'2022-04-16 02:21:27',27.80,'2022-04-16 02:21:27','2022-04-16 02:21:27'),(182,1,1,'2022-04-16 02:22:27',27.50,'2022-04-16 02:22:27','2022-04-16 02:22:27'),(183,1,1,'2022-04-16 02:23:27',26.90,'2022-04-16 02:23:27','2022-04-16 02:23:27'),(184,1,1,'2022-04-16 02:24:27',26.40,'2022-04-16 02:24:27','2022-04-16 02:24:27'),(185,1,1,'2022-04-16 02:27:27',26.10,'2022-04-16 02:27:27','2022-04-16 02:27:27'),(186,1,1,'2022-04-16 02:30:27',27.50,'2022-04-16 02:30:27','2022-04-16 02:30:27'),(187,2,2,'2022-04-16 02:31:13',48.00,'2022-04-16 02:31:13','2022-04-16 02:31:13'),(188,1,1,'2022-04-16 02:31:27',27.90,'2022-04-16 02:31:27','2022-04-16 02:31:27'),(189,1,1,'2022-04-16 02:32:27',27.10,'2022-04-16 02:32:27','2022-04-16 02:32:27'),(190,1,1,'2022-04-16 02:34:27',26.30,'2022-04-16 02:34:27','2022-04-16 02:34:27'),(191,1,1,'2022-04-16 02:37:27',26.00,'2022-04-16 02:37:27','2022-04-16 02:37:27'),(192,3,1,'2022-04-16 02:37:44',-4.20,'2022-04-16 02:37:45','2022-04-16 02:37:45'),(193,3,2,'2022-04-16 02:39:10',77.00,'2022-04-16 02:39:11','2022-04-16 02:39:11'),(194,1,1,'2022-04-16 02:39:27',27.20,'2022-04-16 02:39:27','2022-04-16 02:39:27'),(195,1,1,'2022-04-16 02:40:27',27.80,'2022-04-16 02:40:27','2022-04-16 02:40:27'),(196,1,1,'2022-04-16 02:41:27',27.30,'2022-04-16 02:41:27','2022-04-16 02:41:27'),(197,2,1,'2022-04-16 02:41:58',-1.10,'2022-04-16 02:41:58','2022-04-16 02:41:58'),(198,1,1,'2022-04-16 02:42:27',26.50,'2022-04-16 02:42:27','2022-04-16 02:42:27'),(199,1,1,'2022-04-16 02:43:27',26.30,'2022-04-16 02:43:27','2022-04-16 02:43:27'),(200,1,1,'2022-04-16 02:46:27',26.00,'2022-04-16 02:46:27','2022-04-16 02:46:27'),(201,1,1,'2022-04-16 02:48:27',26.80,'2022-04-16 02:48:27','2022-04-16 02:48:27'),(202,3,1,'2022-04-16 02:49:13',-4.40,'2022-04-16 02:49:13','2022-04-16 02:49:13'),(203,1,1,'2022-04-16 02:49:27',27.70,'2022-04-16 02:49:27','2022-04-16 02:49:27'),(204,1,1,'2022-04-16 02:51:27',26.60,'2022-04-16 02:51:27','2022-04-16 02:51:27'),(205,1,1,'2022-04-16 02:52:27',26.40,'2022-04-16 02:52:27','2022-04-16 02:52:27'),(206,1,1,'2022-04-16 02:54:27',26.10,'2022-04-16 02:54:27','2022-04-16 02:54:27'),(207,1,1,'2022-04-16 02:57:27',26.50,'2022-04-16 02:57:27','2022-04-16 02:57:27'),(208,1,1,'2022-04-16 02:58:27',27.50,'2022-04-16 02:58:27','2022-04-16 02:58:27'),(209,1,1,'2022-04-16 02:59:27',27.70,'2022-04-16 02:59:27','2022-04-16 02:59:27'),(210,1,1,'2022-04-16 03:00:27',26.80,'2022-04-16 03:00:27','2022-04-16 03:00:27'),(211,1,1,'2022-04-16 03:01:27',26.40,'2022-04-16 03:01:27','2022-04-16 03:01:27'),(212,1,1,'2022-04-16 03:03:27',26.10,'2022-04-16 03:03:27','2022-04-16 03:03:27'),(213,2,2,'2022-04-16 03:06:20',49.00,'2022-04-16 03:06:20','2022-04-16 03:06:20'),(214,1,1,'2022-04-16 03:07:27',27.30,'2022-04-16 03:07:27','2022-04-16 03:07:27'),(215,1,1,'2022-04-16 03:08:27',27.70,'2022-04-16 03:08:27','2022-04-16 03:08:27'),(216,1,1,'2022-04-16 03:09:27',26.80,'2022-04-16 03:09:27','2022-04-16 03:09:27'),(217,1,1,'2022-04-16 03:10:27',26.40,'2022-04-16 03:10:27','2022-04-16 03:10:27'),(218,2,1,'2022-04-16 03:10:38',-1.40,'2022-04-16 03:10:38','2022-04-16 03:10:38'),(219,1,1,'2022-04-16 03:12:26',26.10,'2022-04-16 03:12:27','2022-04-16 03:12:27'),(220,1,1,'2022-04-16 03:15:27',26.40,'2022-04-16 03:15:27','2022-04-16 03:15:27'),(221,1,1,'2022-04-16 03:17:27',27.80,'2022-04-16 03:17:27','2022-04-16 03:17:27'),(222,1,1,'2022-04-16 03:18:27',26.80,'2022-04-16 03:18:27','2022-04-16 03:18:27'),(223,1,1,'2022-04-16 03:19:27',26.40,'2022-04-16 03:19:27','2022-04-16 03:19:27'),(224,1,1,'2022-04-16 03:21:27',26.10,'2022-04-16 03:21:27','2022-04-16 03:21:27'),(225,1,1,'2022-04-16 03:25:27',27.30,'2022-04-16 03:25:27','2022-04-16 03:25:27'),(226,1,1,'2022-04-16 03:26:27',27.70,'2022-04-16 03:26:27','2022-04-16 03:26:27'),(227,1,1,'2022-04-16 03:27:27',26.90,'2022-04-16 03:27:27','2022-04-16 03:27:27'),(228,1,1,'2022-04-16 03:28:27',26.50,'2022-04-16 03:28:27','2022-04-16 03:28:27'),(229,1,1,'2022-04-16 03:30:27',26.10,'2022-04-16 03:30:27','2022-04-16 03:30:27'),(230,3,2,'2022-04-16 03:32:13',78.00,'2022-04-16 03:32:13','2022-04-16 03:32:13'),(231,1,1,'2022-04-16 03:34:27',27.50,'2022-04-16 03:34:27','2022-04-16 03:34:27'),(232,1,1,'2022-04-16 03:35:27',27.70,'2022-04-16 03:35:27','2022-04-16 03:35:27'),(233,1,1,'2022-04-16 03:36:27',26.80,'2022-04-16 03:36:27','2022-04-16 03:36:27'),(234,2,1,'2022-04-16 03:37:09',-1.60,'2022-04-16 03:37:09','2022-04-16 03:37:09'),(235,1,1,'2022-04-16 03:37:27',26.40,'2022-04-16 03:37:27','2022-04-16 03:37:27'),(236,1,1,'2022-04-16 03:39:27',26.10,'2022-04-16 03:39:27','2022-04-16 03:39:27'),(237,1,1,'2022-04-16 03:41:27',25.90,'2022-04-16 03:41:27','2022-04-16 03:41:27'),(238,1,1,'2022-04-16 03:42:27',26.40,'2022-04-16 03:42:27','2022-04-16 03:42:27'),(239,2,2,'2022-04-16 03:42:53',50.00,'2022-04-16 03:42:53','2022-04-16 03:42:53'),(240,3,2,'2022-04-16 03:42:58',79.00,'2022-04-16 03:42:58','2022-04-16 03:42:58'),(241,1,1,'2022-04-16 03:43:27',27.60,'2022-04-16 03:43:27','2022-04-16 03:43:27'),(242,1,1,'2022-04-16 03:45:27',26.70,'2022-04-16 03:45:27','2022-04-16 03:45:27'),(243,1,1,'2022-04-16 03:46:27',26.50,'2022-04-16 03:46:27','2022-04-16 03:46:27'),(244,1,1,'2022-04-16 03:47:27',26.30,'2022-04-16 03:47:27','2022-04-16 03:47:27'),(245,1,1,'2022-04-16 03:49:27',26.00,'2022-04-16 03:49:27','2022-04-16 03:49:27'),(246,1,1,'2022-04-16 03:51:27',26.60,'2022-04-16 03:51:27','2022-04-16 03:51:27'),(247,1,1,'2022-04-16 03:52:27',27.60,'2022-04-16 03:52:27','2022-04-16 03:52:27'),(248,1,1,'2022-04-16 03:54:27',26.60,'2022-04-16 03:54:27','2022-04-16 03:54:27'),(249,1,1,'2022-04-16 03:56:27',26.20,'2022-04-16 03:56:27','2022-04-16 03:56:27'),(250,1,1,'2022-04-16 03:59:27',25.90,'2022-04-16 03:59:27','2022-04-16 03:59:27'),(251,1,1,'2022-04-16 04:00:27',26.80,'2022-04-16 04:00:27','2022-04-16 04:00:27'),(252,1,1,'2022-04-16 04:01:27',27.60,'2022-04-16 04:01:27','2022-04-16 04:01:27'),(253,1,1,'2022-04-16 04:03:27',26.60,'2022-04-16 04:03:27','2022-04-16 04:03:27'),(254,1,1,'2022-04-16 04:04:27',26.30,'2022-04-16 04:04:27','2022-04-16 04:04:27'),(255,1,1,'2022-04-16 04:06:27',26.00,'2022-04-16 04:06:27','2022-04-16 04:06:27'),(256,1,1,'2022-04-16 04:09:27',26.90,'2022-04-16 04:09:27','2022-04-16 04:09:27'),(257,1,1,'2022-04-16 04:10:27',27.70,'2022-04-16 04:10:27','2022-04-16 04:10:27'),(258,1,1,'2022-04-16 04:11:27',27.30,'2022-04-16 04:11:27','2022-04-16 04:11:27'),(259,1,1,'2022-04-16 04:12:27',26.50,'2022-04-16 04:12:27','2022-04-16 04:12:27'),(260,1,1,'2022-04-16 04:13:27',26.30,'2022-04-16 04:13:27','2022-04-16 04:13:27'),(261,1,1,'2022-04-16 04:16:27',25.90,'2022-04-16 04:16:27','2022-04-16 04:16:27'),(262,1,1,'2022-04-16 04:19:27',27.70,'2022-04-16 04:19:27','2022-04-16 04:19:27'),(263,1,1,'2022-04-16 04:20:27',27.00,'2022-04-16 04:20:27','2022-04-16 04:20:27'),(264,1,1,'2022-04-16 04:21:27',26.50,'2022-04-16 04:21:27','2022-04-16 04:21:27'),(265,1,1,'2022-04-16 04:22:27',26.30,'2022-04-16 04:22:27','2022-04-16 04:22:27'),(266,1,1,'2022-04-16 04:24:27',26.00,'2022-04-16 04:24:26','2022-04-16 04:24:26'),(267,1,1,'2022-04-16 04:26:27',26.20,'2022-04-16 04:26:26','2022-04-16 04:26:26'),(268,1,1,'2022-04-16 04:27:27',27.60,'2022-04-16 04:27:26','2022-04-16 04:27:26'),(269,1,1,'2022-04-16 04:29:27',26.90,'2022-04-16 04:29:27','2022-04-16 04:29:27'),(270,2,2,'2022-04-16 04:30:11',51.00,'2022-04-16 04:30:11','2022-04-16 04:30:11'),(271,3,1,'2022-04-16 04:30:16',-4.20,'2022-04-16 04:30:16','2022-04-16 04:30:16'),(272,1,1,'2022-04-16 04:30:27',26.30,'2022-04-16 04:30:27','2022-04-16 04:30:27'),(273,1,1,'2022-04-16 04:34:27',25.90,'2022-04-16 04:34:27','2022-04-16 04:34:27'),(274,1,1,'2022-04-16 04:35:27',26.70,'2022-04-16 04:35:27','2022-04-16 04:35:27'),(275,1,1,'2022-04-16 04:36:27',27.80,'2022-04-16 04:36:27','2022-04-16 04:36:27'),(276,1,1,'2022-04-16 04:37:27',27.30,'2022-04-16 04:37:27','2022-04-16 04:37:27'),(277,1,1,'2022-04-16 04:38:27',26.60,'2022-04-16 04:38:26','2022-04-16 04:38:26'),(278,1,1,'2022-04-16 04:39:27',26.20,'2022-04-16 04:39:26','2022-04-16 04:39:26'),(279,1,1,'2022-04-16 04:41:27',26.00,'2022-04-16 04:41:26','2022-04-16 04:41:26'),(280,3,1,'2022-04-16 04:43:10',-3.90,'2022-04-16 04:43:10','2022-04-16 04:43:10'),(281,1,1,'2022-04-16 04:44:27',27.00,'2022-04-16 04:44:26','2022-04-16 04:44:26'),(282,1,1,'2022-04-16 04:45:26',27.60,'2022-04-16 04:45:27','2022-04-16 04:45:27'),(283,1,1,'2022-04-16 04:46:27',27.00,'2022-04-16 04:46:27','2022-04-16 04:46:27'),(284,1,1,'2022-04-16 04:47:26',26.60,'2022-04-16 04:47:27','2022-04-16 04:47:27'),(285,1,1,'2022-04-16 04:48:26',26.20,'2022-04-16 04:48:27','2022-04-16 04:48:27'),(286,1,1,'2022-04-16 04:50:26',26.00,'2022-04-16 04:50:27','2022-04-16 04:50:27'),(287,1,1,'2022-04-16 04:52:27',26.20,'2022-04-16 04:52:26','2022-04-16 04:52:26'),(288,3,1,'2022-04-16 04:52:29',-3.70,'2022-04-16 04:52:29','2022-04-16 04:52:29'),(289,1,1,'2022-04-16 04:53:27',27.30,'2022-04-16 04:53:26','2022-04-16 04:53:26'),(290,1,1,'2022-04-16 04:55:27',26.70,'2022-04-16 04:55:26','2022-04-16 04:55:26'),(291,1,1,'2022-04-16 04:56:27',26.40,'2022-04-16 04:56:26','2022-04-16 04:56:26'),(292,1,1,'2022-04-16 04:57:27',26.10,'2022-04-16 04:57:26','2022-04-16 04:57:26'),(293,3,1,'2022-04-16 04:59:39',-3.50,'2022-04-16 04:59:39','2022-04-16 04:59:39'),(294,1,1,'2022-04-16 05:00:26',25.90,'2022-04-16 05:00:27','2022-04-16 05:00:27'),(295,1,1,'2022-04-16 05:01:26',26.80,'2022-04-16 05:01:27','2022-04-16 05:01:27'),(296,1,1,'2022-04-16 05:02:27',27.60,'2022-04-16 05:02:27','2022-04-16 05:02:27'),(297,3,2,'2022-04-16 05:02:31',78.00,'2022-04-16 05:02:31','2022-04-16 05:02:31'),(298,1,1,'2022-04-16 05:03:26',27.10,'2022-04-16 05:03:27','2022-04-16 05:03:27'),(299,1,1,'2022-04-16 05:04:26',26.60,'2022-04-16 05:04:26','2022-04-16 05:04:26'),(300,1,1,'2022-04-16 05:05:26',26.40,'2022-04-16 05:05:27','2022-04-16 05:05:27'),(301,1,1,'2022-04-16 05:06:26',26.10,'2022-04-16 05:06:27','2022-04-16 05:06:27'),(302,3,1,'2022-04-16 05:06:49',-3.30,'2022-04-16 05:06:49','2022-04-16 05:06:49'),(303,1,1,'2022-04-16 05:08:26',25.90,'2022-04-16 05:08:27','2022-04-16 05:08:27'),(304,1,1,'2022-04-16 05:09:26',26.40,'2022-04-16 05:09:27','2022-04-16 05:09:27'),(305,1,1,'2022-04-16 05:10:26',27.30,'2022-04-16 05:10:27','2022-04-16 05:10:27'),(306,1,1,'2022-04-16 05:11:26',27.80,'2022-04-16 05:11:27','2022-04-16 05:11:27'),(307,1,1,'2022-04-16 05:12:26',26.80,'2022-04-16 05:12:27','2022-04-16 05:12:27'),(308,2,2,'2022-04-16 05:12:28',52.00,'2022-04-16 05:12:28','2022-04-16 05:12:28'),(309,2,1,'2022-04-16 05:13:11',-1.40,'2022-04-16 05:13:11','2022-04-16 05:13:11'),(310,1,1,'2022-04-16 05:13:26',26.50,'2022-04-16 05:13:27','2022-04-16 05:13:27'),(311,3,1,'2022-04-16 05:13:59',-3.10,'2022-04-16 05:13:59','2022-04-16 05:13:59'),(312,1,1,'2022-04-16 05:14:26',26.20,'2022-04-16 05:14:27','2022-04-16 05:14:27'),(313,1,1,'2022-04-16 05:17:26',26.00,'2022-04-16 05:17:27','2022-04-16 05:17:27'),(314,1,1,'2022-04-16 05:18:26',27.10,'2022-04-16 05:18:27','2022-04-16 05:18:27'),(315,1,1,'2022-04-16 05:19:26',27.80,'2022-04-16 05:19:27','2022-04-16 05:19:27'),(316,1,1,'2022-04-16 05:20:26',27.10,'2022-04-16 05:20:27','2022-04-16 05:20:27'),(317,1,1,'2022-04-16 05:21:26',26.50,'2022-04-16 05:21:27','2022-04-16 05:21:27'),(318,1,1,'2022-04-16 05:22:26',26.20,'2022-04-16 05:22:27','2022-04-16 05:22:27'),(319,1,1,'2022-04-16 05:25:26',26.00,'2022-04-16 05:25:27','2022-04-16 05:25:27'),(320,1,1,'2022-04-16 05:26:26',26.30,'2022-04-16 05:26:27','2022-04-16 05:26:27'),(321,1,1,'2022-04-16 05:27:26',27.60,'2022-04-16 05:27:27','2022-04-16 05:27:27'),(322,1,1,'2022-04-16 05:29:26',26.70,'2022-04-16 05:29:27','2022-04-16 05:29:27'),(323,1,1,'2022-04-16 05:30:26',26.20,'2022-04-16 05:30:27','2022-04-16 05:30:27'),(324,3,1,'2022-04-16 05:31:11',-2.80,'2022-04-16 05:31:11','2022-04-16 05:31:11'),(325,1,1,'2022-04-16 05:32:26',26.00,'2022-04-16 05:32:26','2022-04-16 05:32:26'),(326,2,1,'2022-04-16 05:35:24',-1.10,'2022-04-16 05:35:24','2022-04-16 05:35:24'),(327,1,1,'2022-04-16 05:35:26',26.90,'2022-04-16 05:35:27','2022-04-16 05:35:27'),(328,1,1,'2022-04-16 05:36:26',27.70,'2022-04-16 05:36:27','2022-04-16 05:36:27'),(329,3,1,'2022-04-16 05:36:55',-2.60,'2022-04-16 05:36:55','2022-04-16 05:36:55'),(330,1,1,'2022-04-16 05:37:26',27.10,'2022-04-16 05:37:27','2022-04-16 05:37:27'),(331,1,1,'2022-04-16 05:38:26',26.50,'2022-04-16 05:38:27','2022-04-16 05:38:27'),(332,1,1,'2022-04-16 05:39:26',26.20,'2022-04-16 05:39:27','2022-04-16 05:39:27'),(333,1,1,'2022-04-16 05:42:26',25.90,'2022-04-16 05:42:27','2022-04-16 05:42:27'),(334,1,1,'2022-04-16 05:43:26',26.50,'2022-04-16 05:43:26','2022-04-16 05:43:26'),(335,1,1,'2022-04-16 05:44:27',27.30,'2022-04-16 05:44:27','2022-04-16 05:44:27'),(336,1,1,'2022-04-16 05:45:27',27.50,'2022-04-16 05:45:27','2022-04-16 05:45:27'),(337,1,1,'2022-04-16 05:46:26',26.80,'2022-04-16 05:46:26','2022-04-16 05:46:26'),(338,1,1,'2022-04-16 05:47:26',26.40,'2022-04-16 05:47:27','2022-04-16 05:47:27'),(339,2,1,'2022-04-16 05:47:35',-0.90,'2022-04-16 05:47:35','2022-04-16 05:47:35'),(340,1,1,'2022-04-16 05:48:26',26.10,'2022-04-16 05:48:27','2022-04-16 05:48:27'),(341,3,1,'2022-04-16 05:49:49',-2.30,'2022-04-16 05:49:49','2022-04-16 05:49:49'),(342,1,1,'2022-04-16 05:51:26',25.90,'2022-04-16 05:51:27','2022-04-16 05:51:27'),(343,1,1,'2022-04-16 05:52:26',26.80,'2022-04-16 05:52:27','2022-04-16 05:52:27'),(344,1,1,'2022-04-16 05:53:26',27.80,'2022-04-16 05:53:27','2022-04-16 05:53:27'),(345,1,1,'2022-04-16 05:54:26',27.10,'2022-04-16 05:54:27','2022-04-16 05:54:27'),(346,1,1,'2022-04-16 05:55:26',26.50,'2022-04-16 05:55:27','2022-04-16 05:55:27'),(347,1,1,'2022-04-16 05:56:26',26.30,'2022-04-16 05:56:27','2022-04-16 05:56:27'),(348,3,1,'2022-04-16 05:57:42',-2.10,'2022-04-16 05:57:42','2022-04-16 05:57:42'),(349,2,2,'2022-04-16 05:58:20',53.00,'2022-04-16 05:58:21','2022-04-16 05:58:21'),(350,1,1,'2022-04-16 05:59:26',26.00,'2022-04-16 05:59:26','2022-04-16 05:59:26'),(351,1,1,'2022-04-16 06:00:26',26.40,'2022-04-16 06:00:26','2022-04-16 06:00:26'),(352,1,1,'2022-04-16 06:01:26',27.30,'2022-04-16 06:01:27','2022-04-16 06:01:27'),(353,1,1,'2022-04-16 06:02:26',27.70,'2022-04-16 06:02:27','2022-04-16 06:02:27'),(354,1,1,'2022-04-16 06:03:26',26.90,'2022-04-16 06:03:27','2022-04-16 06:03:27'),(355,1,1,'2022-04-16 06:04:26',26.40,'2022-04-16 06:04:27','2022-04-16 06:04:27'),(356,2,1,'2022-04-16 06:04:47',-0.60,'2022-04-16 06:04:47','2022-04-16 06:04:47'),(357,3,2,'2022-04-16 06:04:52',77.00,'2022-04-16 06:04:52','2022-04-16 06:04:52');
/*!40000 ALTER TABLE `measurements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nodes`
--
DROP TABLE IF EXISTS `nodes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`nexaId` int(11) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nodes`
--
LOCK TABLES `nodes` WRITE;
/*!40000 ALTER TABLE `nodes` DISABLE KEYS */;
INSERT INTO `nodes` VALUES (1,'Vrmerret',1066,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(2,'Vxthus',1093,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(3,'Altan Vgg',1096,'2022-04-15 21:59:19','2022-04-15 21:59:19');
/*!40000 ALTER TABLE `nodes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sensors`
--
DROP TABLE IF EXISTS `sensors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sensors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sensors`
--
LOCK TABLES `sensors` WRITE;
/*!40000 ALTER TABLE `sensors` DISABLE KEYS */;
INSERT INTO `sensors` VALUES (1,'temperature','2022-04-15 21:59:19','2022-04-15 21:59:19'),(2,'humidity','2022-04-15 21:59:19','2022-04-15 21:59:19');
/*!40000 ALTER TABLE `sensors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `trackers`
--
DROP TABLE IF EXISTS `trackers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trackers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`node` int(11) NOT NULL,
`sensor` int(11) NOT NULL,
`created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `node` (`node`),
KEY `sensor` (`sensor`),
CONSTRAINT `trackers_ibfk_1` FOREIGN KEY (`node`) REFERENCES `nodes` (`id`),
CONSTRAINT `trackers_ibfk_2` FOREIGN KEY (`sensor`) REFERENCES `sensors` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `trackers`
--
LOCK TABLES `trackers` WRITE;
/*!40000 ALTER TABLE `trackers` DISABLE KEYS */;
INSERT INTO `trackers` VALUES (1,1,1,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(2,2,1,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(3,2,2,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(4,3,1,'2022-04-15 21:59:19','2022-04-15 21:59:19'),(5,3,2,'2022-04-15 21:59:19','2022-04-15 21:59:19');
/*!40000 ALTER TABLE `trackers` 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 2022-04-16 10:44:57