diff options
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"( |