From ab8d42605be3e29653e98fba72f6f22c99220155 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
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

