WebSVN – eFlore/Applications.coel – Path Comparison – / – /trunk/doc/ Rev 1712 and /trunk/doc/ Rev 1713

Compare Revisions

/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) ?';