1 -- Evergreen DB patch 0540.schema.missing_serial_unit_triggers.sql
3 -- Bring serial.unit into line with asset.copy
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('0540', :eg_version);
11 CREATE TRIGGER sunit_status_changed_trig
12 BEFORE UPDATE ON serial.unit
13 FOR EACH ROW EXECUTE PROCEDURE asset.acp_status_changed();
15 SELECT auditor.create_auditor ( 'serial', 'unit' );
16 CREATE INDEX aud_serial_unit_hist_creator_idx ON auditor.serial_unit_history ( creator );
17 CREATE INDEX aud_serial_unit_hist_editor_idx ON auditor.serial_unit_history ( editor );