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

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

INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.224.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('1.201.225.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('103.240.48.0/22', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.79.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.87.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.93.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.95.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.112.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.113.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.114.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.115.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.116.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.117.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.118.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.119.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.121.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.122.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.124.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.126.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.127.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.129.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.131.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.132.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.133.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.134.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.144.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.145.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.146.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.147.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.177.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.178.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.179.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.182.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.192.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.193.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.195.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.196.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('121.78.197.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.0.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.1.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.2.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.3.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.4.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.5.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.6.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.7.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.10.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.11.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.12.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.13.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.14.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.15.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.16.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.17.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.18.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.19.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.20.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.21.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.22.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.23.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.24.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.25.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.26.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.27.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.29.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.31.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('180.131.32.0/19', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.192.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.196.0/22', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.200.0/22', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.205.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.206.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.212.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.213.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.219.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.220.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.221.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.222.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.223.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.224.0/21', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.232.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.233.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.234.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.236.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.237.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.238.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.239.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('183.86.240.0/20', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('202.90.252.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('202.90.253.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('202.90.254.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('202.90.255.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('211.201.198.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('211.244.211.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('219.241.221.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('222.236.220.0/24', 'IPv4');
INSERT INTO `gabia_ips` (`ip_address`, `ip_type`) VALUES ('222.236.221.0/24', 'IPv4');