From 6233a3e28ce39d3773cb0879015045d28c454a37 Mon Sep 17 00:00:00 2001 From: Kristian Lyngstol 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