...
There is also another process to update the landmarks manually. To do that first we need to skim through the schema of landmarks table of Tulip database
| Code Block |
|---|
+----------------------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------------------+-------+
| nodeID | int(11) | | | 0 | |
| name | varchar(80) | | | | |
| hostName | varchar(80) | YES | | NULL | |
| ipv4Addr | varchar(15) | YES | | NULL | |
| domain | varchar(80) | YES | | NULL | |
| description | varchar(200) | YES | | NULL | |
| pingerNickname | varchar(50) | YES | | NULL | |
| pingerMonitor | tinyint(1) | YES | | NULL | |
| pingerBeacon | tinyint(1) | YES | | NULL | |
| notCheckedAtSlac | tinyint(1) | YES | | NULL | |
| enabled | tinyint(1) | YES | | 1 | |
| institution | varchar(100) | YES | | NULL | |
| city | varchar(100) | YES | | NULL | |
| state | varchar(100) | YES | | NULL | |
| country | varchar(100) | YES | | NULL | |
| continent | varchar(100) | YES | | NULL | |
| latitude | float | YES | | NULL | |
| longitude | float | YES | | NULL | |
| serviceInterfaceType | varchar(30) | YES | | NULL | |
| planetLabScript | varchar(120) | YES | | NULL | |
| pingURL | varchar(120) | YES | | NULL | |
| tracerouteURL | varchar(120) | YES | | NULL | |
| pingPacketSize | int(11) | YES | | NULL | |
| tulipScalingFactor | smallint(6) | YES | | NULL | |
| tulipTier | smallint(6) | YES | | NULL | |
| lastUpdateDate | timestamp | YES | | 0000-00-00 00:00:00 | |
| comments | text | YES | | NULL | |
+----------------------+--------------+------+-----+---------------------+-------+
|