From 13d005d263df3e0fd2e1db81fa2d033b3178deea Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 30 Jul 2012 15:34:46 -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 60aac17022..02f2861482 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, internal_id, opac_vis TEXT ) + circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id TEXT, 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 9e5d79f338..c2c487d387 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, internal_id, opac_vis TEXT ) + circ_as TEXT, amessage TEXT, note TEXT, pnote TEXT, internal_id TEXT, opac_vis TEXT ) LOOP attr_set.import_error := NULL; -- 2.11.0