// UPCLOUD / SQL
upcloud · SQL

SQL inserts to load upcloud CIDRs into a database table. 107 CIDRs, refreshed daily.
// upcloud_ips.sql

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

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

INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.22.208.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.22.212.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.22.216.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.22.220.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.57.208.0/24', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.253.32.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('38.100.118.0/23', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('62.164.153.0/24', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('77.81.0.0/24', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('80.69.172.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('81.27.96.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('81.27.100.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('81.27.104.0/23', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('81.27.106.0/23', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('81.27.108.0/22', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('83.136.248.0/21', 'IPv4');
INSERT INTO `upcloud_ips` (`ip_address`, `ip_type`) VALUES ('85.9.192.0/21', 'IPv4');
… (90 more lines)