From 1311cddb157a70de25b48a1ac8d76a1940fe3e22 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Sun, 29 Jul 2012 22:10:38 -0400 Subject: [PATCH] vandelay copy overlay; DB Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/999.functions.global.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay_item_overlay.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index a5214dfe36..60aac17022 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -1794,7 +1794,7 @@ BEGIN FROM oils_xpath_table( 'id', 'marc', 'vandelay.queued_bib_record', xpath, 'id = ' || import_id ) AS t( id INT, ol TEXT, clib TEXT, cn TEXT, cnum TEXT, cs TEXT, cl TEXT, circ TEXT, dep TEXT, dep_amount TEXT, r TEXT, hold TEXT, pr TEXT, bc TEXT, circ_mod TEXT, - circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, opac_vis TEXT, internal_id TEXT ) + circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id, opac_vis TEXT ) LOOP attr_set.import_error := NULL; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay_item_overlay.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay_item_overlay.sql index 22f6af014a..9e5d79f338 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay_item_overlay.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay_item_overlay.sql @@ -288,7 +288,7 @@ BEGIN FROM oils_xpath_table( 'id', 'marc', 'vandelay.queued_bib_record', xpath, 'id = ' || import_id ) AS t( id INT, ol TEXT, clib TEXT, cn TEXT, cnum TEXT, cs TEXT, cl TEXT, circ TEXT, dep TEXT, dep_amount TEXT, r TEXT, hold TEXT, pr TEXT, bc TEXT, circ_mod TEXT, - circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, opac_vis TEXT, internal_id TEXT ) + circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id, opac_vis TEXT ) LOOP attr_set.import_error := NULL; -- 2.11.0