diff options
| author |  Vitaly Takmazov | 2024-01-31 16:50:01 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2024-02-01 19:18:13 +0300 |
| commit | 5ef424120ed694b1f69daeafaa1454455d13dee2 (patch) | |
| tree | 72c0e5cedcdb5420f2760856c6e762cedf31c6de /src/main/resources/schema-h2.sql | |
| parent | 3cf580867600494615a7bdc9ab43ef0735d5aedb (diff) | |
CI: enable SQLite
* SQLite JDBC driver does not support generated keys feature. So we implement `returningId` helper
* only one connection should be used from connection pooler
* changes made to prevent connection locking
Diffstat (limited to 'src/main/resources/schema-h2.sql')
| -rw-r--r-- | src/main/resources/schema-h2.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql index 7aaee493..5fd7fff8 100644 --- a/src/main/resources/schema-h2.sql +++ b/src/main/resources/schema-h2.sql @@ -114,7 +114,7 @@ CREATE MEMORY TABLE "PUBLIC"."REPLIES"( "USER_ID" INTEGER NOT NULL, "REPLYTO" SMALLINT DEFAULT '0' NOT NULL, "TS" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, - "ATTACH" CHARACTER(3), + "ATTACH" ENUM('jpg', 'mp4', 'png') DEFAULT NULL, "TXT" CHARACTER VARYING NOT NULL, "UPDATED_AT" TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL, "USER_URI" CHARACTER VARYING(255) DEFAULT NULL, @@ -131,7 +131,7 @@ CREATE MEMORY TABLE "PUBLIC"."MESSAGES"( "MAXREPLYID" SMALLINT DEFAULT '0' NOT NULL, "PRIVACY" TINYINT DEFAULT '1' NOT NULL, "READONLY" TINYINT DEFAULT '0' NOT NULL, - "ATTACH" CHARACTER(3), + "ATTACH" ENUM('jpg', 'mp4', 'png') DEFAULT NULL, "PLACE_ID" INTEGER DEFAULT NULL, "LAT" DECIMAL(10, 7) DEFAULT NULL, "LON" DECIMAL(10, 7) DEFAULT NULL, @@ -251,8 +251,6 @@ CREATE MEMORY TABLE "PUBLIC"."USER_SERVICES"( "TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, "SERVICE_TYPE" CHARACTER VARYING(255) DEFAULT 'fcm' NOT NULL ); -ALTER TABLE "PUBLIC"."MESSAGES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_131" CHECK("ATTACH" IN('jpg', 'mp4', 'png')) NOCHECK; -ALTER TABLE "PUBLIC"."REPLIES" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_6C" CHECK("ATTACH" IN('jpg', 'mp4', 'png')) NOCHECK; ALTER TABLE "PUBLIC"."LOGINS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_86" UNIQUE("USER_ID"); ALTER TABLE "PUBLIC"."REACTIONS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_6" UNIQUE("LIKE_ID"); ALTER TABLE "PUBLIC"."SUBSCR_TAGS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_B" UNIQUE("TAG_ID", "SUSER_ID"); |