Changes between Version 68 and Version 69 of PATE Anguille

Timestamp:

Mar 8, 2012 5:11:32 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -595 +595 @@
 }}}
 
+{{{
+alter table rht.pate_mortalite add column id_drain integer;
+update rht.pate_mortalite set id_drain=sub.id_drain from (select id_drain, id_roe from rht.pate) as sub where pate_mortalite.id_roe=sub.id_roe;
+
+alter table rht.pate_mortalite add column id_drain integer;
+update rht.pate_mortalite set id_drain=sub.id_drain from (select id_drain, id_roe from rht.pate) as sub where pate_mortalite.id_roe=sub.id_roe;
+update rht.pate_mortalite set id_drain='116909' where id_roe='ROE4907';
+update rht.pate_mortalite set id_drain='121003' where id_roe='ROE22958';
+insert into rht.pate(id_roe) values ('ROE4907'),('ROE22958');
+
+update rht.pate_mortalite set dmer=sub.dmer/1000 from (select id_drain, dmer from rht.rhtvs2) as sub where pate_mortalite.id_drain=sub.id_drain;
+update rht.pate_mortalite set module=sub.module from (select id_drain, module from rht.attributs_rht_fev_2011_vs2) as sub where pate_mortalite.id_drain=sub.id_drain;
+
+alter table rht.pate_mortalite add column mortalite numeric;
+}}}
+
+
 == Export table ==
 {{{