Extension:GeoData/geo tags table


Fields

gt_id

Primary key.

gt_page_id

gt_globe

gt_primary

gt_lat_int

gt_lon_int

gt_lat

gt_lon

gt_dim

gt_type

gt_name

gt_country

gt_region

Schema summary

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    |                |
+------------+------------------+------+-----+---------+----------------+