Bugzilla – Attachment 20178 Details for
Bug 10550
Fix database typo wthdrawn
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10550 - Fix database typo wthdrawn
Bug-10550---Fix-database-typo-wthdrawn.patch (text/plain), 239.32 KB, created by
Kyle M Hall (khall)
on 2013-08-08 17:16:26 UTC
(
hide
)
Description:
Bug 10550 - Fix database typo wthdrawn
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2013-08-08 17:16:26 UTC
Size:
239.32 KB
patch
obsolete
>From 2b762ad3482600ef951dfd28b9866dd9812f5795 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Mon, 8 Jul 2013 12:05:46 -0400 >Subject: [PATCH] Bug 10550 - Fix database typo wthdrawn > >This patch updates the wthdrawn field in items and deleteditems to be >withdrawn instead. No functional changes are made. >--- > C4/Circulation.pm | 12 ++++---- > C4/HoldsQueue.pm | 2 +- > C4/ILSDI/Utility.pm | 2 +- > C4/Items.pm | 20 ++++++++-------- > C4/Reserves.pm | 2 +- > C4/SIP/ILS/Transaction/Checkin.pm | 2 +- > C4/Search.pm | 16 ++++++------ > C4/XSLT.pm | 4 +- > catalogue/moredetail.pl | 2 +- > catalogue/updateitem.pl | 8 +++--- > circ/pendingreserves.pl | 2 +- > circ/reserveratios.pl | 2 +- > circ/returns.pl | 2 +- > docs/opac/OpacHiddenItems.txt | 2 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > installer/data/Pg/kohastructure.sql | 4 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > installer/data/mysql/de-DE/optional/auth_val.sql | 2 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../mandatory/unimarc_framework_DEFAULT.sql | 2 +- > installer/data/mysql/en/optional/auth_val.sql | 2 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../mandatory/unimarc_framework_DEFAULT.sql | 2 +- > installer/data/mysql/es-ES/optional/auth_val.sql | 2 +- > .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- > .../Optionnel/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../unimarc/necessari/unimarc_framework.sql | 6 ++-- > installer/data/mysql/it-IT/necessari/auth_val.sql | 2 +- > installer/data/mysql/kohastructure.sql | 4 +- > .../data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 2 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../marcflavour/normarc/Obligatorisk/normarc.sql | 2 +- > .../Valgfritt/normarc_fastadd_framework.sql | 2 +- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- > .../marc21/optional/marc21_fastadd_framework.sql | 2 +- > .../optional/marc21_simple_bib_frameworks.sql | 16 ++++++------ > .../mandatory/unimarc_framework_DEFAULT.sql | 4 +- > installer/data/mysql/pl-PL/optional/auth_val.sql | 2 +- > .../authorised_values_[WITHDRAWN].txt | 2 +- > .../marc21_bibliographic_DEFAULT_local.sql | 2 +- > .../optional/marc21_bibliographic_AR_local.sql | 2 +- > .../optional/marc21_bibliographic_BKS_local.sql | 2 +- > .../optional/marc21_bibliographic_CF_local.sql | 2 +- > .../optional/marc21_bibliographic_FA_local.sql | 2 +- > .../optional/marc21_bibliographic_IR_local.sql | 2 +- > .../optional/marc21_bibliographic_KT_local.sql | 2 +- > .../optional/marc21_bibliographic_SER_local.sql | 2 +- > .../optional/marc21_bibliographic_SR_local.sql | 2 +- > .../optional/marc21_bibliographic_VR_local.sql | 2 +- > .../unimarc_bibliographic_DEFAULT_local_995.sql | 4 +- > ...rc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- > .../authorised_values_[WITHDRAWN].txt | 2 +- > .../marc21_bibliographic_DEFAULT_local.sql | 2 +- > .../optional/marc21_bibliographic_AR_local.sql | 2 +- > .../optional/marc21_bibliographic_BKS_local.sql | 2 +- > .../optional/marc21_bibliographic_CF_local.sql | 2 +- > .../optional/marc21_bibliographic_FA_local.sql | 2 +- > .../optional/marc21_bibliographic_IR_local.sql | 2 +- > .../optional/marc21_bibliographic_KT_local.sql | 2 +- > .../optional/marc21_bibliographic_SER_local.sql | 2 +- > .../optional/marc21_bibliographic_SR_local.sql | 2 +- > .../optional/marc21_bibliographic_VR_local.sql | 2 +- > .../unimarc_bibliographic_DEFAULT_local_995.sql | 4 +- > .../optional/unimarc_bibliographic_AN_local.sql | 4 +- > .../optional/unimarc_bibliographic_AUD_local.sql | 4 +- > .../optional/unimarc_bibliographic_BOOK_local.sql | 4 +- > ...rc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- > .../optional/unimarc_bibliographic_EL_local.sql | 4 +- > .../optional/unimarc_bibliographic_MIN_local.sql | 4 +- > .../optional/unimarc_bibliographic_NOTE_local.sql | 4 +- > .../optional/unimarc_bibliographic_PER_local.sql | 4 +- > .../optional/unimarc_bibliographic_TECH_local.sql | 4 +- > installer/data/mysql/updatedatabase.pl | 25 ++++++++++++++++++++ > koha-tmpl/intranet-tmpl/prog/en/columns.def | 2 +- > .../prog/en/modules/catalogue/detail.tt | 4 +- > .../prog/en/modules/catalogue/moredetail.tt | 14 +++++----- > .../prog/en/modules/catalogue/results.tt | 2 +- > .../prog/en/modules/cataloguing/addbooks.tt | 2 +- > .../opac-tmpl/prog/en/includes/item-status.inc | 2 +- > koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt | 8 +++--- > .../prog/en/modules/opac-results-grouped.tt | 2 +- > .../opac-tmpl/prog/en/modules/opac-results.tt | 2 +- > opac/opac-ISBDdetail.pl | 2 +- > opac/opac-detail.pl | 2 +- > t/db_dependent/HoldsQueue.t | 2 +- > t/db_dependent/Search.t | 4 +- > t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm | 12 ++++---- > t/db_dependent/lib/KohaTest/Items/SetDefaults.pm | 12 ++++---- > tools/inventory.pl | 10 ++++---- > 101 files changed, 246 insertions(+), 221 deletions(-) > >diff --git a/C4/Circulation.pm b/C4/Circulation.pm >index ca66931..66abda7 100644 >--- a/C4/Circulation.pm >+++ b/C4/Circulation.pm >@@ -564,7 +564,7 @@ sub itemissues { > $data->{'borrower'} = $data2->{'borrowernumber'}; > } > else { >- $data->{'date_due'} = ($data->{'wthdrawn'} eq '1') ? 'Cancelled' : 'Available'; >+ $data->{'date_due'} = ($data->{'withdrawn'} eq '1') ? 'Cancelled' : 'Available'; > } > > >@@ -879,7 +879,7 @@ sub CanBookBeIssued { > } > } > } >- if ( $item->{'wthdrawn'} && $item->{'wthdrawn'} > 0 ) >+ if ( $item->{'withdrawn'} && $item->{'withdrawn'} > 0 ) > { > $issuingimpossible{WTHDRAWN} = 1; > } >@@ -1677,7 +1677,7 @@ The book's home branch is a permanent collection. If you have borrowed > this book, you are not allowed to return it. The value is the code for > the book's home branch. > >-=item C<wthdrawn> >+=item C<withdrawn> > > This book has been withdrawn/cancelled. The value should be ignored. > >@@ -1770,8 +1770,8 @@ sub AddReturn { > return ( $doreturn, $messages, $issue, $borrower ); > } > >- if ( $item->{'wthdrawn'} ) { # book has been cancelled >- $messages->{'wthdrawn'} = 1; >+ if ( $item->{'withdrawn'} ) { # book has been cancelled >+ $messages->{'withdrawn'} = 1; > $doreturn = 0 if C4::Context->preference("BlockReturnOfWithdrawnItems"); > } > >@@ -1882,7 +1882,7 @@ sub AddReturn { > # find reserves..... > # if we don't have a reserve with the status W, we launch the Checkreserves routine > my ($resfound, $resrec); >- ($resfound, $resrec, undef) = C4::Reserves::CheckReserves( $item->{'itemnumber'} ) unless ( $item->{'wthdrawn'} ); >+ ($resfound, $resrec, undef) = C4::Reserves::CheckReserves( $item->{'itemnumber'} ) unless ( $item->{'withdrawn'} ); > if ($resfound) { > $resrec->{'ResFound'} = $resfound; > $messages->{'ResFound'} = $resrec; >diff --git a/C4/HoldsQueue.pm b/C4/HoldsQueue.pm >index 2052f09..d0b4dbb 100755 >--- a/C4/HoldsQueue.pm >+++ b/C4/HoldsQueue.pm >@@ -310,7 +310,7 @@ sub GetItemsAvailableToFillHoldRequestsForBib { > $items_query .= "WHERE items.notforloan = 0 > AND holdingbranch IS NOT NULL > AND itemlost = 0 >- AND wthdrawn = 0"; >+ AND withdrawn = 0"; > $items_query .= " AND damaged = 0" unless C4::Context->preference('AllowHoldsOnDamagedItems'); > $items_query .= " AND items.onloan IS NULL > AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0) >diff --git a/C4/ILSDI/Utility.pm b/C4/ILSDI/Utility.pm >index b8c1457..b56e1fa 100644 >--- a/C4/ILSDI/Utility.pm >+++ b/C4/ILSDI/Utility.pm >@@ -93,7 +93,7 @@ sub Availability { > return ( $biblionumber, 'not available', 'Checked out', $location ); > } elsif ( $item->{'itemlost'} ) { > return ( $biblionumber, 'not available', 'Item lost', $location ); >- } elsif ( $item->{'wthdrawn'} ) { >+ } elsif ( $item->{'withdrawn'} ) { > return ( $biblionumber, 'not available', 'Item withdrawn', $location ); > } elsif ( $item->{'damaged'} ) { > return ( $biblionumber, 'not available', 'Item damaged', $location ); >diff --git a/C4/Items.pm b/C4/Items.pm >index 212a9d3..a3f6dc0 100644 >--- a/C4/Items.pm >+++ b/C4/Items.pm >@@ -463,7 +463,7 @@ my %default_values_for_mod_from_marc = ( > stack => undef, > stocknumber => undef, > uri => undef, >- wthdrawn => 0, >+ withdrawn => 0, > ); > > sub ModItemFromMarc { >@@ -1136,7 +1136,7 @@ sub GetItemsByBiblioitemnumber { > $data->{'borrowernumber'} = $data2->{'borrowernumber'}; > } > else { >- # set date_due to blank, so in the template we check itemlost, and wthdrawn >+ # set date_due to blank, so in the template we check itemlost, and withdrawn > $data->{'date_due'} = ''; > } # else > # Find the last 3 people who borrowed this item. >@@ -1939,7 +1939,7 @@ Given an item hashref containing one or more > columns to modify, fix up certain values. > Specifically, set to 0 any passed value > of C<notforloan>, C<damaged>, C<itemlost>, or >-C<wthdrawn> that is either undefined or >+C<withdrawn> that is either undefined or > contains the empty string. > > =cut >@@ -1959,9 +1959,9 @@ sub _do_column_fixes_for_mod { > (not defined $item->{'itemlost'} or $item->{'itemlost'} eq '')) { > $item->{'itemlost'} = 0; > } >- if (exists $item->{'wthdrawn'} and >- (not defined $item->{'wthdrawn'} or $item->{'wthdrawn'} eq '')) { >- $item->{'wthdrawn'} = 0; >+ if (exists $item->{'withdrawn'} and >+ (not defined $item->{'withdrawn'} or $item->{'withdrawn'} eq '')) { >+ $item->{'withdrawn'} = 0; > } > if (exists $item->{'location'} && !exists $item->{'permanent_location'}) { > $item->{'permanent_location'} = $item->{'location'}; >@@ -2035,7 +2035,7 @@ C<items.itemlost> > > =item * > >-C<items.wthdrawn> >+C<items.withdrawn> > > =back > >@@ -2044,7 +2044,7 @@ C<items.wthdrawn> > sub _set_defaults_for_add { > my $item = shift; > $item->{dateaccessioned} ||= C4::Dates->new->output('iso'); >- $item->{$_} ||= 0 for (qw( notforloan damaged itemlost wthdrawn)); >+ $item->{$_} ||= 0 for (qw( notforloan damaged itemlost withdrawn)); > } > > =head2 _koha_new_item >@@ -2076,7 +2076,7 @@ sub _koha_new_item { > notforloan = ?, > damaged = ?, > itemlost = ?, >- wthdrawn = ?, >+ withdrawn = ?, > itemcallnumber = ?, > coded_location_qualifier = ?, > restricted = ?, >@@ -2118,7 +2118,7 @@ sub _koha_new_item { > $item->{'notforloan'}, > $item->{'damaged'}, > $item->{'itemlost'}, >- $item->{'wthdrawn'}, >+ $item->{'withdrawn'}, > $item->{'itemcallnumber'}, > $item->{'coded_location_qualifier'}, > $item->{'restricted'}, >diff --git a/C4/Reserves.pm b/C4/Reserves.pm >index 1f89127..202bd64 100644 >--- a/C4/Reserves.pm >+++ b/C4/Reserves.pm >@@ -1438,7 +1438,7 @@ sub IsAvailableForItemLevelRequest { > $available_per_item = 0 if $item->{itemlost} or > ( $item->{notforloan} > 0 ) or > ($item->{damaged} and not C4::Context->preference('AllowHoldsOnDamagedItems')) or >- $item->{wthdrawn} or >+ $item->{withdrawn} or > $notforloan_per_itemtype; > > >diff --git a/C4/SIP/ILS/Transaction/Checkin.pm b/C4/SIP/ILS/Transaction/Checkin.pm >index 49ce926..db1f102 100644 >--- a/C4/SIP/ILS/Transaction/Checkin.pm >+++ b/C4/SIP/ILS/Transaction/Checkin.pm >@@ -63,7 +63,7 @@ sub do_checkin { > if ($messages->{BadBarcode}) { > $self->alert_type('99'); > } >- if ($messages->{wthdrawn}) { >+ if ($messages->{withdrawn}) { > $self->alert_type('99'); > } > if ($messages->{Wrongbranch}) { >diff --git a/C4/Search.pm b/C4/Search.pm >index aec024b..836a85b 100644 >--- a/C4/Search.pm >+++ b/C4/Search.pm >@@ -1815,7 +1815,7 @@ sub searchResults { > my $onloan_count = 0; > my $longoverdue_count = 0; > my $other_count = 0; >- my $wthdrawn_count = 0; >+ my $withdrawn_count = 0; > my $itemlost_count = 0; > my $hideatopac_count = 0; > my $itembinding_count = 0; >@@ -1902,7 +1902,7 @@ sub searchResults { > # is item on the reserve shelf? > my $reservestatus = ''; > >- unless ($item->{wthdrawn} >+ unless ($item->{withdrawn} > || $item->{itemlost} > || $item->{damaged} > || $item->{notforloan} >@@ -1925,23 +1925,23 @@ sub searchResults { > } > > # item is withdrawn, lost, damaged, not for loan, reserved or in transit >- if ( $item->{wthdrawn} >+ if ( $item->{withdrawn} > || $item->{itemlost} > || $item->{damaged} > || $item->{notforloan} > || $reservestatus eq 'Waiting' > || ($transfertwhen ne '')) > { >- $wthdrawn_count++ if $item->{wthdrawn}; >+ $withdrawn_count++ if $item->{withdrawn}; > $itemlost_count++ if $item->{itemlost}; > $itemdamaged_count++ if $item->{damaged}; > $item_in_transit_count++ if $transfertwhen ne ''; > $item_onhold_count++ if $reservestatus eq 'Waiting'; >- $item->{status} = $item->{wthdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan}; >+ $item->{status} = $item->{withdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan}; > > # can place hold on item ? > if ( !$item->{itemlost} ) { >- if ( !$item->{wthdrawn} ){ >+ if ( !$item->{withdrawn} ){ > if ( $item->{damaged} ){ > if ( C4::Context->preference('AllowHoldsOnDamagedItems') ){ > # can place a hold on a damaged item if AllowHoldsOnDamagedItems is true >@@ -1960,7 +1960,7 @@ sub searchResults { > $other_count++; > > my $key = $prefix . $item->{status}; >- foreach (qw(wthdrawn itemlost damaged branchname itemcallnumber)) { >+ foreach (qw(withdrawn itemlost damaged branchname itemcallnumber)) { > $other_items->{$key}->{$_} = $item->{$_}; > } > $other_items->{$key}->{intransit} = ( $transfertwhen ne '' ) ? 1 : 0; >@@ -2032,7 +2032,7 @@ sub searchResults { > $oldbiblio->{onloanplural} = 1 if $onloan_count > 1; > $oldbiblio->{othercount} = $other_count; > $oldbiblio->{otherplural} = 1 if $other_count > 1; >- $oldbiblio->{wthdrawncount} = $wthdrawn_count; >+ $oldbiblio->{withdrawncount} = $withdrawn_count; > $oldbiblio->{itemlostcount} = $itemlost_count; > $oldbiblio->{damagedcount} = $itemdamaged_count; > $oldbiblio->{intransitcount} = $item_in_transit_count; >diff --git a/C4/XSLT.pm b/C4/XSLT.pm >index 53f07d3..d85b048 100644 >--- a/C4/XSLT.pm >+++ b/C4/XSLT.pm >@@ -266,7 +266,7 @@ sub buildKohaItemsNamespace { > > my $reservestatus = C4::Reserves::GetReserveStatus( $item->{itemnumber} ); > >- if ( $itemtypes->{ $item->{itype} }->{notforloan} || $item->{notforloan} || $item->{onloan} || $item->{wthdrawn} || $item->{itemlost} || $item->{damaged} || >+ if ( $itemtypes->{ $item->{itype} }->{notforloan} || $item->{notforloan} || $item->{onloan} || $item->{withdrawn} || $item->{itemlost} || $item->{damaged} || > (defined $transfertwhen && $transfertwhen ne '') || $item->{itemnotforloan} || (defined $reservestatus && $reservestatus eq "Waiting") ){ > if ( $item->{notforloan} < 0) { > $status = "On order"; >@@ -277,7 +277,7 @@ sub buildKohaItemsNamespace { > if ($item->{onloan}) { > $status = "Checked out"; > } >- if ( $item->{wthdrawn}) { >+ if ( $item->{withdrawn}) { > $status = "Withdrawn"; > } > if ($item->{itemlost}) { >diff --git a/catalogue/moredetail.pl b/catalogue/moredetail.pl >index f0cfb13..cdb592b 100755 >--- a/catalogue/moredetail.pl >+++ b/catalogue/moredetail.pl >@@ -168,7 +168,7 @@ foreach my $item (@items){ > } > $item->{'datereceived'} = $order->{'datereceived'}; > >- if ($item->{notforloantext} or $item->{itemlost} or $item->{damaged} or $item->{wthdrawn}) { >+ if ($item->{notforloantext} or $item->{itemlost} or $item->{damaged} or $item->{withdrawn}) { > $item->{status_advisory} = 1; > } > >diff --git a/catalogue/updateitem.pl b/catalogue/updateitem.pl >index abc809d..63514c1 100755 >--- a/catalogue/updateitem.pl >+++ b/catalogue/updateitem.pl >@@ -37,7 +37,7 @@ my $itemnumber=$cgi->param('itemnumber'); > my $biblioitemnumber=$cgi->param('biblioitemnumber'); > my $itemlost=$cgi->param('itemlost'); > my $itemnotes=$cgi->param('itemnotes'); >-my $wthdrawn=$cgi->param('wthdrawn'); >+my $withdrawn=$cgi->param('withdrawn'); > my $damaged=$cgi->param('damaged'); > > my $confirm=$cgi->param('confirm'); >@@ -47,7 +47,7 @@ my $dbh = C4::Context->dbh; > my $item_data_hashref = GetItem($itemnumber, undef); > > # make sure item statuses are set to 0 if empty or NULL >-for ($damaged,$itemlost,$wthdrawn) { >+for ($damaged,$itemlost,$withdrawn) { > if (!$_ or $_ eq "") { > $_ = 0; > } >@@ -62,8 +62,8 @@ if (defined $itemnotes) { # i.e., itemnotes parameter passed from form > } > } elsif ($itemlost ne $item_data_hashref->{'itemlost'}) { > $item_changes->{'itemlost'} = $itemlost; >-} elsif ($wthdrawn ne $item_data_hashref->{'wthdrawn'}) { >- $item_changes->{'wthdrawn'} = $wthdrawn; >+} elsif ($withdrawn ne $item_data_hashref->{'withdrawn'}) { >+ $item_changes->{'withdrawn'} = $withdrawn; > } elsif ($damaged ne $item_data_hashref->{'damaged'}) { > $item_changes->{'damaged'} = $damaged; > } else { >diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl >index 9a60ec1..919d3d4 100755 >--- a/circ/pendingreserves.pl >+++ b/circ/pendingreserves.pl >@@ -145,7 +145,7 @@ if ( $run_report ) { > AND issues.itemnumber IS NULL > AND reserves.priority <> 0 > AND reserves.suspend = 0 >- AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 >+ AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0 > "; > # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when > # multiple patrons have a hold on an item >diff --git a/circ/reserveratios.pl b/circ/reserveratios.pl >index 29cd0b6..55eb018 100755 >--- a/circ/reserveratios.pl >+++ b/circ/reserveratios.pl >@@ -109,7 +109,7 @@ my $strsth = > LEFT JOIN items ON items.biblionumber=reserves.biblionumber > LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber > WHERE >- notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0 >+ notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0 > $sqldatewhere > "; > >diff --git a/circ/returns.pl b/circ/returns.pl >index 9472797..618190b 100755 >--- a/circ/returns.pl >+++ b/circ/returns.pl >@@ -430,7 +430,7 @@ foreach my $code ( keys %$messages ) { > elsif ( $code eq 'WasTransfered' ) { > ; # FIXME... anything to do here? > } >- elsif ( $code eq 'wthdrawn' ) { >+ elsif ( $code eq 'withdrawn' ) { > $err{withdrawn} = 1; > $exit_required_p = 1 if C4::Context->preference("BlockReturnOfWithdrawnItems"); > } >diff --git a/docs/opac/OpacHiddenItems.txt b/docs/opac/OpacHiddenItems.txt >index 625d465..d46f94b 100644 >--- a/docs/opac/OpacHiddenItems.txt >+++ b/docs/opac/OpacHiddenItems.txt >@@ -8,5 +8,5 @@ Items can be hidden according to values from the items table: > field: [value1, value2, ...] > > Example : >-wthdrawn: [0, 1] >+withdrawn: [0, 1] > homebranch: [homebranch1, homebranch2] >diff --git a/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index 3c9156d..5b435ff 100644 >--- a/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index ee3e9f1..b154650 100644 >--- a/installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/Pg/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -161,7 +161,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4078,7 +4078,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -7996,7 +7996,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11913,7 +11913,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15829,7 +15829,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19744,7 +19744,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23660,7 +23660,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27574,7 +27574,7 @@ INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/Pg/kohastructure.sql b/installer/data/Pg/kohastructure.sql >index 12967dc..db46826 100644 >--- a/installer/data/Pg/kohastructure.sql >+++ b/installer/data/Pg/kohastructure.sql >@@ -844,7 +844,7 @@ stack int default NULL, > notforloan int default NULL, > damaged int default NULL, > itemlost int default NULL, >-wthdrawn int default NULL, >+withdrawn int default NULL, > bulk varchar(30) default NULL, > issues int default NULL, > renewals int default NULL, >@@ -950,7 +950,7 @@ stack int default NULL, > notforloan int default NULL, > damaged int default NULL, > itemlost int default NULL, >-wthdrawn int default NULL, >+withdrawn int default NULL, > itemcallnumber varchar(30) default NULL, > issues int default NULL, > renewals int default NULL, >diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index aca7cd5..a6e0e8f 100644 >--- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Klassifikationsschema', 'Klassifikationsschema oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index ac7634a..fdf4684 100644 >--- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942','c','Medientyp', 'Medientyp', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942','n','OPAC-Anzeige unterdrücken', 'OPAC-Anzeige unterdrücken', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942','s','Kennzeichen für Zeitschrift', 'Zeitschrift', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Ausgeschieden','Ausgeschieden',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Ausgeschieden','Ausgeschieden',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Verloren','Verloren',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Klassifikation oder Aufstellungssystematik','Klassifikation oder Aufstellungssystematik',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Beilagenotiz','Beilagenotiz',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 73beb49..14f9d71 100644 >--- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4088,7 +4088,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8015,7 +8015,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11941,7 +11941,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15866,7 +15866,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19790,7 +19790,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23715,7 +23715,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27638,7 +27638,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Klassifikation oder Aufstellungssystematik', 'Klassifikation oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql >index 3c45e08..214121d 100644 >--- a/installer/data/mysql/de-DE/optional/auth_val.sql >+++ b/installer/data/mysql/de-DE/optional/auth_val.sql >@@ -30,7 +30,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Nachschlagewerke'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden'); > > -- loanability status of an item, linked to items.notforloan >diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index 5b7fe94..daf6794 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -89,7 +89,7 @@ INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index 40180d0..77dde7e 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 0dc8744..4a28ac0 100644 >--- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4169,7 +4169,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8177,7 +8177,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -12184,7 +12184,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -16190,7 +16190,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -20195,7 +20195,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -24201,7 +24201,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -28205,7 +28205,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >index df3413d..953354f 100644 >--- a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >+++ b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >@@ -121,7 +121,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), > ('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL), >diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql >index db6df3d..5318cee 100644 >--- a/installer/data/mysql/en/optional/auth_val.sql >+++ b/installer/data/mysql/en/optional/auth_val.sql >@@ -30,7 +30,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan >diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index cf0d72f..0ec19b3 100644 >--- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -106,7 +106,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'INFORMACIÃN DE EJEMPLAR Y UBICACIÃN (KOHA)', 'INFORMACIÃN DE EJEMPLAR Y UBICACIÃN (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Suprimido', 'Suprimido', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Suprimido', 'Suprimido', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Estado de pérdida', 'Estado de pérdida', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL), > ('952', '2', 'Fuente de clasificación o esquema de ordenación en estanterÃas', 'Fuente de clasificación o esquema de ordenación en estanterÃas', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materiales especializados (volumen obligatorio u otra parte)', 'Materiales especializados (volumen obligatorio u otra parte)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index 40180d0..77dde7e 100644 >--- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 2d9a7fd..7c4deff 100644 >--- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -163,7 +163,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4089,7 +4089,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8016,7 +8016,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11942,7 +11942,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15867,7 +15867,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19791,7 +19791,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23716,7 +23716,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27639,7 +27639,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >index c1acb4c..ea630bb 100644 >--- a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >+++ b/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >@@ -121,7 +121,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), > ('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL), >diff --git a/installer/data/mysql/es-ES/optional/auth_val.sql b/installer/data/mysql/es-ES/optional/auth_val.sql >index e1c7917..ec433ad 100644 >--- a/installer/data/mysql/es-ES/optional/auth_val.sql >+++ b/installer/data/mysql/es-ES/optional/auth_val.sql >@@ -30,7 +30,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan >diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql >index 3bff18e..a558af6 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >index 1c66be7..6874e11 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4088,7 +4088,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8015,7 +8015,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11941,7 +11941,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15866,7 +15866,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19790,7 +19790,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23715,7 +23715,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27638,7 +27638,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index bc49624..6f2e028 100644 >--- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index 40180d0..77dde7e 100644 >--- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 0744263..70068e6 100644 >--- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4084,7 +4084,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8007,7 +8007,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11929,7 +11929,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15850,7 +15850,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19770,7 +19770,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23691,7 +23691,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27610,7 +27610,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql >index 993724f..6010127 100644 >--- a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql >+++ b/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql >@@ -2520,7 +2520,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('942','s','Serial record flag','Serial record',0,0,'biblio.serial',9,'','','',0,0,'',NULL,'',''); > > -- 995 >-insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.wthdrawn',10,'WITHDRAWN','','',0,0,'',NULL,'','0'); >+insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.withdrawn',10,'WITHDRAWN','','',0,0,'',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','1','Codice di sistema (classificazione specifica o altro schema e edizione)','Codice di sistema (classificazione specifica o altro schema e edizione)',0,0,'',10,'','','',0,-5,'',NULL,'',''); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','2','Copia smarrita','Copia smarrita',0,0,'items.itemlost',10,'LOST','','',0,0,'',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','3','Restrizioni d\'uso','Restrizioni d\'uso',0,0,'items.restricted',10,'RESTRICTED','','',0,0,'',NULL,'','0'); >@@ -2578,7 +2578,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('942','s','Serial record flag','Serial record',0,0,'biblio.serial',9,'','','',0,0,'MN',NULL,'',''); > > -- 995 >-insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.wthdrawn',10,'WITHDRAWN','','',0,0,'MN',NULL,'','0'); >+insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.withdrawn',10,'WITHDRAWN','','',0,0,'MN',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','1','Codice di sistema (classificazione specifica o altro schema e edizione)','Codice di sistema (classificazione specifica o altro schema e edizione)',0,0,'',10,'','','',0,-5,'MN',NULL,'',''); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','2','Copia smarrita','Copia smarrita',0,0,'items.itemlost',10,'LOST','','',0,0,'MN',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','3','Restrizioni d\'uso','Restrizioni d\'uso',0,0,'items.restricted',10,'RESTRICTED','','',0,0,'MN',NULL,'','0'); >@@ -2637,7 +2637,7 @@ insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('942','s','Serial record flag','Serial record',0,0,'biblio.serial',9,'','','',0,0,'PR',NULL,'',''); > > -- 995 >-insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.wthdrawn',10,'WITHDRAWN','','',0,0,'PR',NULL,'','0'); >+insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','0','Ritiro della copia','Ritiro della copia',0,0,'items.withdrawn',10,'WITHDRAWN','','',0,0,'PR',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','1','Codice di sistema (classificazione specifica o altro schema e edizione)','Codice di sistema (classificazione specifica o altro schema e edizione)',0,0,'',10,'','','',0,-5,'PR',NULL,'',''); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','2','Copia smarrita','Copia smarrita',0,0,'items.itemlost',10,'LOST','','',0,0,'PR',NULL,'','0'); > insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,`libopac`,`repeatable`,`mandatory`,`kohafield`,`tab`,`authorised_value`,`authtypecode`,`value_builder`,`isurl`,`hidden`,`frameworkcode`,`seealso`,`link`,`defaultvalue`) values ('995','3','Restrizioni d\'uso','Restrizioni d\'uso',0,0,'items.restricted',10,'RESTRICTED','','',0,0,'PR',NULL,'','0'); >diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql >index f45d637..c3810d1 100644 >--- a/installer/data/mysql/it-IT/necessari/auth_val.sql >+++ b/installer/data/mysql/it-IT/necessari/auth_val.sql >@@ -36,7 +36,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE', > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione'); > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 8a8b70f..7d36527 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -866,7 +866,7 @@ CREATE TABLE `deleteditems` ( > `notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) > `damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) > `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1) >- `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) >+ `withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) > `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o) > `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f) > `issues` smallint(6) default NULL, -- number of times this item has been checked out >@@ -1158,7 +1158,7 @@ CREATE TABLE `items` ( -- holdings/item information > `notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7) > `damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4) > `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1) >- `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) >+ `withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0) > `itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o) > `coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f) > `issues` smallint(6) default NULL, -- number of times this item has been checked out/issued >diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >index e37ae73..567d30d 100644 >--- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >+++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >@@ -51,7 +51,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Oppslagsverk'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake'); > > -- loanability status of an item, linked to items.notforloan >diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index e3bb0bf..2a9b031 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index 1ec4d52..c54c369 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index b34566d..5ce5e58 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4087,7 +4087,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8013,7 +8013,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11938,7 +11938,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15862,7 +15862,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19785,7 +19785,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23709,7 +23709,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27631,7 +27631,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >index 47df729..3bb286d 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >@@ -970,7 +970,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('950','w','Sorteringsdelfelt for delfelt $a','Sorteringsdelfelt for delfelt $a.','0','0','0','9','','','','0','-1','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('950','x','Underavdeling til emneord (R)','Underavdeling til emneord (R)','1','0','0','9','','','','0','-1','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('950','z','Navn eller ord, henvisning til','Navn eller ord, henvisning til','0','0','0','9','','','','0','-1','','','',NULL,'9999'); >-INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','0','Trukket tilbake','Trukket tilbake','0','0','items.wthdrawn','10','WITHDRAWN','','','0','0','','','',NULL,'9999'); >+INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','0','Trukket tilbake','Trukket tilbake','0','0','items.withdrawn','10','WITHDRAWN','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','1','Tapt','Tapt','0','0','items.itemlost','10','LOST','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','2','Kilde for klassifikasjon','Kilde for klassifikasjon','0','0','items.cn_source','10','cn_source','','',NULL,'0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','3','Materialespesifikasjon (innbundet Ã¥rgang eller lignende)','Materialespesifikasjon (innbundet Ã¥rgang eller lignende)','0','0','items.materials','10','','','',NULL,'0','','','',NULL,'9999'); >diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql >index 2d5f7ab..13f3476 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql >@@ -89,7 +89,7 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('942','m','Hyllesignatur postfiks','Hyllesignatur postfiks','0','0','biblioitems.cn_suffix','9','','','','0','-1','FA','','','','9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('942','n','Skjul i OPAC','Skjul i OPAC','0','0','','9','','','','0','-1','FA','','','','9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('942','s','Periodikamark','Periodikamark','0','0','biblio.serial','9','','','','0','-5','FA','','','','9999'); >-INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','0','Trukket tilbake','Trukket tilbake','0','0','items.wthdrawn','10','WITHDRAWN','','','0','0','FA','','','','9999'); >+INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','0','Trukket tilbake','Trukket tilbake','0','0','items.withdrawn','10','WITHDRAWN','','','0','0','FA','','','','9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','1','Tapt','Tapt','0','0','items.itemlost','10','LOST','','','0','0','FA','','','','9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','2','Kilde for klassifikasjon','Kilde for klassifikasjon','0','0','items.cn_source','10','cn_source','','','0','0','FA','','','','9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('952','3','Materialespesifikasjon (innbundet ','Materialespesifikasjon (innbundet ','0','0','items.materials','10','','','','0','0','FA','','','','9999'); >diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >index 9e9179b..cf09504 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql >@@ -103,7 +103,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL), >diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql >index e8d5bf3..a7d47ab 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql >@@ -100,7 +100,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL), > ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL), > ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL), >- ('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), >+ ('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL), > ('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL), > ('952','2','Source of classification or shelving scheme','Source of classification or shelving scheme',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL), > ('952','3','Materials specified (bound volume or other part)','Materials specified (bound volume or other part)',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL), >diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >index 6d55c12..57f4b6b 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql >@@ -162,7 +162,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'BKS'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'BKS', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'BKS', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'BKS', '', '', NULL), >@@ -4088,7 +4088,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'CF'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'CF', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'CF', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'CF', '', '', NULL), >@@ -8015,7 +8015,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SR', '', '', NULL), >@@ -11941,7 +11941,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'VR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'VR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'VR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'VR', '', '', NULL), >@@ -15866,7 +15866,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'AR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'AR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'AR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'AR', '', '', NULL), >@@ -19790,7 +19790,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'KT'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'KT', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'KT', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'KT', '', '', NULL), >@@ -23715,7 +23715,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'IR'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'IR', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'IR', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'IR', '', '', NULL), >@@ -27638,7 +27638,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'SER'); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), >+ ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, 'SER', '', '', NULL), > ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'SER', '', '', NULL), > ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, 'SER', '', '', NULL), >diff --git a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >index ae0c928..60509e1 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql >@@ -118,7 +118,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > -- ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); > > -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >--- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), >+-- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), > -- ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > -- ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', 'unimarc_en_classcodes.pl', NULL, 0, '', '', '', NULL), > -- ('995', '3', 'Classification part', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL), >@@ -171,7 +171,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat > ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); > > INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES >- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), >+ ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), > ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), > ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL), > ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), >diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql >index 0bc10c9..8a7d630 100644 >--- a/installer/data/mysql/pl-PL/optional/auth_val.sql >+++ b/installer/data/mysql/pl-PL/optional/auth_val.sql >@@ -28,7 +28,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > >--- withdrawn status of an item, linked to items.wthdrawn >+-- withdrawn status of an item, linked to items.withdrawn > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt >index 7a0e78a..46a2735 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt >@@ -1 +1 @@ >-СÑаÑÑÑ Ð¸Ð·ÑÑÑÐ¸Ñ ÑкземплÑÑа, ÑвÑзан Ñ items.wthdrawn >\ No newline at end of file >+СÑаÑÑÑ Ð¸Ð·ÑÑÑÐ¸Ñ ÑкземплÑÑа, ÑвÑзан Ñ items.withdrawn >\ No newline at end of file >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >index 4f24cbb..7ef66e5 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >@@ -786,7 +786,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >index decbeb7..8a518e7 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('AR', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('AR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('AR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('AR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('AR', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('AR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >index f0adcf1..f2e78c8 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('BKS', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('BKS', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('BKS', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('BKS', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('BKS', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('BKS', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >index a4f146d..0c9a53b 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('CF', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('CF', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('CF', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('CF', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('CF', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('CF', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >index 41315be..4cc990a 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >@@ -23,7 +23,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('FA', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('FA', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL), >+ ('FA', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL), > ('FA', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL), > ('FA', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL), > ('FA', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >index 71e1468..8b8e28f 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('IR', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('IR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('IR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('IR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('IR', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('IR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >index 360babc..242939c 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('KT', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('KT', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('KT', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('KT', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('KT', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('KT', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >index 738fcd2..fce988a 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('SER', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('SER', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('SER', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('SER', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('SER', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('SER', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >index 161ddaf..5d37a17 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('SR', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('SR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('SR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('SR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('SR', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('SR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >index 61d33c3..395e1de 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('VR', '952', '', 1, 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('VR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('VR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('VR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('VR', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('VR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÐ¸Ñ (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >index 4cf906f..3339d40 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >@@ -316,7 +316,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '995', '', '', 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('', '', '995', '1', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾Ð²ÑеждениÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð¿Ð¾ÑеÑи/оÑÑÑÑÑÑвиÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð³ÑаниÑÐµÐ½Ð¸Ñ Ð´Ð¾ÑÑÑпа', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -399,7 +399,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обоÑоÑа (не Ð´Ð»Ñ Ð²ÑдаÑи) > # damaged 995^1 ÑÑаÑÑÑ Ð¿Ð¾Ð²ÑÐµÐ¶Ð´ÐµÐ½Ð¸Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑи >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð¸Ð·ÑÑÑÐ¸Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð¸Ð·ÑÑÑÐ¸Ñ > # itemcallnumber 995^k полнÑй (ÑкземплÑÑнÑй) ÑиÑÑ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ > # issues вÑÐ´Ð°Ñ Ð² Ñелом > # renewals пÑодолжений в Ñелом >diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >index 1b56ebe..8676f7a 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >@@ -95,7 +95,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '952', '', '', 'ÐаннÑе о ÑкземплÑÑÐ°Ñ Ð¸ ÑаÑположение (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð¸Ð·ÑÑÑиÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑи', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '952', '2', 0, 0, 'ÐÑÑоÑник клаÑÑиÑикаÑии или ÑÑема полоÑного ÑаÑположениÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('', '', '952', '3', 0, 0, 'ÐденÑиÑикаÑÐ¸Ñ Ð¾Ð¿Ð¸ÑÑваемого маÑеÑиала (обÑединеннÑй Ñом или Ð¸Ð½Ð°Ñ ÑаÑÑÑ)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt >index 584fa9f..a52e066 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt >@@ -1 +1 @@ >-СÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ Ð¿ÑимÑÑника, звâÑзаний з items.wthdrawn >+СÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ Ð¿ÑимÑÑника, звâÑзаний з items.withdrawn >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >index 7cea1cb..ba5d4e7 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql >@@ -786,7 +786,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >index f844b1c..a461abf 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('AR', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('AR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('AR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('AR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('AR', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('AR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >index 479de25..88274b4 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('BKS', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('BKS', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('BKS', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('BKS', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('BKS', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('BKS', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >index fb8be73..d55fcbb 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('CF', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('CF', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('CF', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('CF', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('CF', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('CF', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >index 7b4aec0..aad758b 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql >@@ -23,7 +23,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('FA', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('FA', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL), >+ ('FA', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL), > ('FA', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL), > ('FA', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL), > ('FA', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >index 2bb5aaa..240efd8 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('IR', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('IR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('IR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('IR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('IR', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('IR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >index a4e2505..7f5ea90 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('KT', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('KT', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('KT', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('KT', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('KT', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('KT', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >index 82c3752..f19f0b3 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('SER', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('SER', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('SER', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('SER', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('SER', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('SER', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >index 9408f3c..04f00c4 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('SR', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('SR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('SR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('SR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('SR', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('SR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >index 342510a..210280f 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql >@@ -762,7 +762,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('VR', '952', '', 1, 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('VR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL), >+ ('VR', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), > ('VR', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('VR', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('VR', '', '952', '3', 0, 0, 'ÐÑмеÑаÑÑÑ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >index 170246c..6cacf13 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql >index 856d9b6..bb43e48 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('AN', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('AN', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('AN', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('AN', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('AN', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('AN', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql >index c2c7363..86521fe 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('AUD', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('AUD', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('AUD', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('AUD', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('AUD', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('AUD', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql >index 18dbe6a..8d87c59 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('BOOK', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('BOOK', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('BOOK', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('BOOK', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('BOOK', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('BOOK', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >index 05e226c..2a1e13a 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql >@@ -101,7 +101,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('', '952', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('', '', '952', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('', '', '952', '1', 0, 0, 'СÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('', '', '952', '2', 0, 0, 'ÐжеÑело клаÑиÑÑкаÑÑÑ Ñи ÑÑема полиÑного ÑозÑаÑÑваннÑ', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), > ('', '', '952', '3', 0, 0, 'ÐденÑиÑÑкаÑÑÑ Ð¾Ð¿Ð¸ÑÑваного маÑеÑÑÐ°Ð»Ñ (обâÑднаний Ñом Ñи ÑнÑа ÑаÑÑина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql >index c335165..6dcd3fd 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('EL', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('EL', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('EL', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('EL', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('EL', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('EL', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql >index 674e7bc..9067e58 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('MIN', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('MIN', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('MIN', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('MIN', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('MIN', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('MIN', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql >index 5ff766b..0c864e0 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('NOTE', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('NOTE', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('NOTE', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('NOTE', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('NOTE', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('NOTE', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql >index 09e9050..9ac3a72 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('PER', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('PER', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('PER', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('PER', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('PER', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('PER', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql >index c8023c1..5899b28 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql >@@ -286,7 +286,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES > ('TECH', '995', '', '', 'ÐÐ°Ð½Ñ Ð¿Ñо пÑимÑÑники Ñа ÑозÑаÑÑÐ²Ð°Ð½Ð½Ñ (Koha)', '', ''); > INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES >- ('TECH', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL), >+ ('TECH', '', '995', '0', 0, 0, 'СÑаÑÑÑ Ð²Ð¸Ð»ÑÑеннÑ', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), > ('TECH', '', '995', '1', 0, 0, 'СÑан поÑкодженнÑ', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), > ('TECH', '', '995', '2', 0, 0, 'СÑаÑÑÑ Ð²ÑÑаÑи/вÑдÑÑÑноÑÑÑ', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), > ('TECH', '', '995', '3', 0, 0, 'СÑаÑÑÑ Ð¾Ð±Ð¼ÐµÐ¶ÐµÐ½Ð½Ñ Ð´Ð¾ÑÑÑпÑ', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), >@@ -369,7 +369,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > # notforloan 995^o Ñип обÑÐ³Ñ (не Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ) > # damaged 995^1 ÑÑан поÑÐºÐ¾Ð´Ð¶ÐµÐ½Ð½Ñ > # itemlost 995^2 ÑÑаÑÑÑ Ð´Ð¾ÑÑÑпноÑÑÑ >-# wthdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ >+# withdrawn 995^0 ÑÑаÑÑÑ Ð²Ð¸Ð»ÑÑÐµÐ½Ð½Ñ > # itemcallnumber 995^k повний (пÑимÑÑниковий) ÑиÑÑ Ð·Ð±ÐµÑÐµÐ¶ÐµÐ½Ð½Ñ > # issues Ð²Ð¸Ð´Ð°Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ > # renewals пÑÐ¾Ð´Ð¾Ð²Ð¶ÐµÐ½Ñ Ð·Ð°Ð³Ð°Ð»Ð¾Ð¼ >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 74aeb3e..19fe04c 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -7067,6 +7067,31 @@ if ( CheckVersion($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "3.13.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(q{ >+ ALTER TABLE items CHANGE wthdrawn withdrawn TINYINT( 1 ) NOT NULL DEFAULT '0' >+ }); >+ >+ $dbh->do(q{ >+ ALTER TABLE deleteditems CHANGE wthdrawn withdrawn TINYINT( 1 ) NOT NULL DEFAULT '0' >+ }); >+ >+ $dbh->do(q{ >+ UPDATE saved_sql SET savedsql = REPLACE(savedsql, 'wthdrawn', 'withdrawn') >+ }); >+ >+ print "Upgrade to $DBversion done (Bug 10550 - Fix database typo wthdrawn)\n"; >+ SetVersion($DBversion); >+} >+ >+$DBversion = "3.13.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do("UPDATE marc_subfield_structure SET kohafield = 'items.withdrawn' WHERE kohafield = 'items.wthdrawn'"); >+ print "Upgrade to $DBversion done (Bug 10550 - Fix database typo wthdrawn)\n"; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >diff --git a/koha-tmpl/intranet-tmpl/prog/en/columns.def b/koha-tmpl/intranet-tmpl/prog/en/columns.def >index 726ecc6..c48fa48 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/columns.def >+++ b/koha-tmpl/intranet-tmpl/prog/en/columns.def >@@ -81,7 +81,7 @@ items.cn_source Source of classification / shelving scheme > items.cn_sort Koha normalized classification for sorting > items.notforloan Not for loan > items.itemlost Lost status >-items.wthdrawn Withdrawn status >+items.withdrawn Withdrawn status > items.itemcallnumber Call number > items.issues Total checkouts > items.renewals Total renewals >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >index b3a4240..0ad8297 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt >@@ -434,7 +434,7 @@ function verify_images() { > [% END %] > [% END %] > >- [% IF ( item.wthdrawn ) %] >+ [% IF ( item.withdrawn ) %] > <span class="wdn">Withdrawn</span> > [% END %] > >@@ -484,7 +484,7 @@ function verify_images() { > [% END %] > [% END %] > [% END %] >- [% UNLESS ( item.itemnotforloan or item.onloan or item.itemlost or item.wthdrawn or item.damaged or item.transfertwhen or item.reservedate ) %] >+ [% UNLESS ( item.itemnotforloan or item.onloan or item.itemlost or item.withdrawn or item.damaged or item.transfertwhen or item.reservedate ) %] > Available > [% END %] > >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt >index 5234e28..ad3ed4c 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt >@@ -64,7 +64,7 @@ > [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %] > [% IF ( ITEM_DAT.itemlost ) %]Lost[% END %] > [% IF ( ITEM_DAT.damaged ) %]Damaged[% END %] >- [% IF ( ITEM_DAT.wthdrawn ) %]Withdrawn[% END %] >+ [% IF ( ITEM_DAT.withdrawn ) %]Withdrawn[% END %] > )[% END %]</h4> > > <ol class="bibliodetails"> >@@ -104,7 +104,7 @@ > [% END %] > [% END %] > </select> >- <input type="hidden" name="wthdrawn" value="[% ITEM_DAT.wthdrawn %]" /> >+ <input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" /> > <input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" /> > <input type="submit" name="submit" class="submit" value="Set Status" /></form> > [% ELSE %] >@@ -134,7 +134,7 @@ > [% END %] > [% END %] > </select> >- <input type="hidden" name="wthdrawn" value="[% ITEM_DAT.wthdrawn %]" /> >+ <input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" /> > <input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" /> > <input type="submit" name="submit" class="submit" value="Set Status" /></form> > [% ELSE %] >@@ -147,7 +147,7 @@ > [% END %] > </li> > [% END %] >- <li><span class="label">Withdrawn?:</span>[% IF ( ITEM_DAT.wthdrawn ) %]Yes[% ELSE %]No[% END %] >+ <li><span class="label">Withdrawn?:</span>[% IF ( ITEM_DAT.withdrawn ) %]Yes[% ELSE %]No[% END %] > [% IF ( CAN_user_circulate ) %] > <form action="updateitem.pl" method="post"> > <input type="hidden" name="biblionumber" value="[% ITEM_DAT.biblionumber %]" /> >@@ -156,10 +156,10 @@ > <input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" /> > <input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" /> > >- [% IF ( ITEM_DAT.wthdrawn ) %] >- <input type="hidden" name="wthdrawn" value="0" />[% ELSE %]<input type="hidden" name="wthdrawn" value="1" /> >+ [% IF ( ITEM_DAT.withdrawn ) %] >+ <input type="hidden" name="withdrawn" value="0" />[% ELSE %]<input type="hidden" name="withdrawn" value="1" /> > [% END %] >- [% IF ( ITEM_DAT.wthdrawn ) %] >+ [% IF ( ITEM_DAT.withdrawn ) %] > <input type="submit" name="submit" class="submit" value="Restore" />[% ELSE %]<input type="submit" name="submit" class="submit" value="Withdraw" /> > [% END %] > </form> >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt >index db5aaec..083fd18 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt >@@ -564,7 +564,7 @@ var holdForPatron = function () { > [% IF ( other_items_loo.branchname ) %][% other_items_loo.branchname %][% END %] > [% IF ( other_items_loo.location ) %][% other_items_loo.location %][% END %] > [% IF ( other_items_loo.itemcallnumber ) %][<a href="/cgi-bin/koha/catalogue/search.pl?idx=callnum&q=[% other_items_loo.itemcallnumber |url %]">[% other_items_loo.itemcallnumber %]</a>][% END %] >- [% IF ( other_items_loo.wthdrawn ) %](Withdrawn)[% END %] >+ [% IF ( other_items_loo.withdrawn ) %](Withdrawn)[% END %] > [% IF ( other_items_loo.itemlost ) %](Lost)[% END %] > [% IF ( other_items_loo.damaged ) %](Damaged)[% END %] > [% IF ( other_items_loo.intransit ) %](In transit)[% END %] >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbooks.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbooks.tt >index 9155235..3889df8 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbooks.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbooks.tt >@@ -126,7 +126,7 @@ > [% END %] > <span class="unavailable"> > [% IF ( resultsloo.onloancount ) %] Checked out ([% resultsloo.onloancount %]),<br /> [% END %] >- [% IF ( resultsloo.wthdrawncount ) %] Withdrawn ([% resultsloo.wthdrawncount %]),<br /> [% END %] >+ [% IF ( resultsloo.withdrawncount ) %] Withdrawn ([% resultsloo.withdrawncount %]),<br /> [% END %] > [% IF ( resultsloo.itemlostcount ) %] Lost ([% resultsloo.itemlostcount %])<br />[% END %] > [% IF ( resultsloo.orderedcount ) %] On order ([% resultsloo.orderedcount %])[% END %] > </span> >diff --git a/koha-tmpl/opac-tmpl/prog/en/includes/item-status.inc b/koha-tmpl/opac-tmpl/prog/en/includes/item-status.inc >index 98fdb38..60fbe64 100644 >--- a/koha-tmpl/opac-tmpl/prog/en/includes/item-status.inc >+++ b/koha-tmpl/opac-tmpl/prog/en/includes/item-status.inc >@@ -11,7 +11,7 @@ > to [% item.transfertto %] since [% item.transfertwhen %] > [% ELSIF ( item.waiting ) %] > On hold >-[% ELSIF ( item.wthdrawn ) %] >+[% ELSIF ( item.withdrawn ) %] > Item withdrawn > [% ELSIF ( item.itemlost ) %] > [% av_lib_include = KohaAuthorisedValues.GetByCode( 'LOST', item.itemlost, 1 ) %] >diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt b/koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt >index bee032e..6ebfaeb 100644 >--- a/koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt >+++ b/koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt >@@ -184,7 +184,7 @@ > <items> > <item> > <biblioitemnumber>1</biblioitemnumber> >- <wthdrawn>0</wthdrawn> >+ <withdrawn>0</withdrawn> > <holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname> > <notforloan>0</notforloan> > <replacementpricedate>2008-08-20</replacementpricedate> >@@ -272,7 +272,7 @@ > <items> > <item> > <biblioitemnumber>2</biblioitemnumber> >- <wthdrawn>0</wthdrawn> >+ <withdrawn>0</withdrawn> > <holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname> > <notforloan>0</notforloan> > <replacementpricedate>2008-08-20</replacementpricedate> >@@ -473,7 +473,7 @@ > <dateaccessioned>2008-08-23</dateaccessioned> > <onloan>2008-09-17</onloan> > <biblioitemnumber>4483</biblioitemnumber> >- <wthdrawn>0</wthdrawn> >+ <withdrawn>0</withdrawn> > <notforloan>0</notforloan> > <replacementpricedate>2008-08-23</replacementpricedate> > <itemcallnumber>RO STE</itemcallnumber> >@@ -511,7 +511,7 @@ > <notes>La couv. porte en plus : "un guide simple et facile pour apprendre la guitare" | Glossaire. Index</notes> > <onloan>2008-09-25</onloan> > <biblioitemnumber>4486</biblioitemnumber> >- <wthdrawn>0</wthdrawn> >+ <withdrawn>0</withdrawn> > <notforloan>0</notforloan> > <replacementpricedate>2008-08-23</replacementpricedate> > <itemcallnumber>787.87 BUC</itemcallnumber> >diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results-grouped.tt b/koha-tmpl/opac-tmpl/prog/en/modules/opac-results-grouped.tt >index d6b4c11..359f337 100644 >--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results-grouped.tt >+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-results-grouped.tt >@@ -260,7 +260,7 @@ function highlightOn() { > [% END %] > <span class="unavailable"> > [% IF ( GROUP_RESULT.onloancount ) %] Checked out ([% GROUP_RESULT.onloancount %]), [% END %] >- [% IF ( GROUP_RESULT.wthdrawncount ) %] Withdrawn ([% GROUP_RESULT.wthdrawncount %]), [% END %] >+ [% IF ( GROUP_RESULT.withdrawncount ) %] Withdrawn ([% GROUP_RESULT.withdrawncount %]), [% END %] > [% IF ( GROUP_RESULT.itemlostcount ) %] Lost ([% GROUP_RESULT.itemlostcount %]),[% END %] > [% IF ( GROUP_RESULT.damagedcount ) %] Damaged ([% GROUP_RESULT.damagedcount %]),[% END %] > [% IF ( GROUP_RESULT.orderedcount ) %] On order ([% GROUP_RESULT.orderedcount %]),[% END %] >diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt b/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt >index 0df0322..754a054 100644 >--- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt >+++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt >@@ -563,7 +563,7 @@ $(document).ready(function(){ > [% END %] > <span class="unavailable"> > [% IF ( SEARCH_RESULT.onloancount ) %] Checked out ([% SEARCH_RESULT.onloancount %]), [% END %] >- [% IF ( SEARCH_RESULT.wthdrawncount ) %] Withdrawn ([% SEARCH_RESULT.wthdrawncount %]), [% END %] >+ [% IF ( SEARCH_RESULT.withdrawncount ) %] Withdrawn ([% SEARCH_RESULT.withdrawncount %]), [% END %] > [% UNLESS ( SEARCH_RESULT.hidelostitems ) %][% IF ( SEARCH_RESULT.itemlostcount ) %] Lost ([% SEARCH_RESULT.itemlostcount %]),[% END %][% END %] > [% IF ( SEARCH_RESULT.damagedcount ) %] Damaged ([% SEARCH_RESULT.damagedcount %]),[% END %] > [% IF ( SEARCH_RESULT.orderedcount ) %] On order ([% SEARCH_RESULT.orderedcount %]),[% END %] >diff --git a/opac/opac-ISBDdetail.pl b/opac/opac-ISBDdetail.pl >index 94055a9..6bfc500 100755 >--- a/opac/opac-ISBDdetail.pl >+++ b/opac/opac-ISBDdetail.pl >@@ -143,7 +143,7 @@ my @items = GetItemsInfo( $biblionumber ); > my $itemtypes = GetItemTypes(); > for my $itm (@items) { > $norequests = 0 >- if ( (not $itm->{'wthdrawn'} ) >+ if ( (not $itm->{'withdrawn'} ) > && (not $itm->{'itemlost'} ) > && ($itm->{'itemnotforloan'}<0 || not $itm->{'itemnotforloan'} ) > && (not $itemtypes->{$itm->{'itype'}}->{notforloan} ) >diff --git a/opac/opac-detail.pl b/opac/opac-detail.pl >index 9d0851f..ee75150 100755 >--- a/opac/opac-detail.pl >+++ b/opac/opac-detail.pl >@@ -558,7 +558,7 @@ for my $itm (@items) { > $itm->{holds_count} = $item_reserves{ $itm->{itemnumber} }; > $itm->{priority} = $priority{ $itm->{itemnumber} }; > $norequests = 0 >- if ( (not $itm->{'wthdrawn'} ) >+ if ( (not $itm->{'withdrawn'} ) > && (not $itm->{'itemlost'} ) > && ($itm->{'itemnotforloan'}<0 || not $itm->{'itemnotforloan'} ) > && (not $itemtypes->{$itm->{'itype'}}->{notforloan} ) >diff --git a/t/db_dependent/HoldsQueue.t b/t/db_dependent/HoldsQueue.t >index 8de2583..925ca16 100755 >--- a/t/db_dependent/HoldsQueue.t >+++ b/t/db_dependent/HoldsQueue.t >@@ -82,7 +82,7 @@ $dbh->do("INSERT INTO biblioitems (biblionumber, marcxml, itemtype) > my $biblioitemnumber = $dbh->selectrow_array("SELECT biblioitemnumber FROM biblioitems WHERE biblionumber = $biblionumber") > or BAIL_OUT("Cannot find newly created biblioitems record"); > >-my $items_insert_sth = $dbh->prepare("INSERT INTO items (biblionumber, biblioitemnumber, barcode, homebranch, holdingbranch, notforloan, damaged, itemlost, wthdrawn, onloan, itype) >+my $items_insert_sth = $dbh->prepare("INSERT INTO items (biblionumber, biblioitemnumber, barcode, homebranch, holdingbranch, notforloan, damaged, itemlost, withdrawn, onloan, itype) > VALUES ($biblionumber, $biblioitemnumber, ?, ?, ?, 0, 0, 0, 0, NULL, '$itemtype')"); # CURRENT_DATE - 3)"); > my $first_barcode = int(rand(1000000000000)); # XXX > my $barcode = $first_barcode; >diff --git a/t/db_dependent/Search.t b/t/db_dependent/Search.t >index d1f76a4..a3d3ef0 100644 >--- a/t/db_dependent/Search.t >+++ b/t/db_dependent/Search.t >@@ -105,7 +105,7 @@ $contextmodule->mock('marcfromkohafield', sub { > 'items.restricted' => ['952', '5' ], > 'items.stack' => ['952', 'j' ], > 'items.uri' => ['952', 'u' ], >- 'items.wthdrawn' => ['952', '0' ] >+ 'items.withdrawn' => ['952', '0' ] > } > ); > return \%hash; >@@ -167,7 +167,7 @@ $dbh->{mock_add_resultset} = { > [ 'homebranch' ], [ 'price' ], [ 'replacementprice' ], > [ 'replacementpricedate' ], [ 'datelastborrowed' ], [ 'datelastseen' ], > [ 'stack' ], [ 'notforloan' ], [ 'damaged' ], >- [ 'itemlost' ], [ 'wthdrawn' ], [ 'itemcallnumber' ], >+ [ 'itemlost' ], [ 'withdrawn' ], [ 'itemcallnumber' ], > [ 'issues' ], [ 'renewals' ], [ 'reserves' ], > [ 'restricted' ], [ 'itemnotes' ], [ 'nonpublicnote' ], > [ 'holdingbranch' ], [ 'paidfor' ], [ 'timestamp' ], >diff --git a/t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm b/t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm >index aca4f73..cde6953 100644 >--- a/t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm >+++ b/t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm >@@ -28,14 +28,14 @@ sub not_defined : Test( 4 ) { > my $item_mod_fixes_1 = { > notforloan => undef, > damaged => undef, >- wthdrawn => undef, >+ withdrawn => undef, > itemlost => undef, > }; > > C4::Items::_do_column_fixes_for_mod($item_mod_fixes_1); > is( $item_mod_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during mod' ); > is( $item_mod_fixes_1->{'damaged'}, 0, 'null damaged fixed during mod' ); >- is( $item_mod_fixes_1->{'wthdrawn'}, 0, 'null wthdrawn fixed during mod' ); >+ is( $item_mod_fixes_1->{'withdrawn'}, 0, 'null withdrawn fixed during mod' ); > is( $item_mod_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during mod' ); > > } >@@ -45,14 +45,14 @@ sub empty : Test( 4 ) { > my $item_mod_fixes_2 = { > notforloan => '', > damaged => '', >- wthdrawn => '', >+ withdrawn => '', > itemlost => '', > }; > > C4::Items::_do_column_fixes_for_mod($item_mod_fixes_2); > is( $item_mod_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during mod' ); > is( $item_mod_fixes_2->{'damaged'}, 0, 'empty damaged fixed during mod' ); >- is( $item_mod_fixes_2->{'wthdrawn'}, 0, 'empty wthdrawn fixed during mod' ); >+ is( $item_mod_fixes_2->{'withdrawn'}, 0, 'empty withdrawn fixed during mod' ); > is( $item_mod_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during mod' ); > > } >@@ -62,14 +62,14 @@ sub not_clobbered : Test( 4 ) { > my $item_mod_fixes_3 = { > notforloan => 1, > damaged => 2, >- wthdrawn => 3, >+ withdrawn => 3, > itemlost => 4, > }; > > C4::Items::_do_column_fixes_for_mod($item_mod_fixes_3); > is( $item_mod_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' ); > is( $item_mod_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' ); >- is( $item_mod_fixes_3->{'wthdrawn'}, 3, 'do not clobber wthdrawn during mod' ); >+ is( $item_mod_fixes_3->{'withdrawn'}, 3, 'do not clobber withdrawn during mod' ); > is( $item_mod_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' ); > > } >diff --git a/t/db_dependent/lib/KohaTest/Items/SetDefaults.pm b/t/db_dependent/lib/KohaTest/Items/SetDefaults.pm >index fd622a7..cab8a19 100644 >--- a/t/db_dependent/lib/KohaTest/Items/SetDefaults.pm >+++ b/t/db_dependent/lib/KohaTest/Items/SetDefaults.pm >@@ -38,14 +38,14 @@ sub undefined : Test( 4 ) { > my $item_add_fixes_1 = { > notforloan => undef, > damaged => undef, >- wthdrawn => undef, >+ withdrawn => undef, > itemlost => undef, > }; > > C4::Items::_set_defaults_for_add($item_add_fixes_1); > is( $item_add_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during add' ); > is( $item_add_fixes_1->{'damaged'}, 0, 'null damaged fixed during add' ); >- is( $item_add_fixes_1->{'wthdrawn'}, 0, 'null wthdrawn fixed during add' ); >+ is( $item_add_fixes_1->{'withdrawn'}, 0, 'null withdrawn fixed during add' ); > is( $item_add_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during add' ); > } > >@@ -54,14 +54,14 @@ sub empty_gets_fixed : Test( 4 ) { > my $item_add_fixes_2 = { > notforloan => '', > damaged => '', >- wthdrawn => '', >+ withdrawn => '', > itemlost => '', > }; > > C4::Items::_set_defaults_for_add($item_add_fixes_2); > is( $item_add_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during add' ); > is( $item_add_fixes_2->{'damaged'}, 0, 'empty damaged fixed during add' ); >- is( $item_add_fixes_2->{'wthdrawn'}, 0, 'empty wthdrawn fixed during add' ); >+ is( $item_add_fixes_2->{'withdrawn'}, 0, 'empty withdrawn fixed during add' ); > is( $item_add_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during add' ); > > } >@@ -71,14 +71,14 @@ sub do_not_clobber : Test( 4 ) { > my $item_add_fixes_3 = { > notforloan => 1, > damaged => 2, >- wthdrawn => 3, >+ withdrawn => 3, > itemlost => 4, > }; > > C4::Items::_set_defaults_for_add($item_add_fixes_3); > is( $item_add_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' ); > is( $item_add_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' ); >- is( $item_add_fixes_3->{'wthdrawn'}, 3, 'do not clobber wthdrawn during mod' ); >+ is( $item_add_fixes_3->{'withdrawn'}, 3, 'do not clobber withdrawn during mod' ); > is( $item_add_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' ); > > } >diff --git a/tools/inventory.pl b/tools/inventory.pl >index fdf3161..824906b 100755 >--- a/tools/inventory.pl >+++ b/tools/inventory.pl >@@ -93,7 +93,7 @@ for my $fwk (keys %$frameworks){ > } > > my $statuses = []; >-for my $statfield (qw/items.notforloan items.itemlost items.wthdrawn items.damaged/){ >+for my $statfield (qw/items.notforloan items.itemlost items.withdrawn items.damaged/){ > my $hash = {}; > $hash->{fieldname} = $statfield; > $hash->{authcode} = GetAuthValCode($statfield); >@@ -143,13 +143,13 @@ if ($uploadbarcodes && length($uploadbarcodes)>0){ > # warn "$date"; > my $strsth="select * from issues, items where items.itemnumber=issues.itemnumber and items.barcode =?"; > my $qonloan = $dbh->prepare($strsth); >- $strsth="select * from items where items.barcode =? and items.wthdrawn = 1"; >- my $qwthdrawn = $dbh->prepare($strsth); >+ $strsth="select * from items where items.barcode =? and items.withdrawn = 1"; >+ my $qwithdrawn = $dbh->prepare($strsth); > my @errorloop; > my $count=0; > while (my $barcode=<$uploadbarcodes>){ > $barcode =~ s/\r?\n$//; >- if ($qwthdrawn->execute($barcode) &&$qwthdrawn->rows){ >+ if ($qwithdrawn->execute($barcode) &&$qwithdrawn->rows){ > push @errorloop, {'barcode'=>$barcode,'ERR_WTHDRAWN'=>1}; > }else{ > my $item = GetItem('', $barcode); >@@ -173,7 +173,7 @@ if ($uploadbarcodes && length($uploadbarcodes)>0){ > } > } > $qonloan->finish; >- $qwthdrawn->finish; >+ $qwithdrawn->finish; > $template->param(date=>format_date($date),Number=>$count); > # $template->param(errorfile=>$errorfile) if ($errorfile); > $template->param(errorloop=>\@errorloop) if (@errorloop); >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10550
:
19480
|
19481
|
19502
|
20178
|
20179
|
20457
|
20458