gistfile1.txt

+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| id        | int(11)     | YES  | UNI | NULL    |       |
| code      | char(2)     | NO   | PRI | NULL    |       |
| code3     | char(3)     | YES  |     | NULL    |       |
| numcode   | smallint(6) | YES  |     | NULL    |       |
| url       | varchar(50) | NO   | MUL | NULL    |       |
| name      | varchar(50) | NO   | UNI | NULL    |       |
| latitude  | double      | NO   |     | NULL    |       |
| longitude | double      | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+