Meta (Facebook) · SQL

SQL inserts to load Meta (Facebook) CIDRs into a database table. 769 CIDRs, refreshed daily.
// meta_ips.sql

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

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

INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.24.0/21', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.64.0/18', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.64.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.66.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.69.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.71.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.72.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.73.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.76.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.80.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.82.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.83.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.84.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.86.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.87.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.89.0/24', 'IPv4');
INSERT INTO `meta_ips` (`ip_address`, `ip_type`) VALUES ('31.13.91.0/24', 'IPv4');
… (752 more lines)