From 93b812e56856a9426c681d5a783e089bcee3210d Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Tue, 24 Jan 2023 00:14:24 +0300
Subject: user_services: increase regid field to fit web tokens

---
 src/main/resources/db/specific/h2/V1.22__schema.sql             | 2 +-
 src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql | 1 +
 src/main/resources/db/specific/sqlite/V1.22__schema.sql         | 2 +-
 src/test/resources/db/specific/mariadb/V1.22__schema.sql        | 2 +-
 4 files changed, 4 insertions(+), 3 deletions(-)
 create mode 100644 src/main/resources/db/specific/postgresql/V1.36__web_tokens.sql

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)
diff --git a/src/test/resources/db/specific/mariadb/V1.22__schema.sql b/src/test/resources/db/specific/mariadb/V1.22__schema.sql
index 450bc3a7..d767b23b 100644
--- a/src/test/resources/db/specific/mariadb/V1.22__schema.sql
+++ b/src/test/resources/db/specific/mariadb/V1.22__schema.sql
@@ -24,7 +24,7 @@ DROP TABLE IF EXISTS `android`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `android` (
   `user_id` int(10) unsigned NOT NULL,
-  `regid` char(255) NOT NULL,
+  `regid` char(1024) NOT NULL,
   `ts` timestamp NOT NULL DEFAULT current_timestamp(),
   UNIQUE KEY `regid` (`regid`),
   KEY `user_id` (`user_id`)
-- 
cgit v1.2.3