diff options
| -rw-r--r-- | nms/nms-dump.sql | 52 |
1 files changed, 29 insertions, 23 deletions
diff --git a/nms/nms-dump.sql b/nms/nms-dump.sql index 97112b0..bbe141d 100644 --- a/nms/nms-dump.sql +++ b/nms/nms-dump.sql @@ -44,18 +44,17 @@ SET default_tablespace = ''; SET default_with_oids = false; -- --- Name: dhcp; Type: TABLE; Schema: public; Owner: nms; Tablespace: +-- Name: dhcp; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE dhcp ( - switch integer NOT NULL, - network cidr NOT NULL, - last_ack timestamp without time zone, - owner_color character varying + switch integer, + "time" timestamp without time zone, + mac macaddr ); -ALTER TABLE dhcp OWNER TO nms; +ALTER TABLE dhcp OWNER TO postgres; -- -- Name: linknet_ping; Type: TABLE; Schema: public; Owner: nms; Tablespace: @@ -264,7 +263,8 @@ CREATE TABLE switches ( secondary_ip inet, placement box, subnet4 cidr, - subnet6 cidr + subnet6 cidr, + distro character varying ); @@ -354,6 +354,20 @@ ALTER TABLE ONLY switches -- +-- Name: dhcp_switch; Type: INDEX; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE INDEX dhcp_switch ON dhcp USING btree (switch); + + +-- +-- Name: dhcp_time; Type: INDEX; Schema: public; Owner: postgres; Tablespace: +-- + +CREATE INDEX dhcp_time ON dhcp USING btree ("time"); + + +-- -- Name: ping_index; Type: INDEX; Schema: public; Owner: nms; Tablespace: -- @@ -431,13 +445,6 @@ CREATE INDEX switch_temp_index ON switch_temp USING btree (switch); -- --- Name: switches_dhcp; Type: INDEX; Schema: public; Owner: nms; Tablespace: --- - -CREATE UNIQUE INDEX switches_dhcp ON dhcp USING btree (switch); - - --- -- Name: switches_switch; Type: INDEX; Schema: public; Owner: nms; Tablespace: -- @@ -459,6 +466,14 @@ CREATE INDEX updated_index3 ON ping_secondary_ip USING btree ("time"); -- +-- Name: dhcp_switch_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres +-- + +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: postgres -- @@ -501,15 +516,6 @@ GRANT ALL ON SCHEMA public TO PUBLIC; -- --- 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; - - --- -- Name: seen_mac; Type: ACL; Schema: public; Owner: nms -- |