// ZOOM / SQL
Zoom · SQL

SQL inserts to load Zoom CIDRs into a database table. 60 CIDRs, refreshed daily.
// zoom_ips.sql

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

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

INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('3.7.35.0/25', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('3.235.82.0/23', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('3.235.96.0/23', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('15.220.80.0/24', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('15.220.81.0/25', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('18.254.23.128/25', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('18.254.61.0/25', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('20.203.158.80/28', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('20.203.190.192/26', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('52.61.100.128/25', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('64.211.144.0/24', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('64.224.32.0/19', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('69.174.108.0/22', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('101.36.167.0/24', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('101.36.170.0/23', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('103.122.166.0/23', 'IPv4');
INSERT INTO `zoom_ips` (`ip_address`, `ip_type`) VALUES ('111.33.115.0/25', 'IPv4');
… (43 more lines)