diff options
Diffstat (limited to 'nms/nms-dump.sql')
| -rw-r--r-- | nms/nms-dump.sql | 695 |
1 files changed, 0 insertions, 695 deletions
diff --git a/nms/nms-dump.sql b/nms/nms-dump.sql deleted file mode 100644 index 25ba3ac..0000000 --- a/nms/nms-dump.sql +++ /dev/null @@ -1,695 +0,0 @@ --- --- PostgreSQL database dump --- - -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; - --- --- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: --- - -CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; - - --- --- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: --- - -COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; - - -SET search_path = public, pg_catalog; - --- --- Name: comment_state; Type: TYPE; Schema: public; Owner: nms --- - -CREATE TYPE comment_state AS ENUM ( - 'active', - 'inactive', - 'persist', - 'delete' -); - - -ALTER TYPE comment_state OWNER TO nms; - -SET default_tablespace = ''; - -SET default_with_oids = false; - --- --- Name: dhcp; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE dhcp ( - switch integer, - "time" timestamp with time zone, - mac macaddr, - ip inet -); - - -ALTER TABLE dhcp OWNER TO nms; - --- --- Name: linknet_ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE linknet_ping ( - linknet integer NOT NULL, - "time" timestamp with time zone DEFAULT now() NOT NULL, - latency1_ms double precision, - latency2_ms double precision -); - - -ALTER TABLE linknet_ping OWNER TO nms; - --- --- Name: linknets; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE linknets ( - linknet integer NOT NULL, - switch1 integer NOT NULL, - addr1 inet, - switch2 integer NOT NULL, - addr2 inet, - port1 character varying(10), - port2 character varying(10) -); - - -ALTER TABLE linknets OWNER TO nms; - --- --- Name: linknets_linknet_seq; Type: SEQUENCE; Schema: public; Owner: nms --- - -CREATE SEQUENCE linknets_linknet_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE linknets_linknet_seq OWNER TO nms; - --- --- Name: linknets_linknet_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms --- - -ALTER SEQUENCE linknets_linknet_seq OWNED BY linknets.linknet; - - --- --- Name: ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE ping ( - switch integer NOT NULL, - "time" timestamp with time zone DEFAULT now() NOT NULL, - latency_ms double precision -); - - -ALTER TABLE ping OWNER TO nms; - --- --- Name: ping_secondary_ip; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE ping_secondary_ip ( - switch integer NOT NULL, - "time" timestamp with time zone DEFAULT now() NOT NULL, - latency_ms double precision -); - - -ALTER TABLE ping_secondary_ip OWNER TO nms; - --- --- Name: polls; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE polls ( - switch integer NOT NULL, - "time" timestamp with time zone NOT NULL, - ifname character varying(30) NOT NULL, - ifhighspeed integer, - ifhcoutoctets bigint, - ifhcinoctets bigint -); - - -ALTER TABLE polls OWNER TO nms; - --- --- Name: seen_mac; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE seen_mac ( - mac macaddr NOT NULL, - address inet NOT NULL, - seen timestamp with time zone DEFAULT now() NOT NULL -); - - -ALTER TABLE seen_mac OWNER TO nms; - --- --- Name: snmp; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE snmp ( - "time" timestamp without time zone DEFAULT now() NOT NULL, - switch integer NOT NULL, - data jsonb, - id integer NOT NULL -); - - -ALTER TABLE snmp OWNER TO nms; - --- --- Name: snmp_id_seq; Type: SEQUENCE; Schema: public; Owner: nms --- - -CREATE SEQUENCE snmp_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE snmp_id_seq OWNER TO nms; - --- --- Name: snmp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms --- - -ALTER SEQUENCE snmp_id_seq OWNED BY snmp.id; - - --- --- Name: switch_comments; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE switch_comments ( - switch integer NOT NULL, - "time" timestamp with time zone, - comment text, - state comment_state DEFAULT 'active'::comment_state, - username character varying(32), - id integer NOT NULL -); - - -ALTER TABLE switch_comments OWNER TO nms; - --- --- Name: switch_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: nms --- - -CREATE SEQUENCE switch_comments_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE switch_comments_id_seq OWNER TO nms; - --- --- Name: switch_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms --- - -ALTER SEQUENCE switch_comments_id_seq OWNED BY switch_comments.id; - - --- --- Name: switch_temp; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE switch_temp ( - switch integer, - temp integer, - "time" timestamp with time zone -); - - -ALTER TABLE switch_temp OWNER TO nms; - --- --- Name: switches; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE switches ( - switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL, - mgmt_v4_addr inet, - sysname character varying NOT NULL, - switchtype character varying DEFAULT 'ex2200'::character varying NOT NULL, - last_updated timestamp with time zone, - locked boolean DEFAULT false NOT NULL, - poll_frequency interval DEFAULT '00:01:00'::interval NOT NULL, - community character varying DEFAULT 'FullPuppTilNMS'::character varying NOT NULL, - lldp_chassis_id character varying, - mgmt_v6_addr inet, - placement box, - subnet4 cidr, - subnet6 cidr, - distro_name character varying, - distro_phy_port character varying(100), - mgmt_v6_gw inet, - mgmt_v4_gw inet, - mgmt_vlan integer DEFAULT 666, - traffic_vlan integer, - last_config_fetch timestamp with time zone, - current_mac macaddr -); - - -ALTER TABLE switches OWNER TO nms; - --- --- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: nms --- - -CREATE SEQUENCE switches_switch_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE switches_switch_seq OWNER TO nms; - --- --- Name: test_table; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE test_table ( - test timestamp with time zone -); - - -ALTER TABLE test_table OWNER TO nms; - --- --- Name: linknet; Type: DEFAULT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY linknets ALTER COLUMN linknet SET DEFAULT nextval('linknets_linknet_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY snmp ALTER COLUMN id SET DEFAULT nextval('snmp_id_seq'::regclass); - - --- --- Name: id; Type: DEFAULT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY switch_comments ALTER COLUMN id SET DEFAULT nextval('switch_comments_id_seq'::regclass); - - --- --- Name: polls_time_switch_ifname_key; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY polls - ADD CONSTRAINT polls_time_switch_ifname_key UNIQUE ("time", switch, ifname); - - --- --- Name: seen_mac_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY seen_mac - ADD CONSTRAINT seen_mac_pkey PRIMARY KEY (mac, address, seen); - - --- --- Name: switch_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY switch_comments - ADD CONSTRAINT switch_comments_pkey PRIMARY KEY (id); - - --- --- Name: switches_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY switches - ADD CONSTRAINT switches_pkey PRIMARY KEY (switch); - - --- --- Name: switches_sysname_key; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY switches - ADD CONSTRAINT switches_sysname_key UNIQUE (sysname); - - --- --- Name: switches_sysname_key1; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: --- - -ALTER TABLE ONLY switches - ADD CONSTRAINT switches_sysname_key1 UNIQUE (sysname); - - --- --- Name: dhcp_ip; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX dhcp_ip ON dhcp USING btree (ip); - - --- --- Name: dhcp_mac; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX dhcp_mac ON dhcp USING btree (mac); - - --- --- Name: dhcp_switch; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX dhcp_switch ON dhcp USING btree (switch); - - --- --- Name: dhcp_time; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX dhcp_time ON dhcp USING btree ("time"); - - --- --- Name: ping_index; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX ping_index ON ping USING btree ("time"); - - --- --- Name: ping_secondary_index; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX ping_secondary_index ON ping_secondary_ip USING btree ("time"); - - --- --- Name: polls_ifname; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX polls_ifname ON polls USING btree (ifname); - - --- --- Name: polls_switch; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX polls_switch ON polls USING btree (switch); - - --- --- Name: polls_switch_ifname; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX polls_switch_ifname ON polls USING btree (switch, ifname); - - --- --- Name: polls_time; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX polls_time ON polls USING btree ("time"); - - --- --- Name: seen_mac_addr_family; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX seen_mac_addr_family ON seen_mac USING btree (family(address)); - - --- --- Name: seen_mac_seen; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX seen_mac_seen ON seen_mac USING btree (seen); - - --- --- Name: snmp_time; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX snmp_time ON snmp USING btree ("time"); - - --- --- Name: snmp_time15; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX snmp_time15 ON snmp USING btree (id, switch); - - --- --- Name: snmp_time6; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX snmp_time6 ON snmp USING btree ("time" DESC, switch); - - --- --- Name: switch_temp_index; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX switch_temp_index ON switch_temp USING btree (switch); - - --- --- Name: switches_switch; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX switches_switch ON switches USING hash (switch); - - --- --- Name: updated_index2; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX updated_index2 ON linknet_ping USING btree ("time"); - - --- --- Name: updated_index3; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE INDEX updated_index3 ON ping_secondary_ip USING btree ("time"); - - --- --- Name: dhcp_switch_fkey; Type: FK CONSTRAINT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY dhcp - ADD CONSTRAINT dhcp_switch_fkey FOREIGN KEY (switch) REFERENCES switches(switch); - - --- --- Name: snmp_switch_fkey; Type: FK CONSTRAINT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY snmp - ADD CONSTRAINT snmp_switch_fkey FOREIGN KEY (switch) REFERENCES switches(switch); - - --- --- Name: switchname; Type: FK CONSTRAINT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY polls - ADD CONSTRAINT switchname FOREIGN KEY (switch) REFERENCES switches(switch); - - --- --- Name: switchname; Type: FK CONSTRAINT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY ping - ADD CONSTRAINT switchname FOREIGN KEY (switch) REFERENCES switches(switch); - - --- --- Name: switchname; Type: FK CONSTRAINT; Schema: public; Owner: nms --- - -ALTER TABLE ONLY switch_comments - ADD CONSTRAINT switchname FOREIGN KEY (switch) REFERENCES switches(switch); - - --- --- 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; -GRANT ALL ON SCHEMA public TO fap; - - --- --- Name: dhcp; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE dhcp FROM PUBLIC; -REVOKE ALL ON TABLE dhcp FROM nms; -GRANT ALL ON TABLE dhcp TO nms; -GRANT ALL ON TABLE dhcp TO fap; - - --- --- Name: linknet_ping; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE linknet_ping FROM PUBLIC; -REVOKE ALL ON TABLE linknet_ping FROM nms; -GRANT ALL ON TABLE linknet_ping TO nms; -GRANT ALL ON TABLE linknet_ping TO fap; - - --- --- Name: linknets; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE linknets FROM PUBLIC; -REVOKE ALL ON TABLE linknets FROM nms; -GRANT ALL ON TABLE linknets TO nms; -GRANT ALL ON TABLE linknets TO fap; - - --- --- Name: ping; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE ping FROM PUBLIC; -REVOKE ALL ON TABLE ping FROM nms; -GRANT ALL ON TABLE ping TO nms; -GRANT ALL ON TABLE ping TO fap; - - --- --- Name: ping_secondary_ip; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE ping_secondary_ip FROM PUBLIC; -REVOKE ALL ON TABLE ping_secondary_ip FROM nms; -GRANT ALL ON TABLE ping_secondary_ip TO nms; -GRANT ALL ON TABLE ping_secondary_ip TO fap; - - --- --- Name: polls; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE polls FROM PUBLIC; -REVOKE ALL ON TABLE polls FROM nms; -GRANT ALL ON TABLE polls TO nms; -GRANT ALL ON TABLE polls TO fap; - - --- --- Name: seen_mac; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE seen_mac FROM PUBLIC; -REVOKE ALL ON TABLE seen_mac FROM nms; -GRANT ALL ON TABLE seen_mac TO nms; -GRANT ALL ON TABLE seen_mac TO fap; - - --- --- Name: snmp; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE snmp FROM PUBLIC; -REVOKE ALL ON TABLE snmp FROM nms; -GRANT ALL ON TABLE snmp TO nms; -GRANT ALL ON TABLE snmp TO postgres; -GRANT ALL ON TABLE snmp TO fap; - - --- --- Name: snmp_id_seq; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON SEQUENCE snmp_id_seq FROM PUBLIC; -REVOKE ALL ON SEQUENCE snmp_id_seq FROM nms; -GRANT ALL ON SEQUENCE snmp_id_seq TO nms; -GRANT ALL ON SEQUENCE snmp_id_seq TO postgres; - - --- --- Name: switch_comments; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE switch_comments FROM PUBLIC; -REVOKE ALL ON TABLE switch_comments FROM nms; -GRANT ALL ON TABLE switch_comments TO nms; -GRANT ALL ON TABLE switch_comments TO fap; - - --- --- Name: switch_temp; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE switch_temp FROM PUBLIC; -REVOKE ALL ON TABLE switch_temp FROM nms; -GRANT ALL ON TABLE switch_temp TO nms; -GRANT ALL ON TABLE switch_temp TO fap; - - --- --- Name: switches; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE switches FROM PUBLIC; -REVOKE ALL ON TABLE switches FROM nms; -GRANT ALL ON TABLE switches TO nms; -GRANT ALL ON TABLE switches TO fap; - - --- --- Name: test_table; Type: ACL; Schema: public; Owner: nms --- - -REVOKE ALL ON TABLE test_table FROM PUBLIC; -REVOKE ALL ON TABLE test_table FROM nms; -GRANT ALL ON TABLE test_table TO nms; -GRANT ALL ON TABLE test_table TO fap; - - --- --- PostgreSQL database dump complete --- - |