/*
 Navicat Premium Data Transfer

 Source Server         : 120.26.65.52
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : 120.26.65.52:3306
 Source Schema         : city

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

 Date: 22/07/2020 17:03:18
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for city_camera
-- ----------------------------
DROP TABLE IF EXISTS `city_camera`;
CREATE TABLE `city_camera`  (
  `camera_id` int(11) NOT NULL AUTO_INCREMENT,
  `camera_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `coordinate_id` int(11) NULL DEFAULT NULL,
  `position_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`camera_id`) USING BTREE,
  INDEX `camera_coordinate_id`(`coordinate_id`) USING BTREE,
  CONSTRAINT `camera_coordinate_id` FOREIGN KEY (`coordinate_id`) REFERENCES `city_coordinate` (`coordinate_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_camera
-- ----------------------------
INSERT INTO `city_camera` VALUES (5, '上地十街10号', 26, 10);
INSERT INTO `city_camera` VALUES (7, '万力时代', 49, 1);
INSERT INTO `city_camera` VALUES (8, '万达广场', 52, 1);
INSERT INTO `city_camera` VALUES (9, '三清山机场', 51, 1);
INSERT INTO `city_camera` VALUES (10, '南昌工程学院', 48, 3);
INSERT INTO `city_camera` VALUES (11, '祥符街道', 53, 11);
INSERT INTO `city_camera` VALUES (12, '黄龙路', 54, 4);
INSERT INTO `city_camera` VALUES (13, '风情大道', 55, 12);
INSERT INTO `city_camera` VALUES (14, '解放南路', 56, 13);
INSERT INTO `city_camera` VALUES (15, '南营房胡同', 57, 10);
INSERT INTO `city_camera` VALUES (24, '昌东镇天祥大道289号', 61, 3);
INSERT INTO `city_camera` VALUES (26, '亿升广场', 73, 1);
INSERT INTO `city_camera` VALUES (27, '江西师范大学', 74, 3);
INSERT INTO `city_camera` VALUES (28, '章江路', 75, 21);

-- ----------------------------
-- Table structure for city_city
-- ----------------------------
DROP TABLE IF EXISTS `city_city`;
CREATE TABLE `city_city`  (
  `city_id` int(11) NOT NULL AUTO_INCREMENT,
  `province_id` int(11) NOT NULL,
  `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`city_id`) USING BTREE,
  INDEX `city_province_id`(`province_id`) USING BTREE,
  CONSTRAINT `city_province_id` FOREIGN KEY (`province_id`) REFERENCES `city_province` (`province_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_city
-- ----------------------------
INSERT INTO `city_city` VALUES (1, 1, '上饶');
INSERT INTO `city_city` VALUES (2, 1, '南昌');
INSERT INTO `city_city` VALUES (3, 2, '杭州');
INSERT INTO `city_city` VALUES (4, 2, '宁波');
INSERT INTO `city_city` VALUES (5, 2, '温州');
INSERT INTO `city_city` VALUES (6, 1, '赣州');
INSERT INTO `city_city` VALUES (7, 1, '九江');
INSERT INTO `city_city` VALUES (8, 1, '吉安');
INSERT INTO `city_city` VALUES (9, 1, '抚州');
INSERT INTO `city_city` VALUES (10, 1, '萍乡');
INSERT INTO `city_city` VALUES (11, 1, '景德镇');
INSERT INTO `city_city` VALUES (12, 1, '鹰潭');
INSERT INTO `city_city` VALUES (13, 1, '宜春');
INSERT INTO `city_city` VALUES (14, 1, '新余');
INSERT INTO `city_city` VALUES (15, 2, '绍兴');
INSERT INTO `city_city` VALUES (16, 2, '湖州');
INSERT INTO `city_city` VALUES (17, 2, '嘉兴');
INSERT INTO `city_city` VALUES (18, 2, '金华');
INSERT INTO `city_city` VALUES (19, 2, '衢州');
INSERT INTO `city_city` VALUES (20, 2, '台州');
INSERT INTO `city_city` VALUES (21, 2, '丽水');
INSERT INTO `city_city` VALUES (22, 2, '舟山');
INSERT INTO `city_city` VALUES (23, 3, '北京');
INSERT INTO `city_city` VALUES (24, 4, '天津');
INSERT INTO `city_city` VALUES (25, 5, '上海');
INSERT INTO `city_city` VALUES (26, 6, '重庆');
INSERT INTO `city_city` VALUES (27, 7, '石家庄');
INSERT INTO `city_city` VALUES (28, 7, '唐山');
INSERT INTO `city_city` VALUES (29, 7, '秦皇岛');
INSERT INTO `city_city` VALUES (30, 7, '邯郸');
INSERT INTO `city_city` VALUES (31, 7, '邢台');
INSERT INTO `city_city` VALUES (32, 7, '保定');
INSERT INTO `city_city` VALUES (33, 7, '张家口');
INSERT INTO `city_city` VALUES (34, 7, '承德');
INSERT INTO `city_city` VALUES (35, 7, '沧州');
INSERT INTO `city_city` VALUES (36, 7, '廊坊');
INSERT INTO `city_city` VALUES (37, 7, '衡水');

-- ----------------------------
-- Table structure for city_coordinate
-- ----------------------------
DROP TABLE IF EXISTS `city_coordinate`;
CREATE TABLE `city_coordinate`  (
  `coordinate_id` int(11) NOT NULL AUTO_INCREMENT,
  `latitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `longitude` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`coordinate_id`) USING BTREE,
  UNIQUE INDEX `ll`(`latitude`, `longitude`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_coordinate
-- ----------------------------
INSERT INTO `city_coordinate` VALUES (3, '110', '15');
INSERT INTO `city_coordinate` VALUES (14, '110.35', '12.545');
INSERT INTO `city_coordinate` VALUES (2, '110.35', '40.00');
INSERT INTO `city_coordinate` VALUES (4, '111.25', '32.01');
INSERT INTO `city_coordinate` VALUES (67, '113.96854067422115', '27.133462711027769');
INSERT INTO `city_coordinate` VALUES (6, '114.12', '24.12');
INSERT INTO `city_coordinate` VALUES (64, '114.77153821508895', '25.667052930560435');
INSERT INTO `city_coordinate` VALUES (59, '114.91757843671435', '26.79608230054638');
INSERT INTO `city_coordinate` VALUES (12, '115.45', '12.45');
INSERT INTO `city_coordinate` VALUES (76, '115.85265450231498', '28.675728131364914');
INSERT INTO `city_coordinate` VALUES (77, '115.88126229081374', '28.65702584615772');
INSERT INTO `city_coordinate` VALUES (75, '115.88892251199667', '28.684714350791329');
INSERT INTO `city_coordinate` VALUES (25, '115.93', '28.55');
INSERT INTO `city_coordinate` VALUES (60, '115.95046017276752', '28.551604186108276');
INSERT INTO `city_coordinate` VALUES (61, '116.03069886004576', '28.69357809366207');
INSERT INTO `city_coordinate` VALUES (74, '116.03320039834773', '28.68740374598857');
INSERT INTO `city_coordinate` VALUES (48, '116.03749241224243', '28.695855252419574');
INSERT INTO `city_coordinate` VALUES (19, '116.30', '39.95');
INSERT INTO `city_coordinate` VALUES (26, '116.30842', '40.05703');
INSERT INTO `city_coordinate` VALUES (23, '116.37', '39.92');
INSERT INTO `city_coordinate` VALUES (36, '116.37251', '39.918125');
INSERT INTO `city_coordinate` VALUES (65, '116.38083701052999', '39.918878346302147');
INSERT INTO `city_coordinate` VALUES (1, '116.395645', '39.929986');
INSERT INTO `city_coordinate` VALUES (22, '116.42', '39.93');
INSERT INTO `city_coordinate` VALUES (24, '116.43', '39.92');
INSERT INTO `city_coordinate` VALUES (57, '116.4495985621645', '39.926214883319307');
INSERT INTO `city_coordinate` VALUES (72, '116.51288495608856', '39.84746927558593');
INSERT INTO `city_coordinate` VALUES (29, '116.706856', '28.695759');
INSERT INTO `city_coordinate` VALUES (42, '116.70685883396503', '28.695759328061805');
INSERT INTO `city_coordinate` VALUES (63, '117.26237340240043', '39.127393569570518');
INSERT INTO `city_coordinate` VALUES (71, '117.91443700689409', '28.45466086134279');
INSERT INTO `city_coordinate` VALUES (16, '117.95546388', '28.45762255');
INSERT INTO `city_coordinate` VALUES (39, '117.95582', '28.44368');
INSERT INTO `city_coordinate` VALUES (52, '117.9608270305334', '28.45051400151386');
INSERT INTO `city_coordinate` VALUES (32, '117.96083', '28.450514');
INSERT INTO `city_coordinate` VALUES (31, '117.96273', '28.465132');
INSERT INTO `city_coordinate` VALUES (58, '117.96273210295999', '28.465131365602116');
INSERT INTO `city_coordinate` VALUES (21, '117.96682', '28.43121');
INSERT INTO `city_coordinate` VALUES (33, '117.97341', '28.437628');
INSERT INTO `city_coordinate` VALUES (40, '117.97341184157127', '28.437628310999736');
INSERT INTO `city_coordinate` VALUES (51, '117.97498953553793', '28.38273725487966');
INSERT INTO `city_coordinate` VALUES (73, '117.97702644328112', '28.45086954382145');
INSERT INTO `city_coordinate` VALUES (35, '117.97722', '28.452222');
INSERT INTO `city_coordinate` VALUES (30, '117.98273', '28.449284');
INSERT INTO `city_coordinate` VALUES (38, '117.985825', '28.455956');
INSERT INTO `city_coordinate` VALUES (49, '117.99111690418379', '28.453782912659894');
INSERT INTO `city_coordinate` VALUES (37, '117.99112', '28.453783');
INSERT INTO `city_coordinate` VALUES (50, '117.99175497058731', '28.46845388272719');
INSERT INTO `city_coordinate` VALUES (41, '117.99589813525907', '28.46299894229272');
INSERT INTO `city_coordinate` VALUES (53, '120.12112559963518', '30.326088189758388');
INSERT INTO `city_coordinate` VALUES (17, '120.13', '30.27');
INSERT INTO `city_coordinate` VALUES (69, '120.13119873499675', '30.19885230993087');
INSERT INTO `city_coordinate` VALUES (70, '120.13643801205312', '30.265916325588923');
INSERT INTO `city_coordinate` VALUES (54, '120.1433117344256', '30.27471342264234');
INSERT INTO `city_coordinate` VALUES (18, '120.17', '30.28');
INSERT INTO `city_coordinate` VALUES (62, '120.17557880007279', '30.248398420425884');
INSERT INTO `city_coordinate` VALUES (68, '120.18760693119028', '30.286744052561525');
INSERT INTO `city_coordinate` VALUES (55, '120.24272261307708', '30.091549575358525');
INSERT INTO `city_coordinate` VALUES (56, '120.58535007161702', '29.97404885309228');
INSERT INTO `city_coordinate` VALUES (11, '121.125', '45.12');
INSERT INTO `city_coordinate` VALUES (66, '121.49158559252436', '31.23724715206362');
INSERT INTO `city_coordinate` VALUES (20, '123', '123');
INSERT INTO `city_coordinate` VALUES (8, '123.456', '15.464');
INSERT INTO `city_coordinate` VALUES (13, '125.112', '15.464');
INSERT INTO `city_coordinate` VALUES (5, '125.112', '45.12');
INSERT INTO `city_coordinate` VALUES (7, '134.148', '45.684');
INSERT INTO `city_coordinate` VALUES (9, '243.125', '12.545');
INSERT INTO `city_coordinate` VALUES (15, '243.125', '24.12');

-- ----------------------------
-- Table structure for city_district
-- ----------------------------
DROP TABLE IF EXISTS `city_district`;
CREATE TABLE `city_district`  (
  `district_id` int(11) NOT NULL AUTO_INCREMENT,
  `city_id` int(11) NOT NULL,
  `district` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`district_id`) USING BTREE,
  INDEX `district_city_id`(`city_id`) USING BTREE,
  CONSTRAINT `district_city_id` FOREIGN KEY (`city_id`) REFERENCES `city_city` (`city_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 277 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_district
-- ----------------------------
INSERT INTO `city_district` VALUES (1, 1, '信州区');
INSERT INTO `city_district` VALUES (2, 2, '南昌县');
INSERT INTO `city_district` VALUES (3, 1, '广丰区');
INSERT INTO `city_district` VALUES (4, 1, '玉山县');
INSERT INTO `city_district` VALUES (5, 3, '上城区');
INSERT INTO `city_district` VALUES (6, 3, '下城区');
INSERT INTO `city_district` VALUES (7, 3, '西湖区');
INSERT INTO `city_district` VALUES (8, 4, '江北区');
INSERT INTO `city_district` VALUES (9, 4, '象山县');
INSERT INTO `city_district` VALUES (10, 4, '北仑区');
INSERT INTO `city_district` VALUES (11, 2, '东湖区');
INSERT INTO `city_district` VALUES (12, 2, '西湖区');
INSERT INTO `city_district` VALUES (13, 2, '新建区');
INSERT INTO `city_district` VALUES (14, 2, '青云谱区');
INSERT INTO `city_district` VALUES (15, 2, '青山湖区');
INSERT INTO `city_district` VALUES (16, 2, '红谷滩区');
INSERT INTO `city_district` VALUES (17, 2, '进贤县');
INSERT INTO `city_district` VALUES (18, 2, '安义县');
INSERT INTO `city_district` VALUES (19, 6, '章贡区');
INSERT INTO `city_district` VALUES (20, 6, '南康区');
INSERT INTO `city_district` VALUES (21, 6, '赣县区');
INSERT INTO `city_district` VALUES (22, 6, '石城县');
INSERT INTO `city_district` VALUES (23, 6, '安远县');
INSERT INTO `city_district` VALUES (24, 6, '宁都县');
INSERT INTO `city_district` VALUES (25, 6, '寻乌县');
INSERT INTO `city_district` VALUES (26, 6, '兴国县');
INSERT INTO `city_district` VALUES (27, 6, '定南县');
INSERT INTO `city_district` VALUES (28, 6, '上犹县');
INSERT INTO `city_district` VALUES (29, 6, '于都县');
INSERT INTO `city_district` VALUES (30, 6, '龙南县');
INSERT INTO `city_district` VALUES (31, 6, '崇义县');
INSERT INTO `city_district` VALUES (32, 6, '信丰县');
INSERT INTO `city_district` VALUES (33, 6, '全南县');
INSERT INTO `city_district` VALUES (34, 6, '大余县');
INSERT INTO `city_district` VALUES (35, 6, '会昌县');
INSERT INTO `city_district` VALUES (36, 6, '瑞金市');
INSERT INTO `city_district` VALUES (37, 1, '广信区');
INSERT INTO `city_district` VALUES (38, 1, '鄱阳县');
INSERT INTO `city_district` VALUES (39, 1, '婺源县');
INSERT INTO `city_district` VALUES (40, 1, '铅山县');
INSERT INTO `city_district` VALUES (41, 1, '余干县');
INSERT INTO `city_district` VALUES (42, 1, '横峰县');
INSERT INTO `city_district` VALUES (43, 1, '弋阳县');
INSERT INTO `city_district` VALUES (44, 1, '万年县');
INSERT INTO `city_district` VALUES (45, 1, '德兴市');
INSERT INTO `city_district` VALUES (46, 7, '浔阳区');
INSERT INTO `city_district` VALUES (47, 7, '濂溪区');
INSERT INTO `city_district` VALUES (48, 7, '柴桑区');
INSERT INTO `city_district` VALUES (49, 7, '武宁县');
INSERT INTO `city_district` VALUES (50, 7, '彭泽县');
INSERT INTO `city_district` VALUES (51, 7, '永修县');
INSERT INTO `city_district` VALUES (52, 7, '修水县');
INSERT INTO `city_district` VALUES (53, 7, '湖口县');
INSERT INTO `city_district` VALUES (54, 7, '德安县');
INSERT INTO `city_district` VALUES (55, 7, '都昌县');
INSERT INTO `city_district` VALUES (56, 7, '瑞昌市');
INSERT INTO `city_district` VALUES (57, 7, '共青城市');
INSERT INTO `city_district` VALUES (58, 7, '庐山市');
INSERT INTO `city_district` VALUES (59, 8, '吉州区');
INSERT INTO `city_district` VALUES (60, 8, '青原区');
INSERT INTO `city_district` VALUES (61, 8, '吉安县');
INSERT INTO `city_district` VALUES (62, 8, '永丰县');
INSERT INTO `city_district` VALUES (63, 8, '永新县');
INSERT INTO `city_district` VALUES (64, 8, '新干县');
INSERT INTO `city_district` VALUES (65, 8, '泰和县');
INSERT INTO `city_district` VALUES (66, 8, '峡江县');
INSERT INTO `city_district` VALUES (67, 8, '遂川县');
INSERT INTO `city_district` VALUES (68, 8, '安福县');
INSERT INTO `city_district` VALUES (69, 8, '吉水县');
INSERT INTO `city_district` VALUES (70, 8, '万安县');
INSERT INTO `city_district` VALUES (71, 8, '井冈山市');
INSERT INTO `city_district` VALUES (72, 9, '临川区');
INSERT INTO `city_district` VALUES (73, 9, '东乡区');
INSERT INTO `city_district` VALUES (74, 9, '南丰县');
INSERT INTO `city_district` VALUES (75, 9, '乐安县');
INSERT INTO `city_district` VALUES (76, 9, '金溪县');
INSERT INTO `city_district` VALUES (77, 9, '南城县');
INSERT INTO `city_district` VALUES (78, 9, '资溪县');
INSERT INTO `city_district` VALUES (79, 9, '宜黄县');
INSERT INTO `city_district` VALUES (80, 9, '广昌县');
INSERT INTO `city_district` VALUES (81, 9, '黎川县');
INSERT INTO `city_district` VALUES (82, 9, '崇仁县');
INSERT INTO `city_district` VALUES (83, 10, '安源区');
INSERT INTO `city_district` VALUES (84, 10, '湘东区');
INSERT INTO `city_district` VALUES (85, 10, '莲花县');
INSERT INTO `city_district` VALUES (86, 10, '上栗县');
INSERT INTO `city_district` VALUES (87, 10, '芦溪县');
INSERT INTO `city_district` VALUES (88, 11, '珠山区');
INSERT INTO `city_district` VALUES (89, 11, '昌江区');
INSERT INTO `city_district` VALUES (90, 11, '浮梁县');
INSERT INTO `city_district` VALUES (91, 11, '乐平市');
INSERT INTO `city_district` VALUES (92, 12, '月湖区');
INSERT INTO `city_district` VALUES (93, 12, '余江区');
INSERT INTO `city_district` VALUES (94, 12, '贵溪市');
INSERT INTO `city_district` VALUES (95, 13, '袁州区');
INSERT INTO `city_district` VALUES (96, 13, '铜鼓县');
INSERT INTO `city_district` VALUES (97, 13, '靖安县');
INSERT INTO `city_district` VALUES (98, 13, '宜丰县');
INSERT INTO `city_district` VALUES (99, 13, '奉新县');
INSERT INTO `city_district` VALUES (100, 13, '万载县');
INSERT INTO `city_district` VALUES (101, 13, '上高县');
INSERT INTO `city_district` VALUES (102, 13, '丰城市');
INSERT INTO `city_district` VALUES (103, 13, '樟树市');
INSERT INTO `city_district` VALUES (104, 13, '高安市');
INSERT INTO `city_district` VALUES (105, 14, '渝水区');
INSERT INTO `city_district` VALUES (106, 14, '分宜县');
INSERT INTO `city_district` VALUES (107, 3, '江干区');
INSERT INTO `city_district` VALUES (108, 3, '拱墅区');
INSERT INTO `city_district` VALUES (109, 3, '滨江区');
INSERT INTO `city_district` VALUES (110, 3, '余杭区');
INSERT INTO `city_district` VALUES (111, 3, '萧山区');
INSERT INTO `city_district` VALUES (112, 3, '富阳区');
INSERT INTO `city_district` VALUES (113, 3, '临安区');
INSERT INTO `city_district` VALUES (114, 3, '建德市');
INSERT INTO `city_district` VALUES (115, 3, '桐庐县');
INSERT INTO `city_district` VALUES (116, 3, '淳安县');
INSERT INTO `city_district` VALUES (117, 4, '海曙区');
INSERT INTO `city_district` VALUES (118, 4, '镇海区');
INSERT INTO `city_district` VALUES (119, 4, '鄞州区');
INSERT INTO `city_district` VALUES (120, 4, '奉化区');
INSERT INTO `city_district` VALUES (121, 4, '余姚市');
INSERT INTO `city_district` VALUES (122, 4, '慈溪市');
INSERT INTO `city_district` VALUES (123, 4, '宁海县');
INSERT INTO `city_district` VALUES (124, 5, '鹿城区');
INSERT INTO `city_district` VALUES (125, 5, '龙湾区');
INSERT INTO `city_district` VALUES (126, 5, '瓯海区');
INSERT INTO `city_district` VALUES (127, 5, '洞头区');
INSERT INTO `city_district` VALUES (128, 5, '瑞安市');
INSERT INTO `city_district` VALUES (129, 5, '乐清市');
INSERT INTO `city_district` VALUES (130, 5, '永嘉县');
INSERT INTO `city_district` VALUES (131, 5, '平阳县');
INSERT INTO `city_district` VALUES (132, 5, '苍南县');
INSERT INTO `city_district` VALUES (133, 5, '文成县');
INSERT INTO `city_district` VALUES (134, 5, '泰顺县');
INSERT INTO `city_district` VALUES (135, 5, '龙港市');
INSERT INTO `city_district` VALUES (136, 15, '越城区');
INSERT INTO `city_district` VALUES (137, 15, '柯桥区');
INSERT INTO `city_district` VALUES (138, 15, '上虞区');
INSERT INTO `city_district` VALUES (139, 15, '诸暨市');
INSERT INTO `city_district` VALUES (140, 15, '嵊州市');
INSERT INTO `city_district` VALUES (141, 15, '新昌县');
INSERT INTO `city_district` VALUES (142, 16, '吴兴区');
INSERT INTO `city_district` VALUES (143, 16, '南浔区');
INSERT INTO `city_district` VALUES (144, 16, '德清县');
INSERT INTO `city_district` VALUES (145, 16, '长兴县');
INSERT INTO `city_district` VALUES (146, 16, '安吉县');
INSERT INTO `city_district` VALUES (147, 17, '南湖区');
INSERT INTO `city_district` VALUES (148, 17, '秀洲区');
INSERT INTO `city_district` VALUES (149, 17, '海宁市');
INSERT INTO `city_district` VALUES (150, 17, '平湖市');
INSERT INTO `city_district` VALUES (151, 17, '桐乡市');
INSERT INTO `city_district` VALUES (152, 17, '嘉善县');
INSERT INTO `city_district` VALUES (153, 17, '海盐县');
INSERT INTO `city_district` VALUES (154, 18, '婺城区');
INSERT INTO `city_district` VALUES (155, 18, '金东区');
INSERT INTO `city_district` VALUES (156, 18, '兰溪市');
INSERT INTO `city_district` VALUES (157, 18, '东阳市');
INSERT INTO `city_district` VALUES (158, 18, '永康市');
INSERT INTO `city_district` VALUES (159, 18, '义乌市');
INSERT INTO `city_district` VALUES (160, 18, '武义县');
INSERT INTO `city_district` VALUES (161, 18, '浦江县');
INSERT INTO `city_district` VALUES (162, 18, '磐安县');
INSERT INTO `city_district` VALUES (163, 19, '柯城区');
INSERT INTO `city_district` VALUES (164, 19, '衢江区');
INSERT INTO `city_district` VALUES (165, 19, '江山市');
INSERT INTO `city_district` VALUES (166, 19, '常山县');
INSERT INTO `city_district` VALUES (167, 19, '开化县');
INSERT INTO `city_district` VALUES (168, 19, '龙游县');
INSERT INTO `city_district` VALUES (169, 20, '椒江区');
INSERT INTO `city_district` VALUES (170, 20, '黄岩区');
INSERT INTO `city_district` VALUES (171, 20, '路桥区');
INSERT INTO `city_district` VALUES (172, 20, '临海市');
INSERT INTO `city_district` VALUES (173, 20, '温岭市');
INSERT INTO `city_district` VALUES (174, 20, '玉环市');
INSERT INTO `city_district` VALUES (175, 20, '三门县');
INSERT INTO `city_district` VALUES (176, 20, '天台县');
INSERT INTO `city_district` VALUES (177, 20, '仙居县');
INSERT INTO `city_district` VALUES (178, 21, '莲都区');
INSERT INTO `city_district` VALUES (179, 21, '龙泉市');
INSERT INTO `city_district` VALUES (180, 21, '青田县');
INSERT INTO `city_district` VALUES (181, 21, '缙云县');
INSERT INTO `city_district` VALUES (182, 21, '遂昌县');
INSERT INTO `city_district` VALUES (183, 21, '松阳县');
INSERT INTO `city_district` VALUES (184, 21, '云和县');
INSERT INTO `city_district` VALUES (185, 21, '庆元县');
INSERT INTO `city_district` VALUES (186, 21, '景宁畲族自治县');
INSERT INTO `city_district` VALUES (187, 22, '定海区');
INSERT INTO `city_district` VALUES (188, 22, '普陀区');
INSERT INTO `city_district` VALUES (189, 22, '岱山县');
INSERT INTO `city_district` VALUES (190, 22, '嵊泗县');
INSERT INTO `city_district` VALUES (191, 23, '东城区');
INSERT INTO `city_district` VALUES (192, 23, '西城区');
INSERT INTO `city_district` VALUES (193, 23, '朝阳区');
INSERT INTO `city_district` VALUES (194, 23, '丰台区');
INSERT INTO `city_district` VALUES (195, 23, '石景山区');
INSERT INTO `city_district` VALUES (196, 23, '海淀区');
INSERT INTO `city_district` VALUES (197, 23, '顺义区');
INSERT INTO `city_district` VALUES (198, 23, '通州区');
INSERT INTO `city_district` VALUES (199, 23, '大兴区');
INSERT INTO `city_district` VALUES (200, 23, '房山区');
INSERT INTO `city_district` VALUES (201, 23, '门头沟区');
INSERT INTO `city_district` VALUES (202, 23, '昌平区');
INSERT INTO `city_district` VALUES (203, 23, '平谷区');
INSERT INTO `city_district` VALUES (204, 23, '密云区');
INSERT INTO `city_district` VALUES (205, 23, '怀柔区');
INSERT INTO `city_district` VALUES (206, 23, '延庆区');
INSERT INTO `city_district` VALUES (207, 24, '和平区');
INSERT INTO `city_district` VALUES (208, 24, '河东区');
INSERT INTO `city_district` VALUES (209, 24, '河西区');
INSERT INTO `city_district` VALUES (210, 24, '南开区');
INSERT INTO `city_district` VALUES (211, 24, '河北区');
INSERT INTO `city_district` VALUES (212, 24, '红桥区');
INSERT INTO `city_district` VALUES (213, 24, '滨海新区');
INSERT INTO `city_district` VALUES (214, 24, '东丽区');
INSERT INTO `city_district` VALUES (215, 24, '西青区');
INSERT INTO `city_district` VALUES (216, 24, '津南区');
INSERT INTO `city_district` VALUES (217, 24, '北辰区');
INSERT INTO `city_district` VALUES (218, 24, '武清区');
INSERT INTO `city_district` VALUES (219, 24, '宝坻区');
INSERT INTO `city_district` VALUES (220, 24, '宁河区');
INSERT INTO `city_district` VALUES (221, 24, '静海区');
INSERT INTO `city_district` VALUES (222, 24, '蓟州区');
INSERT INTO `city_district` VALUES (223, 25, '黄浦区');
INSERT INTO `city_district` VALUES (224, 25, '徐汇区');
INSERT INTO `city_district` VALUES (225, 25, '长宁区');
INSERT INTO `city_district` VALUES (226, 25, '静安区');
INSERT INTO `city_district` VALUES (227, 25, '普陀区');
INSERT INTO `city_district` VALUES (228, 25, '虹口区');
INSERT INTO `city_district` VALUES (229, 25, '杨浦区');
INSERT INTO `city_district` VALUES (230, 25, '闵行区');
INSERT INTO `city_district` VALUES (231, 25, '宝山区');
INSERT INTO `city_district` VALUES (232, 25, '嘉定区');
INSERT INTO `city_district` VALUES (233, 25, '浦东新区');
INSERT INTO `city_district` VALUES (234, 25, '金山区');
INSERT INTO `city_district` VALUES (235, 25, '松江区');
INSERT INTO `city_district` VALUES (236, 25, '青浦区');
INSERT INTO `city_district` VALUES (237, 25, '奉贤区');
INSERT INTO `city_district` VALUES (238, 25, '崇明区');
INSERT INTO `city_district` VALUES (239, 26, '渝中区');
INSERT INTO `city_district` VALUES (240, 26, '万州区');
INSERT INTO `city_district` VALUES (241, 26, '涪陵区');
INSERT INTO `city_district` VALUES (242, 26, '大渡口区');
INSERT INTO `city_district` VALUES (243, 26, '江北区');
INSERT INTO `city_district` VALUES (244, 26, '沙坪坝区');
INSERT INTO `city_district` VALUES (245, 26, '九龙坡区');
INSERT INTO `city_district` VALUES (246, 26, '南岸区');
INSERT INTO `city_district` VALUES (247, 26, '北碚区');
INSERT INTO `city_district` VALUES (248, 26, '綦江区');
INSERT INTO `city_district` VALUES (249, 26, '大足区');
INSERT INTO `city_district` VALUES (250, 26, '渝北区');
INSERT INTO `city_district` VALUES (251, 26, '巴南区');
INSERT INTO `city_district` VALUES (252, 26, '黔江区');
INSERT INTO `city_district` VALUES (253, 26, '长寿区');
INSERT INTO `city_district` VALUES (254, 26, '江津区');
INSERT INTO `city_district` VALUES (255, 26, '合川区');
INSERT INTO `city_district` VALUES (256, 26, '永川区');
INSERT INTO `city_district` VALUES (257, 26, '南川区');
INSERT INTO `city_district` VALUES (258, 26, '璧山区');
INSERT INTO `city_district` VALUES (259, 26, '铜梁区');
INSERT INTO `city_district` VALUES (260, 26, '潼南区');
INSERT INTO `city_district` VALUES (261, 26, '荣昌区');
INSERT INTO `city_district` VALUES (262, 26, '开州区');
INSERT INTO `city_district` VALUES (263, 26, '梁平区');
INSERT INTO `city_district` VALUES (264, 26, '武隆区');
INSERT INTO `city_district` VALUES (265, 26, '城口县');
INSERT INTO `city_district` VALUES (266, 26, '丰都县');
INSERT INTO `city_district` VALUES (267, 26, '垫江县');
INSERT INTO `city_district` VALUES (268, 26, '忠县');
INSERT INTO `city_district` VALUES (269, 26, '云阳县');
INSERT INTO `city_district` VALUES (270, 26, '奉节县');
INSERT INTO `city_district` VALUES (271, 26, '巫山县');
INSERT INTO `city_district` VALUES (272, 26, '巫溪县');
INSERT INTO `city_district` VALUES (273, 26, '石柱土家族自治县');
INSERT INTO `city_district` VALUES (274, 26, '秀山土家族苗族自治县');
INSERT INTO `city_district` VALUES (275, 26, '酉阳土家族苗族自治县');
INSERT INTO `city_district` VALUES (276, 26, '彭水苗族土家族自治县');

-- ----------------------------
-- Table structure for city_image
-- ----------------------------
DROP TABLE IF EXISTS `city_image`;
CREATE TABLE `city_image`  (
  `image_id` int(11) NOT NULL AUTO_INCREMENT,
  `image_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `image_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `image_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `position_id` int(11) NULL DEFAULT NULL,
  `result_id` int(11) NULL DEFAULT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `coordinate_id` int(11) NULL DEFAULT NULL,
  `image_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`image_id`) USING BTREE,
  INDEX `image_position_id`(`position_id`) USING BTREE,
  INDEX `image_result_id`(`result_id`) USING BTREE,
  INDEX `image_user_id`(`user_id`) USING BTREE,
  INDEX `image_coordinate_id`(`coordinate_id`) USING BTREE,
  CONSTRAINT `image_coordinate_id` FOREIGN KEY (`coordinate_id`) REFERENCES `city_coordinate` (`coordinate_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `image_position_id` FOREIGN KEY (`position_id`) REFERENCES `city_position` (`position_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `image_result_id` FOREIGN KEY (`result_id`) REFERENCES `city_result` (`result_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `image_user_id` FOREIGN KEY (`user_id`) REFERENCES `city_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 124 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_image
-- ----------------------------
INSERT INTO `city_image` VALUES (20, '北京海淀区', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zsU-Aa7GMAAAN0xNQp_g338.jpg', '2', '机器识别', '用户', 6, 2, 6, 19, '2020-05-07 14:57:22');
INSERT INTO `city_image` VALUES (21, '北京东城区', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwaCAdIe9AAARRVDCAF4056.jpg', '2', '机器识别', '用户', 8, 3, 6, 22, '2020-05-07 16:06:59');
INSERT INTO `city_image` VALUES (22, '北京西城区', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwe-AECH8AAAQPUEp19k202.jpg', '2', '机器识别', '用户', 9, 4, 6, 23, '2020-05-07 16:08:16');
INSERT INTO `city_image` VALUES (23, '北京朝阳区', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwjmAcbKzAAAQqeCx1R0275.jpg', '2', '机器识别', '用户', 10, 2, 6, 24, '2020-05-07 16:09:30');
INSERT INTO `city_image` VALUES (25, '上地十街10号', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l60_laAINOpAAAQpvbnmTo410.jpg', '2', '机器识别', '用户', 6, 1, 6, 26, '2020-05-08 14:38:18');
INSERT INTO `city_image` VALUES (26, '五三大道', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61AK2Ae7O7AAANIJ_E2Vs596.jpg', '2', '机器识别', '用户', 1, 1, 6, 29, '2020-05-08 14:48:19');
INSERT INTO `city_image` VALUES (27, '中山路', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61FGyAOkCwAAANlagHv2k560.jpg', '2', '机器识别', '摄像头', 1, 1, 6, 30, '2020-05-08 16:13:07');
INSERT INTO `city_image` VALUES (28, '凤凰大道', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61FPiAZZREAAAQILU4Yg4333.jpg', '2', '机器识别', '用户', 1, 1, 6, 31, '2020-05-08 16:15:53');
INSERT INTO `city_image` VALUES (29, '万达广场', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61FdCAa2dnAAAO4Nz6r5c094.jpg', '2', '机器识别', '用户', 1, 1, 6, 32, '2020-05-08 16:19:12');
INSERT INTO `city_image` VALUES (32, '爱尔眼科', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61HEiAMCFaAC58w2waMmk859.jpg', '2', '人工修改', '用户', 1, 1, 6, 35, '2020-05-30 10:36:34');
INSERT INTO `city_image` VALUES (33, '天安门', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61HdCAOczxAAAO0GEoSZI055.jpg', '2', '机器识别', '摄像头', 9, 4, 6, 36, '2020-05-08 16:52:36');
INSERT INTO `city_image` VALUES (34, '万力时代', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62VAqAAAwYAAAPPRqhgYE816.jpg', '2', '机器识别', '用户', 1, 3, 6, 37, '2020-05-09 14:56:17');
INSERT INTO `city_image` VALUES (35, '万达广场', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62VDeALBvxAAAPrDTchVI681.jpg', '2', '机器识别', '用户', 1, 4, 6, 32, '2020-05-09 14:56:57');
INSERT INTO `city_image` VALUES (36, '四中', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62VPKAa-OkAAAQBpc5G2s063.jpg', '2', '机器识别', '用户', 1, 1, 6, 38, '2020-05-09 15:00:04');
INSERT INTO `city_image` VALUES (49, '现代城', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62Y22AW83OAAAQUPDJQoc339.jpg', '2', '机器识别', '摄像头', 1, 3, 6, 41, '2020-05-09 16:01:54');
INSERT INTO `city_image` VALUES (51, '南昌工程学院', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6-yOuAVKNLAAAOLB0DaWI970.jpg', '2', '人工修改', '摄像头', 3, 1, 6, 48, '2020-07-15 16:55:03');
INSERT INTO `city_image` VALUES (57, '紫阳公园', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l6_gjKAZzYXAAAPzNwq23Q476.jpg', '2', '机器识别', '用户', 1, 3, 6, 50, '2020-05-16 14:03:35');
INSERT INTO `city_image` VALUES (58, '上饶火车站', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l6_grKAU1AcAAARt8Ky9k8490.jpg', '2', '机器识别', '摄像头', 1, 3, 6, 40, '2020-05-16 14:05:41');
INSERT INTO `city_image` VALUES (59, '三清山机场', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l6_hcyAOZV7AAAM-y1rSdk374.jpg', '2', '机器识别', '用户', 1, 4, 6, 51, '2020-05-16 14:18:57');
INSERT INTO `city_image` VALUES (61, '凤凰大道', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7BQmaAYaR-AAAMgqCkA1g424.jpg', '2', '机器识别', '用户', 1, 2, 6, 58, '2020-05-17 21:55:55');
INSERT INTO `city_image` VALUES (74, '上海黄浦区', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7KIbeAEsv5AAQaY5QMjq0345.jpg', '2', '机器识别', '用户', 18, 3, 6, 66, '2020-05-24 15:26:49');
INSERT INTO `city_image` VALUES (103, '凤凰大道', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nkDSAbdHvAAAMUApQls0155.jpg', '2', '机器识别', '用户', 1, 1, 6, 58, '2020-06-15 23:13:58');
INSERT INTO `city_image` VALUES (106, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nmf6AdProAAJxDax3V-I119.jpg', '2', '机器识别', '用户', 21, 4, 6, 75, '2020-06-15 23:55:44');
INSERT INTO `city_image` VALUES (107, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nmjaAcFU0AALCWspklEk484.jpg', '2', '人工修改', '用户', 21, 4, 6, 75, '2020-06-15 23:59:14');
INSERT INTO `city_image` VALUES (108, '丰和立交', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nmmaAQq6CAAq7FcZDqV4352.jpg', '2', '机器识别', '用户', 3, 1, 6, 76, '2020-06-15 23:57:27');
INSERT INTO `city_image` VALUES (109, '丰和立交', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nmymAdfe6AAl6ugmmWX0174.jpg', '2', '机器识别', '用户', 3, 1, 6, 76, '2020-06-16 00:00:42');
INSERT INTO `city_image` VALUES (110, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nm6eATx_AAAKqYAZFJFY370.jpg', '2', '人工修改', '用户', 21, 4, 6, 75, '2020-06-16 00:04:10');
INSERT INTO `city_image` VALUES (111, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnICALFbFAALB0u0X7eM042.jpg', '2', '机器识别', '用户', 21, 1, 6, 75, '2020-06-16 00:06:26');
INSERT INTO `city_image` VALUES (112, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnNCAACKSAALc9rxXdSY104.jpg', '2', '机器识别', '用户', 21, 3, 6, 75, '2020-06-16 00:07:45');
INSERT INTO `city_image` VALUES (113, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnP-AXn8gAAK3luLDTJI394.jpg', '2', '机器识别', '用户', 21, 2, 6, 75, '2020-06-16 00:08:33');
INSERT INTO `city_image` VALUES (114, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnSOAD-mdAAJx1dMaLzg700.jpg', '2', '机器识别', '用户', 21, 4, 6, 75, '2020-06-16 00:09:09');
INSERT INTO `city_image` VALUES (115, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnWaAWnWRAAJxgR7BwgQ416.jpg', '2', '机器识别', '用户', 21, 4, 6, 75, '2020-06-16 00:10:15');
INSERT INTO `city_image` VALUES (116, '章江路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnXaABMjjAAJxDax3V-I593.jpg', '2', '机器识别', '用户', 21, 4, 6, 75, '2020-06-16 00:10:31');
INSERT INTO `city_image` VALUES (117, '抚生路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnZaALuKTAAKShnNhEzM400.jpg', '2', '机器识别', '用户', 22, 3, 6, 77, '2020-06-16 00:11:03');
INSERT INTO `city_image` VALUES (118, '抚生路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnemAUJxOAAJOlrIj37I705.jpg', '2', '机器识别', '用户', 22, 3, 6, 77, '2020-06-16 00:12:27');
INSERT INTO `city_image` VALUES (119, '抚生路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nngGAdGhZAAJw9Di7HHg544.jpg', '2', '机器识别', '用户', 22, 3, 6, 77, '2020-06-16 00:12:51');
INSERT INTO `city_image` VALUES (120, '抚生路', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nni-AfjDUAAM7BZEBK0M404.jpg', '2', '机器识别', '用户', 22, 4, 6, 77, '2020-06-16 00:13:36');

-- ----------------------------
-- Table structure for city_manager
-- ----------------------------
DROP TABLE IF EXISTS `city_manager`;
CREATE TABLE `city_manager`  (
  `manager_id` int(11) NOT NULL AUTO_INCREMENT,
  `manager_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_time` datetime(0) NOT NULL,
  PRIMARY KEY (`manager_id`) USING BTREE,
  UNIQUE INDEX `manager_name`(`manager_name`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_manager
-- ----------------------------
INSERT INTO `city_manager` VALUES (1, '林宇聪', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6RhCKANmBPAAIvYDWV9Lg468.jpg', '1746661428@qq.com', '2020-04-11 16:47:31');
INSERT INTO `city_manager` VALUES (2, '朱经莹', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6RhCKANmBPAAIvYDWV9Lg468.jpg', '841564948@qq.com', '2020-07-20 20:48:21');
INSERT INTO `city_manager` VALUES (3, '叶健安', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6RhCKANmBPAAIvYDWV9Lg468.jpg', '4818488715@qq.com', '2020-07-20 20:49:20');

-- ----------------------------
-- Table structure for city_message
-- ----------------------------
DROP TABLE IF EXISTS `city_message`;
CREATE TABLE `city_message`  (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `message_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `coordinate_id` int(11) NULL DEFAULT NULL,
  `position_id` int(11) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `result` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `image_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`message_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_message
-- ----------------------------
INSERT INTO `city_message` VALUES (16, '系统上传', '人工修改', 22, 8, '2020-05-30 10:36:13', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwaCAdIe9AAARRVDCAF4056.jpg');
INSERT INTO `city_message` VALUES (17, '系统上传', '系统上传', 23, 9, '2020-05-07 16:08:16', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwe-AECH8AAAQPUEp19k202.jpg');
INSERT INTO `city_message` VALUES (18, '系统上传', '系统上传', 24, 10, '2020-05-07 16:09:30', '内涝', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6zwjmAcbKzAAAQqeCx1R0275.jpg');
INSERT INTO `city_message` VALUES (19, '系统上传', '系统上传', 36, 9, '2020-05-08 16:52:36', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l61HdCAOczxAAAO0GEoSZI055.jpg');
INSERT INTO `city_message` VALUES (20, '系统上传', '系统上传', 37, 1, '2020-05-09 14:56:17', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62VAqAAAwYAAAPPRqhgYE816.jpg');
INSERT INTO `city_message` VALUES (21, '系统上传', '系统上传', 32, 1, '2020-05-09 14:56:57', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62VDeALBvxAAAPrDTchVI681.jpg');
INSERT INTO `city_message` VALUES (32, '系统上传', '系统上传', 40, 1, '2020-05-09 15:57:10', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62YgaAN2hIAAAPuwEjjzk955.jpg');
INSERT INTO `city_message` VALUES (33, '系统上传', '系统上传', 41, 1, '2020-05-09 16:01:54', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l62Y22AW83OAAAQUPDJQoc339.jpg');
INSERT INTO `city_message` VALUES (35, '系统上传', '系统上传', 50, 1, '2020-05-16 14:03:35', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l6_gjKAZzYXAAAPzNwq23Q476.jpg');
INSERT INTO `city_message` VALUES (36, '系统上传', '系统上传', 40, 1, '2020-05-16 14:05:41', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l6_grKAU1AcAAARt8Ky9k8490.jpg');
INSERT INTO `city_message` VALUES (39, '系统上传', '系统上传', 58, 1, '2020-05-17 21:55:55', '内涝', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7BQmaAYaR-AAAMgqCkA1g424.jpg');
INSERT INTO `city_message` VALUES (40, '系统上传', '系统上传', 63, 16, '2020-05-24 14:38:48', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7KFnaADmUZAAQaY5QMjq0405.jpg');
INSERT INTO `city_message` VALUES (46, '系统上传', '系统上传', 75, 21, '2020-06-15 23:55:44', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nmf6AdProAAJxDax3V-I119.jpg');
INSERT INTO `city_message` VALUES (47, '系统上传', '系统上传', 75, 21, '2020-06-16 00:07:45', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnNCAACKSAALc9rxXdSY104.jpg');
INSERT INTO `city_message` VALUES (48, '系统上传', '系统上传', 75, 21, '2020-06-16 00:08:33', '内涝', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnP-AXn8gAAK3luLDTJI394.jpg');
INSERT INTO `city_message` VALUES (49, '系统上传', '系统上传', 75, 21, '2020-06-16 00:09:09', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnSOAD-mdAAJx1dMaLzg700.jpg');
INSERT INTO `city_message` VALUES (50, '系统上传', '系统上传', 75, 21, '2020-06-16 00:10:15', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnWaAWnWRAAJxgR7BwgQ416.jpg');
INSERT INTO `city_message` VALUES (51, '系统上传', '系统上传', 75, 21, '2020-06-16 00:10:31', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnXaABMjjAAJxDax3V-I593.jpg');
INSERT INTO `city_message` VALUES (52, '系统上传', '系统上传', 77, 22, '2020-06-16 00:11:03', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnZaALuKTAAKShnNhEzM400.jpg');
INSERT INTO `city_message` VALUES (53, '系统上传', '系统上传', 77, 22, '2020-06-16 00:12:27', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nnemAUJxOAAJOlrIj37I705.jpg');
INSERT INTO `city_message` VALUES (54, '系统上传', '系统上传', 77, 22, '2020-06-16 00:12:51', '积水', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nngGAdGhZAAJw9Di7HHg544.jpg');
INSERT INTO `city_message` VALUES (55, '系统上传', '系统上传', 77, 22, '2020-06-16 00:13:36', '冰雪', '匿名', 'http://120.26.65.52:80/group1/M00/00/01/rBAc3l7nni-AfjDUAAM7BZEBK0M404.jpg');

-- ----------------------------
-- Table structure for city_position
-- ----------------------------
DROP TABLE IF EXISTS `city_position`;
CREATE TABLE `city_position`  (
  `position_id` int(11) NOT NULL AUTO_INCREMENT,
  `province_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  `district_id` int(11) NOT NULL,
  PRIMARY KEY (`position_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_position
-- ----------------------------
INSERT INTO `city_position` VALUES (1, 1, 1, 1);
INSERT INTO `city_position` VALUES (3, 1, 2, 2);
INSERT INTO `city_position` VALUES (4, 2, 3, 7);
INSERT INTO `city_position` VALUES (5, 2, 3, 6);
INSERT INTO `city_position` VALUES (6, 3, 23, 196);
INSERT INTO `city_position` VALUES (7, 1, 1, 41);
INSERT INTO `city_position` VALUES (8, 3, 23, 191);
INSERT INTO `city_position` VALUES (9, 3, 23, 192);
INSERT INTO `city_position` VALUES (10, 3, 23, 193);
INSERT INTO `city_position` VALUES (11, 2, 3, 108);
INSERT INTO `city_position` VALUES (12, 2, 3, 111);
INSERT INTO `city_position` VALUES (14, 1, 8, 65);
INSERT INTO `city_position` VALUES (15, 2, 3, 5);
INSERT INTO `city_position` VALUES (16, 4, 24, 208);
INSERT INTO `city_position` VALUES (17, 1, 6, 20);
INSERT INTO `city_position` VALUES (18, 5, 25, 223);
INSERT INTO `city_position` VALUES (19, 1, 10, 85);
INSERT INTO `city_position` VALUES (20, 1, 1, 37);
INSERT INTO `city_position` VALUES (21, 1, 2, 12);
INSERT INTO `city_position` VALUES (22, 1, 2, 11);

-- ----------------------------
-- Table structure for city_province
-- ----------------------------
DROP TABLE IF EXISTS `city_province`;
CREATE TABLE `city_province`  (
  `province_id` int(11) NOT NULL AUTO_INCREMENT,
  `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`province_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_province
-- ----------------------------
INSERT INTO `city_province` VALUES (1, '江西省');
INSERT INTO `city_province` VALUES (2, '浙江省');
INSERT INTO `city_province` VALUES (3, '北京市');
INSERT INTO `city_province` VALUES (4, '天津市');
INSERT INTO `city_province` VALUES (5, '上海市');
INSERT INTO `city_province` VALUES (6, '重庆市');
INSERT INTO `city_province` VALUES (7, '河北省');
INSERT INTO `city_province` VALUES (8, '山西省');
INSERT INTO `city_province` VALUES (9, '辽宁省');
INSERT INTO `city_province` VALUES (10, '吉林省');
INSERT INTO `city_province` VALUES (11, '黑龙江省');
INSERT INTO `city_province` VALUES (12, '江苏省');
INSERT INTO `city_province` VALUES (13, '安徽省');
INSERT INTO `city_province` VALUES (14, '福建省');
INSERT INTO `city_province` VALUES (15, '山东省');
INSERT INTO `city_province` VALUES (16, '河南省');
INSERT INTO `city_province` VALUES (17, '湖北省');
INSERT INTO `city_province` VALUES (18, '湖南省');
INSERT INTO `city_province` VALUES (19, '广东省');
INSERT INTO `city_province` VALUES (20, '海南省');
INSERT INTO `city_province` VALUES (21, '四川省');
INSERT INTO `city_province` VALUES (22, '贵州省');
INSERT INTO `city_province` VALUES (23, '云南省');
INSERT INTO `city_province` VALUES (24, '陕西省');
INSERT INTO `city_province` VALUES (25, '甘肃省');
INSERT INTO `city_province` VALUES (26, '青海省');
INSERT INTO `city_province` VALUES (27, '台湾省');
INSERT INTO `city_province` VALUES (28, '内蒙古自治区');
INSERT INTO `city_province` VALUES (29, '广西壮族自治区');
INSERT INTO `city_province` VALUES (30, '西藏自治区');
INSERT INTO `city_province` VALUES (31, '宁夏回族自治区');
INSERT INTO `city_province` VALUES (32, '新疆维吾尔自治区');
INSERT INTO `city_province` VALUES (33, '香港特别行政区');
INSERT INTO `city_province` VALUES (34, '澳门特别行政区');

-- ----------------------------
-- Table structure for city_result
-- ----------------------------
DROP TABLE IF EXISTS `city_result`;
CREATE TABLE `city_result`  (
  `result_id` int(11) NOT NULL AUTO_INCREMENT,
  `result_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`result_id`) USING BTREE,
  UNIQUE INDEX `result_name`(`result_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_result
-- ----------------------------
INSERT INTO `city_result` VALUES (2, '内涝');
INSERT INTO `city_result` VALUES (4, '冰雪');
INSERT INTO `city_result` VALUES (1, '无积水');
INSERT INTO `city_result` VALUES (3, '积水');

-- ----------------------------
-- Table structure for city_user
-- ----------------------------
DROP TABLE IF EXISTS `city_user`;
CREATE TABLE `city_user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id(数据库自增)|int',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名(不可重复，用于登录)|varchar(255)',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码|varchar(255)',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像(存url)|varchar(255)',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱(不可重复)|varchar(255)',
  `flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '激活状态(1or2)|char',
  `create_time` datetime(0) NOT NULL COMMENT '注册时间|datetime',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `username`(`user_name`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of city_user
-- ----------------------------
INSERT INTO `city_user` VALUES (6, '系统用户', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6RZLmALwgcAAIvYDWV9Lg854.jpg', '344962079@qq.com', '1', '2020-04-11 14:33:29');
INSERT INTO `city_user` VALUES (7, '叶健安', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6dLy6AfTEHAAamktmMelo212.jpg', '1234567@qq.com', '1', '2020-04-20 13:12:15');
INSERT INTO `city_user` VALUES (9, '朱经莹', 'e10adc3949ba59abbe56e057f20f883e', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6mlJyAZwiiAAamktmMelo463.jpg', '51411651@qq.com', '1', '2020-04-27 16:15:24');
INSERT INTO `city_user` VALUES (10, '林宇聪', '92d10e871a74f865b69ea2f70eb90145', 'http://120.26.65.52:80/group1/M00/00/00/rBAc3l6w-eGAepEBABVdPsx3fI0879.png', '708901735@qq.com', '1', '2020-05-05 13:30:11');

SET FOREIGN_KEY_CHECKS = 1;