[encoded data, 124091 characters]	2011-10-28 03:40:10
52	3733	\\x[encoded data, 133884 characters]	2011-10-28 03:34:37
53	3733	\\x[encoded data, 133884 characters]	2011-10-28 03:40:10
54	3734	\\x[encoded data, 46428 characters]	2011-11-30 22:42:49
\.


--
-- Name: router_configuration_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ngnms
--

SELECT pg_catalog.setval('router_configuration_id_seq', 54, true);


--
-- Data for Name: router_graph; Type: TABLE DATA; Schema: public; Owner: ngnms
--

COPY router_graph (router_id, x, y) FROM stdin;
3724	155.955002	103.482002
3725	156.052002	224.311005
3726	270.052002	103.310997
3727	42.0521011	224.311005
3730	489.052002	217.710999
3731	389.052002	101.710999
3732	489.052002	101.710999
3733	30	164
3734	320	164
\.


--
-- Data for Name: router_vendors; Type: TABLE DATA; Schema: public; Owner: ngnms
--

COPY router_vendors (id, name, rgb) FROM stdin;
2	Juniper	0000FF
1	Cisco	449970
\.


--
-- Name: router_vendors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ngnms
--

SELECT pg_catalog.setval('router_vendors_id_seq', 3, true);


--
-- Data for Name: routers; Type: TABLE DATA; Schema: public; Owner: ngnms
--

COPY routers (router_id, name, ip_addr, eq_type, eq_vendor, location, status, icon_color) FROM stdin;
3732	r201	10.100.254.23	m10                                               	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3730	atlas	10.100.254.21	m5                                                	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3724	192.168.50.2	192.168.50.2	\N	\N	\N	down                	\N
3726	adrastea	172.26.27.37	m40                                               	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3727	jupiter	172.26.27.18	t640                                              	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3725	192.168.50.3	192.168.50.3	\N	\N	\N	down                	\N
3731	ganymede	10.100.254.20	m10                                               	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3733	172.26.27.37	0.0.0.0	m40                                               	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
3734	172.26.27.18	0.0.0.0	t640                                              	Juniper                                           	AMS, EPOC                                                                                                                                                                                                                                                      	up                  	\N
\.


--
-- Name: routers_router_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ngnms
--

SELECT pg_catalog.setval('routers_router_id_seq', 3734, true);


--
-- Data for Name: tbl_user; Type: TABLE DATA; Schema: public; Owner: ngnms
--

COPY tbl_user (id, username, password, email, fname, lname, company) FROM stdin;
1	admin	773ed20b67466ee0ef5ac5e5e1ccd290	ajaropud@opt-net.eu	Andre	Jaropud	Opt-Net
\.


--
-- Name: tbl_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ngnms
--

SELECT pg_catalog.setval('tbl_user_id_seq', 1, false);


--
-- Data for Name: usrs; Type: TABLE DATA; Schema: public; Owner: ngnms
--

COPY usrs (usr, psw) FROM stdin;
admin	admin
taras	taras
\.


--
-- Name: admrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY admrecords
    ADD CONSTRAINT admrecords_pkey PRIMARY KEY (rec_id);


--
-- Name: archives_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY archives
    ADD CONSTRAINT archives_pkey PRIMARY KEY (archive_id);


--
-- Name: authassignment_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY authassignment
    ADD CONSTRAINT authassignment_pkey PRIMARY KEY (itemname, userid);


--
-- Name: authitem_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY authitem
    ADD CONSTRAINT authitem_pkey PRIMARY KEY (name);


--
-- Name: authitemchild_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_pkey PRIMARY KEY (parent, child);


--
-- Name: event_id_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY events
    ADD CONSTRAINT event_id_pkey PRIMARY KEY (event_id);


--
-- Name: interfaces_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY interfaces
    ADD CONSTRAINT interfaces_pkey PRIMARY KEY (ifc_id);


--
-- Name: menu_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY menu
    ADD CONSTRAINT menu_pkey PRIMARY KEY (id);


--
-- Name: menuitem_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY menuitem
    ADD CONSTRAINT menuitem_pkey PRIMARY KEY (id);


