IBM Cloud · SQL

SQL inserts to load IBM Cloud CIDRs into a database table. 411 CIDRs, refreshed daily.
// ibmcloud_ips.sql

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

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

INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.10.96.0/19', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.83.159.0/24', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('13.116.64.0/18', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('13.120.64.0/18', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('13.121.64.0/18', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('13.122.64.0/18', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('43.245.168.0/24', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('46.16.184.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.0.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.8.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.16.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.24.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.24.0/22', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.32.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.40.0/21', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.64.0/20', 'IPv4');
INSERT INTO `ibmcloud_ips` (`ip_address`, `ip_type`) VALUES ('50.22.128.0/18', 'IPv4');
… (394 more lines)