<?php
$queries = array();
$queries[]="CREATE TABLE IF NOT EXISTS %%TABLEPREFIX%%geostats (
  `IP_FROM` double NOT NULL,
  `IP_TO` double NOT NULL,
  `COUNTRY_CODE` char(2) NOT NULL,
  `COUNTRY_NAME` varchar(64) NOT NULL,
  `REGION` varchar(128) NOT NULL,
  `CITY` varchar(128) NOT NULL
)";
$queries[]="CREATE TABLE IF NOT EXISTS %%TABLEPREFIX%%geostats_cache (
  `IP_FROM` double NOT NULL,
  `IP_TO` double NOT NULL,
  `COUNTRY_CODE` char(2) NOT NULL,
  `COUNTRY_NAME` varchar(64) NOT NULL,
  `REGION` varchar(128) NOT NULL,
  `CITY` varchar(128) NOT NULL
)";
$queries[]="CREATE TABLE IF NOT EXISTS %%TABLEPREFIX%%geostats_cache_stats (
  `uid` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL,
  `data` longtext NOT NULL,
  `query` varchar(255) NOT NULL,
  `updated` varchar(255) NOT NULL,
  PRIMARY KEY  (`uid`)
)";