| /trunk/scripts/modules/ifn/Ifn.php |
|---|
| 94,7 → 94,7 |
| } |
| private function creerVueTapir() { |
| $requete = "DROP VIEW ifn_tapir; CREATE VIEW ifn_tapir AS ". |
| $requete = "DROP VIEW IF EXISTS ifn_tapir; CREATE VIEW ifn_tapir AS ". |
| "SELECT f.idp as observation_id, b.nom_sci as nom_scientifique_complet, b.num_nom, ". |
| " fo.lieu_commune_code_insee, fo.lieu_station_latitude, fo.lieu_station_longitude,". |
| " 'WGS84' AS geodeticDatum, e.dateeco as observation_date, '' AS observateur_nom_complet". |