// AKAMAI / SQL
akamai · SQL

SQL inserts to load akamai CIDRs into a database table. 11,134 CIDRs, refreshed daily.
// akamai_ips.sql

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

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

INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.0.0/13', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.0.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.1.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.2.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.3.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.4.0/23', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.6.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.7.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.8.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.10.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.11.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.12.0/23', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.14.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.15.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.16.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.18.0/24', 'IPv4');
INSERT INTO `akamai_ips` (`ip_address`, `ip_type`) VALUES ('2.16.22.0/24', 'IPv4');
… (11117 more lines)