salesforce · SQL

SQL inserts to load salesforce CIDRs into a database table. 62 CIDRs, refreshed daily.
// salesforce_ips.sql

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

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

INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('13.108.0.0/15', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('13.110.0.0/16', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('13.111.0.0/16', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('64.132.88.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('64.132.89.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('64.132.92.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('66.203.114.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('66.203.115.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('66.231.80.0/20', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('68.232.192.0/20', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('85.222.128.0/19', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('96.43.144.0/20', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('101.53.160.0/19', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('104.161.128.0/18', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('104.161.232.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('104.161.233.0/24', 'IPv4');
INSERT INTO `salesforce_ips` (`ip_address`, `ip_type`) VALUES ('104.161.234.0/24', 'IPv4');
… (45 more lines)