From 6d4c59353f0438daaed524d33750735575e383ab Mon Sep 17 00:00:00 2001 From: Lam Voong Date: Tue, 19 May 2020 14:24:02 -0700 Subject: [PATCH] DRYD-835: Update UOC migration script: Updated comments --- .../db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql b/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql index 44c5a80ec..7312d6dfd 100644 --- a/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql +++ b/src/main/resources/db/postgresql/upgrade/6.0.0/post-init/05_uoc.sql @@ -31,7 +31,7 @@ public.uoc_common ============> MIGRATION NEEDED: various fields updated to repeatable fields/groups. public.uoc_common_methodlist => NO MIGRATION NEEDED. - public.usergroup =============> MIGRATION NEEDED: 3 new fields added; MIGRATE userType to userInstitutionRole + public.usergroup =============> MIGRATION NEEDED: 2 new fields added; MIGRATE userType to userInstitutionRole -- Version 5.2 uoc_common table description and migration note: @@ -416,7 +416,6 @@ $$; usertype | character varying | | MIGRATE to userinstitutionrole user | character varying | | NO CHANGE userinstitution | character varying | | NEW COLUMN - userrole | character varying | | NEW COLUMN userinstitutionrole | character varying | | NEW; MIGRATE from usertype useruocrole | character varying | | NEW COLUMN Indexes: @@ -426,7 +425,7 @@ $$; -- Migration Note: - Three new columns were added for User Role, User Institution Role, and User Use of Collections role. + Two new columns were added for User: Institution Role, and User: Use of Collections role. Instead of re-nameing the userType column to userInstitutionRole, the old column will remain, and the userType data is migrated to userInstitutionRole. */ -- 2.47.3