3 -- Add new column status_changed_date to asset.copy, with trigger to maintain it
4 -- Add corresponding new column to auditor.asset_copy_history
6 INSERT INTO config.upgrade_log (version) VALUES ('0039'); -- mck9
9 ADD COLUMN status_changed_time TIMESTAMPTZ;
11 ALTER TABLE auditor.asset_copy_history
12 ADD COLUMN status_changed_time TIMESTAMPTZ;
14 CREATE OR REPLACE FUNCTION asset.acp_status_changed()
17 IF NEW.status <> OLD.status THEN
18 NEW.status_changed_time := now();
24 CREATE TRIGGER acp_status_changed_trig
25 BEFORE UPDATE ON asset.copy
26 FOR EACH ROW EXECUTE PROCEDURE asset.acp_status_changed();