// AWS / SQL
AWS · SQL

SQL inserts to load AWS CIDRs into a database table. 16,830 CIDRs, refreshed daily.
// aws_ips.sql

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

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

INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.1.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.1.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.4.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.4.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.4.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.5.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.5.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.5.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.6.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.6.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.6.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.7.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.7.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.7.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.8.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.8.0/24', 'IPv4');
INSERT INTO `aws_ips` (`ip_address`, `ip_type`) VALUES ('1.178.8.0/24', 'IPv4');
… (16813 more lines)