// CONTABO / SQL
Contabo · SQL

SQL inserts to load Contabo CIDRs into a database table. 758 CIDRs, refreshed daily.
// contabo_ips.sql

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

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

INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('2.58.80.0/23', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('2.58.82.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('2.58.83.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('2.59.156.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.104.80.0/22', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.104.84.0/22', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.180.148.0/23', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.180.150.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.180.151.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.182.17.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.182.33.0/24', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.189.128.0/20', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.189.144.0/20', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.189.160.0/20', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.189.176.0/20', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.252.52.0/23', 'IPv4');
INSERT INTO `contabo_ips` (`ip_address`, `ip_type`) VALUES ('5.252.54.0/23', 'IPv4');
… (741 more lines)