aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2023-01-24 00:14:24 +0300
committerGravatar Vitaly Takmazov2023-01-24 00:14:24 +0300
commit93b812e56856a9426c681d5a783e089bcee3210d (patch)
tree77b6a2a2f473423d5ceacb94eb29dde33376dba2 /src/main/resources/db/specific
parentf2a68aae4cff4bce428720c97eef1cb25d821ec7 (diff)
user_services: increase regid field to fit web tokens
Diffstat (limited to 'src/main/resources/db/specific')
-rw-r--r--src/main/resources/db/specific/h2/V1.22__schema.sql2
-rw-r--r--src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql1
-rw-r--r--src/main/resources/db/specific/sqlite/V1.22__schema.sql2
3 files changed, 3 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 46d39ac6..e616c943 100644
--- a/src/main/resources/db/specific/h2/V1.22__schema.sql
+++ b/src/main/resources/db/specific/h2/V1.22__schema.sql
@@ -3,7 +3,7 @@ SET DB_CLOSE_DELAY -1;
CREATE MEMORY TABLE "PUBLIC"."ANDROID"(
"USER_ID" INTEGER NOT NULL,
- "REGID" VARCHAR(255) NOT NULL,
+ "REGID" VARCHAR(1024) NOT NULL,
"TS" TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANDROID;
diff --git a/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql b/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql
new file mode 100644
index 00000000..ccdefad2
--- /dev/null
+++ b/src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql
@@ -0,0 +1 @@
+ALTER TABLE user_services ALTER COLUMN regid TYPE character varying(1024)
diff --git a/src/main/resources/db/specific/sqlite/V1.22__schema.sql b/src/main/resources/db/specific/sqlite/V1.22__schema.sql
index 8685cbb7..072b2a1a 100644
--- a/src/main/resources/db/specific/sqlite/V1.22__schema.sql
+++ b/src/main/resources/db/specific/sqlite/V1.22__schema.sql
@@ -1,6 +1,6 @@
CREATE TABLE android (
user_id INTEGER NOT NULL,
- regid character varying(255) NOT NULL,
+ regid character varying(1024) NOT NULL,
ts timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
FOREIGN KEY (user_id) REFERENCES users(id),
UNIQUE (regid)