// HETZNER / SQL
Hetzner · SQL

SQL inserts to load Hetzner CIDRs into a database table. 686 CIDRs, refreshed daily.
// hetzner_ips.sql

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

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

INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.9.0.0/16', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.75.128.0/17', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.0.0/16', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.8.0/21', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.16.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.17.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.18.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.19.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.20.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.21.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.22.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.23.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.24.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.25.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.26.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.27.0/24', 'IPv4');
INSERT INTO `hetzner_ips` (`ip_address`, `ip_type`) VALUES ('5.78.28.0/24', 'IPv4');
… (669 more lines)