Extension:GeoData/geo tags table

From MediaWiki.org
Jump to navigation Jump to search


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