CREATE TABLE ip4_120 ( b tinyint(3) unsigned NOT NULL default '0', c tinyint(3) unsigned NOT NULL default '0', country smallint(5) unsigned NOT NULL default '0', city smallint(5) unsigned NOT NULL default '0', cron datetime NOT NULL default '0000-00-00 00:00:00', KEY kCountry (country), KEY kCity (city), KEY kb (b), KEY kc (c), KEY kcron (cron) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table ip4_120 -- /*!40000 ALTER TABLE ip4_120 DISABLE KEYS */; LOCK TABLES ip4_120 WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE ip4_120 ENABLE KEYS */; -- -- Table structure for table ip4_21 -- DROP TABLE IF EXISTS ip4_21; CREATE TABLE ip4_21 ( b tinyint(3) unsigned NOT NULL default '0', c tinyint(3) unsigned NOT NULL default '0', country smallint(5) unsigned NOT NULL default '0', city smallint(5) unsigned NOT NULL default '0', cron datetime NOT NULL default '0000-00-00 00:00:00', KEY kCountry (country), KEY kCity (city), KEY kb (b), KEY kc (c), KEY kcron (cron) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table ip4_21 -- /*!40000 ALTER TABLE ip4_21 DISABLE KEYS */; LOCK TABLES ip4_21 WRITE; CREATE TABLE ip4_71 ( b tinyint(3) unsigned NOT NULL default '0', c tinyint(3) unsigned NOT NULL default '0', country smallint(5) unsigned NOT NULL default '0', city smallint(5) unsigned NOT NULL default '0', cron datetime NOT NULL default '0000-00-00 00:00:00', KEY kCountry (country), KEY kCity (city), KEY kb (b), KEY kc (c), KEY kcron (cron) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table ip4_71 -- /*!40000 ALTER TABLE ip4_71 DISABLE KEYS */; LOCK TABLES ip4_71 WRITE; CREATE TABLE ip4_105 ( b tinyint(3) unsigned NOT NULL default '0', c tinyint(3) unsigned NOT NULL default '0', country smallint(5) unsigned NOT NULL default '0', city smallint(5) unsigned NOT NULL default '0', cron datetime NOT NULL default '0000-00-00 00:00:00', KEY kCountry (country), KEY kCity (city), KEY kb (b), KEY kc (c), KEY kcron (cron) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table ip4_105 -- /*!40000 ALTER TABLE ip4_105 DISABLE KEYS */; LOCK TABLES ip4_105 WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE ip4_105 ENABLE KEYS */; -- -- Table structure for table ip4_58 -- DROP TABLE IF EXISTS ip4_58; CREATE TABLE ip4_58 ( b tinyint(3) unsigned NOT NULL default '0', c tinyint(3) unsigned NOT NULL default '0', country smallint(5) unsigned NOT NULL default '0', city smallint(5) unsigned NOT NULL default '0', cron datetime NOT NULL default '0000-00-00 00:00:00', KEY kCountry (country), KEY kCity (city), KEY kb (b), KEY kc (c), KEY kcron (cron) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;