// LINODE / SQL
Linode · SQL

SQL inserts to load Linode CIDRs into a database table. 5,342 CIDRs, refreshed daily.
// linode_ips.sql

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

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

INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c00::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:2::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c01::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:3::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c02::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:4::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c03::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:6::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2a01:7e00::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:7::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2400:8901::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:9::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2a01:7e01::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:10::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2400:8902::/32', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2600:3c0f:11::/48', 'IPv6');
INSERT INTO `linode_ips` (`ip_address`, `ip_type`) VALUES ('2400:8904::/32', 'IPv6');
… (5325 more lines)