Googlebot · SQL

SQL inserts to load Googlebot CIDRs into a database table. 311 CIDRs, refreshed daily.
// googlebot_ips.sql

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

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

INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:10::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:11::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:12::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:13::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:14::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:15::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:16::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:17::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:18::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:19::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1a::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1b::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1c::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1d::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1e::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:1f::/64', 'IPv6');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('2001:4860:4801:20::/64', 'IPv6');
… (294 more lines)