From df28edffa7cc8f6c72ac688472340098f0fd2da3 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 17 Mar 2006 17:35:24 +0000 Subject: [PATCH] adding delete protection to copy and bib records git-svn-id: svn://svn.open-ils.org/ILS/trunk@3389 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 2 ++ Open-ILS/src/sql/Pg/040.schema.asset.sql | 1 + 2 files changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index 139ab76885..cb5c934ce0 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -26,6 +26,8 @@ CREATE TABLE biblio.record_entry ( CREATE INDEX biblio_record_entry_creator_idx ON biblio.record_entry ( creator ); CREATE INDEX biblio_record_entry_editor_idx ON biblio.record_entry ( editor ); CREATE UNIQUE INDEX biblio_record_unique_tcn ON biblio.record_entry (tcn_source,tcn_value) WHERE deleted IS FALSE; +CREATE RULE protect_bib_rec_delete AS ON DELETE TO biblio.record_entry DO INSTEAD UPDATE biblio.record_entry SET deleted = TRUE WHERE OLD.id = biblio.record_entry.id; + CREATE TABLE biblio.record_note ( id BIGSERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 6a9db92427..e8454cae73 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -43,6 +43,7 @@ CREATE TABLE asset.copy ( ); CREATE INDEX cp_cn_idx ON asset.copy (call_number); CREATE INDEX cp_avail_cn_idx ON asset.copy (call_number) WHERE status = 0; +CREATE RULE protect_copy_delete AS ON DELETE TO asset.copy DO INSTEAD UPDATE asset.copy SET deleted = TRUE WHERE OLD.id = asset.copy.id; CREATE TABLE asset.copy_transparency ( id SERIAL PRIMARY KEY, -- 2.43.2