manuel/V03/Documentation-Utilisateurs/8.-Automatisations.md

@@ -176,8 +176,12 @@ Metodo :
 1. SQL ajout flow_accum_km2
 SQL
 
+```sql
 ALTER TABLE m060_milieux_continuite_tetes_de_bv.t_mnt_sc_sk_stream_4000 ADD COLUMN flow_accum_km2 numeric;
+UPDATE m060_milieux_continuite_tetes_de_bv.t_mnt_sc_sk_stream_4000 ADD COLUMN flow_accum_km2 numeric
+SET flow_accum_km2 =flow_accum*25./1000000. ;
 COMMENT ON COLUMN m060_milieux_continuite_tetes_de_bv.t_mnt_sc_sk_stream_4000.flow_accum_km2 IS 'champ additionnel flow_accum en km2 : flow_accum*25. / 1000 000.';
+```
 
    
    * wkb_geometry --nom de la colonne geom du réseau hydro theo