/[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 11 - (hide annotations)
Wed Feb 16 14:53:37 2005 UTC (19 years, 1 month ago) by dpavlin
File size: 5323 byte(s)
small edits

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 dpavlin 11 -- Data for TOC entry 9 (OID 5763008)
14 dpavlin 3 -- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow
15     --
16    
17    
18    
19     --
20 dpavlin 11 -- Data for TOC entry 10 (OID 5763015)
21 dpavlin 3 -- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow
22     --
23    
24    
25    
26     --
27 dpavlin 11 -- Data for TOC entry 11 (OID 5763022)
28 dpavlin 3 -- 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 dpavlin 7 INSERT INTO link (link_id, link_name) VALUES (3, 'HT');
34     INSERT INTO link (link_id, link_name) VALUES (4, 'Iskon');
35 dpavlin 3
36    
37     --
38 dpavlin 11 -- Data for TOC entry 12 (OID 5763036)
39 dpavlin 7 -- 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 dpavlin 11 INSERT INTO country (country_id, country_name) VALUES (5, 'USA');
47 dpavlin 7
48    
49     --
50 dpavlin 11 -- Data for TOC entry 13 (OID 5763049)
51 dpavlin 3 -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow
52     --
53    
54 dpavlin 7 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (2, 'Zagreb - Vukovarska', 1, NULL);
55     INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (1, 'Zagreb - PBF', 1, NULL);
56     INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (4, 'Brno', 3, NULL);
57     INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (3, 'Krakow', 2, NULL);
58     INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (5, 'Ljubljana', 4, NULL);
59 dpavlin 11 INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (6, 'New Jersey', 5, NULL);
60 dpavlin 3
61    
62     --
63 dpavlin 11 -- Data for TOC entry 14 (OID 5763071)
64 dpavlin 3 -- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow
65     --
66    
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 (2, 1, 2, 1, '10.100.0.30', '10.111.0.2', 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 (5, 1, 3, 2, '192.168.27.3', '213.202.73.2', NULL);
69 dpavlin 7 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);
70 dpavlin 11 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, 4, 4, '192.168.27.3', '213.202.73.10', NULL);
71     INSERT INTO vpn (vpn_id, vpn_from_location_id, vpn_to_location_id, vpn_link, vpn_local_gw, vpn_remote_gw, vpn_comment) VALUES (10, 1, 6, 3, '127.0.0.10', '127.0.0.11', NULL);
72 dpavlin 3
73    
74     --
75 dpavlin 11 -- Data for TOC entry 15 (OID 5763101)
76 dpavlin 3 -- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow
77     --
78    
79     INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (1, 1, 3, false, 'pliva.com');
80 dpavlin 7 INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (2, 1, 2, true, NULL);
81 dpavlin 3
82    
83     --
84 dpavlin 11 -- Data for TOC entry 16 (OID 5763125)
85 dpavlin 7 -- Name: dns_type; Type: TABLE DATA; Schema: public; Owner: flow
86     --
87    
88     INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (1, 'primary');
89     INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (2, 'secondary');
90     INSERT INTO dns_type (dns_type_id, dns_type_name) VALUES (3, 'forwarder');
91    
92    
93     --
94 dpavlin 11 -- Data for TOC entry 17 (OID 5763142)
95 dpavlin 3 -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow
96     --
97    
98 dpavlin 7 INSERT INTO dns (dns_id, dns_on_location_id, dns_type, dns_domain) VALUES (1, 1, 1, 'pliva.hr');
99     INSERT INTO dns (dns_id, dns_on_location_id, dns_type, dns_domain) VALUES (2, 1, 2, 'pliva.pl');
100 dpavlin 3
101    
102     --
103 dpavlin 11 -- TOC entry 2 (OID 5763020)
104 dpavlin 3 -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
105     --
106    
107 dpavlin 7 SELECT pg_catalog.setval('link_link_id_seq', 4, true);
108 dpavlin 3
109    
110     --
111 dpavlin 11 -- TOC entry 3 (OID 5763034)
112 dpavlin 7 -- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
113     --
114    
115 dpavlin 11 SELECT pg_catalog.setval('country_country_id_seq', 5, true);
116 dpavlin 7
117    
118     --
119 dpavlin 11 -- TOC entry 4 (OID 5763047)
120 dpavlin 3 -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
121     --
122    
123 dpavlin 11 SELECT pg_catalog.setval('location_location_id_seq', 8, true);
124 dpavlin 3
125    
126     --
127 dpavlin 11 -- TOC entry 5 (OID 5763069)
128 dpavlin 3 -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
129     --
130    
131 dpavlin 11 SELECT pg_catalog.setval('vpn_vpn_id_seq', 10, true);
132 dpavlin 3
133    
134     --
135 dpavlin 11 -- TOC entry 6 (OID 5763099)
136 dpavlin 3 -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
137     --
138    
139 dpavlin 7 SELECT pg_catalog.setval('trust_trust_id_seq', 2, true);
140 dpavlin 3
141    
142 dpavlin 7 --
143 dpavlin 11 -- TOC entry 7 (OID 5763123)
144 dpavlin 7 -- Name: dns_type_dns_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
145     --
146    
147     SELECT pg_catalog.setval('dns_type_dns_type_id_seq', 1, false);
148    
149    
150     --
151 dpavlin 11 -- TOC entry 8 (OID 5763140)
152 dpavlin 7 -- Name: dns_dns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
153     --
154    
155     SELECT pg_catalog.setval('dns_dns_id_seq', 2, true);
156    
157    

  ViewVC Help
Powered by ViewVC 1.1.26