// OVHCLOUD / SQL
OVHcloud · SQL

SQL inserts to load OVHcloud CIDRs into a database table. 716 CIDRs, refreshed daily.
// ovhcloud_ips.sql

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

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

INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.26.132.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.26.153.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.26.166.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.27.97.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.27.117.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('2.58.172.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.39.0.0/17', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.135.0.0/16', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.172.36.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.175.162.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.175.168.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.175.195.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.178.106.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.178.110.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.182.19.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.183.214.0/24', 'IPv4');
INSERT INTO `ovhcloud_ips` (`ip_address`, `ip_type`) VALUES ('5.196.0.0/16', 'IPv4');
… (699 more lines)