// DISCORD / SQL
Discord · SQL

SQL inserts to load Discord CIDRs into a database table. 20 CIDRs, refreshed daily.
// discord_ips.sql

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

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

INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.73.62.161/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.74.100.84/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.74.113.139/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.75.19.245/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.138.20.118/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.138.218.50/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.139.115.226/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('34.148.171.212/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.190.130.193/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.196.132.85/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.227.34.53/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.227.62.178/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.231.24.24/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.231.179.220/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.237.4.214/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.237.58.227/32', 'IPv4');
INSERT INTO `discord_ips` (`ip_address`, `ip_type`) VALUES ('35.237.169.55/32', 'IPv4');
… (3 more lines)