Extension:GeoData/geo_tags table
Fields
[edit]gt_id
[edit]Primary key.
gt_page_id
[edit]gt_globe
[edit]gt_primary
[edit]gt_lat_int
[edit]gt_lon_int
[edit]gt_lat
[edit]gt_lon
[edit]gt_dim
[edit]gt_type
[edit]gt_name
[edit]gt_country
[edit]gt_region
[edit]Schema summary
[edit]mysql> describe geo_tags; +------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | gt_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | gt_page_id | int(10) unsigned | NO | MUL | NULL | | | gt_globe | varbinary(32) | NO | | NULL | | | gt_primary | tinyint(1) | NO | | NULL | | | gt_lat_int | smallint(6) | NO | MUL | NULL | | | gt_lon_int | smallint(6) | NO | | NULL | | | gt_lat | decimal(11,8) | NO | | NULL | | | gt_lon | decimal(11,8) | NO | | NULL | | | gt_dim | int(11) | YES | | NULL | | | gt_type | varbinary(32) | YES | | NULL | | | gt_name | varbinary(255) | YES | | NULL | | | gt_country | binary(2) | YES | | NULL | | | gt_region | varbinary(3) | YES | | NULL | | +------------+------------------+------+-----+---------+----------------+
