From ab8d42605be3e29653e98fba72f6f22c99220155 Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol Date: Tue, 15 Nov 2016 10:10:54 +0100 Subject: Remove switch_temp table relic.... Hasn't been used since tg15 afaik. --- build/schema.sql | 30 ------------------------------ 1 file changed, 30 deletions(-) (limited to 'build/schema.sql') diff --git a/build/schema.sql b/build/schema.sql index 3e8ee91..d72106d 100644 --- a/build/schema.sql +++ b/build/schema.sql @@ -270,20 +270,6 @@ ALTER TABLE snmp_id_seq OWNER TO nms; ALTER SEQUENCE snmp_id_seq OWNED BY snmp.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: -- @@ -510,13 +496,6 @@ CREATE INDEX snmp_time15 ON snmp USING btree (id, switch); 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: -- @@ -672,15 +651,6 @@ GRANT ALL ON SEQUENCE snmp_id_seq TO nms; GRANT ALL ON SEQUENCE snmp_id_seq TO postgres; --- --- 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; - - -- -- Name: switches; Type: ACL; Schema: public; Owner: nms -- -- cgit v1.2.3