// GCORE / SQL
gcore · SQL

SQL inserts to load gcore CIDRs into a database table. 1,835 CIDRs, refreshed daily.
// gcore_ips.sql

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

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

INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('1.37.77.98/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.1.107.249/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.8.92.4/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.8.92.5/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.8.92.6/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.8.92.7/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.8.92.8/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.217.4/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.217.5/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.217.6/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.219.5/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.219.6/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.219.7/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.219.8/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.220.9/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.222.4/32', 'IPv4');
INSERT INTO `gcore_ips` (`ip_address`, `ip_type`) VALUES ('5.101.222.5/32', 'IPv4');
… (1818 more lines)