// ALIBABA / SQL
Alibaba · SQL

SQL inserts to load Alibaba CIDRs into a database table. 2,304 CIDRs, refreshed daily.
// alibaba_ips.sql

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

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

INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('5.181.224.0/23', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.4.0/22', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.4.0/23', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.6.0/23', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.32.0/19', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.32.0/20', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.48.0/20', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.64.0/20', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.64.0/21', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.72.0/21', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.80.0/20', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.80.0/21', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.88.0/21', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.96.0/21', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.96.0/22', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.100.0/22', 'IPv4');
INSERT INTO `alibaba_ips` (`ip_address`, `ip_type`) VALUES ('8.128.104.0/21', 'IPv4');
… (2287 more lines)