// YANDEX / SQL
yandex · SQL

SQL inserts to load yandex CIDRs into a database table. 142 CIDRs, refreshed daily.
// yandex_ips.sql

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

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

INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.192.0/18', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.202.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.205.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.214.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.215.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.219.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.241.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.243.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.45.252.0/22', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.255.192.0/18', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.255.197.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.255.205.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('5.255.255.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('31.44.8.0/21', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('31.44.9.0/24', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('37.9.64.0/18', 'IPv4');
INSERT INTO `yandex_ips` (`ip_address`, `ip_type`) VALUES ('37.9.64.0/24', 'IPv4');
… (125 more lines)