--
-- Name: network_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_pkey PRIMARY KEY (link_id);


--
-- Name: ph_int_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY ph_int
    ADD CONSTRAINT ph_int_pkey PRIMARY KEY (ph_int_id);


--
-- Name: router_configuration_id_key; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY router_configuration
    ADD CONSTRAINT router_configuration_id_key UNIQUE (id);


--
-- Name: router_vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY router_vendors
    ADD CONSTRAINT router_vendors_pkey PRIMARY KEY (id);


--
-- Name: routers_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY routers
    ADD CONSTRAINT routers_pkey PRIMARY KEY (router_id);


--
-- Name: tbl_user_pkey; Type: CONSTRAINT; Schema: public; Owner: ngnms; Tablespace: 
--

ALTER TABLE ONLY tbl_user
    ADD CONSTRAINT tbl_user_pkey PRIMARY KEY (id);


--
-- Name: child; Type: INDEX; Schema: public; Owner: ngnms; Tablespace: 
--

CREATE INDEX child ON authitemchild USING btree (child);


--
-- Name: event_origin_idx; Type: INDEX; Schema: public; Owner: ngnms; Tablespace: 
--

CREATE INDEX event_origin_idx ON events USING btree (origin_ts);


--
-- Name: event_receiver_idx; Type: INDEX; Schema: public; Owner: ngnms; Tablespace: 
--

CREATE INDEX event_receiver_idx ON events USING btree (receiver_ts);


--
-- Name: events_event_id_key; Type: INDEX; Schema: public; Owner: ngnms; Tablespace: 
--

CREATE UNIQUE INDEX events_event_id_key ON events USING btree (event_id);


--
-- Name: usrs_usr_key; Type: INDEX; Schema: public; Owner: ngnms; Tablespace: 
--

CREATE UNIQUE INDEX usrs_usr_key ON usrs USING btree (usr);


--
-- Name: authassignment_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY authassignment
    ADD CONSTRAINT authassignment_ibfk_1 FOREIGN KEY (itemname) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: authitemchild_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_ibfk_1 FOREIGN KEY (parent) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: authitemchild_ibfk_2; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_ibfk_2 FOREIGN KEY (child) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_id; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY router_graph
    ADD CONSTRAINT fk_router_id FOREIGN KEY (router_id) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_id_conf; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY router_configuration
    ADD CONSTRAINT fk_router_id_conf FOREIGN KEY (router_id) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: interfaces_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY interfaces
    ADD CONSTRAINT interfaces_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: inv_hw_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY inv_hw
    ADD CONSTRAINT inv_hw_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: inv_sw_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY inv_sw
    ADD CONSTRAINT inv_sw_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: network_router_id_a_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_router_id_a_fkey FOREIGN KEY (router_id_a) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: network_router_id_b_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_router_id_b_fkey FOREIGN KEY (router_id_b) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: ph_int_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ngnms
--

ALTER TABLE ONLY ph_int
    ADD CONSTRAINT ph_int_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: admrecords; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE admrecords FROM PUBLIC;
REVOKE ALL ON TABLE admrecords FROM ngnms;
GRANT ALL ON TABLE admrecords TO ngnms;


--
-- Name: admrecords_RecID_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE "admrecords_RecID_seq" FROM PUBLIC;
REVOKE ALL ON SEQUENCE "admrecords_RecID_seq" FROM ngnms;
GRANT ALL ON SEQUENCE "admrecords_RecID_seq" TO ngnms;


--
-- Name: archives; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE archives FROM PUBLIC;
REVOKE ALL ON TABLE archives FROM ngnms;
GRANT ALL ON TABLE archives TO ngnms;


--
-- Name: archives_archive_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE archives_archive_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE archives_archive_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE archives_archive_id_seq TO ngnms;


--
-- Name: events; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE events FROM PUBLIC;
REVOKE ALL ON TABLE events FROM ngnms;
GRANT ALL ON TABLE events TO ngnms;


--
-- Name: events_event_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE events_event_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE events_event_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE events_event_id_seq TO ngnms;


