10 |
SET search_path = public, pg_catalog; |
SET search_path = public, pg_catalog; |
11 |
|
|
12 |
-- |
-- |
13 |
-- Data for TOC entry 6 (OID 5757707) |
-- Data for TOC entry 9 (OID 5763008) |
14 |
-- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow |
-- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow |
15 |
-- |
-- |
16 |
|
|
17 |
|
|
18 |
|
|
19 |
-- |
-- |
20 |
-- Data for TOC entry 7 (OID 5757714) |
-- Data for TOC entry 10 (OID 5763015) |
21 |
-- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow |
-- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow |
22 |
-- |
-- |
23 |
|
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('trust', 'comment', 'widget', 'area'); |
|
|
INSERT INTO meta_fields (meta_fields_table, meta_fields_field, meta_fields_attribute, meta_fields_value) VALUES ('vpn', 'comment', 'widget', 'area'); |
|
24 |
|
|
25 |
|
|
26 |
-- |
-- |
27 |
-- Data for TOC entry 8 (OID 5757721) |
-- Data for TOC entry 11 (OID 5763022) |
28 |
-- Name: link; Type: TABLE DATA; Schema: public; Owner: flow |
-- Name: link; Type: TABLE DATA; Schema: public; Owner: flow |
29 |
-- |
-- |
30 |
|
|
31 |
INSERT INTO link (link_id, link_name) VALUES (1, 'own wireless'); |
INSERT INTO link (link_id, link_name) VALUES (1, 'own wireless'); |
32 |
INSERT INTO link (link_id, link_name) VALUES (2, 'Telia'); |
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 9 (OID 5757735) |
-- Data for TOC entry 12 (OID 5763036) |
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 |
|
INSERT INTO country (country_id, country_name) VALUES (5, 'USA'); |
47 |
|
|
48 |
|
|
49 |
|
-- |
50 |
|
-- Data for TOC entry 13 (OID 5763049) |
51 |
-- Name: location; Type: TABLE DATA; Schema: public; Owner: flow |
-- Name: location; Type: TABLE DATA; Schema: public; Owner: flow |
52 |
-- |
-- |
53 |
|
|
54 |
INSERT INTO "location" (location_id, location_name) VALUES (1, 'Zagreb - PBF'); |
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) VALUES (2, 'Zagreb - Vukovarska'); |
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) VALUES (3, 'Krakow'); |
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 |
|
INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (6, 'New Jersey', 5, NULL); |
60 |
|
|
61 |
|
|
62 |
-- |
-- |
63 |
-- Data for TOC entry 10 (OID 5757749) |
-- Data for TOC entry 14 (OID 5763071) |
64 |
-- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow |
-- 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); |
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); |
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 |
|
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 |
|
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 |
|
|
73 |
|
|
74 |
-- |
-- |
75 |
-- Data for TOC entry 11 (OID 5757776) |
-- Data for TOC entry 15 (OID 5763101) |
76 |
-- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow |
-- 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'); |
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 |
|
INSERT INTO trust (trust_id, trust_from_location_id, trust_to_location_id, trust_mutual, trust_comment) VALUES (2, 1, 2, true, NULL); |
81 |
|
|
82 |
|
|
83 |
-- |
-- |
84 |
-- Data for TOC entry 12 (OID 5757798) |
-- Data for TOC entry 16 (OID 5763125) |
85 |
|
-- 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 |
|
-- Data for TOC entry 17 (OID 5763142) |
95 |
-- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow |
-- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow |
96 |
-- |
-- |
97 |
|
|
98 |
INSERT INTO dns (dns_on_location_id, dns_type, dns_domain) VALUES (1, 'p', 'pliva.hr'); |
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 |
|
|
101 |
|
|
102 |
-- |
-- |
103 |
-- TOC entry 2 (OID 5757719) |
-- TOC entry 2 (OID 5763020) |
104 |
-- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
-- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
105 |
-- |
-- |
106 |
|
|
107 |
SELECT pg_catalog.setval('link_link_id_seq', 2, true); |
SELECT pg_catalog.setval('link_link_id_seq', 4, true); |
108 |
|
|
109 |
|
|
110 |
-- |
-- |
111 |
-- TOC entry 3 (OID 5757733) |
-- TOC entry 3 (OID 5763034) |
112 |
|
-- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
113 |
|
-- |
114 |
|
|
115 |
|
SELECT pg_catalog.setval('country_country_id_seq', 5, true); |
116 |
|
|
117 |
|
|
118 |
|
-- |
119 |
|
-- TOC entry 4 (OID 5763047) |
120 |
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
121 |
-- |
-- |
122 |
|
|
123 |
SELECT pg_catalog.setval('location_location_id_seq', 3, true); |
SELECT pg_catalog.setval('location_location_id_seq', 8, true); |
124 |
|
|
125 |
|
|
126 |
-- |
-- |
127 |
-- TOC entry 4 (OID 5757747) |
-- TOC entry 5 (OID 5763069) |
128 |
-- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
-- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
129 |
-- |
-- |
130 |
|
|
131 |
SELECT pg_catalog.setval('vpn_vpn_id_seq', 5, true); |
SELECT pg_catalog.setval('vpn_vpn_id_seq', 10, true); |
132 |
|
|
133 |
|
|
134 |
-- |
-- |
135 |
-- TOC entry 5 (OID 5757774) |
-- TOC entry 6 (OID 5763099) |
136 |
-- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
-- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow |
137 |
-- |
-- |
138 |
|
|
139 |
SELECT pg_catalog.setval('trust_trust_id_seq', 1, true); |
SELECT pg_catalog.setval('trust_trust_id_seq', 2, true); |
140 |
|
|
141 |
|
|
142 |
|
-- |
143 |
|
-- TOC entry 7 (OID 5763123) |
144 |
|
-- 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 |
|
-- TOC entry 8 (OID 5763140) |
152 |
|
-- 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 |
|
|