aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorKristian Lyngstol <kristian@bohemians.org>2016-11-15 10:10:54 +0100
committerKristian Lyngstol <kristian@bohemians.org>2016-11-15 10:10:54 +0100
commitab8d42605be3e29653e98fba72f6f22c99220155 (patch)
treee81924bad241da92117e03e5dafb248bac437871
parentd9069802f61b3a36807c02c429ec0b9c9a63c857 (diff)
Remove switch_temp table relic....
Hasn't been used since tg15 afaik.
-rw-r--r--build/schema.sql30
1 files changed, 0 insertions, 30 deletions
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:
--
@@ -511,13 +497,6 @@ 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:
--
@@ -673,15 +652,6 @@ 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
--