-- Evergreen DB patch 0619.schema.au_last_update_time.sql BEGIN; -- check whether patch can be applied SELECT evergreen.upgrade_deps_block_check('0619', :eg_version); -- Add new column last_update_time 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_time TIMESTAMPTZ; ALTER TABLE auditor.actor_usr_history ADD COLUMN last_update_time TIMESTAMPTZ; CREATE OR REPLACE FUNCTION actor.au_updated() RETURNS TRIGGER AS $$ BEGIN NEW.last_update_time := now(); RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER au_update_trig BEFORE INSERT OR UPDATE ON actor.usr FOR EACH ROW EXECUTE PROCEDURE actor.au_updated(); COMMIT;