From f9b26987e5dc55dc40addcc5f6a4547ce8fc8bf2 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Thu, 6 Aug 2020 13:26:20 -0400 Subject: [PATCH] lp1846354 update auditors fixes updating patrons and allowing them to login one consequence of this is that old alert_messages in the auditor will be deleted Signed-off-by: Jason Etheridge Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation index a109ac2c01..5da0cac0e5 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation @@ -209,8 +209,9 @@ do $$ begin ) = 0, 'failed migrating to actor.usr_standing_penalty'; end; $$; --- extends to auditor.actor_usr_lifecycle +-- WARNING: we're going to lose the history of alert_message ALTER TABLE actor.usr DROP COLUMN alert_message CASCADE; +SELECT auditor.update_auditors(); -- fun part where we migrate actor.usr_notes as penalties to preserve -- their creator, and then the private ones to private user messages. -- 2.11.0