// SCALEWAY / SQL
Scaleway · SQL

SQL inserts to load Scaleway CIDRs into a database table. 61 CIDRs, refreshed daily.
// scaleway_ips.sql

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

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

INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.160.0.0/14', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.160.0.0/15', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.160.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.161.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.162.0.0/15', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.162.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('37.163.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('51.15.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('51.15.0.0/17', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('51.158.0.0/15', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('51.158.128.0/17', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('51.159.224.0/19', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('62.4.0.0/19', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('62.210.0.0/16', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('78.208.0.0/13', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('78.208.0.0/17', 'IPv4');
INSERT INTO `scaleway_ips` (`ip_address`, `ip_type`) VALUES ('78.208.128.0/17', 'IPv4');
… (44 more lines)