/[gedafe]/trunk/network_topology/network_topology.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/network_topology/network_topology.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 7 by dpavlin, Wed Feb 16 12:21:09 2005 UTC revision 8 by dpavlin, Wed Feb 16 12:41:02 2005 UTC
# Line 141  comment on column vpn_list.from_location Line 141  comment on column vpn_list.from_location
141  comment on column vpn_list.to_location is 'To location';  comment on column vpn_list.to_location is 'To location';
142    
143    
144    create view vpn_rep as        
145            select
146                    fl.location_name as from_location,
147                    fc.country_name as from_country,
148                    vpn_local_gw,
149                    tl.location_name as to_location,
150                    tc.country_name as to_country,
151                    vpn_remote_gw,
152                    link_name,
153                    vpn_comment
154            from vpn, location fl, location tl, link, country fc, country tc
155            where fl.location_id = vpn_from_location_id
156                    and tl.location_id = vpn_to_location_id
157                    and fl.location_country_id = fc.country_id
158                    and tl.location_country_id = tc.country_id
159                    and link_id = vpn_link ;
160    
161    comment on view vpn_rep is 'All VPN connections';
162    comment on column vpn_rep.from_country is 'From country';
163    comment on column vpn_rep.to_country is 'To country';
164    
165  -- location trust  -- location trust
166    
167  create table trust (  create table trust (
# Line 194  create view dns_type_combo as Line 215  create view dns_type_combo as
215    
216    
217  -- hide this table  -- hide this table
218  -- INSERT INTO meta_tables VALUES ('dns_type_combo', 'hide', 1);  INSERT INTO meta_tables VALUES ('dns_type', 'hide', 1);
219    
220  -- DNS on location  -- DNS on location
221    

Legend:
Removed from v.7  
changed lines
  Added in v.8

  ViewVC Help
Powered by ViewVC 1.1.26