From dde8db5c8aa7746def652e5285452f6a387ed4ed Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 5 Aug 2011 06:58:07 -0400 Subject: [PATCH] upgrade script for actor.usr.last_update_date Signed-off-by: Jason Etheridge Signed-off-by: Thomas Berezansky --- .../Pg/upgrade/XXXX.schema.au_last_update_date.sql | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql new file mode 100644 index 0000000000..3b792913ee --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.au_last_update_date.sql @@ -0,0 +1,28 @@ +-- Evergreen DB patch XXXX.schema.au_last_update_date.sql +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +-- Add new column last_update_date to actor.usr, with trigger to maintain it +-- Add corresponding new column to auditor.actor_usr_history + +ALTER TABLE actor.usr + ADD COLUMN last_update_date TIMESTAMPTZ; + +ALTER TABLE auditor.actor_usr_history + ADD COLUMN last_update_date TIMESTAMPTZ; + +CREATE OR REPLACE FUNCTION actor.au_updated() +RETURNS TRIGGER AS $$ +BEGIN + NEW.last_update_date := now(); + RETURN NEW; +END; +$$ LANGUAGE plpgsql; + +CREATE TRIGGER au_update_trig + BEFORE UPDATE ON actor.usr + FOR EACH ROW EXECUTE PROCEDURE actor.au_updated(); + +COMMIT; -- 2.11.0