From d9910bb80513f3db01df932f0fa2d44875c466f5 Mon Sep 17 00:00:00 2001 From: scottmk Date: Fri, 20 Mar 2009 15:21:15 +0000 Subject: [PATCH] Add ON DELETE CASCADE to distribution_formula_entry.formula git-svn-id: svn://svn.open-ils.org/ILS/trunk@12628 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 6b82abade4..565ac802d2 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -285,6 +285,7 @@ CREATE TABLE acq.distribution_formula ( CREATE TABLE acq.distribution_formula_entry ( id SERIAL PRIMARY KEY, formula INTEGER NOT NULL REFERENCES acq.distribution_formula(id) + ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, position INTEGER NOT NULL, item_count INTEGER NOT NULL, -- 2.11.0