3 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1045', :eg_version); -- csharp/berick/gmcharlt
5 ALTER TABLE action.transit_copy
6 ADD COLUMN cancel_time TIMESTAMPTZ;
8 -- change "abort" to "cancel" in stock perm descriptions
9 UPDATE permission.perm_list
10 SET description = 'Allow a user to cancel a copy transit if the user is at the transit destination or source'
11 WHERE code = 'ABORT_TRANSIT'
12 AND description = 'Allow a user to abort a copy transit if the user is at the transit destination or source';
13 UPDATE permission.perm_list
14 SET description = 'Allow a user to cancel a copy transit if the user is not at the transit source or dest'
15 WHERE code = 'ABORT_REMOTE_TRANSIT'
16 AND description = 'Allow a user to abort a copy transit if the user is not at the transit source or dest';
17 UPDATE permission.perm_list
18 SET description = 'Allows a user to cancel a transit on a copy with status of LOST'
19 WHERE code = 'ABORT_TRANSIT_ON_LOST'
20 AND description = 'Allows a user to abort a transit on a copy with status of LOST';
21 UPDATE permission.perm_list
22 SET description = 'Allows a user to cancel a transit on a copy with status of MISSING'
23 WHERE code = 'ABORT_TRANSIT_ON_MISSING'
24 AND description = 'Allows a user to abort a transit on a copy with status of MISSING';