statuscake · SQL

SQL inserts to load statuscake CIDRs into a database table. 183 CIDRs, refreshed daily.
// statuscake_ips.sql

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

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

INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.48.110.214/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.48.238.157/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.49.141.132/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.245.199.158/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.245.222.203/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.246.54.122/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('13.247.17.60/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('15.160.68.179/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('15.161.88.159/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('16.170.114.19/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('18.102.1.62/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('18.102.253.202/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('34.13.166.3/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('34.13.185.113/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('34.13.188.75/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('34.22.96.192/32', 'IPv4');
INSERT INTO `statuscake_ips` (`ip_address`, `ip_type`) VALUES ('34.34.97.213/32', 'IPv4');
… (166 more lines)