wmantly/mp
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
mp/schema/eco_saver_api-logs.sql
newtbot a9912d4ddc a
2024-01-05 19:42:02 +08:00

61 lines
28 KiB
SQL
Raw Permalink Blame History

-- MySQL dump 10.13 Distrib 8.0.34, for Win64 (x86_64)
--
-- Host: mpsqldatabase.mysql.database.azure.com Database: eco_saver
-- ------------------------------------------------------
-- Server version 8.0.34
/*!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 */;
/*!50503 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 `api-logs`
--
DROP TABLE IF EXISTS `api-logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api-logs` (
`id` int NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`method` varchar(255) NOT NULL,
`host` varchar(255) NOT NULL,
`statusCode` varchar(255) NOT NULL,
`Responsesize` varchar(255) NOT NULL,
`referrer` varchar(255) NOT NULL,
`userAgent` varchar(255) NOT NULL,
`createdAt` datetime DEFAULT NULL,
`updatedAt` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `api-logs`
--
LOCK TABLES `api-logs` WRITE;
/*!40000 ALTER TABLE `api-logs` DISABLE KEYS */;
INSERT INTO `api-logs` VALUES (1,'::1','Mon, 01 Jan 2024 18:48:04 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-01 18:48:04','2024-01-01 18:48:04'),(2,'::1','Tue, 02 Jan 2024 08:00:10 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:00:10','2024-01-02 08:00:10'),(3,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:00:16 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:00:16','2024-01-02 08:00:16'),(4,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:00:48 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:00:48','2024-01-02 08:00:48'),(5,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:01:02 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:01:02','2024-01-02 08:01:02'),(6,'::1','Tue, 02 Jan 2024 08:01:17 GMT','GET','http://localhost/api/v0/sensor-data/2','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:01:17','2024-01-02 08:01:17'),(7,'::1','Tue, 02 Jan 2024 08:01:19 GMT','GET','http://localhost/api/v0/sensor-data/2','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:01:19','2024-01-02 08:01:19'),(8,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:01:52 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:01:52','2024-01-02 08:01:52'),(9,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:02:41 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:02:41','2024-01-02 08:02:41'),(10,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:03:25 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:03:25','2024-01-02 08:03:25'),(11,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:03:51 GMT','PUT','http://localhost/api/v0/sensor-data/update','200','0','none','curl/7.87.0','2024-01-02 08:03:51','2024-01-02 08:03:51'),(12,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:05:10 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-02 08:05:10','2024-01-02 08:05:10'),(13,'::1','Tue, 02 Jan 2024 08:05:20 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:05:20','2024-01-02 08:05:20'),(14,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:07:48 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-02 08:07:48','2024-01-02 08:07:48'),(15,'::1','Tue, 02 Jan 2024 08:07:54 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:07:54','2024-01-02 08:07:54'),(16,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:41:38 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-02 08:41:38','2024-01-02 08:41:38'),(17,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:41:51 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-02 08:41:51','2024-01-02 08:41:51'),(18,'::1','Tue, 02 Jan 2024 08:42:02 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:42:02','2024-01-02 08:42:02'),(19,'::1','Tue, 02 Jan 2024 08:43:03 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:43:03','2024-01-02 08:43:03'),(20,'::1','Tue, 02 Jan 2024 08:43:05 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:43:05','2024-01-02 08:43:05'),(21,'::ffff:127.0.0.1','Tue, 02 Jan 2024 08:46:34 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-02 08:46:34','2024-01-02 08:46:34'),(22,'::1','Tue, 02 Jan 2024 08:46:41 GMT','GET','http://localhost/api/v0/location','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-02 08:46:41','2024-01-02 08:46:41'),(23,'::1','Wed, 03 Jan 2024 07:54:42 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 07:54:42','2024-01-03 07:54:42'),(24,'::1','Wed, 03 Jan 2024 07:54:53 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 07:54:53','2024-01-03 07:54:53'),(25,'::1','Wed, 03 Jan 2024 10:56:40 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 10:56:40','2024-01-03 10:56:40'),(26,'::1','Wed, 03 Jan 2024 11:08:01 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:08:01','2024-01-03 11:08:01'),(27,'::1','Wed, 03 Jan 2024 11:11:00 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:11:00','2024-01-03 11:11:00'),(28,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:14:34 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:14:34','2024-01-03 11:14:34'),(29,'::1','Wed, 03 Jan 2024 11:39:25 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:39:25','2024-01-03 11:39:25'),(30,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:39:34 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:39:34','2024-01-03 11:39:34'),(31,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:39:42 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:39:42','2024-01-03 11:39:42'),(32,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:39:48 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:39:48','2024-01-03 11:39:48'),(33,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:40:29 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:40:29','2024-01-03 11:40:29'),(34,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:40:37 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:40:37','2024-01-03 11:40:37'),(35,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:41:01 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:41:01','2024-01-03 11:41:01'),(36,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:41:42 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:41:42','2024-01-03 11:41:42'),(37,'::1','Wed, 03 Jan 2024 11:41:47 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:41:47','2024-01-03 11:41:47'),(38,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:41:57 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:41:57','2024-01-03 11:41:57'),(39,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:42:12 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:42:12','2024-01-03 11:42:12'),(40,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:42:54 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:42:54','2024-01-03 11:42:54'),(41,'::1','Wed, 03 Jan 2024 11:43:00 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:43:00','2024-01-03 11:43:00'),(42,'::1','Wed, 03 Jan 2024 11:43:00 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:43:00','2024-01-03 11:43:00'),(43,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:43:16 GMT','POST','http://localhost/api/v0/location/new','200','0','none','curl/7.87.0','2024-01-03 11:43:16','2024-01-03 11:43:16'),(44,'::1','Wed, 03 Jan 2024 11:43:19 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:43:19','2024-01-03 11:43:19'),(45,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:45:04 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 11:45:04','2024-01-03 11:45:04'),(46,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:45:08 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 11:45:08','2024-01-03 11:45:08'),(47,'::1','Wed, 03 Jan 2024 11:45:10 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:45:10','2024-01-03 11:45:10'),(48,'::1','Wed, 03 Jan 2024 11:59:34 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:59:34','2024-01-03 11:59:34'),(49,'::ffff:127.0.0.1','Wed, 03 Jan 2024 11:59:48 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 11:59:48','2024-01-03 11:59:48'),(50,'::1','Wed, 03 Jan 2024 11:59:52 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 11:59:52','2024-01-03 11:59:52'),(51,'::1','Wed, 03 Jan 2024 12:05:54 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:05:54','2024-01-03 12:05:54'),(52,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:05:59 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:05:59','2024-01-03 12:05:59'),(53,'::1','Wed, 03 Jan 2024 12:10:10 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:10:10','2024-01-03 12:10:10'),(54,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:10:18 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:10:18','2024-01-03 12:10:18'),(55,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:10:20 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:10:20','2024-01-03 12:10:20'),(56,'::1','Wed, 03 Jan 2024 12:21:48 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:21:48','2024-01-03 12:21:48'),(57,'::1','Wed, 03 Jan 2024 12:21:50 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:21:50','2024-01-03 12:21:50'),(58,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:21:53 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:21:53','2024-01-03 12:21:53'),(59,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:21:56 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:21:56','2024-01-03 12:21:56'),(60,'::1','Wed, 03 Jan 2024 12:23:12 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:23:12','2024-01-03 12:23:12'),(61,'::1','Wed, 03 Jan 2024 12:28:15 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:28:15','2024-01-03 12:28:15'),(62,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:28:22 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:28:22','2024-01-03 12:28:22'),(63,'::ffff:127.0.0.1','Wed, 03 Jan 2024 12:28:24 GMT','DELETE','http://localhost/api/v0/location/delete','200','0','none','curl/7.87.0','2024-01-03 12:28:24','2024-01-03 12:28:24'),(64,'::1','Wed, 03 Jan 2024 12:28:29 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:28:29','2024-01-03 12:28:29'),(65,'::1','Wed, 03 Jan 2024 12:28:33 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 12:28:33','2024-01-03 12:28:33'),(66,'::1','Wed, 03 Jan 2024 13:40:01 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 13:40:01','2024-01-03 13:40:01'),(67,'::1','Wed, 03 Jan 2024 13:40:07 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 13:40:07','2024-01-03 13:40:07'),(68,'::1','Wed, 03 Jan 2024 16:28:22 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 16:28:22','2024-01-03 16:28:22'),(69,'::1','Wed, 03 Jan 2024 16:28:24 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 16:28:24','2024-01-03 16:28:24'),(70,'::ffff:127.0.0.1','Wed, 03 Jan 2024 16:29:05 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 16:29:05','2024-01-03 16:29:05'),(71,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:20:57 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:20:57','2024-01-03 17:20:57'),(72,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:21:21 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:21:21','2024-01-03 17:21:21'),(73,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:23:23 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:23:23','2024-01-03 17:23:23'),(74,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:23:50 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:23:50','2024-01-03 17:23:50'),(75,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:24:16 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:24:16','2024-01-03 17:24:16'),(76,'::1','Wed, 03 Jan 2024 17:24:51 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:24:51','2024-01-03 17:24:51'),(77,'::1','Wed, 03 Jan 2024 17:24:54 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:24:54','2024-01-03 17:24:54'),(78,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:25:18 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:25:18','2024-01-03 17:25:18'),(79,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:25:27 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:25:27','2024-01-03 17:25:27'),(80,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:28:02 GMT','POST','http://localhost/api/v0/sensor-data/new','200','0','none','curl/7.87.0','2024-01-03 17:28:02','2024-01-03 17:28:02'),(81,'::1','Wed, 03 Jan 2024 17:28:05 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:28:05','2024-01-03 17:28:05'),(82,'::1','Wed, 03 Jan 2024 17:31:06 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:31:06','2024-01-03 17:31:06'),(83,'::1','Wed, 03 Jan 2024 17:31:07 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:31:07','2024-01-03 17:31:07'),(84,'::1','Wed, 03 Jan 2024 17:31:08 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:31:08','2024-01-03 17:31:08'),(85,'::1','Wed, 03 Jan 2024 17:31:09 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:31:09','2024-01-03 17:31:09'),(86,'::1','Wed, 03 Jan 2024 17:32:30 GMT','GET','http://localhost/api/v0/sensor/1','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:32:30','2024-01-03 17:32:30'),(87,'::1','Wed, 03 Jan 2024 17:33:37 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:33:37','2024-01-03 17:33:37'),(88,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:33:46 GMT','POST','http://localhost/api/v0/sensor/new','200','0','none','curl/7.87.0','2024-01-03 17:33:46','2024-01-03 17:33:46'),(89,'::1','Wed, 03 Jan 2024 17:34:21 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:21','2024-01-03 17:34:21'),(90,'::1','Wed, 03 Jan 2024 17:34:23 GMT','GET','http://localhost/api/v0/sensor/1','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:23','2024-01-03 17:34:23'),(91,'::1','Wed, 03 Jan 2024 17:34:24 GMT','GET','http://localhost/api/v0/sensor/1','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:24','2024-01-03 17:34:24'),(92,'::1','Wed, 03 Jan 2024 17:34:25 GMT','GET','http://localhost/api/v0/sensor/1','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:25','2024-01-03 17:34:25'),(93,'::1','Wed, 03 Jan 2024 17:34:25 GMT','GET','http://localhost/api/v0/sensor/1','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:25','2024-01-03 17:34:25'),(94,'::1','Wed, 03 Jan 2024 17:34:55 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:34:55','2024-01-03 17:34:55'),(95,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:35:04 GMT','PUT','http://localhost/api/v0/sensor/update','200','0','none','curl/7.87.0','2024-01-03 17:35:04','2024-01-03 17:35:04'),(96,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:35:22 GMT','PUT','http://localhost/api/v0/sensor/update','200','0','none','curl/7.87.0','2024-01-03 17:35:22','2024-01-03 17:35:22'),(97,'::1','Wed, 03 Jan 2024 17:35:28 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:35:28','2024-01-03 17:35:28'),(98,'::1','Wed, 03 Jan 2024 17:35:32 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:35:32','2024-01-03 17:35:32'),(99,'::1','Wed, 03 Jan 2024 17:35:34 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:35:34','2024-01-03 17:35:34'),(100,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:35:53 GMT','PUT','http://localhost/api/v0/sensor/update','200','0','none','curl/7.87.0','2024-01-03 17:35:53','2024-01-03 17:35:53'),(101,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:36:14 GMT','PUT','http://localhost/api/v0/sensor/update','200','0','none','curl/7.87.0','2024-01-03 17:36:14','2024-01-03 17:36:14'),(102,'::1','Wed, 03 Jan 2024 17:36:19 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:36:19','2024-01-03 17:36:19'),(103,'::1','Wed, 03 Jan 2024 17:36:32 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:36:32','2024-01-03 17:36:32'),(104,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:36:38 GMT','DELETE','http://localhost/api/v0/sensor/delete','200','0','none','curl/7.87.0','2024-01-03 17:36:38','2024-01-03 17:36:38'),(105,'::ffff:127.0.0.1','Wed, 03 Jan 2024 17:36:41 GMT','DELETE','http://localhost/api/v0/sensor/delete','200','0','none','curl/7.87.0','2024-01-03 17:36:41','2024-01-03 17:36:41'),(106,'::1','Wed, 03 Jan 2024 17:36:43 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-03 17:36:43','2024-01-03 17:36:43'),(107,'::1','Thu, 04 Jan 2024 15:26:25 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-04 15:26:25','2024-01-04 15:26:25'),(108,'::1','Thu, 04 Jan 2024 15:26:40 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-04 15:26:40','2024-01-04 15:26:40'),(109,'::1','Thu, 04 Jan 2024 15:27:03 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-04 15:27:03','2024-01-04 15:27:03'),(110,'::1','Thu, 04 Jan 2024 15:34:42 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-04 15:34:42','2024-01-04 15:34:42'),(111,'::1','Fri, 05 Jan 2024 10:16:02 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 10:16:02','2024-01-05 10:16:02'),(112,'::1','Fri, 05 Jan 2024 10:35:54 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 10:35:54','2024-01-05 10:35:54'),(113,'::1','Fri, 05 Jan 2024 10:59:14 GMT','GET','http://localhost/api/v0/location/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 10:59:14','2024-01-05 10:59:14'),(114,'::1','Fri, 05 Jan 2024 10:59:32 GMT','GET','http://localhost/api/v0/sensor/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 10:59:32','2024-01-05 10:59:32'),(115,'::1','Fri, 05 Jan 2024 11:22:52 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 11:22:52','2024-01-05 11:22:52'),(116,'::1','Fri, 05 Jan 2024 11:29:14 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 11:29:14','2024-01-05 11:29:14'),(117,'::1','Fri, 05 Jan 2024 11:29:36 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 11:29:36','2024-01-05 11:29:36'),(118,'::1','Fri, 05 Jan 2024 11:33:49 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 11:33:49','2024-01-05 11:33:49'),(119,'::1','Fri, 05 Jan 2024 11:34:15 GMT','GET','http://localhost/api/v0/sensor-data/','200','0','none','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36','2024-01-05 11:34:15','2024-01-05 11:34:15');
/*!40000 ALTER TABLE `api-logs` 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 2024-01-05 19:39:23
Reference in New Issue View Git Blame Copy Permalink