From ab23f660bdd18d52e31367b66744410cdf321744 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 1 May 2015 16:06:14 -0400 Subject: [PATCH] Forward-port 2.8.0 to 2.8.1 SQL upgrade Signed-off-by: Bill Erickson --- .../2.8.0-2.8.1-upgrade-db.sql | 35 +++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.8.0-2.8.1-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.8.0-2.8.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.8.0-2.8.1-upgrade-db.sql new file mode 100644 index 0000000000..4cdda1232e --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.8.0-2.8.1-upgrade-db.sql @@ -0,0 +1,35 @@ +--Upgrade Script for 2.8.0 to 2.8.1 +\set eg_version '''2.8.1''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.8.1', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('0916', :eg_version); + +CREATE OR REPLACE FUNCTION actor.convert_usr_note_to_message () RETURNS TRIGGER AS $$ +DECLARE + sending_ou INTEGER; +BEGIN + IF NEW.pub THEN + IF TG_OP = 'UPDATE' THEN + IF OLD.pub = TRUE THEN + RETURN NEW; + END IF; + END IF; + + SELECT INTO sending_ou aw.owning_lib + FROM auditor.get_audit_info() agai + JOIN actor.workstation aw ON (aw.id = agai.eg_ws); + IF sending_ou IS NULL THEN + SELECT INTO sending_ou home_ou + FROM actor.usr + WHERE id = NEW.creator; + END IF; + INSERT INTO actor.usr_message (usr, title, message, sending_lib) + VALUES (NEW.usr, NEW.title, NEW.value, sending_ou); + END IF; + + RETURN NEW; +END; +$$ LANGUAGE PLPGSQL; + +COMMIT; -- 2.43.2