X-Git-Url: https://git.evergreen-ils.org/?p=Evergreen.git;a=blobdiff_plain;f=Open-ILS%2Fsrc%2Fsql%2FPg%2F005.schema.actors.sql;h=0572543768319d2cfc090ca65715874fa3599b85;hp=c97afd79744ae377e677f45fa89b69665429a4dd;hb=be0e7e2cd4139d6e1e3d9a42440cf04296e96dcb;hpb=c7727d4966d63a14419c2a8e9df5cabf11f76ee3

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,