--
-- Name: interfaces; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE interfaces FROM PUBLIC;
REVOKE ALL ON TABLE interfaces FROM ngnms;
GRANT ALL ON TABLE interfaces TO ngnms;


--
-- Name: interfaces_ifc_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE interfaces_ifc_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE interfaces_ifc_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE interfaces_ifc_id_seq TO ngnms;


--
-- Name: inv_hw; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE inv_hw FROM PUBLIC;
REVOKE ALL ON TABLE inv_hw FROM ngnms;
GRANT ALL ON TABLE inv_hw TO ngnms;


--
-- Name: inv_sw; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE inv_sw FROM PUBLIC;
REVOKE ALL ON TABLE inv_sw FROM ngnms;
GRANT ALL ON TABLE inv_sw TO ngnms;


--
-- Name: network; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE network FROM PUBLIC;
REVOKE ALL ON TABLE network FROM ngnms;
GRANT ALL ON TABLE network TO ngnms;


--
-- Name: network_link_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE network_link_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE network_link_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE network_link_id_seq TO ngnms;


--
-- Name: pga_forms; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_forms FROM PUBLIC;
REVOKE ALL ON TABLE pga_forms FROM ngnms;
GRANT ALL ON TABLE pga_forms TO ngnms;
GRANT ALL ON TABLE pga_forms TO PUBLIC;


--
-- Name: pga_layout; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_layout FROM PUBLIC;
REVOKE ALL ON TABLE pga_layout FROM ngnms;
GRANT ALL ON TABLE pga_layout TO ngnms;
GRANT ALL ON TABLE pga_layout TO PUBLIC;


--
-- Name: pga_queries; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_queries FROM PUBLIC;
REVOKE ALL ON TABLE pga_queries FROM ngnms;
GRANT ALL ON TABLE pga_queries TO ngnms;
GRANT ALL ON TABLE pga_queries TO PUBLIC;


--
-- Name: pga_reports; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_reports FROM PUBLIC;
REVOKE ALL ON TABLE pga_reports FROM ngnms;
GRANT ALL ON TABLE pga_reports TO ngnms;
GRANT ALL ON TABLE pga_reports TO PUBLIC;


--
-- Name: pga_schema; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_schema FROM PUBLIC;
REVOKE ALL ON TABLE pga_schema FROM ngnms;
GRANT ALL ON TABLE pga_schema TO ngnms;
GRANT ALL ON TABLE pga_schema TO PUBLIC;


--
-- Name: pga_scripts; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE pga_scripts FROM PUBLIC;
REVOKE ALL ON TABLE pga_scripts FROM ngnms;
GRANT ALL ON TABLE pga_scripts TO ngnms;
GRANT ALL ON TABLE pga_scripts TO PUBLIC;


--
-- Name: ph_int; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE ph_int FROM PUBLIC;
REVOKE ALL ON TABLE ph_int FROM ngnms;
GRANT ALL ON TABLE ph_int TO ngnms;


--
-- Name: ph_int_ph_int_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE ph_int_ph_int_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE ph_int_ph_int_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE ph_int_ph_int_id_seq TO ngnms;


--
-- Name: router_graph; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE router_graph FROM PUBLIC;
REVOKE ALL ON TABLE router_graph FROM ngnms;
GRANT ALL ON TABLE router_graph TO ngnms;


--
-- Name: router_vendors; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE router_vendors FROM PUBLIC;
REVOKE ALL ON TABLE router_vendors FROM ngnms;
GRANT ALL ON TABLE router_vendors TO ngnms;


--
-- Name: router_vendors_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE router_vendors_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE router_vendors_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE router_vendors_id_seq TO ngnms;


--
-- Name: routers; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON TABLE routers FROM PUBLIC;
REVOKE ALL ON TABLE routers FROM ngnms;
GRANT ALL ON TABLE routers TO ngnms;


--
-- Name: routers_router_id_seq; Type: ACL; Schema: public; Owner: ngnms
--

REVOKE ALL ON SEQUENCE routers_router_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE routers_router_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE routers_router_id_seq TO ngnms;


--
--

