From be0e7e2cd4139d6e1e3d9a42440cf04296e96dcb Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Mon, 19 Nov 2018 15:53:00 -0800 Subject: [PATCH] LP#1715767: remove privacy waiver entries when referenced actor.usr rows are deleted Signed-off-by: Jeff Davis Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- .../src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index c97afd7974..0572543768 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -1267,7 +1267,7 @@ $FUNC$ LANGUAGE PLPGSQL; CREATE TABLE actor.usr_privacy_waiver ( id BIGSERIAL PRIMARY KEY, - usr BIGINT NOT NULL REFERENCES actor.usr(id) DEFERRABLE INITIALLY DEFERRED, + usr BIGINT NOT NULL REFERENCES actor.usr(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, name TEXT NOT NULL, place_holds BOOL DEFAULT FALSE, pickup_holds BOOL DEFAULT FALSE, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql index 6b2b7b8a78..e79cbec15d 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql @@ -4,7 +4,7 @@ INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); CREATE TABLE actor.usr_privacy_waiver ( id BIGSERIAL PRIMARY KEY, - usr BIGINT NOT NULL REFERENCES actor.usr(id) DEFERRABLE INITIALLY DEFERRED, + usr BIGINT NOT NULL REFERENCES actor.usr(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, name TEXT NOT NULL, place_holds BOOL DEFAULT FALSE, pickup_holds BOOL DEFAULT FALSE, -- 2.43.2