From bbc802a13be65de2d8d59aa5741579b82057f8f1 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sat, 22 Jun 2019 23:15:11 -0400 Subject: [PATCH] use 001 instead of 999 for storing the old openbiblio bibid Signed-off-by: Jason Etheridge --- sql/base/base.sql | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 8ff83f4..8ef5d0c 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1717,7 +1717,7 @@ BEGIN -- l_title_remainder -> 245b -- l_responsibility_stmt -> 245c -- l_topic? -> 650a --- l_bibid -> 999a +-- l_bibid -> 001 RETURN migration_tools.make_stub_bib(y.tag,y.ind1,y.ind2,y.data) @@ -1823,10 +1823,10 @@ FROM ( where l_bibid = x_bibid and nullif(btrim(l_topic5),'') is not null union select - '999' as "l_tag", - 'a' as "l_subfield_cd", - ' ' as "l_ind1_cd", - ' ' as "l_ind2_cd", + '001' as "l_tag", + '' as "l_subfield_cd", + '' as "l_ind1_cd", + '' as "l_ind2_cd", l_bibid as "l_field_data" from export_biblio_tsv where l_bibid = x_bibid -- 1.7.2.5