// GOCACHE / SQL
gocache · SQL

SQL inserts to load gocache CIDRs into a database table. 25 CIDRs, refreshed daily.
// gocache_ips.sql

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

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

INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.148.131/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.164.249/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.168.58/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.209.169/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.213.225/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('34.95.253.129/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('35.247.222.78/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('38.224.134.0/24', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('45.77.97.241/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('52.67.255.165/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('129.159.48.87/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('140.82.27.226/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('144.22.216.139/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('150.230.84.126/32', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('170.82.175.0/24', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('170.84.29.208/29', 'IPv4');
INSERT INTO `gocache_ips` (`ip_address`, `ip_type`) VALUES ('186.211.161.0/29', 'IPv4');
… (8 more lines)