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