plugins/geo/share/db/sql/geo_cities.sql.php

Summary

Maintainability
A
0 mins
Test Coverage
<?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`)
';