--- trunk/network_topology/network_topology.sql	2005/02/16 12:21:09	7
+++ trunk/network_topology/network_topology.sql	2005/02/16 12:41:02	8
@@ -141,6 +141,27 @@
 comment on column vpn_list.to_location is 'To location';
 
 
+create view vpn_rep as        
+	select
+		fl.location_name as from_location,
+		fc.country_name as from_country,
+		vpn_local_gw,
+		tl.location_name as to_location,
+		tc.country_name as to_country,
+		vpn_remote_gw,
+		link_name,
+		vpn_comment
+	from vpn, location fl, location tl, link, country fc, country tc
+	where fl.location_id = vpn_from_location_id
+		and tl.location_id = vpn_to_location_id
+		and fl.location_country_id = fc.country_id
+		and tl.location_country_id = tc.country_id
+		and link_id = vpn_link ;
+
+comment on view vpn_rep is 'All VPN connections';
+comment on column vpn_rep.from_country is 'From country';
+comment on column vpn_rep.to_country is 'To country';
+
 -- location trust
 
 create table trust (
@@ -194,7 +215,7 @@
 
 
 -- hide this table
--- INSERT INTO meta_tables VALUES ('dns_type_combo', 'hide', 1);
+INSERT INTO meta_tables VALUES ('dns_type', 'hide', 1);
 
 -- DNS on location
 
