| 60,6 → 60,8 |
|---|
| `date_creation` DATETIME NOT NULL, |
| `date_modification` DATETIME NOT NULL, |
| `date_transmission` DATETIME NOT NULL COMMENT 'Date à laquelle l\'observation a été rendu publique.', |
| `certitude` VARCHAR(255) NOT NULL, |
| `pays` VARCHAR(2) NOT NULL, |
| PRIMARY KEY (`id_observation`)) |
| ENGINE = MyISAM |
| DEFAULT CHARACTER SET = utf8 |
| 268,7 → 270,7 |
|---|
| nom_sel, nom_sel_nn, nom_ret, nom_ret_nn, nt, famille, |
| ce_zone_geo, zone_geo, lieudit, station, milieu, nom_referentiel, |
| date_observation, o.mots_cles_texte, o.commentaire, |
| o.date_creation, o.date_modification, o.date_transmission, certitude |
| o.date_creation, o.date_modification, o.date_transmission, certitude, pays |
| FROM tb_cel.cel_obs AS o WHERE o.id_observation IN (SELECT i.ce_observation FROM tb_cel.cel_images i) |
| AND o.transmission = '1'; |
| |