From 7f8fad09daafd9653eb61fff55c0a1b472036f2a Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 24 Apr 2020 16:33:49 -0400 Subject: [PATCH] lp1846354 set existing user messages to public before adding new ones; also, remove a lingering reference to alert_message in Storage/CDBI/actor.pm Signed-off-by: Jason Etheridge Signed-off-by: Mike Rylander --- Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm | 2 +- .../src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm index a4047f794e..4db37c2b0f 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm @@ -17,7 +17,7 @@ __PACKAGE__->columns( Essential => qw/usrname email first_given_name ident_type2 ident_value2 net_access_level alias photo_url create_date expire_date credit_forward_balance super_user usrgroup passwd card last_xact_id - standing barred profile prefix suffix alert_message + standing barred profile prefix suffix day_phone evening_phone other_phone mailing_address claims_never_checked_out_count last_update_time/ ); 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 f798d50014..728147bbf8 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 @@ -13,6 +13,10 @@ AS SELECT * FROM actor.usr_message WHERE pub AND NOT deleted; ALTER TABLE actor.usr_standing_penalty ADD COLUMN usr_message BIGINT REFERENCES actor.usr_message(id); +-- alright, let's set all existing user messages to public + +UPDATE actor.usr_message SET pub = TRUE; + -- alright, let's migrate penalty notes to usr_messages and link the messages back to the penalties: CREATE TEMP TABLE XXXX_penalty_notes AS -- 2.11.0