/*
Navicat Premium Data Transfer
Source Server : 192.168.170.100
Source Server Type : MySQL
Source Server Version : 80100
Source Host : 192.168.170.100:3306
Source Schema : echartsdb
Target Server Type : MySQL
Target Server Version : 80100
File Encoding : 65001
Date: 02/04/2024 21:07:55
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_location_count
-- ----------------------------
DROP TABLE IF EXISTS `t_location_count`;
CREATE TABLE `t_location_count` (
`location` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`count` int(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_location_count
-- ----------------------------
INSERT INTO `t_location_count` VALUES ('0', 19843);
INSERT INTO `t_location_count` VALUES ('贵州', 3668);
INSERT INTO `t_location_count` VALUES ('广东', 682);
INSERT INTO `t_location_count` VALUES ('四川', 656);
INSERT INTO `t_location_count` VALUES ('湖南', 406);
INSERT INTO `t_location_count` VALUES ('上海', 403);
INSERT INTO `t_location_count` VALUES ('北京', 375);
INSERT INTO `t_location_count` VALUES ('云南', 331);
INSERT INTO `t_location_count` VALUES ('重庆', 322);
INSERT INTO `t_location_count` VALUES ('江苏', 273);
INSERT INTO `t_location_count` VALUES ('广西', 270);
INSERT INTO `t_location_count` VALUES ('浙江', 202);
INSERT INTO `t_location_count` VALUES ('湖北', 199);
INSERT INTO `t_location_count` VALUES ('陕西', 149);
INSERT INTO `t_location_count` VALUES ('山东', 148);
INSERT INTO `t_location_count` VALUES ('福建', 123);
INSERT INTO `t_location_count` VALUES ('河南', 107);
INSERT INTO `t_location_count` VALUES ('辽宁', 100);
INSERT INTO `t_location_count` VALUES ('江西', 96);
INSERT INTO `t_location_count` VALUES ('安徽', 84);
INSERT INTO `t_location_count` VALUES ('天津', 81);
INSERT INTO `t_location_count` VALUES ('河北', 77);
INSERT INTO `t_location_count` VALUES ('未知', 73);
INSERT INTO `t_location_count` VALUES ('山西', 46);
INSERT INTO `t_location_count` VALUES ('黑龙江', 42);
INSERT INTO `t_location_count` VALUES ('海南', 39);
INSERT INTO `t_location_count` VALUES ('吉林', 37);
INSERT INTO `t_location_count` VALUES ('新疆', 36);
INSERT INTO `t_location_count` VALUES ('甘肃', 36);
INSERT INTO `t_location_count` VALUES ('内蒙古', 27);
INSERT INTO `t_location_count` VALUES ('宁夏', 17);
INSERT INTO `t_location_count` VALUES ('青海', 13);
INSERT INTO `t_location_count` VALUES ('西藏', 13);
INSERT INTO `t_location_count` VALUES ('美国', 6);
INSERT INTO `t_location_count` VALUES ('中国澳门', 6);
INSERT INTO `t_location_count` VALUES ('泰国', 5);
INSERT INTO `t_location_count` VALUES ('加拿大', 4);
INSERT INTO `t_location_count` VALUES ('中国香港', 3);
INSERT INTO `t_location_count` VALUES ('澳大利亚', 2);
INSERT INTO `t_location_count` VALUES ('日本', 2);
INSERT INTO `t_location_count` VALUES ('韩国', 2);
INSERT INTO `t_location_count` VALUES ('马来西亚', 2);
SET FOREIGN_KEY_CHECKS = 1;
