// VULTR / SQL
Vultr · SQL
SQL inserts to load Vultr CIDRs into a database table. 490 CIDRs, refreshed daily.
// vultr_ips.sql
-- SQL script to create table `vultr_ips` and insert IP addresses
CREATE TABLE IF NOT EXISTS `vultr_ips` (
`ip_address` VARCHAR(45) NOT NULL,
`ip_type` VARCHAR(10) NOT NULL,
PRIMARY KEY (`ip_address`)
);
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('43.224.32.0/22', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.0.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.8.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.16.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.24.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.32.0/19', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.64.0/19', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.96.0/19', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.128.0/20', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.144.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.152.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.160.0/20', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.176.0/21', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.184.0/22', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.188.0/22', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.192.0/20', 'IPv4');
INSERT INTO `vultr_ips` (`ip_address`, `ip_type`) VALUES ('45.32.208.0/20', 'IPv4');
… (473 more lines)