From c79b3dedbe91a960c947876598f4701c12b710b2 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
Date: Tue, 15 Nov 2016 10:14:32 +0100
Subject: SQL: Nuke more unused relics of the past

---
 build/schema.sql | 90 +-------------------------------------------------------
 1 file changed, 1 insertion(+), 89 deletions(-)

(limited to 'build/schema.sql')

diff --git a/build/schema.sql b/build/schema.sql
index d72106d..41d513d 100644
--- a/build/schema.sql
+++ b/build/schema.sql
@@ -207,22 +207,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: 
 --
@@ -312,17 +297,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
 --
@@ -351,14 +325,6 @@ ALTER TABLE ONLY oplog ALTER COLUMN id SET DEFAULT nextval('oplog_id_seq'::regcl
 ALTER TABLE ONLY snmp ALTER COLUMN id SET DEFAULT nextval('snmp_id_seq'::regclass);
 
 
---
--- 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: 
 --
@@ -433,34 +399,6 @@ CREATE INDEX ping_index ON ping USING btree ("time");
 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: 
 --
@@ -533,14 +471,6 @@ ALTER TABLE ONLY snmp
     ADD CONSTRAINT snmp_switch_fkey FOREIGN KEY (switch) REFERENCES switches(switch);
 
 
---
--- 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
 --
@@ -613,15 +543,6 @@ REVOKE ALL ON TABLE ping_secondary_ip FROM nms;
 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
 --
@@ -660,15 +581,6 @@ REVOKE ALL ON TABLE switches FROM nms;
 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
 --
-- 
cgit v1.2.3

