// APPLEBOT / SQL
Applebot · SQL

SQL inserts to load Applebot CIDRs into a database table. 33 CIDRs, refreshed daily.
// applebot_ips.sql

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

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

INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.22.237.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.22.245.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.22.253.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.20.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.21.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.22.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.23.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.24.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.25.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.150.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.151.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.152.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.153.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.154.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.155.0/24', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.192.48/28', 'IPv4');
INSERT INTO `applebot_ips` (`ip_address`, `ip_type`) VALUES ('17.166.232.0/24', 'IPv4');
… (16 more lines)