-- MySQL dump 10.10
--
-- Host: localhost Database: ipaddress
-- ------------------------------------------------------
-- Server version 5.0.22-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `bbsgood_ip`
--
DROP TABLE IF EXISTS `bbsgood_ip`;
CREATE TABLE `bbsgood_ip` (
`ip1` double NOT NULL,
`ip2` double NOT NULL,
`ip3` varchar(50) default NULL,
`ip4` varchar(50) default NULL,
`country` varchar(50) default NULL,
`city` varchar(255) default NULL,
UNIQUE KEY `ip1` (`ip1`),
UNIQUE KEY `ip2` (`ip2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `bbsgood_ip`
--
/*!40000 ALTER TABLE `bbsgood_ip` DISABLE KEYS */;
LOCK TABLES `bbsgood_ip` WRITE;
INSERT INTO `bbsgood_ip` VALUES (-1,16777214,'0.0.0.0','0.255.255.255','IANA',''),(16777215,20185086,'1.0.0.0','1.51.255.255','IANA',''),(20185087,20250622,'1.52.0.0','1.52.255.255','美国',''),(20250623,26869758,'1.53.0.0','1.153.255.255','IANA',''),(26869759,26935294,'1.154.0.0','1.154.255.255','美国',''),(26935295,33554430,'1.155.0.0','1.255.255.255','IANA',''),(33554431,50331646,'2.0.0.0','2.255.255.255','IANA',''),(50331647,67108862,'3.0.0.0','3.255.255.255','美国','新泽西通用电气公司'),(67108863,67764222,'4.0.0.0','4.9.255.255','美国',''),(67764223,67829758,'4.10.0.0','4.10.255.255','美国','新泽西州立大学'),(67829759,67895294,'4.11.0.0','4.11.255.255','美国','夏威夷'),(67895295,68374014,'4.12.0.0','4.19.77.255','美国',''),(68374015,68374270,'4.19.78.0','4.19.78.255','美国','西南政法大学'),(68374271,68374334,'4.19.79.0','4.19.79.63','美国','Armed Forces Radio/Television'),(68374335,68530430,'4.19.79.64','4.21.176.255','美国',''),(68530431,68530686,'4.21.177.0','4.21.177.255','美国','西南政法大学'),(68530687,69500030,'4.21.178.0','4.36.124.127','美国',''),(69500031,69500158,'4.36.124.128','4.36.124.255','美国','Technical Resource Connections Inc'),(69500159,69500926,'4.36.125.0','4.36.127.255','美国','坦帕大学'),(69500927,69588990,'4.36.128.0','4.37.215.255','美国',''),(69588991,69590014,'4.37.216.0','4.37.219.255','美国','德克萨斯女子大学'),(69590015,69811454,'4.37.220.0','4.41.60.255','美国',''),(69811455,69811710,'4.41.61.0','4.41.61.255','美国','EARTHLINK公司'),(69811711,69944574,'4.41.62.0','4.43.68.255','美国',''),(69944575,69944670,'4.43.69.0','4.43.69.95','美国','罗斯门特学院'),(69944671,80752894,'4.43.69.96','4.208.48.255','美国','Genuity用户'),(80752895,80753150,'4.208.49.0','4.208.49.255','美国','加洲'),(80753151,82706430,'4.208.50.0','4.237.255.255','美国','Genuity用户'),(82706431,82837502,'4.238.0.0','4.239.255.255','美国','宾夕法尼亚州'),(82837503,83886078,'4.240.0.0','4.255.255.255','美国','Genuity用户'),(83886079,93585406,'5.0.0.0','5.147.255.255','IANA',''),(93585407,93650942,'5.148.0.0','5.148.255.255','加拿大',''),(93650943,100663294,'5.149.0.0','5.255.255.255','IANA',''),(100663295,150994942,'6.0.0.0','8.255.255.255','美国','DoD网络信息中心'),(150994943,167772158,'9.0.0.0','9.255.255.255','美国','纽约IBM公司'),(167772159,184549374,'10.0.0.0','10.255.255.255','局域网','对方和您在同一内部网'),(184549375,201326590,'11.0.0.0','11.255.255.255','美国','DoD网络信息中心'),(201326591,201338878,'12.0.0.0','12.0.47.255','美国','ATT用户'),(201338879,201342974,'12.0.48.0','12.0.63.255','美国','哈佛大学'),(201342975,201500926,'12.0.64.0','12.2.168.255','美国','ATT用户'),(201500927,201501182,'12.2.169.0','12.2.169.255','美国','Leepfrog Technologies'),(201501183,201557502,'12.2.170.0','12.3.133.255','美国','ATT用户'),(201557503,201558014,'12.3.134.0','12.3.135.255','美国','Lycoming College'),(201558015,201699566,'12.3.136.0','12.5.176.239','美国','ATT用户'),(201699567,201699582,'12.5.176.240','12.5.176.255','美国','Friends University'),(201699583,201773054,'12.5.177.0','12.6.207.255','美国','ATT用户'),(201773055,201777150,'12.6.208.0','12.6.223.255','美国','哈佛大学'),(201777151,201778686,'12.6.224.0','12.6.229.255','美国','ATT用户'),(201778687,201779198,'12.6.230.0','12.6.231.255','美国','Marlboro College'),(201779199,202083070,'12.6.232.0','12.11.138.255','美国','ATT用户'),(202083071,202083326,'12.11.139.0','12.11.139.255','美国','南佛蒙特学院'),(202083327,202223742,'12.11.140.0','12.13.176.127','美国','ATT用户'),(202223743,202223870,'12.13.176.128','12.13.176.255','美国','Spelman College'),(202223871,202430462,'12.13.177.0','12.16.215.255','美国','ATT用户'),(202430463,202431486,'12.16.216.0','12.16.219.255','美国','太平洋联合学院'),(202431487,202630654,'12.16.220.0','12.19.229.255','美国','ATT用户'),(202630655,202630910,'12.19.230.0','12.19.230.255','美国','Houghton College'),(202630911,202790142,'12.19.231.0','12.22.84.255','美国','ATT用户'),(202790143,202790398,'12.22.85.0','12.22.85.255','美国','新泽西'),(202790399,202813950,'12.22.86.0','12.22.177.255','美国','ATT用户'),(202813951,202814462,'12.22.178.0','12.22.179.255','美国','First Technology Solutions'),(202814463,203026142,'12.22.180.0','12.25.238.223','美国','ATT用户'),(203026143,203026174,'12.25.238.224','12.25.238.255','美国','InFlow STL01'),(203026175,203881982,'12.25.239.0','12.38.253.255','美国','ATT用户'),(203881983,203882014,'12.38.254.0','12.38.254.31','美国','卡森纽曼学院'),(203882015,204266878,'12.38.254.32','12.44.221.127','美国','ATT用户'),(204266879,204267006,'12.44.221.128','12.44.221.255','美国','斯波丁尔大学'),(204267007,204328334,'12.44.222.0','12.45.205.143','美国','ATT用户'),(204328335,204328350,'12.45.205.144','12.45.205.159','美国','AAA AI SOFTWARE SOLUTIONS'),(204328351,206132734,'12.45.205.160','12.73.85.255','美国','ATT用户'),(206132735,206132990,'12.73.86.0','12.73.86.255','美国','休斯顿'),(206132991,208347582,'12.73.87.0','12.107.33.191','美国','ATT用户'),(208347583,208347646,'12.107.33.192','12.107.33.255','美国','Lenoir-Rhyne College'),(208347647,208618878,'12.107.34.0','12.111.69.127','美国','ATT用户'),(208618879,208619006,'12.111.69.128','12.111.69.255','美国','Springfield College'),(208619007,211255806,'12.111.70.0','12.151.129.255','美国','ATT用户'),(211255807,211256062,'12.151.130.0','12.151.130.255','美国','STONEHILL COLLEGE'),(211256063,211366910,'12.151.131.0','12.153.51.255','美国','ATT用户'),(211366911,211367934,'12.153.52.0','12.153.55.255','美国','哥伦比亚联合学院'),(211367935,211448830,'12.153.56.0','12.154.115.255','美国','ATT用户'),(211448831,211449342,'12.154.116.0','12.154.117.255','美国','BARBOURVILLE UTILITIES'),(211449343,211460094,'12.154.118.0','12.154.159.255','美国','ATT用户'),(211460095,211460350,'12.154.160.0','12.154.160.255','美国','Salve Regina University'),(211460351,211812350,'12.154.161.0','12.159.255.255','美国','ATT用户'),(211812351,211877886,'12.160.0.0','12.160.255.255','美国','新泽西'),(211877887,212367614,'12.161.0.0','12.168.120.255','美国','ATT用户'),(212367615,212367870,'12.168.121.0','12.168.121.255','美国','CARILION HEALTH SYSTEM'),(212367871,212819966,'12.168.122.0','12.175.95.255','美国','ATT用户'),(212819967,212819974,'12.175.96.0','12.175.96.7','美国','耶鲁大学'),(212819975,215482366,'12.175.96.8','12.215.255.255','美国','ATT用户'),(215482367,21554