// LEASEWEB / SQL
leaseweb · SQL

SQL inserts to load leaseweb CIDRs into a database table. 2,029 CIDRs, refreshed daily.
// leaseweb_ips.sql

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

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

INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('2.56.100.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('2.57.20.0/23', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('2.59.20.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.61.32.0/20', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.79.64.0/18', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.181.40.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.181.41.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.181.42.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.181.43.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('5.188.222.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.0.0/19', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.32.0/21', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.41.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.44.0/22', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.52.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.53.0/24', 'IPv4');
INSERT INTO `leaseweb_ips` (`ip_address`, `ip_type`) VALUES ('23.19.56.0/21', 'IPv4');
… (2012 more lines)