From c0bd8cd2c410fe89ee584dbeb1874e4d2ce5d963 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Thu, 17 Nov 2011 16:37:56 -0500 Subject: [PATCH] More fix lp851000. Add an upgrade script to delete circ.lost_immediately_available from the database. Signed-off-by: Jason Stephenson --- .../XXXX.data.circ_lost_immediately_available_delete.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_lost_immediately_available_delete.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_lost_immediately_available_delete.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_lost_immediately_available_delete.sql new file mode 100644 index 0000000000..a242974134 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_lost_immediately_available_delete.sql @@ -0,0 +1,12 @@ +BEGIN; + +DELETE FROM actor.org_unit_setting +WHERE name = 'circ.lost_immediately_available'; + +DELETE FROM config.org_unit_setting_type_log +WHERE field_name = 'circ.lost_immediately_available'; + +DELETE FROM config.org_unit_setting_type +WHERE name = 'circ.lost_immediately_available'; + +COMMIT; -- 2.11.0