全球所有国家城市数据以及国旗logo，两个版本一个来源网络，一个来源于qq配置文件提取翻译

/* Navicat Premium Data Transfer Source Server : 本地MySQL Source Server Type : MySQL Source Server Version : 80023 Source Host : localhost:3306 Source Schema : lspsaaa Target Server Type : MySQL Target Server Version : 80023 File Encoding : 65001 Date: 07/07/2022 16:28:37 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for city -- ---------------------------- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `id` bigint(0) NOT NULL AUTO_INCREMENT, `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cn_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `en_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `state_id` bigint(0) NULL DEFAULT NULL, `state_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `country_id` bigint(0) NULL DEFAULT NULL, `country_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `state_id`(`state_id`, `country_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of city -- ---------------------------- INSERT INTO `city` VALUES (2314, '1', '东城', 'Dongcheng', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2315, '2', '西城', 'XiCheng', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2316, '5', '朝阳', 'Chaoyang', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2317, '6', '丰台', 'Fengtai', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2318, '7', '石景山', 'Shijingshan', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2319, '8', '海淀', 'Haidian', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2320, '9', '门头沟', 'Mentougou', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2321, '11', '房山', 'Fangshan', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2322, '12', '通州', 'Tongzhou', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2323, '13', '顺义', 'Shunyi', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2324, '21', '昌平', 'Changping', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2325, '24', '大兴', 'Daxing', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2326, '26', '平谷', 'Pinggu', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2327, '27', '怀柔', 'Huairou', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2328, '28', '密云', 'Miyun', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2329, '29', '延庆', 'Yanqing', 104, '11', 135, 'CHN'); INSERT INTO `city` VALUES (2330, '1', '和平', 'Heping', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2331, '2', '河东', 'Hedong', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2332, '3', '河西', 'Hexi', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2333, '4', '南开', 'Nankai', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2334, '5', '河北', 'Hebei', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2335, '6', '红桥', 'Hongqiao', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2336, '26', '滨海新区', 'Binhai New Area', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2337, '10', '东丽', 'Toray', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2338, '11', '西青', 'West Green', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2339, '12', '津南', 'Jinnan', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2340, '13', '北辰', 'Beichen', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2341, '21', '宁河', 'Ninghe', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2342, '22', '武清', 'Wuqing', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2343, '23', '静海', 'Tranquil Sea', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2344, '24', '宝坻', 'Baodi', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2345, '25', '蓟县', 'Ji County', 105, '12', 135, 'CHN'); INSERT INTO `city` VALUES (2346, '1', '石家庄', 'Shijiazhuang', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2347, '2', '唐山', 'Tangshan', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2348, '3', '秦皇岛', 'Qinhuangdao', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2349, '4', '邯郸', 'Handan', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2350, '5', '邢台', 'Xingtai', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2351, '6', '保定', 'Baoding', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2352, '7', '张家口', 'Zhangjiakou', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2353, '8', '承德', 'Chengde', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2354, '9', '沧州', 'Cangzhou', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2355, '10', '廊坊', 'Langfang', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2356, '11', '衡水', 'Hengshui', 106, '13', 135, 'CHN'); INSERT INTO `city` VALUES (2357, '1', '太原', 'Taiyuan', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2358, '2', '大同', 'Datong', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2359, '3', '阳泉', 'Yangquan', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2360, '4', '长治', 'Changzhi', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2361, '5', '晋城', 'Jincheng', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2362, '6', '朔州', 'Shuozhou', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2363, '7', '晋中', 'Jinzhong', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2364, '8', '运城', 'Yuncheng', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2365, '9', '忻州', 'Xinzhou', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2366, '10', '临汾', 'Linfen', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2367, '11', '吕梁', 'Lu Liang', 107, '14', 135, 'CHN'); INSERT INTO `city` VALUES (2368, '1', '呼和浩特', 'Hohhot', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2369, '2', '包头', 'Baotou', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2370, '3', '乌海', 'Wuhai', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2371, '4', '赤峰', 'Chifeng', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2372, '5', '通辽', 'Tongliao', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2373, '6', '鄂尔多斯', 'Ordos', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2374, '7', '呼伦贝尔', 'Hulunbuir', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2375, '8', '巴彦淖尔', 'bayannaoer', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2376, '9', '乌兰察布', 'Ulanqab', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2377, '22', '兴安', 'Xing\'an', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2378, '25', '锡林郭勒', 'Xilin Gol', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2379, '29', '阿拉善', 'Alxa', 108, '15', 135, 'CHN'); INSERT INTO `city` VALUES (2380, '1', '沈阳', 'Shenyang', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2381, '2', '大连', 'Dalian', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2382, '3', '鞍山', 'Anshan', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2383, '4', '抚顺', 'Fushun', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2384, '5', '本溪', 'Benxi', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2385, '6', '丹东', 'Dandong', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2386, '7', '锦州', 'Jinzhou', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2387, '8', '营口', 'yingkou', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2388, '9', '阜新', 'Fuxin', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2389, '10', '辽阳', 'Liaoyang', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUES (2390, '11', '盘锦', 'Panjin', 109, '21', 135, 'CHN'); INSERT INTO `city` VALUE