From 8af016aa2a310d4da48f20002a09d1dc3a7e40be Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Sun, 22 Oct 2017 23:48:45 +0100 Subject: [PATCH] db: Drop unused slogans table Signed-off-by: Michael Tremer --- src/database.sql | 48 ------------------------------------------------ 1 file changed, 48 deletions(-) diff --git a/src/database.sql b/src/database.sql index 529c93a..7e683dd 100644 --- a/src/database.sql +++ b/src/database.sql @@ -1731,39 +1731,6 @@ CREATE TABLE settings ( ALTER TABLE settings OWNER TO pakfire; --- --- Name: slogans; Type: TABLE; Schema: public; Owner: pakfire; Tablespace: --- - -CREATE TABLE slogans ( - id integer NOT NULL, - message text NOT NULL -); - - -ALTER TABLE slogans OWNER TO pakfire; - --- --- Name: slogans_id_seq; Type: SEQUENCE; Schema: public; Owner: pakfire --- - -CREATE SEQUENCE slogans_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - - -ALTER TABLE slogans_id_seq OWNER TO pakfire; - --- --- Name: slogans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: pakfire --- - -ALTER SEQUENCE slogans_id_seq OWNED BY slogans.id; - - -- -- Name: sources; Type: TABLE; Schema: public; Owner: pakfire; Tablespace: -- @@ -2228,13 +2195,6 @@ ALTER TABLE ONLY repositories_builds ALTER COLUMN id SET DEFAULT nextval('reposi ALTER TABLE ONLY sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass); --- --- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire --- - -ALTER TABLE ONLY slogans ALTER COLUMN id SET DEFAULT nextval('slogans_id_seq'::regclass); - - -- -- Name: id; Type: DEFAULT; Schema: public; Owner: pakfire -- @@ -2500,14 +2460,6 @@ ALTER TABLE ONLY repositories_builds ADD CONSTRAINT idx_2198189_primary PRIMARY KEY (id); --- --- Name: idx_2198207_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace: --- - -ALTER TABLE ONLY slogans - ADD CONSTRAINT idx_2198207_primary PRIMARY KEY (id); - - -- -- Name: idx_2198213_primary; Type: CONSTRAINT; Schema: public; Owner: pakfire; Tablespace: -- -- 2.47.3