Changes between Version 11 and Version 12 of PATE Anguille

Timestamp:

Feb 1, 2012 6:21:21 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -43 +43 @@
 
 
-
 drop table if exists rht.rhtvs2_roe_pate_bv11axes;
 create table rht.rhtvs2_roe_pate_bv11axes as (
-select r.id_drain,t.dmer, module, module_icinf, module_icsup, minqmx, minqmxicinf, minqmxicsup, b.* from rht.rhtvs2_roev2 r     
-        join  rht.roe_pate_bv11axes b on r.id_roe=b.Id_ROE 
-        join rht.rhtvs2 t on t.id_drain=r.id_drain
-        join rht.attributs_rht_fev_2011_vs2 a on r.id_drain=a.id_drain);
+select  b.*, t.dmer, module, module_icinf, module_icsup, minqmx, minqmxicinf, minqmxicsup, cumnbbar, etatnom from rht.roe_pate_bv11axes b     
+        join roe_v2.pre_ice_v2 r on r.id_roe=b.id_roe
+        join rht.rhtvs2 t on t.id_drain=b.id_drain
+        join rht.attributs_rht_fev_2011_vs2 a on b.id_drain=a.id_drain);
+
+alter table rht.rhtvs2_roe_pate_bv11axes rename to rht.pate;
 }}}