--- trunk/network_topology/data.sql 2005/02/16 14:11:02 10 +++ trunk/network_topology/data.sql 2005/02/16 14:53:37 11 @@ -10,21 +10,21 @@ SET search_path = public, pg_catalog; -- --- Data for TOC entry 9 (OID 5762650) +-- Data for TOC entry 9 (OID 5763008) -- Name: meta_tables; Type: TABLE DATA; Schema: public; Owner: flow -- -- --- Data for TOC entry 10 (OID 5762657) +-- Data for TOC entry 10 (OID 5763015) -- Name: meta_fields; Type: TABLE DATA; Schema: public; Owner: flow -- -- --- Data for TOC entry 11 (OID 5762664) +-- Data for TOC entry 11 (OID 5763022) -- Name: link; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -35,7 +35,7 @@ -- --- Data for TOC entry 12 (OID 5762678) +-- Data for TOC entry 12 (OID 5763036) -- Name: country; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -43,10 +43,11 @@ INSERT INTO country (country_id, country_name) VALUES (2, 'Poland'); INSERT INTO country (country_id, country_name) VALUES (3, 'Czeck'); INSERT INTO country (country_id, country_name) VALUES (4, 'Slovenia'); +INSERT INTO country (country_id, country_name) VALUES (5, 'USA'); -- --- Data for TOC entry 13 (OID 5762691) +-- Data for TOC entry 13 (OID 5763049) -- Name: location; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -55,21 +56,23 @@ 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 (3, 'Krakow', 2, NULL); 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 (6, 'New Jersey', 5, NULL); -- --- Data for TOC entry 14 (OID 5762713) +-- Data for TOC entry 14 (OID 5763071) -- Name: vpn; Type: TABLE DATA; Schema: public; Owner: flow -- 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 (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 (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 (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); +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); -- --- Data for TOC entry 15 (OID 5762743) +-- Data for TOC entry 15 (OID 5763101) -- Name: trust; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -78,7 +81,7 @@ -- --- Data for TOC entry 16 (OID 5762767) +-- Data for TOC entry 16 (OID 5763125) -- Name: dns_type; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -88,7 +91,7 @@ -- --- Data for TOC entry 17 (OID 5762784) +-- Data for TOC entry 17 (OID 5763142) -- Name: dns; Type: TABLE DATA; Schema: public; Owner: flow -- @@ -97,7 +100,7 @@ -- --- TOC entry 2 (OID 5762662) +-- TOC entry 2 (OID 5763020) -- Name: link_link_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- @@ -105,31 +108,31 @@ -- --- TOC entry 3 (OID 5762676) +-- TOC entry 3 (OID 5763034) -- Name: country_country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- -SELECT pg_catalog.setval('country_country_id_seq', 4, true); +SELECT pg_catalog.setval('country_country_id_seq', 5, true); -- --- TOC entry 4 (OID 5762689) +-- TOC entry 4 (OID 5763047) -- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- -SELECT pg_catalog.setval('location_location_id_seq', 5, true); +SELECT pg_catalog.setval('location_location_id_seq', 8, true); -- --- TOC entry 5 (OID 5762711) +-- TOC entry 5 (OID 5763069) -- Name: vpn_vpn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- -SELECT pg_catalog.setval('vpn_vpn_id_seq', 7, true); +SELECT pg_catalog.setval('vpn_vpn_id_seq', 10, true); -- --- TOC entry 6 (OID 5762741) +-- TOC entry 6 (OID 5763099) -- Name: trust_trust_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- @@ -137,7 +140,7 @@ -- --- TOC entry 7 (OID 5762765) +-- TOC entry 7 (OID 5763123) -- Name: dns_type_dns_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow -- @@ -145,7 +148,7 @@ -- --- TOC entry 8 (OID 5762782) +-- TOC entry 8 (OID 5763140) -- Name: dns_dns_id_seq; Type: SEQUENCE SET; Schema: public; Owner: flow --