// QUICCLOUD / SQL
quiccloud · SQL
SQL inserts to load quiccloud CIDRs into a database table. 153 CIDRs, refreshed daily.
// quiccloud_ips.sql
-- SQL script to create table `quiccloud_ips` and insert IP addresses
CREATE TABLE IF NOT EXISTS `quiccloud_ips` (
`ip_address` VARCHAR(45) NOT NULL,
`ip_type` VARCHAR(10) NOT NULL,
PRIMARY KEY (`ip_address`)
);
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('5.134.119.103', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('15.204.231.24', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('15.235.180.91', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('15.235.181.227', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('18.192.146.200', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('23.95.72.16', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('23.160.56.125', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('31.22.115.186', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('31.40.212.152', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('31.131.4.244', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('37.120.163.165', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('38.54.30.228', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('38.54.79.187', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('38.60.253.237', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('38.114.121.40', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('40.160.225.31', 'IPv4');
INSERT INTO `quiccloud_ips` (`ip_address`, `ip_type`) VALUES ('40.160.241.195', 'IPv4');
… (136 more lines)