/[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 10 by dpavlin, Wed Feb 16 12:41:02 2005 UTC revision 11 by dpavlin, Wed Feb 16 14:53:37 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 9 (OID 5762650)  -- 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 10 (OID 5762657)  -- 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    
24    
25    
26  --  --
27  -- Data for TOC entry 11 (OID 5762664)  -- 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    
# Line 35  INSERT INTO link (link_id, link_name) VA Line 35  INSERT INTO link (link_id, link_name) VA
35    
36    
37  --  --
38  -- Data for TOC entry 12 (OID 5762678)  -- Data for TOC entry 12 (OID 5763036)
39  -- Name: country; Type: TABLE DATA; Schema: public; Owner: flow  -- Name: country; Type: TABLE DATA; Schema: public; Owner: flow
40  --  --
41    
# Line 43  INSERT INTO country (country_id, country Line 43  INSERT INTO country (country_id, country
43  INSERT INTO country (country_id, country_name) VALUES (2, 'Poland');  INSERT INTO country (country_id, country_name) VALUES (2, 'Poland');
44  INSERT INTO country (country_id, country_name) VALUES (3, 'Czeck');  INSERT INTO country (country_id, country_name) VALUES (3, 'Czeck');
45  INSERT INTO country (country_id, country_name) VALUES (4, 'Slovenia');  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 5762691)  -- 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    
# Line 55  INSERT INTO "location" (location_id, loc Line 56  INSERT INTO "location" (location_id, loc
56  INSERT INTO "location" (location_id, location_name, location_country_id, location_comment) VALUES (4, 'Brno', 3, NULL);  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);  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);  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 14 (OID 5762713)  -- 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);  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, 3, 4, '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 (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 15 (OID 5762743)  -- 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    
# Line 78  INSERT INTO trust (trust_id, trust_from_ Line 81  INSERT INTO trust (trust_id, trust_from_
81    
82    
83  --  --
84  -- Data for TOC entry 16 (OID 5762767)  -- Data for TOC entry 16 (OID 5763125)
85  -- Name: dns_type; Type: TABLE DATA; Schema: public; Owner: flow  -- Name: dns_type; Type: TABLE DATA; Schema: public; Owner: flow
86  --  --
87    
# Line 88  INSERT INTO dns_type (dns_type_id, dns_t Line 91  INSERT INTO dns_type (dns_type_id, dns_t
91    
92    
93  --  --
94  -- Data for TOC entry 17 (OID 5762784)  -- 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    
# Line 97  INSERT INTO dns (dns_id, dns_on_location Line 100  INSERT INTO dns (dns_id, dns_on_location
100    
101    
102  --  --
103  -- TOC entry 2 (OID 5762662)  -- 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    
# Line 105  SELECT pg_catalog.setval('link_link_id_s Line 108  SELECT pg_catalog.setval('link_link_id_s
108    
109    
110  --  --
111  -- TOC entry 3 (OID 5762676)  -- TOC entry 3 (OID 5763034)
112  -- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
113  --  --
114    
115  SELECT pg_catalog.setval('country_country_id_seq', 4, true);  SELECT pg_catalog.setval('country_country_id_seq', 5, true);
116    
117    
118  --  --
119  -- TOC entry 4 (OID 5762689)  -- 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', 5, true);  SELECT pg_catalog.setval('location_location_id_seq', 8, true);
124    
125    
126  --  --
127  -- TOC entry 5 (OID 5762711)  -- 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', 7, true);  SELECT pg_catalog.setval('vpn_vpn_id_seq', 10, true);
132    
133    
134  --  --
135  -- TOC entry 6 (OID 5762741)  -- 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    
# Line 137  SELECT pg_catalog.setval('trust_trust_id Line 140  SELECT pg_catalog.setval('trust_trust_id
140    
141    
142  --  --
143  -- TOC entry 7 (OID 5762765)  -- TOC entry 7 (OID 5763123)
144  -- Name: dns_type_dns_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: dns_type_dns_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
145  --  --
146    
# Line 145  SELECT pg_catalog.setval('dns_type_dns_t Line 148  SELECT pg_catalog.setval('dns_type_dns_t
148    
149    
150  --  --
151  -- TOC entry 8 (OID 5762782)  -- TOC entry 8 (OID 5763140)
152  -- Name: dns_dns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow  -- Name: dns_dns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow
153  --  --
154    
Legend:
Removed from v.10  
changed lines
  Added in v.11
  ViewVC Help
Powered by ViewVC 1.1.26