| /trunk/doc/bdd/coel.mwb |
|---|
| Cannot display: file marked as a binary type. |
| svn:mime-type = application/octet-stream |
| /trunk/doc/bdd/maj_v1.2.0.sql |
|---|
| New file |
| 0,0 → 1,6 |
| UPDATE coel_structure SET cs_longitude = REPLACE(cs_longitude, ",", "."), cs_latitude = REPLACE(cs_latitude, ",", "."); |
| ALTER TABLE coel_structure MODIFY cs_longitude DOUBLE(12,9) NULL DEFAULT NULL; |
| ALTER TABLE coel_structure MODIFY cs_latitude DOUBLE(12,9) NULL DEFAULT NULL; |
| UPDATE coel_structure SET cs_latitude = NULL, cs_longitude = NULL WHERE cs_latitude = "0" AND cs_longitude = "0"; |
| UPDATE coel_structure SET cs_nbre_personne = NULL WHERE cs_nbre_personne = 0; |
| ALTER TABLE coel_structure_conservation MODIFY csc_mark_collection_commune TINYINT(1) NULL COMMENT 'Les collections botaniques sont-elles conservées avec d\'autres collections dans les mêmes locaux (problèe de conservation en commun) ?'; |
| /trunk/jrest/services/CoelStructure.php |
|---|
| 13,7 → 13,7 |
| static $optional_bool_fields = array( |
| 'cs_nbre_personne', |
| 'csc_mark_formation', 'csc_mark_formation_interet', |
| /*'csc_mark_collection_commune',*/ 'csc_mark_acces_controle', 'csc_mark_restauration', 'csc_mark_traitement', |
| 'csc_mark_collection_commune', 'csc_mark_acces_controle', 'csc_mark_restauration', 'csc_mark_traitement', |
| 'csc_mark_acquisition_collection', 'csc_mark_acquisition_echantillon', |
| 'cs_latitude', 'cs_longitude', |
| ); |
| /trunk/scripts/modules/201310-bulk-coord-update.php |
|---|
| 41,12 → 41,6 |
| printf("cache already contains %d entries, will start in 4 seconds:\n", count($cache)); |
| sleep(4); |
| // correction |
| $db->query('UPDATE coel_structure SET cs_longitude = REPLACE(cs_longitude, ",", "."), cs_latitude = REPLACE(cs_latitude, ",", ".")'); |
| $db->query('ALTER TABLE coel_structure MODIFY cs_longitude DOUBLE(12,9) NULL DEFAULT NULL'); |
| $db->query('ALTER TABLE coel_structure MODIFY cs_latitude DOUBLE(12,9) NULL DEFAULT NULL'); |
| $db->query('UPDATE coel_structure SET cs_latitude = NULL, cs_longitude = NULL WHERE cs_latitude = "0" AND cs_longitude = "0"'); |
| $db->query('UPDATE coel_structure SET cs_nbre_personne = NULL WHERE cs_nbre_personne = 0'); |
| // smooth: |
| $q = "SELECT * FROM coel_structure". |
| " WHERE cs_latitude IS NULL OR cs_latitude = '' OR cs_longitude IS NULL". |