From 17be46d6f0e8db77193c1ab9428f8f42fee10e5e Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 8 Jul 2013 12:00:13 -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 | 24 +++++++++++++++----- 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, 239 insertions(+), 227 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 30cbe2f..ca52cfd 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'; } @@ -873,7 +873,7 @@ sub CanBookBeIssued { } } } - if ( $item->{'wthdrawn'} && $item->{'wthdrawn'} > 0 ) + if ( $item->{'withdrawn'} && $item->{'withdrawn'} > 0 ) { $issuingimpossible{WTHDRAWN} = 1; } @@ -1671,7 +1671,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 +=item C This book has been withdrawn/cancelled. The value should be ignored. @@ -1764,8 +1764,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"); } @@ -1876,7 +1876,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..d50c70f 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, C, C, or -C that is either undefined or +C 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 =item * -C +C =back @@ -2044,7 +2044,7 @@ C 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 5ff12e4..2f2621a 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -1458,7 +1458,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..56b3f58 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..532768f 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..55ae7d2 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..29bd6ee 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..d7b923e 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..c1d4f1d 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 2a7c10b..1ddc99a 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 @@ -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, -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..4473891 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..1f3a38d 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..8d7980d 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..b675525 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..4473891 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..e67d6f1 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..4d96273 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..8c61452 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..377b50c 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..9ac5e1e 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..4473891 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..70d147b 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 f5e1862..c81283e 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..e0eb25b 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..d47a098 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..abe4e56 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..3990cc5 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..7e759b6 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..b872be5 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..72d42d2 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 08722cc..7cef576 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -265,7 +265,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { MODIFY `price` DECIMAL(8,2) DEFAULT NULL, MODIFY `replacementprice` DECIMAL(8,2) DEFAULT NULL, DROP `bulk`, - MODIFY `itemcallnumber` VARCHAR(30) DEFAULT NULL AFTER `wthdrawn`, + MODIFY `itemcallnumber` VARCHAR(30) DEFAULT NULL AFTER `withdrawn`, MODIFY `holdingbranch` VARCHAR(10) DEFAULT NULL, DROP `interim`, MODIFY `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP AFTER `paidfor`, @@ -764,7 +764,7 @@ $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,ty $DBversion = "3.00.00.032"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("UPDATE `marc_subfield_structure` SET `kohafield` = 'items.wthdrawn' WHERE `kohafield` = 'items.withdrawn'"); + $dbh->do("UPDATE `marc_subfield_structure` SET `kohafield` = 'items.withdrawn' WHERE `kohafield` = 'items.withdrawn'"); print "Upgrade to $DBversion done (fixed MARC framework references to items.withdrawn)\n"; SetVersion ($DBversion); } @@ -848,21 +848,21 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("UPDATE items SET notforloan = 0 WHERE notforloan IS NULL"); $dbh->do("UPDATE items SET damaged = 0 WHERE damaged IS NULL"); $dbh->do("UPDATE items SET itemlost = 0 WHERE itemlost IS NULL"); - $dbh->do("UPDATE items SET wthdrawn = 0 WHERE wthdrawn IS NULL"); + $dbh->do("UPDATE items SET withdrawn = 0 WHERE withdrawn IS NULL"); $dbh->do("ALTER TABLE items MODIFY notforloan tinyint(1) NOT NULL default 0, MODIFY damaged tinyint(1) NOT NULL default 0, MODIFY itemlost tinyint(1) NOT NULL default 0, - MODIFY wthdrawn tinyint(1) NOT NULL default 0"); + MODIFY withdrawn tinyint(1) NOT NULL default 0"); $dbh->do("UPDATE deleteditems SET notforloan = 0 WHERE notforloan IS NULL"); $dbh->do("UPDATE deleteditems SET damaged = 0 WHERE damaged IS NULL"); $dbh->do("UPDATE deleteditems SET itemlost = 0 WHERE itemlost IS NULL"); - $dbh->do("UPDATE deleteditems SET wthdrawn = 0 WHERE wthdrawn IS NULL"); + $dbh->do("UPDATE deleteditems SET withdrawn = 0 WHERE withdrawn IS NULL"); $dbh->do("ALTER TABLE deleteditems MODIFY notforloan tinyint(1) NOT NULL default 0, MODIFY damaged tinyint(1) NOT NULL default 0, MODIFY itemlost tinyint(1) NOT NULL default 0, - MODIFY wthdrawn tinyint(1) NOT NULL default 0"); + MODIFY withdrawn tinyint(1) NOT NULL default 0"); print "Upgrade to $DBversion done (disallow NULL in several item status columns)\n"; SetVersion ($DBversion); } @@ -7029,6 +7029,18 @@ INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( 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' + }); + + print "Upgrade to $DBversion done (Bug 10550 - Fix database typo wthdrawn)\n"; + SetVersion($DBversion); +} =head1 FUNCTIONS 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 9ebb4cb..50b6b4e 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 ) %] Withdrawn [% 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 %]
    @@ -104,7 +104,7 @@ [% END %] [% END %] - + [% ELSE %] @@ -134,7 +134,7 @@ [% END %] [% END %] - + [% ELSE %] @@ -147,7 +147,7 @@ [% END %] [% END %] -
  1. Withdrawn?:[% IF ( ITEM_DAT.wthdrawn ) %]Yes[% ELSE %]No[% END %] +
  2. Withdrawn?:[% IF ( ITEM_DAT.withdrawn ) %]Yes[% ELSE %]No[% END %] [% IF ( CAN_user_circulate ) %]
    @@ -156,10 +156,10 @@ - [% IF ( ITEM_DAT.wthdrawn ) %] - [% ELSE %] + [% IF ( ITEM_DAT.withdrawn ) %] + [% ELSE %] [% END %] - [% IF ( ITEM_DAT.wthdrawn ) %] + [% IF ( ITEM_DAT.withdrawn ) %] [% ELSE %] [% END %]
    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 ) %][[% other_items_loo.itemcallnumber %]][% 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 %] [% IF ( resultsloo.onloancount ) %] Checked out ([% resultsloo.onloancount %]),
    [% END %] - [% IF ( resultsloo.wthdrawncount ) %] Withdrawn ([% resultsloo.wthdrawncount %]),
    [% END %] + [% IF ( resultsloo.withdrawncount ) %] Withdrawn ([% resultsloo.withdrawncount %]),
    [% END %] [% IF ( resultsloo.itemlostcount ) %] Lost ([% resultsloo.itemlostcount %])
    [% END %] [% IF ( resultsloo.orderedcount ) %] On order ([% resultsloo.orderedcount %])[% END %]
    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 9311599..c2479f5 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 44fd575..6df9bb3 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 @@ -259,7 +259,7 @@ function highlightOn() { [% END %] [% 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 923effa..5b7c115 100644 --- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt +++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt @@ -560,7 +560,7 @@ $(document).ready(function(){ [% END %] [% 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