From 38dadde8877b56f52d38536001945e7e3676f3dc Mon Sep 17 00:00:00 2001
From: Jane Sandberg <sandbej@linnbenton.edu>
Date: Tue, 5 Jan 2021 13:27:05 -0800
Subject: [PATCH] LP1800871: small correction to upgrade script

Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu>
Signed-off-by: Jason Boyer <JBoyer@equinoxOLI.org>
---
 Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql
index e1ed27d373..fe706e7ef7 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql
@@ -2,7 +2,7 @@ BEGIN;
 
 -- SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version);
 
-INSERT INTO config.xml_transform (name,namespace_uri,prefix,xslt) VALUES ('mads21','http://www.loc.gov/mads/v2','mads21',$XSLT$<?xml version="1.0" encoding="UTF-8"?>
+UPDATE config.xml_transform SET xslt=$XSLT$<?xml version="1.0" encoding="UTF-8"?>
 <xsl:stylesheet version="1.0" xmlns:mads="http://www.loc.gov/mads/v2"
 	xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:marc="http://www.loc.gov/MARC21/slim"
 	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="marc">
@@ -1626,6 +1626,6 @@ INSERT INTO config.xml_transform (name,namespace_uri,prefix,xslt) VALUES ('mads2
 		</xsl:choose>
 	</xsl:template>
 	<xsl:template match="*"/>
-</xsl:stylesheet>$XSLT$);
+</xsl:stylesheet>$XSLT$ WHERE name = 'mads21';
 
 COMMIT;
-- 
2.11.0