4dkankan-fusion/doc/update-1.7.3.sql

/*
 Navicat Premium Data Transfer

 Source Server         : local-192.168.0.25
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : 192.168.0.25:3306
 Source Schema         : fd_fusion

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

 Date: 25/04/2025 17:13:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_map_config
-- ----------------------------
DROP TABLE IF EXISTS `t_map_config`;
CREATE TABLE `t_map_config`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `map_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `coord` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `tb_status` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_map_config
-- ----------------------------
INSERT INTO `t_map_config` VALUES (1, '高德影像地图', '[{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=6&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18},{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=8&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18}]', NULL, '2025-03-28 11:21:01', '2025-04-25 17:13:17', 1);
INSERT INTO `t_map_config` VALUES (2, '高德矢量地图', '[{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=8&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18},{\"tempUrl\":\"//wprd04.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=7&x={x}&y={y}&z={z}&layer=6&token=YOUR_API_KEY\",\"maximumLevel\":18}]', NULL, '2025-03-28 11:22:00', '2025-04-25 17:13:17', 1);
INSERT INTO `t_map_config` VALUES (3, '江门内网地图', '[{\"tempUrl\":\"//a.map.jms.gd/tile/osm/{z}/{x}/{y}.png\",\"maximumLevel\":18}]', NULL, '2025-04-25 17:13:02', '2025-04-25 17:13:13', 0);

SET FOREIGN_KEY_CHECKS = 1;