diff options
| author |  Vitaly Takmazov | 2023-02-03 06:39:25 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-02-03 06:39:25 +0300 |
| commit | 89f20b0ff36c8413adc2aa9e3c5226ae2eed2101 (patch) | |
| tree | fe56fa9f8de597ff313c334b69ffafe5adf0b95d /src/main/resources/schema-h2.sql | |
| parent | 73b8c2dc544df207d8c7b9e36d20955ff1d88577 (diff) | |
messages_txt -> messages
Diffstat (limited to 'src/main/resources/schema-h2.sql')
| -rw-r--r-- | src/main/resources/schema-h2.sql | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql index 58ce9219..08a63839 100644 --- a/src/main/resources/schema-h2.sql +++ b/src/main/resources/schema-h2.sql @@ -121,13 +121,6 @@ CREATE MEMORY TABLE "PUBLIC"."REPLIES"( "HTML" TINYINT DEFAULT '0' NOT NULL ); CREATE INDEX "PUBLIC"."REPLY_URI_INDEX" ON "PUBLIC"."REPLIES"("REPLY_URI" NULLS FIRST); -CREATE MEMORY TABLE "PUBLIC"."MESSAGES_TXT"( - "MESSAGE_ID" INTEGER NOT NULL, - "REPLIESBY" CHARACTER VARYING(96) DEFAULT NULL, - "TXT" CHARACTER VARYING NOT NULL, - "UPDATED_AT" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL -); -ALTER TABLE "PUBLIC"."MESSAGES_TXT" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_3E" PRIMARY KEY("MESSAGE_ID"); CREATE MEMORY TABLE "PUBLIC"."MESSAGES"( "MESSAGE_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) DEFAULT ON NULL NOT NULL, "USER_ID" INTEGER NOT NULL, @@ -144,7 +137,10 @@ CREATE MEMORY TABLE "PUBLIC"."MESSAGES"( "POPULAR" TINYINT DEFAULT '0' NOT NULL, "HIDDEN" TINYINT DEFAULT '0' NOT NULL, "LIKES" SMALLINT DEFAULT '0' NOT NULL, - "UPDATED" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL + "UPDATED" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL, + "REPLIESBY" CHARACTER VARYING(96) DEFAULT NULL, + "TXT" CHARACTER VARYING NOT NULL, + "UPDATED_AT" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL ); ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_13" PRIMARY KEY("MESSAGE_ID"); CREATE MEMORY TABLE "PUBLIC"."VK"( |