uptimerobot · SQL

SQL inserts to load uptimerobot CIDRs into a database table. 232 CIDRs, refreshed daily.
// uptimerobot_ips.sql

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

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

INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.12.251.153/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.20.63.178/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.77.67.4/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.79.134.69/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.105.133.239/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.105.190.221/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.133.226.214/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.149.57.90/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('3.212.128.62/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.61.238/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.73.160/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.75.7/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.113.195/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.117.52/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.177.47/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.194.92/32', 'IPv4');
INSERT INTO `uptimerobot_ips` (`ip_address`, `ip_type`) VALUES ('5.161.215.244/32', 'IPv4');
… (215 more lines)