/*
 Navicat Premium Data Transfer

 Source Server         : 腾讯云：175.178.66.143
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : 175.178.66.143:3307
 Source Schema         : gps

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 25/05/2022 16:54:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_dev
-- ----------------------------
DROP TABLE IF EXISTS `tb_dev`;
CREATE TABLE `tb_dev`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `msg_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报文文本',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1368 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_dev
-- ----------------------------
INSERT INTO `tb_dev` VALUES (1, '014141138693', '2022-05-10 16:49:55', '2022-05-10 16:49:58', '014141138693设备');
INSERT INTO `tb_dev` VALUES (2, '019923518817', '2022-05-12 15:34:36', '2022-05-12 15:34:38', '8817设备');
INSERT INTO `tb_dev` VALUES (3, '199999999999', '2022-05-13 17:19:53', '2022-05-13 17:19:55', '9999设备');
INSERT INTO `tb_dev` VALUES (4, '014161853581', '2022-05-25 16:45:23', '2022-05-25 16:45:25', '014161853581');

-- ----------------------------
-- Table structure for tb_gps
-- ----------------------------
DROP TABLE IF EXISTS `tb_gps`;
CREATE TABLE `tb_gps`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `longitude` double(20, 6) NULL DEFAULT NULL COMMENT '经度',
  `latitude` double(20, 6) NULL DEFAULT NULL COMMENT '纬度',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `byte_next` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '报文文本',
  `msg_id` int(11) NULL DEFAULT NULL,
  `msg_property` int(11) NULL DEFAULT NULL,
  `msg_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `msg_Flow` int(11) UNSIGNED NULL DEFAULT NULL,
  `gps_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `longitude_wgs848` double(20, 6) NULL DEFAULT NULL COMMENT '经度',
  `latitude_wgs848` double(20, 6) NULL DEFAULT NULL COMMENT '经度',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1405 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_gps
-- ----------------------------
INSERT INTO `tb_gps` VALUES (1391, 114.027616, 22.547950, '2022-05-13 13:41:40', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1392, 113.027616, 22.537950, '2022-05-13 13:41:45', '2022-05-13 13:41:45', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1393, 112.027616, 22.527950, '2022-05-13 13:41:48', '2022-05-13 13:41:45', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1394, 111.027616, 22.517950, '2022-05-13 13:41:55', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1395, 106.546264, 29.518558, '2022-05-16 13:41:00', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '019923518817', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1396, 106.540256, 29.519529, '2022-05-16 13:41:30', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '019923518817', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1397, 106.528411, 29.519753, '2022-05-16 13:42:00', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '019923518817', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1398, 106.518026, 29.519903, '2022-05-16 13:42:30', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '019923518817', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1399, 106.517253, 29.512956, '2022-05-16 13:43:00', '2022-05-13 13:41:46', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '019923518817', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1400, 106.551052, 29.583920, '2022-05-16 13:41:00', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1401, 106.548048, 29.584256, '2022-05-16 13:41:30', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1402, 106.543198, 29.585898, '2022-05-16 13:42:00', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1403, 106.541911, 29.587241, '2022-05-16 13:42:30', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1404, 106.541911, 29.587241, '2022-05-17 13:42:30', '2022-05-13 13:41:40', '7E0200005B014141138693224E00000100000000000157E6DE06CBEC600000000000001703090019200104000026F5EB3700060089FFFFFFFD000700B400FFFFFFFF002400A901CC000627BD0FABCC27910000B727911287BF27BD1159C327BD0000BB27910ED1B5C97E', 512, 91, '014141138693', 0, NULL, NULL, NULL);
INSERT INTO `tb_gps` VALUES (1405, 106.522415, 29.494847, '2022-05-25 16:52:14', '2022-05-25 16:52:14', '7E020000730141618535810024000000000000000101C219280659586000000000000022052516521201040000004BEB4F0004002D0D4800060089FFFFFFFF000300A81E002400A901CC000633442B23183344759F1A33442B2115334475BE113344339B0E334480FF0D000C00B289860477012170960651000600C5FFFFFFE7067E', 512, 115, '014161853581', 0, '2022-05-26 00:52:12', 106.518624, 29.497640);
INSERT INTO `tb_gps` VALUES (1406, 106.510506, 29.500855, '2022-05-25 16:52:35', '2022-05-25 16:52:35', '7E020000730141618535810046000000000000000101C2307A065929B800000000000022052315301701040000004BEB4F0004002D0F4600060089FFFFFFFF000300A851002400A901CC000633442B21193344759F1733442B23163344339B14334480FF0E333F4F760A000C00B289860477012170960651000600C5FFFFFFE7137E', 512, 115, '014161853581', 0, '2022-05-23 15:30:17', 106.506680, 29.503610);
INSERT INTO `tb_gps` VALUES (1407, 106.510506, 29.500855, '2022-05-25 16:52:37', '2022-05-25 16:52:37', '7E020000730141618535810046000000000000000101C2307A065929B800000000000022052315301701040000004BEB4F0004002D0F4600060089FFFFFFFF000300A851002400A901CC000633442B21193344759F1733442B23163344339B14334480FF0E333F4F760A000C00B289860477012170960651000600C5FFFFFFE7137E', 512, 115, '014161853581', 0, '2022-05-23 15:30:17', 106.506680, 29.503610);
INSERT INTO `tb_gps` VALUES (1408, 106.510506, 29.500855, '2022-05-25 16:52:38', '2022-05-25 16:52:38', '7E020000730141618535810046000000000000000101C2307A065929B800000000000022052315301701040000004BEB4F0004002D0F4600060089FFFFFFFF000300A851002400A901CC000633442B21193344759F1733442B23163344339B14334480FF0E333F4F760A000C00B289860477012170960651000600C5FFFFFFE7137E', 512, 115, '014161853581', 0, '2022-05-23 15:30:17', 106.506680, 29.503610);
INSERT INTO `tb_gps` VALUES (1409, 106.522415, 29.494847, '2022-05-25 16:52:44', '2022-05-25 16:52:44', '7E020000730141618535810026000000000000000101C219280659586000000000000022052516524201040000004BEB4F0004002D0D4800060089FFFFFFFF000300A81E002400A901CC00063344759F1C33442B2113334475BE11334479880F3344339B0E334480FF0C000C00B289860477012170960651000600C5FFFFFFE7BB7E', 512, 115, '014161853581', 0, '2022-05-26 00:52:42', 106.518624, 29.497640);
INSERT INTO `tb_gps` VALUES (1410, 106.510506, 29.500855, '2022-05-25 16:53:00', '2022-05-25 16:53:00', '7E020000730141618535810046000000000000000101C2307A065929B800000000000022052315301701040000004BEB4F0004002D0F4600060089FFFFFFFF000300A851002400A901CC000633442B21193344759F1733442B23163344339B14334480FF0E333F4F760A000C00B289860477012170960651000600C5FFFFFFE7137E', 512, 115, '014161853581', 0, '2022-05-23 23:30:17', 106.506680, 29.503610);
INSERT INTO `tb_gps` VALUES (1411, 106.510506, 29.500855, '2022-05-25 16:53:02', '2022-05-25 16:53:02', '7E020000730141618535810046000000000000000101C2307A065929B800000000000022052315301701040000004BEB4F0004002D0F4600060089FFFFFFFF000300A851002400A901CC000633442B21193344759F1733442B23163344339B14334480FF0E333F4F760A000C00B289860477012170960651000600C5FFFFFFE7137E', 512, 115, '014161853581', 0, '2022-05-23 23:30:17', 106.506680, 29.503610);
INSERT INTO `tb_gps` VALUES (1412, 106.522415, 29.494847, '2022-05-25 16:53:14', '2022-05-25 16:53:14', '7E020000730141618535810027000000000000000101C219280659586000000000000022052516531201040000004BEB4F0004002D0D4800060089FFFFFFFF000300A81E002400A901CC00063344759F1C33442B2114334475BE11334479880F3344339B0F334480FF0E000C00B289860477012170960651000600C5FFFFFFE7EF7E', 512, 115, '014161853581', 0, '2022-05-26 00:53:12', 106.518624, 29.497640);
INSERT INTO `tb_gps` VALUES (1413, 106.522415, 29.494847, '2022-05-25 16:54:03', '2022-05-25 16:54:03', '7E020000730141618535810028000000000000000101C219280659586000000000000022052516534201040000004BEB4F0004002D0D4800060089FFFFFFFF000300A81E002400A901CC00063344759F1C33442B2116334475BE11334479880F3344339B0F334480FF0D000C00B289860477012170960651000600C5FFFFFFE7B17E', 512, 115, '014161853581', 0, '2022-05-26 00:53:42', 106.518624, 29.497640);
INSERT INTO `tb_gps` VALUES (1414, 106.522415, 29.494847, '2022-05-25 16:54:14', '2022-05-25 16:54:14', '7E020000730141618535810029000000000000000101C219280659586000000000000022052516541201040000004BEB4F0004002D0D4800060089FFFFFFFF000300A81E002400A901CC00033344759F1C3344339B0F334480FF0D000000000000000000000000000000000C00B289860477012170960651000600C5FFFFFFE7AD7E', 512, 115, '014161853581', 0, '2022-05-26 00:54:12', 106.518624, 29.497640);

SET FOREIGN_KEY_CHECKS = 1;