Atlassian · SQL

SQL inserts to load Atlassian CIDRs into a database table. 254 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 ('52.82.172.0/22', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('76.223.144.220/31', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('76.223.147.128/25', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('76.223.176.0/20', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('167.89.0.0/17', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('168.245.0.0/17', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('104.192.136.0/21', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('185.166.140.0/22', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('2401:1d80:3000::/36', 'IPv6');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('34.218.156.209/32', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('34.218.168.212/32', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('52.41.219.63/32', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('185.166.140.128/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('43.202.69.112/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 ('104.192.137.224/28', 'IPv4');
INSERT INTO `atlassian_ips` (`ip_address`, `ip_type`) VALUES ('104.192.143.224/28', 'IPv4');
… (237 more lines)