Changes between Version 78 and Version 79 of PATE Anguille

Timestamp:

Mar 26, 2012 3:15:20 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -172 +172 @@
 alter table rht.rhtvs2 drop column BV_PATE;
 alter table rht.rhtvs2 add column BV_PATE character varying(25);
-update rht.rhtvs2 set BV_PATE='Dronne' where id_drain in (select rht.upstream_segments(105792)) or id_drain='105505';  ---595 lines
+update rht.rhtvs2 set BV_PATE='Dronne' where id_drain in (select rht.upstream_segments(105792)) or id_drain='105792';  ---595 lines
 update rht.rhtvs2 set BV_PATE='Blavet' where id_drain in (select rht.upstream_segments(209549)) or id_drain='209549'; ---573 lines
 update rht.rhtvs2 set BV_PATE='Bresle' where id_drain in (select rht.upstream_segments(300002)) or id_drain='300002'; ---163 lines
@@ -180 +180 @@
 update rht.rhtvs2 set BV_PATE='Herault' where id_drain in (select rht.upstream_segments(22611)) or id_drain='22611'; ---603 lines
 update rht.rhtvs2 set BV_PATE='VilaineOust' where id_drain in (select rht.upstream_segments(212340)) or id_drain='212340'; ---2360 lines
-update rht.rhtvs2 set BV_PATE='Mayenne' where id_drain in (select rht.upstream_segments(213048)) or id_drain='214925'; ---1309 lines
+update rht.rhtvs2 set BV_PATE='Mayenne' where id_drain in (select rht.upstream_segments(213048)) or id_drain='213048'; ---1309 lines
 update rht.rhtvs2 set BV_PATE='Adour' where id_drain in (select rht.upstream_segments(118671)) or id_drain='118671'; ---3180 lines