-- -- PostgreSQL database dump -- -- Dumped from database version 9.3.9 -- Dumped by pg_dump version 9.3.9 -- Started on 2015-10-07 17:26:56 CEST SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 190 (class 1259 OID 30242) -- Name: ipinterface; Type: TABLE; Schema: public; Owner: opennms; Tablespace: -- CREATE TABLE ipinterface ( id integer DEFAULT nextval('opennmsnxtid'::regclass) NOT NULL, nodeid integer NOT NULL, ipaddr text NOT NULL, iphostname character varying(256), ismanaged character(1), ipstatus integer, iplastcapsdpoll timestamp with time zone, issnmpprimary character(1), snmpinterfaceid integer ); ALTER TABLE public.ipinterface OWNER TO opennms; -- -- TOC entry 2291 (class 0 OID 30242) -- Dependencies: 190 -- Data for Name: ipinterface; Type: TABLE DATA; Schema: public; Owner: opennms -- COPY ipinterface (id, nodeid, ipaddr, iphostname, ismanaged, ipstatus, iplastcapsdpoll, issnmpprimary, snmpinterfaceid) FROM stdin; 2 1 127.0.0.1 127.0.0.1 M \N 2015-10-07 10:53:03.14+02 P \N \. -- -- TOC entry 2180 (class 2606 OID 30246) -- Name: ipinterface_pkey; Type: CONSTRAINT; Schema: public; Owner: opennms; Tablespace: -- ALTER TABLE ONLY ipinterface ADD CONSTRAINT ipinterface_pkey PRIMARY KEY (id); -- -- TOC entry 2173 (class 1259 OID 30956) -- Name: ipinterface_ipaddr_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_ipaddr_idx ON ipinterface USING btree (ipaddr); -- -- TOC entry 2174 (class 1259 OID 30957) -- Name: ipinterface_ipaddr_ismanaged_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_ipaddr_ismanaged_idx ON ipinterface USING btree (ipaddr, ismanaged); -- -- TOC entry 2175 (class 1259 OID 30262) -- Name: ipinterface_ismanaged_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_ismanaged_idx ON ipinterface USING btree (ismanaged); -- -- TOC entry 2176 (class 1259 OID 30263) -- Name: ipinterface_nodeid_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_nodeid_idx ON ipinterface USING btree (nodeid); -- -- TOC entry 2177 (class 1259 OID 30958) -- Name: ipinterface_nodeid_ipaddr_ismanaged_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_nodeid_ipaddr_ismanaged_idx ON ipinterface USING btree (nodeid, ipaddr, ismanaged); -- -- TOC entry 2178 (class 1259 OID 30959) -- Name: ipinterface_nodeid_ipaddr_notzero_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE UNIQUE INDEX ipinterface_nodeid_ipaddr_notzero_idx ON ipinterface USING btree (nodeid, ipaddr); -- -- TOC entry 2181 (class 1259 OID 30264) -- Name: ipinterface_snmpinterfaceid_idx; Type: INDEX; Schema: public; Owner: opennms; Tablespace: -- CREATE INDEX ipinterface_snmpinterfaceid_idx ON ipinterface USING btree (snmpinterfaceid); -- -- TOC entry 2183 (class 2606 OID 30253) -- Name: fk_nodeid1; Type: FK CONSTRAINT; Schema: public; Owner: opennms -- ALTER TABLE ONLY ipinterface ADD CONSTRAINT fk_nodeid1 FOREIGN KEY (nodeid) REFERENCES node(nodeid) ON DELETE CASCADE; -- -- TOC entry 2182 (class 2606 OID 30248) -- Name: snmpinterface_fkey2; Type: FK CONSTRAINT; Schema: public; Owner: opennms -- ALTER TABLE ONLY ipinterface ADD CONSTRAINT snmpinterface_fkey2 FOREIGN KEY (snmpinterfaceid) REFERENCES snmpinterface(id) ON DELETE SET NULL; -- Completed on 2015-10-07 17:26:56 CEST -- -- PostgreSQL database dump complete --