diff options
| author |  Vitaly Takmazov | 2023-01-06 17:06:43 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-01-07 04:04:26 +0300 |
| commit | c5e6a65323a7558ca0322ec810a9dff847968730 (patch) | |
| tree | 037ff0ac5a2eb8224c3c5bc440484ffcef1cd0e9 /src/main/resources/db/specific/h2 | |
| parent | 02e31496ee0ff099dd2a0fe0b1754acee6f2263a (diff) | |
Initial SQLite schema (work in progress)
Diffstat (limited to 'src/main/resources/db/specific/h2')
| -rw-r--r-- | src/main/resources/db/specific/h2/V1.22__schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/main/resources/db/specific/h2/V1.22__schema.sql b/src/main/resources/db/specific/h2/V1.22__schema.sql index dcb92374..de6946e8 100644 --- a/src/main/resources/db/specific/h2/V1.22__schema.sql +++ b/src/main/resources/db/specific/h2/V1.22__schema.sql @@ -169,7 +169,7 @@ 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, "LANG" ENUM('en', 'ru', 'fr', 'fa', '__') DEFAULT '__' NOT NULL, - "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, + "TS" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL, "REPLIES" SMALLINT DEFAULT '0' NOT NULL, "MAXREPLYID" SMALLINT DEFAULT '0' NOT NULL, "PRIVACY" TINYINT DEFAULT '1' NOT NULL, @@ -181,7 +181,7 @@ 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(6) DEFAULT CURRENT_TIMESTAMP NOT NULL + "UPDATED" TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP NOT NULL ); ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_13" PRIMARY KEY("MESSAGE_ID"); -- 0 +/- SELECT COUNT(*) FROM PUBLIC.MESSAGES; |