also update wikipedia from linked places

[nominatim.git] / utils / update.php

diff --git a/utils/update.php b/utils/update.php
index ef7e3c9f25395ec7a0c114327f81261bdbbe9449..31c911ccccb85b737d26f88a07e5c9d9f1f23bef 100644 (file)
--- a/utils/update.php
+++ b/utils/update.php
@@ -328,6 +328,7 @@ if ($aResult['recompute-importance']) {
 
     $sSQL = 'ALTER TABLE placex DISABLE TRIGGER ALL;';
     $sSQL .= 'UPDATE placex SET (wikipedia, importance) = (SELECT wikipedia, importance FROM compute_importance(extratags, country_code, osm_type, osm_id));';
 
     $sSQL = 'ALTER TABLE placex DISABLE TRIGGER ALL;';
     $sSQL .= 'UPDATE placex SET (wikipedia, importance) = (SELECT wikipedia, importance FROM compute_importance(extratags, country_code, osm_type, osm_id));';

+    $sSQL .= 'UPDATE placex s SET wikipedia = d.wikipedia, importance = d.importance FROM placex d WHERE s.place_id = d.linked_place_id and d.wikipedia is not null and (s.wikipedia is null or s.importance < d.importance);';

     $sSQL .= 'ALTER TABLE placex ENABLE TRIGGER ALL;';
     $oDB->exec($sSQL);
 }
     $sSQL .= 'ALTER TABLE placex ENABLE TRIGGER ALL;';
     $oDB->exec($sSQL);
 }