Subversion Repositories eFlore/Applications.cel

Compare Revisions

Ignore whitespace Rev 2753 → Rev 2754

/trunk/doc/bdd/2015-04_migration_lat_lon_sauvages/maj_lat_lon_sauvages.sql
New file
0,0 → 1,11
UPDATE cel_obs co
INNER JOIN cel_obs_etendues coe
ON coe.id_observation = co.id_observation
AND cle = 'latitudeDebutRue'
SET co.latitude = coe.valeur;
 
UPDATE cel_obs co
INNER JOIN cel_obs_etendues coe
ON coe.id_observation = co.id_observation
AND cle = 'longitudeDebutRue'
SET co.longitude = coe.valeur;