// NHNCLOUD / SQL
nhncloud · SQL

SQL inserts to load nhncloud CIDRs into a database table. 372 CIDRs, refreshed daily.
// nhncloud_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `nhncloud_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `nhncloud_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('1.209.199.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.227.116.0/22', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.227.116.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.227.117.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.227.118.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.227.119.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('43.254.244.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.125.232.0/22', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.125.232.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.125.233.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.125.234.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.125.235.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.249.160.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.249.161.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.249.162.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('45.249.163.0/24', 'IPv4');
INSERT INTO `nhncloud_ips` (`ip_address`, `ip_type`) VALUES ('59.150.32.0/24', 'IPv4');
… (355 more lines)