// HUAWEI / SQL
huawei · SQL

SQL inserts to load huawei CIDRs into a database table. 659 CIDRs, refreshed daily.
// huawei_ips.sql

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

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

INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('1.178.32.0/20', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('1.178.48.0/20', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.132.0/22', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.136.0/22', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.140.0/22', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.152.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.153.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.155.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.156.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.157.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.161.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.163.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.164.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.169.0/24', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.170.0/23', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('14.137.172.0/22', 'IPv4');
INSERT INTO `huawei_ips` (`ip_address`, `ip_type`) VALUES ('27.106.0.0/20', 'IPv4');
… (642 more lines)