From 4c8bb89d8840fb2eacc092852388080a940ccc11 Mon Sep 17 00:00:00 2001 From: Ray Lee Date: Fri, 15 Mar 2024 20:45:21 -0400 Subject: [PATCH] Add SQL to upgrade acl_object_identity table for 8.0. --- .../src/main/resources/db/postgresql/authentication.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/services/authentication/pstore/src/main/resources/db/postgresql/authentication.sql b/services/authentication/pstore/src/main/resources/db/postgresql/authentication.sql index 210959dbf..d8c645f5a 100644 --- a/services/authentication/pstore/src/main/resources/db/postgresql/authentication.sql +++ b/services/authentication/pstore/src/main/resources/db/postgresql/authentication.sql @@ -16,6 +16,8 @@ ALTER TABLE users ADD COLUMN IF NOT EXISTS salt VARCHAR(128); UPDATE users SET passwd = concat('{SHA-256}', '{', salt, '}', passwd) WHERE left(passwd, 1) <> '{'; +-- Create tokens table required in 8.0 + CREATE TABLE IF NOT EXISTS tokens ( id VARCHAR(128) NOT NULL PRIMARY KEY, account_csid VARCHAR(128) NOT NULL, @@ -25,3 +27,7 @@ CREATE TABLE IF NOT EXISTS tokens ( created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP ); + +-- Upgrade older acl_object_identity tables to 8.0 + +ALTER TABLE acl_object_identity ALTER COLUMN object_id_identity TYPE VARCHAR (36); -- 2.47.3