// ZOHO / SQL
zoho · SQL

SQL inserts to load zoho CIDRs into a database table. 179 CIDRs, refreshed daily.
// zoho_ips.sql

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

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

INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.33.38.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.33.39.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.39.54.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.40.222.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.47.10.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('8.47.11.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('43.239.212.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('43.239.214.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('65.154.166.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('74.188.224.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('74.188.226.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('74.188.226.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('94.31.54.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('101.97.36.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('103.84.216.0/23', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('103.84.216.0/24', 'IPv4');
INSERT INTO `zoho_ips` (`ip_address`, `ip_type`) VALUES ('103.84.218.0/23', 'IPv4');
… (162 more lines)