Changes between Version 1 and Version 2 of PATE Anguille

Timestamp:

Jan 17, 2012 6:01:39 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -5 +5 @@
 }}}
 
+{{{
+alter table "ROE-BV" set schema rht
+alter table rht."ROE-BV" rename to roe_pate_bv11axes
+alter table rht.roe_pate_bv11axes rename column "Id_ROE" to Id_ROE
+
+select count(*) from rht.roe_pate_bv11axes limit 7
+
+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);
+}}}