/[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 3 - (show annotations)
Mon Feb 14 20:58:20 2005 UTC (14 years, 8 months ago) by dpavlin
File size: 6669 byte(s)
my own application about Network Topology

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