rackspace · SQL

SQL inserts to load rackspace CIDRs into a database table. 325 CIDRs, refreshed daily.
// rackspace_ips.sql

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

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

INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('5.79.0.0/18', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.0.0/18', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.64.0/18', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.128.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.160.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.192.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('23.253.224.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('31.222.128.0/18', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('37.188.96.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('46.38.160.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('46.227.46.0/24', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.0.0/17', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.128.0/20', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.144.0/22', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.152.0/21', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.160.0/19', 'IPv4');
INSERT INTO `rackspace_ips` (`ip_address`, `ip_type`) VALUES ('50.56.192.0/18', 'IPv4');
… (308 more lines)