Changes between Version 62 and Version 63 of Noeud - parcours RHT

Timestamp:

Feb 15, 2012 5:58:05 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -245 +245 @@
 create table rht.rhtvs2_roev2_nbdams as
 select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 as r group by id_drain;
-
+alter table rht.rhtvs2_roev2_nbdams add column height integer;
+alter table rht.rhtvs2_roev2_nbdams add column score integer;
+update rht.rhtvs2_roev2_nbdams set height=1;
+update rht.rhtvs2_roev2_nbdams set score=1;
 
 select * from roe_v2.roe_geo_v2 where idtrcart is null  ---2625 lignes   etanom validé