]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0131.schema.serials.protect-delete.sql
LP#1178377: Make bib source optional element from unapi.bre
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0131.schema.serials.protect-delete.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0131'); -- dbs
4
5 CREATE RULE protect_mfhd_delete AS ON DELETE TO serial.record_entry DO INSTEAD UPDATE serial.record_entry SET deleted = true WHERE old.id = serial.record_entry.id;
6
7 COMMIT;