Drop unused tables

6 files changed, 2 insertions, 74 deletions

diff --git a/src/main/resources/db/migration/V1.40__drop_images.sql b/src/main/resources/db/migration/V1.40__drop_images.sql
new file mode 100644
index 00000000..69c762c1
--- /dev/null
+++ b/src/main/resources/db/migration/V1.40__drop_images.sql
@@ -0,0 +1 @@
+DROP TABLE images
diff --git a/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql b/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql
new file mode 100644
index 00000000..181fa48a
--- /dev/null
+++ b/src/main/resources/db/migration/V1.41__drop_tags_synonyms.sql
@@ -0,0 +1 @@
+DROP TABLE tags_synonyms
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index a02804d5..c2ecd4b7 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -34,16 +34,6 @@ CREATE MEMORY TABLE "PUBLIC"."AUTH"(
     "AUTHCODE" CHARACTER(8) NOT NULL,
     "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
-CREATE MEMORY TABLE "PUBLIC"."IMAGES"(
-    "MID" INTEGER NOT NULL,
-    "RID" INTEGER NOT NULL,
-    "THUMB" INTEGER NOT NULL,
-    "SMALL" INTEGER NOT NULL,
-    "MEDIUM" INTEGER NOT NULL,
-    "HEIGHT" INTEGER NOT NULL,
-    "WIDTH" INTEGER NOT NULL
-);
-ALTER TABLE "PUBLIC"."IMAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_8" PRIMARY KEY("MID", "RID");
 CREATE MEMORY TABLE "PUBLIC"."MESSAGES_PROPERTIES"(
     "MESSAGE_ID" INTEGER NOT NULL,
     "REPLY_ID" SMALLINT NOT NULL,
@@ -204,10 +194,6 @@ ALTER TABLE "PUBLIC"."TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_27" PRIMARY KEY(
 CREATE MEMORY TABLE "PUBLIC"."TAGS_IGNORE"(
     "TAG_ID" INTEGER NOT NULL
 );
-CREATE MEMORY TABLE "PUBLIC"."TAGS_SYNONYMS"(
-    "NAME" CHARACTER(64) NOT NULL,
-    "CHANGETO" CHARACTER(64) NOT NULL
-);
 CREATE MEMORY TABLE "PUBLIC"."TELEGRAM"(
     "USER_ID" INTEGER DEFAULT NULL,
     "TG_ID" BIGINT NOT NULL,
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index 0f6321fd..58192261 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -132,25 +132,6 @@ CREATE TABLE `followers` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `images`
---
-
-DROP TABLE IF EXISTS `images`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `images` (
-  `mid` int(10) unsigned NOT NULL,
-  `rid` int(10) unsigned NOT NULL,
-  `thumb` int(10) unsigned NOT NULL,
-  `small` int(10) unsigned NOT NULL,
-  `medium` int(10) unsigned NOT NULL,
-  `height` int(10) unsigned NOT NULL,
-  `width` int(10) unsigned NOT NULL,
-  PRIMARY KEY (`mid`,`rid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `jids`
 --
 
@@ -539,19 +520,6 @@ CREATE TABLE `tags_ignore` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `tags_synonyms`
---
-
-DROP TABLE IF EXISTS `tags_synonyms`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `tags_synonyms` (
-  `name` char(64) NOT NULL,
-  `changeto` char(64) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `telegram`
 --
 
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,
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 71539577..aafc159d 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -87,16 +87,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 bigint,
     jid character varying(64) NOT NULL,
@@ -229,10 +219,6 @@ CREATE TABLE tags_ignore (
     tag_id integer 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 bigint,
     tg_id numeric NOT NULL,