-- SQL script to create table `circleci_ips` and insert IP addresses

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

INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('100.27.248.128/25', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('100.29.139.128/25', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('98.80.165.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.41.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.42.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.43.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('207.254.116.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('207.254.118.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.97.4.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.97.6.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.97.7.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.48.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.49.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.50.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.51.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('38.23.52.0/24', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.161.182.76/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('34.197.6.234/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('34.194.144.202/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.3.128.216/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.164.161.41/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('35.174.253.146/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.172.26.132/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.21.153.129/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.166.105.113/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.208.72.234/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.5.58.121/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.72.72.233/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.167.72.230/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.209.115.53/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('35.169.17.173/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('3.228.39.90/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.92.235.88/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.205.138.102/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.213.67.41/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.4.195.249/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('34.194.94.201/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('54.236.156.101/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('34.197.216.176/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.206.105.184/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('3.210.128.175/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.20.166.242/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('35.174.249.131/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.22.215.219/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('52.6.77.249/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.214.70.5/32', 'IPv4');
INSERT INTO `circleci_ips` (`ip_address`, `ip_type`) VALUES ('18.214.156.84/32', 'IPv4');