backblaze · SQL

SQL inserts to load backblaze CIDRs into a database table. 59 CIDRs, refreshed daily.
// backblaze_ips.sql

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

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

INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('23.144.80.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('45.11.36.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('45.11.37.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('45.11.38.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('45.11.39.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.232.0/23', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.234.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.235.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.236.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.237.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('104.153.238.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.128.0/23', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.130.0/23', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.132.0/23', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.134.0/23', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.136.0/24', 'IPv4');
INSERT INTO `backblaze_ips` (`ip_address`, `ip_type`) VALUES ('149.137.137.0/24', 'IPv4');
… (42 more lines)