// PLAY2GO / SQL
Play2Go · SQL

SQL inserts to load Play2Go CIDRs into a database table. 180 CIDRs, refreshed daily.
// play2go_ips.sql

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

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

INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.0.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.1.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.2.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.3.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.5.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.6.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.7.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.48.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.49.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.50.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.51.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.52.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.53.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.54.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.55.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.80.0/24', 'IPv4');
INSERT INTO `play2go_ips` (`ip_address`, `ip_type`) VALUES ('2.26.81.0/24', 'IPv4');
… (163 more lines)