From b5af952dac548fa31e69b462e7072d8dfb75996d Mon Sep 17 00:00:00 2001 From: erickson Date: Wed, 15 Apr 2009 15:49:51 +0000 Subject: [PATCH] if we keep the li around, reset some other fields git-svn-id: svn://svn.open-ils.org/ILS/trunk@12879 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/support-scripts/test-scripts/purge_po.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/support-scripts/test-scripts/purge_po.sql b/Open-ILS/src/support-scripts/test-scripts/purge_po.sql index 8169102db6..8dced970fc 100644 --- a/Open-ILS/src/support-scripts/test-scripts/purge_po.sql +++ b/Open-ILS/src/support-scripts/test-scripts/purge_po.sql @@ -20,7 +20,7 @@ BEGIN DELETE FROM acq.lineitem_attr WHERE lineitem = li.id; DELETE from acq.lineitem WHERE id = li.id; ELSE - UPDATE acq.lineitem SET purchase_order = NULL WHERE id = li.id; + UPDATE acq.lineitem SET purchase_order = NULL, eg_bib_id = NULL, state = 'new' WHERE id = li.id; END IF; END LOOP; -- 2.11.0