// BAIDU / SQL
baidu · SQL
SQL inserts to load baidu CIDRs into a database table. 195 CIDRs, refreshed daily.
// baidu_ips.sql
-- SQL script to create table `baidu_ips` and insert IP addresses
CREATE TABLE IF NOT EXISTS `baidu_ips` (
`ip_address` VARCHAR(45) NOT NULL,
`ip_type` VARCHAR(10) NOT NULL,
PRIMARY KEY (`ip_address`)
);
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('42.199.240.0/22', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('45.113.192.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('45.113.193.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('45.113.194.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('103.235.44.0/22', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('103.235.45.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('103.235.46.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('103.235.47.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('104.193.88.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('104.193.89.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('104.193.90.0/24', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.0.0/18', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.0.0/19', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.32.0/19', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.64.0/18', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.64.0/20', 'IPv4');
INSERT INTO `baidu_ips` (`ip_address`, `ip_type`) VALUES ('106.12.80.0/20', 'IPv4');
… (178 more lines)