CREATE TABLE `xp_test_point_0` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_1` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_2` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_3` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_4` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_5` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_6` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_7` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_8` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE `xp_test_point_9` ( `id` bigint NOT NULL, `electronic_area_id` bigint NULL DEFAULT NULL COMMENT '电子围栏区域id', `fp_electronic_area_id` bigint NULL DEFAULT NULL COMMENT '分片建', `point_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位名称', `point_poi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '点位poi', `point_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '点位编号唯一', `operation_status` int NULL DEFAULT 1 COMMENT '运营状态 1=待启用 2=启用中 3=已停用 4=已失效', `point_type` int NULL DEFAULT 1 COMMENT '点位类型 1=运营点位 2=测试点位', `verification_status` int NULL DEFAULT 1 COMMENT '验证状态 1=待验证、2=验证中、3=已验证 4验证失败', `parking_time_limit` int NULL DEFAULT NULL COMMENT '限停时长', `operation_type` int NULL DEFAULT 1 COMMENT '运营类型 1=与运营区同步 2=自定义时间段', `effective_period` int NULL DEFAULT NULL COMMENT '生效周期 1=“每日生效”、2=“仅工作日生效”、3=“仅非工作日生效”、4=“仅节假日生效”', `effective_time_period` json NULL COMMENT '生效时间段', `point_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情地址', `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `point_pictures` json NULL COMMENT '点位照片', `point_lon` double(20, 10) NOT NULL COMMENT '经度', `point_lat` double(20, 10) NOT NULL COMMENT '纬度', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除 0=未删除 1=已删除', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间', `create_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '创建人', `update_by` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '修改人', `charge_point` int NULL DEFAULT 0 COMMENT '0否 1是充电点位', `parking_point` int NULL DEFAULT NULL COMMENT '0否 1是 收车点位', `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份名称', `province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '省份code', `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市名称', `city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '城市code', `district_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县名称', `district_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '区县code', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_type`(`point_type` ASC) USING BTREE COMMENT '类型', INDEX `idx_status`(`operation_status` ASC) USING BTREE COMMENT '状态', INDEX `idx_name`(`point_name` ASC) USING BTREE COMMENT '名称', INDEX `idx_poi`(`point_poi` ASC) USING BTREE COMMENT 'poi', INDEX `idx_number`(`point_number` ASC) USING BTREE COMMENT '唯一ID' ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点位管理' ROW_FORMAT = Dynamic; CREATE TABLE IF NOT EXISTS `xp_admin_operation_log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'primary key', `business_type` tinyint NOT NULL COMMENT 'business type', `business_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'business type name', `operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'operator name', `operator_account` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'operator account', `operator_account_id` bigint NULL DEFAULT NULL COMMENT 'operator account id', `operation_type` tinyint NOT NULL COMMENT 'operation type', `operation_type_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'operation type name', `operation_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'operation content', `operation_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'operation ip', `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'request uri', `request_method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'request method', `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'interface method', `status` tinyint NOT NULL DEFAULT 0 COMMENT 'status: 0 success, 1 failed', `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'error message', `operation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'operation time', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'create time', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_business_type` (`business_type`) USING BTREE, INDEX `idx_operation_type` (`operation_type`) USING BTREE, INDEX `idx_operator_account` (`operator_account`) USING BTREE, INDEX `idx_operation_time` (`operation_time`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'admin operation log' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS=1;