// GABIA / SQL
gabia · SQL

SQL inserts to load gabia CIDRs into a database table. 144 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.16.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.17.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.18.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.19.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.65.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.66.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.67.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.68.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.99.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.111.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.112.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.113.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.114.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.115.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.116.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.117.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.118.0/24', 'IPv4');
… (127 more lines)