Google Cloud · SQL

SQL inserts to load Google Cloud CIDRs into a database table. 967 CIDRs, refreshed daily.
// googlecloud_ips.sql

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

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

INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.1.208.0/20', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.35.0.0/16', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.152.86.0/23', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.177.50.0/23', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('2600:1900:8000::/44', 'IPv6');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.80.0.0/15', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.137.0.0/16', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.183.71.0/24', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.183.104.0/24', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.184.70.0/24', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('34.184.83.0/24', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.185.128.0/19', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.185.160.0/20', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.187.144.0/20', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.189.160.0/19', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.194.128.0/17', 'IPv4');
INSERT INTO `googlecloud_ips` (`ip_address`, `ip_type`) VALUES ('35.201.128.0/17', 'IPv4');
… (950 more lines)