/[gedafe]/trunk/network_topology/data.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

Annotation of /trunk/network_topology/data.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 3 - (hide annotations)
Mon Feb 14 20:58:20 2005 UTC (15 years, 8 months ago) by dpavlin
File size: 6669 byte(s)
my own application about Network Topology

1 dpavlin 3 --
2     -- PostgreSQL database dump
3     --
4    
5     SET client_encoding = 'SQL_ASCII';
6     SET check_function_bodies = false;
7    
8     SET SESSION AUTHORIZATION 'flow';
9    
10     SET search_path = public, pg_catalog;
11    
12     --
13     -- Data for TOC entry 6 (OID 5757707)
14     -- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow
15     --
16    
17    
18    
19     --
20     -- Data for TOC entry 7 (OID 5757714)
21     -- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow
22     --
23    
24     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
25     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
26     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
27     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
28     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
29     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
30     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
31     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
32     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
33     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
34     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
35     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
36     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
37     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
38     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
39     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
40     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
41     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
42     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
43     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
44     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
45     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
46     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
47     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
48     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
49     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area');
50     INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area');
51    
52    
53     --
54     -- Data for TOC entry 8 (OID 5757721)
55     -- Name: link; Type: TABLE DATA; Schema: public; Owner: flow
56     --
57    
58     INSERT INTO link (link_id, link_name) VALUES (1, 'own wireless');
59     INSERT INTO link (link_id, link_name) VALUES (2, 'Telia');
60    
61    
62     --
63     -- Data for TOC entry 9 (OID 5757735)
64     -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow
65     --
66    
67     INSERT INTO "location" (location_id, location_name) VALUES (1, 'Zagreb - PBF');
68     INSERT INTO "location" (location_id, location_name) VALUES (2, 'Zagreb - Vukovarska');
69     INSERT INTO "location" (location_id, location_name) VALUES (3, 'Krakow');
70    
71    
72     --
73     -- Data for TOC entry 10 (OID 5757749)
74     -- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow
75     --
76    
77     INSERT INTO vpn (vpn_id, vpn_from_location_id, vpn_to_location_id, vpn_link, vpn_local_gw, vpn_remote_gw, vpn_comment) VALUES (2, 1, 2, 1, '10.100.0.30', '10.111.0.2', NULL);
78     INSERT INTO vpn (vpn_id, vpn_from_location_id, vpn_to_location_id, vpn_link, vpn_local_gw, vpn_remote_gw, vpn_comment) VALUES (5, 1, 3, 2, '192.168.27.3', '213.202.73.2', NULL);
79    
80    
81     --
82     -- Data for TOC entry 11 (OID 5757776)
83     -- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow
84     --
85    
86     INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (1, 1, 3, false, 'pliva.com');
87    
88    
89     --
90     -- Data for TOC entry 12 (OID 5757798)
91     -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow
92     --
93    
94     INSERT INTO dns (dns_on_location_id, dns_type, dns_domain) VALUES (1, 'p', 'pliva.hr');
95    
96    
97     --
98     -- TOC entry 2 (OID 5757719)
99     -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
100     --
101    
102     SELECT pg_catalog.setval('link_link_id_seq', 2, true);
103    
104    
105     --
106     -- TOC entry 3 (OID 5757733)
107     -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
108     --
109    
110     SELECT pg_catalog.setval('location_location_id_seq', 3, true);
111    
112    
113     --
114     -- TOC entry 4 (OID 5757747)
115     -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
116     --
117    
118     SELECT pg_catalog.setval('vpn_vpn_id_seq', 5, true);
119    
120    
121     --
122     -- TOC entry 5 (OID 5757774)
123     -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
124     --
125    
126     SELECT pg_catalog.setval('trust_trust_id_seq', 1, true);
127    
128    

  ViewVC Help
Powered by ViewVC 1.1.26