From 6233a3e28ce39d3773cb0879015045d28c454a37 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
Date: Wed, 18 May 2016 20:27:30 +0200
Subject: Remove comments from SQL

---
 build/schema.sql | 69 --------------------------------------------------------
 1 file changed, 69 deletions(-)

(limited to 'build/schema.sql')

diff --git a/build/schema.sql b/build/schema.sql
index a323d6b..2cddcc3 100644
--- a/build/schema.sql
+++ b/build/schema.sql
@@ -270,43 +270,6 @@ ALTER TABLE snmp_id_seq OWNER TO nms;
 ALTER SEQUENCE snmp_id_seq OWNED BY snmp.id;
 
 
---
--- Name: switch_comments; Type: TABLE; Schema: public; Owner: nms; Tablespace: 
---
-
-CREATE TABLE switch_comments (
-    switch integer NOT NULL,
-    "time" timestamp with time zone,
-    comment text,
-    state comment_state DEFAULT 'active'::comment_state,
-    username character varying(32),
-    id integer NOT NULL
-);
-
-
-ALTER TABLE switch_comments OWNER TO nms;
-
---
--- Name: switch_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: nms
---
-
-CREATE SEQUENCE switch_comments_id_seq
-    START WITH 1
-    INCREMENT BY 1
-    NO MINVALUE
-    NO MAXVALUE
-    CACHE 1;
-
-
-ALTER TABLE switch_comments_id_seq OWNER TO nms;
-
---
--- Name: switch_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nms
---
-
-ALTER SEQUENCE switch_comments_id_seq OWNED BY switch_comments.id;
-
-
 --
 -- Name: switch_temp; Type: TABLE; Schema: public; Owner: nms; Tablespace: 
 --
@@ -404,13 +367,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: id; Type: DEFAULT; Schema: public; Owner: nms
---
-
-ALTER TABLE ONLY switch_comments ALTER COLUMN id SET DEFAULT nextval('switch_comments_id_seq'::regclass);
-
-
 --
 -- Name: polls_time_switch_ifname_key; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: 
 --
@@ -427,14 +383,6 @@ ALTER TABLE ONLY seen_mac
     ADD CONSTRAINT seen_mac_pkey PRIMARY KEY (mac, address, seen);
 
 
---
--- Name: switch_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: 
---
-
-ALTER TABLE ONLY switch_comments
-    ADD CONSTRAINT switch_comments_pkey PRIMARY KEY (id);
-
-
 --
 -- Name: switches_pkey; Type: CONSTRAINT; Schema: public; Owner: nms; Tablespace: 
 --
@@ -624,14 +572,6 @@ ALTER TABLE ONLY ping
     ADD CONSTRAINT switchname FOREIGN KEY (switch) REFERENCES switches(switch);
 
 
---
--- Name: switchname; Type: FK CONSTRAINT; Schema: public; Owner: nms
---
-
-ALTER TABLE ONLY switch_comments
-    ADD CONSTRAINT switchname FOREIGN KEY (switch) REFERENCES switches(switch);
-
-
 --
 -- Name: public; Type: ACL; Schema: -; Owner: postgres
 --
@@ -734,15 +674,6 @@ GRANT ALL ON SEQUENCE snmp_id_seq TO nms;
 GRANT ALL ON SEQUENCE snmp_id_seq TO postgres;
 
 
---
--- Name: switch_comments; Type: ACL; Schema: public; Owner: nms
---
-
-REVOKE ALL ON TABLE switch_comments FROM PUBLIC;
-REVOKE ALL ON TABLE switch_comments FROM nms;
-GRANT ALL ON TABLE switch_comments TO nms;
-
-
 --
 -- Name: switch_temp; Type: ACL; Schema: public; Owner: nms
 --
-- 
cgit v1.2.3

