/*
Navicat MySQL Data Transfer
Source Server : MyTest
Source Server Version : 50639
Source Host : localhost:3306
Source Database : cmccnet
Target Server Type : MYSQL
Target Server Version : 50639
File Encoding : 65001
Date: 2018-05-14 15:18:09
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ipaddressusage
-- ----------------------------
DROP TABLE IF EXISTS `ipaddressusage`;
CREATE TABLE `ipaddressusage` (
`GID` int(11) NOT NULL AUTO_INCREMENT,
`AREA` varchar(255) DEFAULT NULL,
`IPADDFIELD` varchar(255) DEFAULT NULL,
`GATEWAYIP` varchar(255) DEFAULT NULL,
`USERIP` varchar(255) DEFAULT NULL,
`ENTERPRISENAME` varchar(255) DEFAULT NULL,
`SPECIALLINENUM` varchar(255) DEFAULT NULL,
`BILLINGNUM` varchar(255) DEFAULT NULL,
PRIMARY KEY (`GID`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of ipaddressusage
-- ----------------------------
INSERT INTO `ipaddressusage` VALUES ('1', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.2', '宁波世林电器有限公司', 'default-2120561', 'e5574754187');
INSERT INTO `ipaddressusage` VALUES ('2', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.3', '慈溪汉马电子商务有限公司', 'default-2129486', 'e5574757385');
INSERT INTO `ipaddressusage` VALUES ('3', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.4', '慈溪市鹰威电子有限公司', 'default-2130281', 'e5574757728');
INSERT INTO `ipaddressusage` VALUES ('4', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.5', '信元新科通信科技有限公司', 'default-2157574', 'e5574769674');
INSERT INTO `ipaddressusage` VALUES ('5', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.6', '博莱特光电科技股份有限公司', 'default-2157189', 'e5574769470');
INSERT INTO `ipaddressusage` VALUES ('6', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.7', '彩格新材料科技有限公司', 'CMNET-2157798', 'e5574769781');
INSERT INTO `ipaddressusage` VALUES ('7', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.8', '古塘纯色花艺店', 'default-2158041', 'e5574769849');
INSERT INTO `ipaddressusage` VALUES ('8', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.9', '掌起桃源水果农场', 'default-2157517', 'e5574769632');
INSERT INTO `ipaddressusage` VALUES ('9', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.10', '新浦胜凯果蔬农场', 'CMNET-2158968', 'e5574770134');
INSERT INTO `ipaddressusage` VALUES ('10', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.11', '中琅置业有限公司', 'default-2158858', 'e5574770108');
INSERT INTO `ipaddressusage` VALUES ('11', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.12', '世纪城社区服务中心', 'default-2158962', 'e5574770132');
INSERT INTO `ipaddressusage` VALUES ('12', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.13', '东埠头石业有限公司', 'CMNET-2159718', 'e5574770422');
INSERT INTO `ipaddressusage` VALUES ('13', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.14', '匠心建筑材料有限公司', 'default-2158899', 'e5574770118');
INSERT INTO `ipaddressusage` VALUES ('14', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.15', '德萨电器制造有限公司', 'CMNET-2176702', 'e5574778459');
INSERT INTO `ipaddressusage` VALUES ('15', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.16', '德萨电器制造有限公司', 'CMNET-2176693', 'e5574778454');
INSERT INTO `ipaddressusage` VALUES ('16', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.17', '中国移动(南洋小镇)', 'CMNET-2177480', 'e5574778859');
INSERT INTO `ipaddressusage` VALUES ('17', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.18', '合力众创资产管理有限公司', 'default-2174708', 'e5574777558');
INSERT INTO `ipaddressusage` VALUES ('18', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.19', '创沅网络科技有限公司', 'CMNET-2161244', 'e5574771058');
INSERT INTO `ipaddressusage` VALUES ('19', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.20', '万意新能源有限公司', 'CMNET-2176964', 'e5574778629');
INSERT INTO `ipaddressusage` VALUES ('20', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.21', '聚创金属材料有限公司', 'default-2177936', 'e5574779143');
INSERT INTO `ipaddressusage` VALUES ('21', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.22', '观海卫镇蒋家村', 'CMNET-2175366', 'e5574777844');
INSERT INTO `ipaddressusage` VALUES ('22', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.23', '盟谊体育文化发展有限公司', 'default-2052073', 'e5574689672');
INSERT INTO `ipaddressusage` VALUES ('23', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.24', '长河昌鑫五金配件厂', 'default-2176241', 'e5574778270');
INSERT INTO `ipaddressusage` VALUES ('24', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.25', '合拾瑜伽馆', 'CMNET-2176932', 'e5574778580');
INSERT INTO `ipaddressusage` VALUES ('25', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.26', '浩滨生态农场', 'CMNET-2176546', 'e5574778389');
INSERT INTO `ipaddressusage` VALUES ('26', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.27', '古塘御舒坊足浴店', 'CMNET-2178717', 'e5574779785');
INSERT INTO `ipaddressusage` VALUES ('27', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.28', '慈溪市匡堰浙文童装店', 'CMNET-2180641', 'e5574780988');
INSERT INTO `ipaddressusage` VALUES ('28', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.29', '慈溪市龙山镇羽毛球协会', 'CMNET-2180284', 'e5574780731');
INSERT INTO `ipaddressusage` VALUES ('29', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.30', '宁波杭州湾新区鼎红手机店', 'CMNET-2180974', 'e5574781351');
INSERT INTO `ipaddressusage` VALUES ('30', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.31', '慈溪市掌起依达果蔬农场', 'CMNET-2164744', 'e5574772683');
INSERT INTO `ipaddressusage` VALUES ('31', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.32', '慈溪市掌起燕兴水稻农场', 'CMNET-2165470', 'e5574772937');
INSERT INTO `ipaddressusage` VALUES ('32', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.33', '慈溪市浒山飞飞软件商行', 'default-2178580', 'e5574779653');
INSERT INTO `ipaddressusage` VALUES ('33', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.34', '中山市中恒电器有限公司', 'CMNET-2180899', 'e5574781263');
INSERT INTO `ipaddressusage` VALUES ('34', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.35', '慈溪市横河镇振兴水暖器材厂', 'default-2181708', 'e5574781730');
INSERT INTO `ipaddressusage` VALUES ('35', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.36', '慈溪市古塘春夏秋冬服装店', 'CMNET-2181491', 'e5574781593');
INSERT INTO `ipaddressusage` VALUES ('36', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.37', '海斌生态农场', 'CMNET-2182436', 'e5574782143');
INSERT INTO `ipaddressusage` VALUES ('37', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.38', '立宇电子有限公司', 'default-2182030', 'e5574781939');
INSERT INTO `ipaddressusage` VALUES ('38', '慈溪(自动)', '112.14.17.0/24', '112.14.17.1', '112.14.17.39', '上格照明科技有限公司', 'default-2183400', 'e5574782612');
INSERT INTO `ipaddressusage` VALUES ('39', '慈溪(自动)'