Changes between Version 82 and Version 83 of PATE Anguille

Timestamp:

Apr 13, 2012 6:09:21 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -682 +682 @@
 }}}
 
+Zone non colonisable et ouvrages non hydroélectrique
+{{{
+#!sql
+alter table rht.pate_mortalite add column colonisable boolean default TRUE;
+update rht.pate_mortalite set colonisable=pate.colonisable from rht.pate where pate_mortalite.id_roe=pate.id_roe;
+update rht.pate_mortalite set colonisable=true where id_roe='ROE29006'
+
+
+alter table rht.pate_mortalite add column pasusagehydroelectrique boolean default false;
+update rht.pate_mortalite set pasusagehydroelectrique='true' where id_roe in ('ROE53383','ROE67681','ROE40720','ROE40770','ROE41094','ROE41266','ROE41396','ROE42085','ROE41308','ROE30483','ROE33992','ROE45655','ROE11436','ROE8994','ROE34342','ROE50550','ROE42219','ROE43146','ROE43235','ROE43248','ROE43275','ROE50540','ROE50562','ROE52953','ROE50596','ROE52181','ROE52185','ROE52186','ROE51911','ROE51845','ROE11245','ROE51405','ROE13462','ROE65180','ROE50424','ROE50398','ROE50403','ROE30840');  --0
+alter table rht.pate_france add column pasusagehydroelectrique boolean default false;
+update rht.pate_france set pasusagehydroelectrique='true' where id_roe in ('ROE53383','ROE67681','ROE40720','ROE40770','ROE41094','ROE41266','ROE41396','ROE42085','ROE41308','ROE30483','ROE33992','ROE45655','ROE11436','ROE8994','ROE34342','ROE50550','ROE42219','ROE43146','ROE43235','ROE43248','ROE43275','ROE50540','ROE50562','ROE52953','ROE50596','ROE52181','ROE52185','ROE52186','ROE51911','ROE51845','ROE11245','ROE51405','ROE13462','ROE65180','ROE50424','ROE50398','ROE50403','ROE30840'); ---37
+alter table rht.pate add column pasusagehydroelectrique boolean default false;
+update rht.pate set pasusagehydroelectrique='true' where id_roe in ('ROE53383','ROE67681','ROE40720','ROE40770','ROE41094','ROE41266','ROE41396','ROE42085','ROE41308','ROE30483','ROE33992','ROE45655','ROE11436','ROE8994','ROE34342','ROE50550','ROE42219','ROE43146','ROE43235','ROE43248','ROE43275','ROE50540','ROE50562','ROE52953','ROE50596','ROE52181','ROE52185','ROE52186','ROE51911','ROE51845','ROE11245','ROE51405','ROE13462','ROE65180','ROE50424','ROE50398','ROE50403','ROE30840');  ---38
+}}}
+
 == Export table ==
 {{{