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 ( |
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 |
|
|