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-h2.sql | 14 --------------
 1 file changed, 14 deletions(-)

(limited to 'src/main/resources/schema-h2.sql')

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,
-- 
cgit v1.2.3

