// HOSTWAY / SQL
hostway · SQL

SQL inserts to load hostway CIDRs into a database table. 174 CIDRs, refreshed daily.
// hostway_ips.sql

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

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

INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.0.0/20', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.0.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.1.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.2.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.3.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.4.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.5.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.6.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.7.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.8.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.9.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.10.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.11.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.12.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.13.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.14.0/24', 'IPv4');
INSERT INTO `hostway_ips` (`ip_address`, `ip_type`) VALUES ('61.100.15.0/24', 'IPv4');
… (157 more lines)