diff options
Diffstat (limited to 'build/schema.sql')
-rw-r--r-- | build/schema.sql | 90 |
1 files changed, 1 insertions, 89 deletions
diff --git a/build/schema.sql b/build/schema.sql index d72106d..41d513d 100644 --- a/build/schema.sql +++ b/build/schema.sql @@ -208,22 +208,6 @@ CREATE TABLE ping_secondary_ip ( 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: -- @@ -270,6 +254,7 @@ ALTER TABLE snmp_id_seq OWNER TO nms; ALTER SEQUENCE snmp_id_seq OWNED BY snmp.id; + -- -- Name: switches; Type: TABLE; Schema: public; Owner: nms; Tablespace: -- @@ -313,17 +298,6 @@ CREATE SEQUENCE switches_switch_seq 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: id; Type: DEFAULT; Schema: public; Owner: nms -- @@ -352,14 +326,6 @@ ALTER TABLE ONLY snmp ALTER COLUMN id SET DEFAULT nextval('snmp_id_seq'::regclas -- --- 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: -- @@ -434,34 +400,6 @@ 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: -- @@ -537,14 +475,6 @@ ALTER TABLE ONLY snmp -- 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); @@ -614,15 +544,6 @@ GRANT ALL ON TABLE ping_secondary_ip TO nms; -- --- 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; - - --- -- Name: seen_mac; Type: ACL; Schema: public; Owner: nms -- @@ -661,15 +582,6 @@ GRANT ALL ON TABLE switches TO nms; -- --- 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; - - --- -- PostgreSQL database dump complete -- |