Atlassian · SQL

SQL inserts to load Atlassian CIDRs into a database table. 166 CIDRs, refreshed daily.
// atlassian_ips.sql

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

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

INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('3.216.235.48/32', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('3.221.151.112/32', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.35.248.0/24', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.52.5.96/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.200.41.128/25', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.200.41.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.200.41.240/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.227.180.0/24', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.227.213.0/24', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('13.236.8.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('16.63.53.128/25', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('16.63.53.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('16.63.53.240/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('18.136.214.96/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('18.184.99.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('18.234.32.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('18.246.31.208/28', 'IPv4');
… (149 more lines)