/[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

Contents of /trunk/network_topology/data.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 8 - (show annotations)
Wed Feb 16 12:41:02 2005 UTC (19 years, 1 month ago) by dpavlin
File size: 4954 byte(s)
first report

1 --
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 9 (OID 5762650)
14 -- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow
15 --
16
17
18
19 --
20 -- Data for TOC entry 10 (OID 5762657)
21 -- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow
22 --
23
24
25
26 --
27 -- Data for TOC entry 11 (OID 5762664)
28 -- Name: link; Type: TABLE DATA; Schema: public; Owner: flow
29 --
30
31 INSERT INTO link (link_id, link_name) VALUES (1, 'own wireless');
32 INSERT INTO link (link_id, link_name) VALUES (2, 'Telia');
33 INSERT INTO link (link_id, link_name) VALUES (3, 'HT');
34 INSERT INTO link (link_id, link_name) VALUES (4, 'Iskon');
35
36
37 --
38 -- Data for TOC entry 12 (OID 5762678)
39 -- Name: country; Type: TABLE DATA; Schema: public; Owner: flow
40 --
41
42 INSERT INTO country (country_id, country_name) VALUES (1, 'Croatia');
43 INSERT INTO country (country_id, country_name) VALUES (2, 'Poland');
44 INSERT INTO country (country_id, country_name) VALUES (3, 'Czeck');
45 INSERT INTO country (country_id, country_name) VALUES (4, 'Slovenia');
46
47
48 --
49 -- Data for TOC entry 13 (OID 5762691)
50 -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow
51 --
52
53 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (2, 'Zagreb - Vukovarska', 1, NULL);
54 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (1, 'Zagreb - PBF', 1, NULL);
55 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (4, 'Brno', 3, NULL);
56 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (3, 'Krakow', 2, NULL);
57 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (5, 'Ljubljana', 4, NULL);
58
59
60 --
61 -- Data for TOC entry 14 (OID 5762713)
62 -- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow
63 --
64
65 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);
66 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);
67 INSERT INTO vpn (vpn_id, vpn_from_location_id, vpn_to_location_id, vpn_link, vpn_local_gw, vpn_remote_gw, vpn_comment) VALUES (6, 1, 5, 4, '195.29.208.1', '193.189.171.177', NULL);
68 INSERT INTO vpn (vpn_id, vpn_from_location_id, vpn_to_location_id, vpn_link, vpn_local_gw, vpn_remote_gw, vpn_comment) VALUES (7, 1, 3, 4, '192.168.27.3', '213.202.73.2', NULL);
69
70
71 --
72 -- Data for TOC entry 15 (OID 5762743)
73 -- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow
74 --
75
76 INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (1, 1, 3, false, 'pliva.com');
77 INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (2, 1, 2, true, NULL);
78
79
80 --
81 -- Data for TOC entry 16 (OID 5762767)
82 -- Name: dns_type; Type: TABLE DATA; Schema: public; Owner: flow
83 --
84
85 INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (1, 'primary');
86 INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (2, 'secondary');
87 INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (3, 'forwarder');
88
89
90 --
91 -- Data for TOC entry 17 (OID 5762784)
92 -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow
93 --
94
95 INSERT INTO dns (dns_id, dns_on_location_id, dns_type, dns_domain) VALUES (1, 1, 1, 'pliva.hr');
96 INSERT INTO dns (dns_id, dns_on_location_id, dns_type, dns_domain) VALUES (2, 1, 2, 'pliva.pl');
97
98
99 --
100 -- TOC entry 2 (OID 5762662)
101 -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
102 --
103
104 SELECT pg_catalog.setval('link_link_id_seq', 4, true);
105
106
107 --
108 -- TOC entry 3 (OID 5762676)
109 -- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
110 --
111
112 SELECT pg_catalog.setval('country_country_id_seq', 4, true);
113
114
115 --
116 -- TOC entry 4 (OID 5762689)
117 -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
118 --
119
120 SELECT pg_catalog.setval('location_location_id_seq', 5, true);
121
122
123 --
124 -- TOC entry 5 (OID 5762711)
125 -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
126 --
127
128 SELECT pg_catalog.setval('vpn_vpn_id_seq', 7, true);
129
130
131 --
132 -- TOC entry 6 (OID 5762741)
133 -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
134 --
135
136 SELECT pg_catalog.setval('trust_trust_id_seq', 2, true);
137
138
139 --
140 -- TOC entry 7 (OID 5762765)
141 -- Name: dns_type_dns_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
142 --
143
144 SELECT pg_catalog.setval('dns_type_dns_type_id_seq', 1, false);
145
146
147 --
148 -- TOC entry 8 (OID 5762782)
149 -- Name: dns_dns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
150 --
151
152 SELECT pg_catalog.setval('dns_dns_id_seq', 2, true);
153
154

  ViewVC Help
Powered by ViewVC 1.1.26