DigitalOcean · SQL

SQL inserts to load DigitalOcean CIDRs into a database table. 1,219 CIDRs, refreshed daily.
// digitalocean_ips.sql

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

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

INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('5.101.96.0/21', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('5.101.104.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.64.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.68.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.74.0/23', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.76.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.80.0/20', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.144.96.0/19', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.64.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.68.0/22', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.72.0/21', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.80.0/20', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.96.0/20', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('24.199.112.0/20', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('37.139.0.0/19', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('45.55.0.0/19', 'IPv4');
INSERT INTO `digitalocean_ips` (`ip_address`, `ip_type`) VALUES ('45.55.32.0/19', 'IPv4');
… (1202 more lines)