/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50505
Source Host : 127.0.0.1:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50505
File Encoding : 65001
Date: 2017-06-07 15:12:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for mobile
-- ----------------------------
DROP TABLE IF EXISTS `mobile`;
CREATE TABLE `mobile` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`phone` char(9) NOT NULL DEFAULT '' COMMENT '手机号码段',
`province` char(10) NOT NULL DEFAULT '' COMMENT '省份',
`city` char(10) NOT NULL DEFAULT '' COMMENT '市',
`service_provider` char(10) NOT NULL DEFAULT '' COMMENT '运营商',
`city_code` char(9) NOT NULL DEFAULT '' COMMENT '区号',
`postcode` char(9) NOT NULL DEFAULT '' COMMENT '邮编',
PRIMARY KEY (`id`),
UNIQUE KEY `phone` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=360570 DEFAULT CHARSET=utf8 COMMENT='全国手机号码段归属地';
-- ----------------------------
-- Records of mobile
-- ----------------------------
INSERT INTO `mobile` VALUES ('1', '1300000', '山东', '济南', '中国联通', '0531', '250000\r');
INSERT INTO `mobile` VALUES ('2', '1300001', '江苏', '常州', '中国联通', '0519', '213000\r');
INSERT INTO `mobile` VALUES ('3', '1300002', '安徽', '巢湖', '中国联通', '0565', '238000\r');
INSERT INTO `mobile` VALUES ('4', '1300003', '四川', '宜宾', '中国联通', '0831', '644000\r');
INSERT INTO `mobile` VALUES ('5', '1300004', '四川', '自贡', '中国联通', '0813', '643000\r');
INSERT INTO `mobile` VALUES ('6', '1300005', '陕西', '西安', '中国联通', '029', '710000\r');
INSERT INTO `mobile` VALUES ('7', '1300006', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('8', '1300007', '陕西', '西安', '中国联通', '029', '710000\r');
INSERT INTO `mobile` VALUES ('9', '1300008', '湖北', '武汉', '中国联通', '027', '430000\r');
INSERT INTO `mobile` VALUES ('10', '1300009', '陕西', '西安', '中国联通', '029', '710000\r');
INSERT INTO `mobile` VALUES ('11', '1300010', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('12', '1300011', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('13', '1300012', '天津', '天津', '中国联通', '022', '300000\r');
INSERT INTO `mobile` VALUES ('14', '1300013', '天津', '天津', '中国联通', '022', '300000\r');
INSERT INTO `mobile` VALUES ('15', '1300014', '天津', '天津', '中国联通', '022', '300000\r');
INSERT INTO `mobile` VALUES ('16', '1300015', '山东', '淄博', '中国联通', '0533', '255000\r');
INSERT INTO `mobile` VALUES ('17', '1300016', '山东', '烟台', '中国联通', '0535', '264000\r');
INSERT INTO `mobile` VALUES ('18', '1300017', '山东', '济南', '中国联通', '0531', '250000\r');
INSERT INTO `mobile` VALUES ('19', '1300018', '天津', '天津', '中国联通', '022', '300000\r');
INSERT INTO `mobile` VALUES ('20', '1300019', '天津', '天津', '中国联通', '022', '300000\r');
INSERT INTO `mobile` VALUES ('21', '1300020', '上海', '上海', '中国联通', '021', '200000\r');
INSERT INTO `mobile` VALUES ('22', '1300021', '上海', '上海', '中国联通', '021', '200000\r');
INSERT INTO `mobile` VALUES ('23', '1300022', '上海', '上海', '中国联通', '021', '200000\r');
INSERT INTO `mobile` VALUES ('24', '1300023', '上海', '上海', '中国联通', '021', '200000\r');
INSERT INTO `mobile` VALUES ('25', '1300024', '上海', '上海', '中国联通', '021', '200000\r');
INSERT INTO `mobile` VALUES ('26', '1300025', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('27', '1300026', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('28', '1300027', '山东', '烟台', '中国联通', '0535', '264000\r');
INSERT INTO `mobile` VALUES ('29', '1300028', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('30', '1300029', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('31', '1300030', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('32', '1300031', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('33', '1300032', '江苏', '南京', '中国联通', '025', '210000\r');
INSERT INTO `mobile` VALUES ('34', '1300033', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('35', '1300034', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('36', '1300035', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('37', '1300036', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('38', '1300037', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('39', '1300038', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('40', '1300039', '江苏', '无锡', '中国联通', '0510', '214000\r');
INSERT INTO `mobile` VALUES ('41', '1300040', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('42', '1300041', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('43', '1300042', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('44', '1300043', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('45', '1300044', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('46', '1300045', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('47', '1300046', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('48', '1300047', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('49', '1300048', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('50', '1300049', '北京', '北京', '中国联通', '010', '100000\r');
INSERT INTO `mobile` VALUES ('51', '1300050', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('52', '1300051', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('53', '1300052', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('54', '1300053', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('55', '1300054', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('56', '1300055', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('57', '1300056', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('58', '1300057', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('59', '1300058', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('60', '1300059', '广西', '南宁', '中国联通', '0771', '530000\r');
INSERT INTO `mobile` VALUES ('61', '1300060', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('62', '1300061', '湖北', '荆门', '中国联通', '0724', '448000\r');
INSERT INTO `mobile` VALUES ('63', '1300062', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('64', '1300063', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('65', '1300064', '广东', '广州', '中国联通', '020', '510000\r');
INSERT INTO `mobile` VALUES ('66', '1300065', '山东', '潍坊', '中国联通', '0536', '261000\r');
INSERT INTO `mob
