CREATE TABLE `tbl_OperatorIPRanges` (
  `iSNo` int(11) NOT NULL AUTO_INCREMENT,
  `cOperatorName` char(20) NOT NULL,
  `cNetworkType` char(50) NOT NULL,
  `cCidr` char(20) NOT NULL,
  `cLowIp` char(20) NOT NULL,
  `cHighIp` char(20) NOT NULL,
  `cLowLongIp` char(100) DEFAULT NULL,
  `cHighLongIp` char(100) DEFAULT NULL,
  `iStatus` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`iSNo`)
) ENGINE=InnoDB;

insert into tbl_OperatorIPRanges values(null,'AIS','Mobile 3G2100 NAT Public IP - Mobile + WiFi','49.229.0.0/16','49.229.0.0','49.229.255.255','837091328','837156863',1);
insert into tbl_OperatorIPRanges values(null,'AIS','Mobile 3G2100 NAT Public IP - Mobile','49.230.0.0/16','49.230.0.0','49.230.255.255','837156864','837222399',1);
insert into tbl_OperatorIPRanges values(null,'AIS','Mobile 4G NAT Public IP - Mobile','182.232.0.0/16','182.232.0.0','18.232.255.255','3068657664','3068723199',1);
