// TENCENT / SQL
Tencent · SQL

SQL inserts to load Tencent CIDRs into a database table. 3,389 CIDRs, refreshed daily.
// tencent_ips.sql

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

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

INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.0.0/14', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.0.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.0.0/20', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.14.0/23', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.34.0/23', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.64.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.128.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.12.192.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.13.0.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.13.64.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.13.128.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.13.148.0/24', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.13.192.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.14.0.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.14.64.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.14.128.0/18', 'IPv4');
INSERT INTO `tencent_ips` (`ip_address`, `ip_type`) VALUES ('1.14.192.0/18', 'IPv4');
… (3372 more lines)