// GABIA / SQL
gabia · SQL

SQL inserts to load gabia CIDRs into a database table. 97 CIDRs, refreshed daily.
// gabia_ips.sql

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

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

INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.224.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.225.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('103.240.48.0/22', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.79.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.87.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.93.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.95.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.112.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.113.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.114.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.115.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.116.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.117.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.118.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.119.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.121.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.122.0/24', 'IPv4');
… (80 more lines)