]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Modify a pre-delete trigger, and add a post-delete trigger, to ensure that
authorscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 24 Sep 2009 13:58:03 +0000 (13:58 +0000)
committerscottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 24 Sep 2009 13:58:03 +0000 (13:58 +0000)
commit08e86ca59adf362d5f663f9dac83529942c97ac9
tree323393eab5d822c84c5ab04eba1e58861600729a
parentf292942f1c677569190f069fdcaa918d04a423cc
Modify a pre-delete trigger, and add a post-delete trigger, to ensure that
(1) We don't delete/archive a circulation if there are any undeleted renewals
for it, and (2) when we delete/archive a renewal, we also delete/archive
all its predecessors.

Also: expand the view action.circulation to include four new columns.

M    Open-ILS/src/sql/Pg/090.schema.action.sql
M    Open-ILS/src/sql/Pg/002.schema.config.sql
A    Open-ILS/src/sql/Pg/upgrade/0021.schema.triggers-for-deleting-circs.sql

git-svn-id: svn://svn.open-ils.org/ILS/trunk@14145 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/upgrade/0021.schema.triggers-for-deleting-circs.sql [new file with mode: 0644]