diff options
4 files changed, 4 insertions, 3 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) 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`) |