Changes between Version 3 and Version 4 of Download and load RHT topology

Timestamp:

Oct 4, 2011 10:40:46 AM (14 years ago)

Author:

celine

Comment:

--

Download and load RHT topology

@@ -34 +34 @@
 #!sql
 Alter table rht.topologie_rht_sept2011 rename column Length to length;
-
 ALTER TABLE rht.topologie_rht_sept2011 RENAME COLUMN id_drain TO id_draintopo;
-CREATE VIEW rht.rht_topology AS select * from rht.rht r inner join rht.topologie_rht_sept2011 t on t.id_draintopo=r.id_drain;
 }}}
 
@@ -61 +59 @@
 {{{
 #!sql
-select * from rht.topologie_rht_sept2011 where tnode not in (select fnode from rht.topologie_rht_sept2011);
-create view rht.noeudmer as
-select * from rht.rht r left join rht.topologie_rht_sept2011 t on r.id_drain=t.id_draintopo;
+select * from rht.rht r left join rht.topologie_rht_sept2011 t on r.id_drain=t.id_draintopo where id_draintopo is null;    --- 1 lines
+
+drop table if exists rht.rht_topology;
+drop table if exists rht.noeudmer;
+CREATE table rht.rht_topology AS select * from rht.rht r inner join rht.topologie_rht_sept2011 t on t.id_draintopo=r.id_drain;
+create table rht.noeudmer as select * from rht.rht_topology where tnode not in (select fnode from rht.topologie_rht_sept2011);
+
+COMMENT ON table rht.rht_topology IS 'Joining between rht and topologie_rht_sept2011 to see it on Qgis';
+COMMENT ON table rht.noeudmer IS 'Table test to know the downstream node from the sea';
+
+
 }}}