From 17aa96df5776812e2b2fb212b071a821685c9598 Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Fri, 3 Feb 2023 00:31:50 +0300 Subject: Drop unused tables --- src/main/resources/schema-sqlite.sql | 14 -------------- 1 file changed, 14 deletions(-) (limited to 'src/main/resources/schema-sqlite.sql') diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql index 39895b2e..9037aef0 100644 --- a/src/main/resources/schema-sqlite.sql +++ b/src/main/resources/schema-sqlite.sql @@ -61,16 +61,6 @@ CREATE TABLE followers ( PRIMARY KEY (user_id) FOREIGN KEY (user_id) REFERENCES users(id) ); -CREATE TABLE images ( - mid bigint NOT NULL, - rid bigint NOT NULL, - thumb bigint NOT NULL, - small bigint NOT NULL, - medium bigint NOT NULL, - height bigint NOT NULL, - width bigint NOT NULL, - PRIMARY KEY (mid, rid) -); CREATE TABLE jids ( user_id INTEGER, jid character varying(64) NOT NULL, @@ -213,10 +203,6 @@ CREATE TABLE tags_ignore ( tag_id bigint NOT NULL, FOREIGN KEY (tag_id) REFERENCES tags(tag_id) ); -CREATE TABLE tags_synonyms ( - name character varying(64) NOT NULL, - changeto character varying(64) NOT NULL -); CREATE TABLE telegram ( user_id INTEGER, tg_id numeric NOT NULL, -- cgit v1.2.3