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

Diff of /trunk/network_topology/data.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 6 by dpavlin, Mon Feb 14 20:58:20 2005 UTC revision 7 by dpavlin, Wed Feb 16 12:21:09 2005 UTC
# Line 10  SET SESSION AUTHORIZATION 'flow'; Line 10  SET SESSION AUTHORIZATION 'flow';
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 5762127)
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 5762134)
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 5762141)
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 5762155)
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 5762168)
50  -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow  -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow
51  --  --
52    
53  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);
54  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);
55  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);
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 10 (OID 5757749)  -- Data for TOC entry 14 (OID 5762190)
62  -- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow  -- 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);  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);  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 11 (OID 5757776)  -- Data for TOC entry 15 (OID 5762217)
73  -- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow  -- 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');  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 12 (OID 5757798)  -- Data for TOC entry 16 (OID 5762241)
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 5762257)
92  -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow  -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow
93  --  --
94    
95  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');
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 5757719)  -- TOC entry 2 (OID 5762139)
101  -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
102  --  --
103    
104  SELECT pg_catalog.setval('link_link_id_seq', 2, true);  SELECT pg_catalog.setval('link_link_id_seq', 4, true);
105    
106    
107  --  --
108  -- TOC entry 3 (OID 5757733)  -- TOC entry 3 (OID 5762153)
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 5762166)
117  -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
118  --  --
119    
120  SELECT pg_catalog.setval('location_location_id_seq', 3, true);  SELECT pg_catalog.setval('location_location_id_seq', 5, true);
121    
122    
123  --  --
124  -- TOC entry 4 (OID 5757747)  -- TOC entry 5 (OID 5762188)
125  -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
126  --  --
127    
128  SELECT pg_catalog.setval('vpn_vpn_id_seq', 5, true);  SELECT pg_catalog.setval('vpn_vpn_id_seq', 7, true);
129    
130    
131  --  --
132  -- TOC entry 5 (OID 5757774)  -- TOC entry 6 (OID 5762215)
133  -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
134  --  --
135    
136  SELECT pg_catalog.setval('trust_trust_id_seq', 1, true);  SELECT pg_catalog.setval('trust_trust_id_seq', 2, true);
137    
138    
139    --
140    -- TOC entry 7 (OID 5762239)
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 5762255)
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    
Legend:
Removed from v.6  
changed lines
  Added in v.7
  ViewVC Help
Powered by ViewVC 1.1.26