aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/schema-h2.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/schema-h2.sql')
-rw-r--r--src/main/resources/schema-h2.sql14
1 files changed, 0 insertions, 14 deletions
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,