Changes between Version 50 and Version 51 of PATE Anguille

Timestamp:

Feb 15, 2012 5:32:17 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -394 +394 @@
 #!sql
 id_roe in ('ROE42025','ROE20586','ROE46202','ROE45125','ROE6785','ROE43996')
-update rht.rht_roev2 set id_drain=103936 where id_roe='ROE42025';
-update rht.rht_roev2 set id_drain=207306 where id_roe='ROE20586';
-update rht.rht_roev2 set id_drain=122291 where id_roe='ROE46202';
-update rht.rht_roev2 set id_drain=120931 where id_roe='ROE45125';
-update rht.rht_roev2 set id_drain=121592 where id_roe='ROE6785';
-update rht.rht_roev2 set id_drain=121530 where id_roe='ROE43996';
-update rht.rht_roev2 set id_drain=20602 where id_roe='ROE42134';
-update rht.rht_roev2 set id_drain=306907 where id_roe='ROE7104';
-update rht.rht_roev2 set id_drain=201665 where id_roe='ROE11608';
-
-drop table if exists rht.rhvs2_roev2_nbdams;
+update rht.rhtvs2_roev2 set id_drain=103936 where id_roe='ROE42025';
+update rht.rhtvs2_roev2 set id_drain=207306 where id_roe='ROE20586';
+update rht.rhtvs2_roev2 set id_drain=122291 where id_roe='ROE46202';
+update rht.rhtvs2_roev2 set id_drain=120931 where id_roe='ROE45125';
+update rht.rhtvs2_roev2 set id_drain=121592 where id_roe='ROE6785';
+update rht.rhtvs2_roev2 set id_drain=121530 where id_roe='ROE43996';
+update rht.rhtvs2_roev2 set id_drain=20602 where id_roe='ROE42134';
+update rht.rhtvs2_roev2 set id_drain=306907 where id_roe='ROE7104';
+update rht.rhtvs2_roev2 set id_drain=201665 where id_roe='ROE11608';
+
+drop table if exists rht.rhtvs2_roev2_nbdams;
 create table rht.rhtvs2_roev2_nbdams as
 select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 as r group by id_drain;
 
+A FINIR !
 -- mise à jour des données dans rhtvs2
 update rht.rhtvs2 set (dmer, cumnbbar)=(sub.dmer, sub.cumnbbar)