/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50711
Source Host : localhost:3306
Source Database : rdms
Target Server Type : MYSQL
Target Server Version : 50711
File Encoding : 65001
Date: 2016-07-07 15:10:03
*/
use sppay;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tab_imsi
-- ----------------------------
DROP TABLE IF EXISTS `tab_imsi`;
CREATE TABLE `tab_imsi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`area_code` varchar(255) DEFAULT NULL,
`mobile_area` varchar(255) DEFAULT NULL,
`mobile_number` varchar(255) DEFAULT NULL,
`mobile_type` varchar(255) DEFAULT NULL,
`post_code` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
INDEX phone_index (mobile_number(7))
) ENGINE=InnoDB AUTO_INCREMENT=314884 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tab_imsi
-- ----------------------------
INSERT INTO `tab_imsi` VALUES ('1', '0771', '广西 南宁市', '1330000', '电信CDMA卡', '530000');
INSERT INTO `tab_imsi` VALUES ('2', '023', '重庆', '1330002', '电信CDMA卡', '400000');
INSERT INTO `tab_imsi` VALUES ('3', '023', '重庆', '1330003', '电信CDMA卡', '400000');
INSERT INTO `tab_imsi` VALUES ('4', '010', '北京', '1330010', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('5', '010', '北京', '1330011', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('6', '021', '上海', '1330018', '电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('7', '021', '上海', '1330019', '电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('8', '022', '天津', '1330033', '电信CDMA卡', '300000');
INSERT INTO `tab_imsi` VALUES ('9', '022', '天津', '1330034', '电信CDMA卡', '300000');
INSERT INTO `tab_imsi` VALUES ('10', '021', '上海', '1330050', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('11', '021', '上海', '1330051', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('12', '021', '上海', '1330052', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('13', '021', '上海', '1330053', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('14', '021', '上海', '1330054', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('15', '021', '上海', '1330063', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('16', '021', '上海', '1330064', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('17', '021', '上海', '1330066', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('18', '021', '上海', '1330080', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('19', '021', '上海', '1330081', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('20', '021', '上海', '1330082', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('21', '021', '上海', '1330083', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('22', '021', '上海', '1330084', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('23', '021', '上海', '1330085', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('24', '021', '上海', '1330086', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('25', '021', '上海', '1330087', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('26', '021', '上海', '1330088', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('27', '021', '上海', '1330089', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('28', '021', '上海', '1330098', '上海电信CDMA卡', '200000');
INSERT INTO `tab_imsi` VALUES ('29', '010', '北京', '1330100', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('30', '010', '北京', '1330101', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('31', '010', '北京', '1330102', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('32', '010', '北京', '1330103', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('33', '010', '北京', '1330104', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('34', '010', '北京', '1330105', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('35', '010', '北京', '1330106', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('36', '010', '北京', '1330107', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('37', '010', '北京', '1330108', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('38', '010', '北京', '1330109', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('39', '010', '北京', '1330110', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('40', '010', '北京', '1330111', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('41', '010', '北京', '1330112', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('42', '010', '北京', '1330113', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('43', '010', '北京', '1330114', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('44', '010', '北京', '1330115', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('45', '010', '北京', '1330116', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('46', '010', '北京', '1330117', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('47', '010', '北京', '1330118', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('48', '010', '北京', '1330119', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('49', '010', '北京', '1330120', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('50', '010', '北京', '1330121', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('51', '010', '北京', '1330122', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('52', '010', '北京', '1330123', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('53', '010', '北京', '1330124', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('54', '010', '北京', '1330125', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('55', '010', '北京', '1330126', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('56', '010', '北京', '1330127', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('57', '010', '北京', '1330128', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('58', '010', '北京', '1330129', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('59', '010', '北京', '1330130', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('60', '010', '北京', '1330131', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('61', '010', '北京', '1330132', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('62', '010', '北京', '1330133', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('63', '010', '北京', '1330134', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('64', '010', '北京', '1330135', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('65', '010', '北京', '1330136', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('66', '010', '北京', '1330137', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('67', '010', '北京', '1330138', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('68', '010', '北京', '1330139', '电信CDMA卡', '100000');
INSERT INTO `tab_imsi` VALUES ('69', '0517', '江苏 淮安市', '1330140', '电信CDMA卡', '223001');
INSERT INTO `tab_imsi` VALUES ('70', '0515', '江苏 盐城市', '1330141', '电信CDMA卡', '224000');
INSERT INTO `tab_imsi` VALUES ('71', '0523', '江苏 泰州市', '1330142', '电信CDMA卡', '225300');
INSERT INTO `tab_imsi` VALUES ('72', '0523', '江苏 泰州市', '1330143', '电信CDMA卡', '225300');
INSERT INTO `tab_imsi` VALUES ('73', '0514', '江苏 扬州市', '1330144', '电信CDMA卡',