30W+条IP地址手机号码短信中心号解析省份城市数据库

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50711 Source Host : localhost Source Database : location Target Server Type : MySQL Target Server Version : 50711 File Encoding : utf-8 Date: 08/16/2016 11:45:56 AM */ SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `area_city_info` -- ---------------------------- DROP TABLE IF EXISTS `area_city_info`; CREATE TABLE `area_city_info` ( `id` int(11) NOT NULL COMMENT '编号', `city_name` varchar(45) NOT NULL COMMENT '城市名称', `province_id` int(11) NOT NULL COMMENT '省份编号', `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '建立时间', PRIMARY KEY (`id`), UNIQUE KEY `index2` (`city_name`), KEY `province_id` (`province_id`), CONSTRAINT `area_city_info_ibfk_1` FOREIGN KEY (`province_id`) REFERENCES `area_province_info` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='城市信息表'; -- ---------------------------- -- Records of `area_city_info` -- ---------------------------- BEGIN; INSERT INTO `area_city_info` VALUES ('-1', '全部', '-1', '2016-08-16 11:37:56'), ('0', '北京', '0', '2016-08-16 11:37:56'), ('1', '天津', '1', '2016-08-16 11:37:56'), ('3', '上海', '2', '2016-08-16 11:37:56'), ('4', '重庆', '3', '2016-08-16 11:37:56'), ('7', '大兴安岭', '4', '2016-08-16 11:37:56'), ('8', '黑河', '4', '2016-08-16 11:37:56'), ('9', '齐齐哈尔', '4', '2016-08-16 11:37:56'), ('10', '绥化', '4', '2016-08-16 11:37:56'), ('11', '鹤岗', '4', '2016-08-16 11:37:56'), ('12', '佳木斯', '4', '2016-08-16 11:37:56'), ('13', '伊春', '4', '2016-08-16 11:37:56'), ('14', '双鸭山', '4', '2016-08-16 11:37:56'), ('15', '哈尔滨', '4', '2016-08-16 11:37:56'), ('16', '鸡西', '4', '2016-08-16 11:37:56'), ('18', '大庆', '4', '2016-08-16 11:37:56'), ('19', '七台河', '4', '2016-08-16 11:37:56'), ('20', '牡丹江', '4', '2016-08-16 11:37:56'), ('22', '辽源', '5', '2016-08-16 11:37:56'), ('23', '通化', '5', '2016-08-16 11:37:56'), ('24', '白城', '5', '2016-08-16 11:37:56'), ('25', '松原', '5', '2016-08-16 11:37:56'), ('26', '长春', '5', '2016-08-16 11:37:56'), ('27', '吉林', '5', '2016-08-16 11:37:56'), ('29', '延边', '5', '2016-08-16 11:37:56'), ('31', '白山', '5', '2016-08-16 11:37:56'), ('32', '四平', '5', '2016-08-16 11:37:56'), ('33', '葫芦岛', '6', '2016-08-16 11:37:56'), ('34', '盘锦', '6', '2016-08-16 11:37:56'), ('35', '辽阳', '6', '2016-08-16 11:37:56'), ('36', '铁岭', '6', '2016-08-16 11:37:56'), ('37', '阜新', '6', '2016-08-16 11:37:56'), ('38', '朝阳', '6', '2016-08-16 11:37:56'), ('39', '锦州', '6', '2016-08-16 11:37:56'), ('40', '鞍山', '6', '2016-08-16 11:37:56'), ('41', '沈阳', '6', '2016-08-16 11:37:56'), ('42', '本溪', '6', '2016-08-16 11:37:56'), ('43', '抚顺', '6', '2016-08-16 11:37:56'), ('44', '营口', '6', '2016-08-16 11:37:56'), ('45', '丹东', '6', '2016-08-16 11:37:56'), ('47', '大连', '6', '2016-08-16 11:37:56'), ('48', '呼伦贝尔', '7', '2016-08-16 11:37:56'), ('49', '兴安盟', '7', '2016-08-16 11:37:56'), ('50', '锡林郭勒盟', '7', '2016-08-16 11:37:56'), ('51', '巴彦淖尔', '7', '2016-08-16 11:37:56'), ('52', '包头', '7', '2016-08-16 11:37:56'), ('53', '呼和浩特', '7', '2016-08-16 11:37:56'), ('55', '通辽', '7', '2016-08-16 11:37:56'), ('56', '赤峰', '7', '2016-08-16 11:37:56'), ('57', '乌海', '7', '2016-08-16 11:37:56'), ('58', '鄂尔多斯', '7', '2016-08-16 11:37:56'), ('59', '乌兰察布', '7', '2016-08-16 11:37:56'), ('60', '石嘴山', '8', '2016-08-16 11:37:56'), ('61', '银川', '8', '2016-08-16 11:37:56'), ('62', '吴忠', '8', '2016-08-16 11:37:56'), ('63', '固原', '8', '2016-08-16 11:37:56'), ('64', '张掖', '9', '2016-08-16 11:37:56'), ('65', '金昌', '9', '2016-08-16 11:37:56'), ('66', '武威', '9', '2016-08-16 11:37:56'), ('67', '兰州', '9', '2016-08-16 11:37:56'), ('68', '白银', '9', '2016-08-16 11:37:56'), ('69', '定西', '9', '2016-08-16 11:37:56'), ('70', '平凉', '9', '2016-08-16 11:37:56'), ('71', '庆阳', '9', '2016-08-16 11:37:56'), ('72', '甘南', '9', '2016-08-16 11:37:56'), ('73', '临夏', '9', '2016-08-16 11:37:56'), ('74', '天水', '9', '2016-08-16 11:37:56'), ('75', '嘉峪关', '9', '2016-08-16 11:37:56'), ('76', '酒泉', '9', '2016-08-16 11:37:56'), ('77', '陇南', '9', '2016-08-16 11:37:56'), ('78', '昌吉', '10', '2016-08-16 11:37:56'), ('79', '克孜勒', '10', '2016-08-16 11:37:56'), ('80', '伊犁', '10', '2016-08-16 11:37:56'), ('81', '阿拉尔', '10', '2016-08-16 11:37:56'), ('82', '克拉玛依', '10', '2016-08-16 11:37:56'), ('83', '博尔塔拉', '10', '2016-08-16 11:37:56'), ('84', '乌鲁木齐', '10', '2016-08-16 11:37:56'), ('85', '吐鲁番', '10', '2016-08-16 11:37:56'), ('86', '阿克苏', '10', '2016-08-16 11:37:56'), ('87', '石河子', '10', '2016-08-16 11:37:56'), ('88', '喀什', '10', '2016-08-16 11:37:56'), ('89', '和田', '10', '2016-08-16 11:37:56'), ('90', '哈密', '10', '2016-08-16 11:37:56'), ('92', '榆林', '11', '2016-08-16 11:37:56'), ('93', '延安', '11', '2016-08-16 11:37:56'), ('94', '咸阳', '11', '2016-08-16 11:37:56'), ('95', '西安', '11', '2016-08-16 11:37:56'), ('96', '渭南', '11', '2016-08-16 11:37:56'), ('97', '汉中', '11', '2016-08-16 11:37:56'), ('98', '商洛', '11', '2016-08-16 11:37:56'), ('99', '安康', '11', '2016-08-16 11:37:56'), ('100', '铜川', '11', '2016-08-16 11:37:56'), ('101', '宝鸡', '11', '2016-08-16 11:37:56'), ('102', '长治', '12', '2016-08-16 11:37:56'), ('103', '晋中', '12', '2016-08-16 11:37:56'), ('104', '朔州', '12', '2016-08-16 11:37:56'), ('105', '大同', '12', '2016-08-16 11:37:56'), ('106', '吕梁', '12', '2016-08-16 11:37:56'), ('107', '忻州', '12', '2016-08-16 11:37:56'), ('108', '太原', '12', '2016-08-16 11:37:56'), ('109', '阳泉', '12', '2016-08-16 11:37:56'), ('110', '临汾', '12', '2016-08-16 11:37:56'), ('111', '运城', '12', '2016-08-16 11:37:56'), ('112', '晋城', '12', '2016-08-16 11:37:56'), ('114', '德州', '13', '2016-08-16 11:37:56'), ('115', '滨州', '13', '2016-08-16 11:37:56'), ('116', '烟台', '13', '2016-08-16 11:37:56'), ('117', '聊城', '13', '2016-08-16 11:37:56'), ('118', '济南', '13', '2016-08-16 11:37:56'), ('119', '泰安', '13', '2016-08-16 11:37:56'), ('120', '淄博', '13', '2016-08-16 11:37:56'), ('121', '潍坊', '13', '2016-08-16 11:37:56'), ('122', '青岛', '13', '2016-08-16 11:37:56'), ('123', '济宁', '13', '2016-08-16 11:37:56'), ('124', '日照', '13', '2016-08-16 11:37:56'), ('126', '枣庄', '13', '2016-08-16 11:37:56'), ('127', '东营', '13', '2016-08-16 11:37:56'), ('128', '威海', '13', '2016-08-16 11:37:56'), ('129', '莱芜', '13', '2016-08-16 11:37:56'), ('130', '临沂', '13', '2016-08-16 11:37:56'), ('131', '菏泽', '13', '2016-08-16 11:37:56'), ('132', '邯郸', '14', '2016-08-16 11:37:56'), ('133', '衡水', '14', '2016-08-16 11:37:56'), ('134', '石家庄', '14', '2016-08-16 11:37:56'), ('135', '邢台', '14', '2016-08-16 11:37:56'), ('136', '张家口', '14', '2016-08-16 11:37:56'), ('137', '承德', '14', '2016-08-16 11:37:56'), ('138', '秦皇岛', '14', '2016-08-16 11:37:56'), ('139', '廊坊', '14', '2016-08-16 11:37:56'), ('140', '唐山', '14', '2016-08-16 11:37:56'), ('141', '保定', '14', '2016-08-16 11:37:56'), ('142', '沧州', '14', '2016-08-16 11:37:56'), ('143', '安阳', '15', '2016-08-16 11:37:56'), ('144', '三门峡', '15', '2016-08-16 11:37:56'), ('145', '郑州', '15', '2016-08-16 11:37:56'), ('146', '南阳', '15', '2016-08-16 11:37:56'), ('147', '周口', '15', '2016-08-16 11:37:56'), ('148', '驻马店', '15', '2016-08-16 11:37:56'), ('149', '信阳', '15', '2016-08-16 11:37:56'), ('150', '开封', '15', '2016-08-16 11:37:56'), ('151', '洛阳', '15', '2016-08-16 11:37:56'), ('152', '平顶山',