BEGIN; INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1045', :eg_version); -- csharp/berick/gmcharlt ALTER TABLE action.transit_copy ADD COLUMN cancel_time TIMESTAMPTZ; -- change "abort" to "cancel" in stock perm descriptions UPDATE permission.perm_list SET description = 'Allow a user to cancel a copy transit if the user is at the transit destination or source' WHERE code = 'ABORT_TRANSIT' AND description = 'Allow a user to abort a copy transit if the user is at the transit destination or source'; UPDATE permission.perm_list SET description = 'Allow a user to cancel a copy transit if the user is not at the transit source or dest' WHERE code = 'ABORT_REMOTE_TRANSIT' AND description = 'Allow a user to abort a copy transit if the user is not at the transit source or dest'; UPDATE permission.perm_list SET description = 'Allows a user to cancel a transit on a copy with status of LOST' WHERE code = 'ABORT_TRANSIT_ON_LOST' AND description = 'Allows a user to abort a transit on a copy with status of LOST'; UPDATE permission.perm_list SET description = 'Allows a user to cancel a transit on a copy with status of MISSING' WHERE code = 'ABORT_TRANSIT_ON_MISSING' AND description = 'Allows a user to abort a transit on a copy with status of MISSING'; COMMIT;