LP#1715767: remove privacy waiver entries when referenced actor.usr rows are deleted

Signed-off-by: Jeff Davis <jdavis@sitka.bclibraries.ca>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>

diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql
index c97afd7..0572543 100644 (file)
--- 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 6b2b7b8..e79cbec 100644 (file)
--- 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,