plugins/geo/share/db/sql/geo_cities.sql.php
<?php
return '
`id` int(10) unsigned NOT NULL,
`country` char(2) NOT NULL,
`region_id` int(10) unsigned NOT NULL,
`name` varchar(32) NOT NULL,
`name_eng` varchar(32) NOT NULL,
`lat` float NOT NULL,
`lon` float NOT NULL,
`population` int(8) NOT NULL DEFAULT \'0\',
`active` enum(\'0\',\'1\') NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
KEY `idx_2` (`country`),
KEY `idx_3` (`region_id`)
';