diff options
| author |  Vitaly Takmazov | 2023-02-03 00:31:50 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-02-03 03:39:43 +0300 |
| commit | 17aa96df5776812e2b2fb212b071a821685c9598 (patch) | |
| tree | fd26d5fc9a961d88d64bc5a8cab1669e5b6bd7d1 /src/main/resources/schema-h2.sql | |
| parent | ed8f4b3397219c3e224504def022e5b3535c6773 (diff) | |
Drop unused tables
Diffstat (limited to 'src/main/resources/schema-h2.sql')
| -rw-r--r-- | src/main/resources/schema-h2.sql | 14 |
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, |