Attachment #19481 for bug #10550

View | Details | Raw Unified | Return to bug 10550
Collapse All | Expand All




            $data->{'borrower'} = $data2->{'borrowernumber'};
        }
        else {
            $data->{'date_due'} = ($data->{'withdrawn'} eq '1') ? 'Cancelled' : 'Available';
        }



            }
        }
    }
    if ( $item->{'withdrawn'} && $item->{'withdrawn'} > 0 )
    {
        $issuingimpossible{WTHDRAWN} = 1;
    }

this book, you are not allowed to return it. The value is the code for
the book's home branch.

=item C<withdrawn>

This book has been withdrawn/cancelled. The value should be ignored.


        return ( $doreturn, $messages, $issue, $borrower );
    }

    if ( $item->{'withdrawn'} ) { # book has been cancelled
        $messages->{'withdrawn'} = 1;
        $doreturn = 0 if C4::Context->preference("BlockReturnOfWithdrawnItems");
    }


    # 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->{'withdrawn'} );
    if ($resfound) {
          $resrec->{'ResFound'} = $resfound;
        $messages->{'ResFound'} = $resrec;

Lines 310-316 sub GetItemsAvailableToFillHoldRequestsForBib { Link Here

(-)a/C4/HoldsQueue.pm (-1 / +1 lines)
310	$items_query .= "WHERE items.notforloan = 0	310	$items_query .= "WHERE items.notforloan = 0
311	AND holdingbranch IS NOT NULL	311	AND holdingbranch IS NOT NULL
312	AND itemlost = 0	312	AND itemlost = 0
313	AND wthdrawn = 0";	313	AND withdrawn = 0";
314	$items_query .= " AND damaged = 0" unless C4::Context->preference('AllowHoldsOnDamagedItems');	314	$items_query .= " AND damaged = 0" unless C4::Context->preference('AllowHoldsOnDamagedItems');
315	$items_query .= " AND items.onloan IS NULL	315	$items_query .= " AND items.onloan IS NULL
316	AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0)	316	AND (itemtypes.notforloan IS NULL OR itemtypes.notforloan = 0)

Lines 93-99 sub Availability { Link Here

(-)a/C4/ILSDI/Utility.pm (-1 / +1 lines)
93	return ( $biblionumber, 'not available', 'Checked out', $location );	93	return ( $biblionumber, 'not available', 'Checked out', $location );
94	} elsif ( $item->{'itemlost'} ) {	94	} elsif ( $item->{'itemlost'} ) {
95	return ( $biblionumber, 'not available', 'Item lost', $location );	95	return ( $biblionumber, 'not available', 'Item lost', $location );
96	} elsif ( $item->{'wthdrawn'} ) {	96	} elsif ( $item->{'withdrawn'} ) {
97	return ( $biblionumber, 'not available', 'Item withdrawn', $location );	97	return ( $biblionumber, 'not available', 'Item withdrawn', $location );
98	} elsif ( $item->{'damaged'} ) {	98	} elsif ( $item->{'damaged'} ) {
99	return ( $biblionumber, 'not available', 'Item damaged', $location );	99	return ( $biblionumber, 'not available', 'Item damaged', $location );




    stack                => undef, 
    stocknumber          => undef, 
    uri                  => undef, 
    withdrawn             => 0,
);

sub ModItemFromMarc {

            $data->{'borrowernumber'}   = $data2->{'borrowernumber'};
        }
        else {
            # 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.                  

columns to modify, fix up certain values.
Specifically, set to 0 any passed value
of C<notforloan>, C<damaged>, C<itemlost>, or
C<withdrawn> that is either undefined or
contains the empty string.

=cut

        (not defined $item->{'itemlost'} or $item->{'itemlost'} eq '')) {
        $item->{'itemlost'} = 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'};


=item *

C<items.withdrawn>

=back


sub _set_defaults_for_add {
    my $item = shift;
    $item->{dateaccessioned} ||= C4::Dates->new->output('iso');
    $item->{$_} ||= 0 for (qw( notforloan damaged itemlost withdrawn));
}

=head2 _koha_new_item

            notforloan          = ?,
            damaged             = ?,
            itemlost            = ?,
            withdrawn            = ?,
            itemcallnumber      = ?,
            coded_location_qualifier = ?,
            restricted          = ?,

            $item->{'notforloan'},
            $item->{'damaged'},
            $item->{'itemlost'},
            $item->{'withdrawn'},
            $item->{'itemcallnumber'},
            $item->{'coded_location_qualifier'},
            $item->{'restricted'},

Lines 1458-1464 sub IsAvailableForItemLevelRequest { Link Here

(-)a/C4/Reserves.pm (-1 / +1 lines)
1458	$available_per_item = 0 if $item->{itemlost} or	1458	$available_per_item = 0 if $item->{itemlost} or
1459	( $item->{notforloan} > 0 ) or	1459	( $item->{notforloan} > 0 ) or
1460	($item->{damaged} and not C4::Context->preference('AllowHoldsOnDamagedItems')) or	1460	($item->{damaged} and not C4::Context->preference('AllowHoldsOnDamagedItems')) or
1461	$item->{wthdrawn} or	1461	$item->{withdrawn} or
1462	$notforloan_per_itemtype;	1462	$notforloan_per_itemtype;
1463		1463
1464		1464

Lines 63-69 sub do_checkin { Link Here

(-)a/C4/SIP/ILS/Transaction/Checkin.pm (-1 / +1 lines)
63	if ($messages->{BadBarcode}) {	63	if ($messages->{BadBarcode}) {
64	$self->alert_type('99');	64	$self->alert_type('99');
65	}	65	}
66	if ($messages->{wthdrawn}) {	66	if ($messages->{withdrawn}) {
67	$self->alert_type('99');	67	$self->alert_type('99');
68	}	68	}
69	if ($messages->{Wrongbranch}) {	69	if ($messages->{Wrongbranch}) {




        my $onloan_count          = 0;
        my $longoverdue_count     = 0;
        my $other_count           = 0;
        my $withdrawn_count        = 0;
        my $itemlost_count        = 0;
        my $hideatopac_count      = 0;
        my $itembinding_count     = 0;

                # is item on the reserve shelf?
                my $reservestatus = '';

                unless ($item->{withdrawn}
                        || $item->{itemlost}
                        || $item->{damaged}
                        || $item->{notforloan}

                }

                # item is withdrawn, lost, damaged, not for loan, reserved or in transit
                if (   $item->{withdrawn}
                    || $item->{itemlost}
                    || $item->{damaged}
                    || $item->{notforloan}
                    || $reservestatus eq 'Waiting'
                    || ($transfertwhen ne ''))
                {
                    $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->{withdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan};

                    # can place hold on item ?
                    if ( !$item->{itemlost} ) {
                        if ( !$item->{withdrawn} ){
                            if ( $item->{damaged} ){
                                if ( C4::Context->preference('AllowHoldsOnDamagedItems') ){
                                    # can place a hold on a damaged item if AllowHoldsOnDamagedItems is true

                    $other_count++;

                    my $key = $prefix . $item->{status};
                    foreach (qw(withdrawn itemlost damaged branchname itemcallnumber)) {
                        $other_items->{$key}->{$_} = $item->{$_};
                    }
                    $other_items->{$key}->{intransit} = ( $transfertwhen ne '' ) ? 1 : 0;

        $oldbiblio->{onloanplural}         = 1 if $onloan_count > 1;
        $oldbiblio->{othercount}           = $other_count;
        $oldbiblio->{otherplural}          = 1 if $other_count > 1;
        $oldbiblio->{withdrawncount}        = $withdrawn_count;
        $oldbiblio->{itemlostcount}        = $itemlost_count;
        $oldbiblio->{damagedcount}         = $itemdamaged_count;
        $oldbiblio->{intransitcount}       = $item_in_transit_count;

Lines 266-272 sub buildKohaItemsNamespace { Link Here

(-)a/C4/XSLT.pm (-2 / +2 lines)
266		266
267	my $reservestatus = C4::Reserves::GetReserveStatus( $item->{itemnumber} );	267	my $reservestatus = C4::Reserves::GetReserveStatus( $item->{itemnumber} );
268		268
269	if ( $itemtypes->{ $item->{itype} }->{notforloan} \|\| $item->{notforloan} \|\| $item->{onloan} \|\| $item->{wthdrawn} \|\| $item->{itemlost} \|\| $item->{damaged} \|\|	269	if ( $itemtypes->{ $item->{itype} }->{notforloan} \|\| $item->{notforloan} \|\| $item->{onloan} \|\| $item->{withdrawn} \|\| $item->{itemlost} \|\| $item->{damaged} \|\|
270	(defined $transfertwhen && $transfertwhen ne '') \|\| $item->{itemnotforloan} \|\| (defined $reservestatus && $reservestatus eq "Waiting") ){	270	(defined $transfertwhen && $transfertwhen ne '') \|\| $item->{itemnotforloan} \|\| (defined $reservestatus && $reservestatus eq "Waiting") ){
271	if ( $item->{notforloan} < 0) {	271	if ( $item->{notforloan} < 0) {
272	$status = "On order";	272	$status = "On order";
Lines 277-283 sub buildKohaItemsNamespace { Link Here
277	if ($item->{onloan}) {	277	if ($item->{onloan}) {
278	$status = "Checked out";	278	$status = "Checked out";
279	}	279	}
280	if ( $item->{wthdrawn}) {	280	if ( $item->{withdrawn}) {
281	$status = "Withdrawn";	281	$status = "Withdrawn";
282	}	282	}
283	if ($item->{itemlost}) {	283	if ($item->{itemlost}) {

Lines 168-174 foreach my $item (@items){ Link Here

(-)a/catalogue/moredetail.pl (-1 / +1 lines)
168	}	168	}
169	$item->{'datereceived'} = $order->{'datereceived'};	169	$item->{'datereceived'} = $order->{'datereceived'};
170		170
171	if ($item->{notforloantext} or $item->{itemlost} or $item->{damaged} or $item->{wthdrawn}) {	171	if ($item->{notforloantext} or $item->{itemlost} or $item->{damaged} or $item->{withdrawn}) {
172	$item->{status_advisory} = 1;	172	$item->{status_advisory} = 1;
173	}	173	}
174		174




my $biblioitemnumber=$cgi->param('biblioitemnumber');
my $itemlost=$cgi->param('itemlost');
my $itemnotes=$cgi->param('itemnotes');
my $withdrawn=$cgi->param('withdrawn');
my $damaged=$cgi->param('damaged');

my $confirm=$cgi->param('confirm');

my $item_data_hashref = GetItem($itemnumber, undef);

# make sure item statuses are set to 0 if empty or NULL
for ($damaged,$itemlost,$withdrawn) {
    if (!$_ or $_ eq "") {
        $_ = 0;
    }

    }
} elsif ($itemlost ne $item_data_hashref->{'itemlost'}) {
    $item_changes->{'itemlost'} = $itemlost;
} elsif ($withdrawn ne $item_data_hashref->{'withdrawn'}) {
    $item_changes->{'withdrawn'} = $withdrawn;
} elsif ($damaged ne $item_data_hashref->{'damaged'}) {
    $item_changes->{'damaged'} = $damaged;
} else {

Lines 145-151 if ( $run_report ) { Link Here

(-)a/circ/pendingreserves.pl (-1 / +1 lines)
145	AND issues.itemnumber IS NULL	145	AND issues.itemnumber IS NULL
146	AND reserves.priority <> 0	146	AND reserves.priority <> 0
147	AND reserves.suspend = 0	147	AND reserves.suspend = 0
148	AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0	148	AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
149	";	149	";
150	# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when	150	# GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when
151	# multiple patrons have a hold on an item	151	# multiple patrons have a hold on an item

Lines 109-115 my $strsth = Link Here

(-)a/circ/reserveratios.pl (-1 / +1 lines)
109	LEFT JOIN items ON items.biblionumber=reserves.biblionumber	109	LEFT JOIN items ON items.biblionumber=reserves.biblionumber
110	LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber	110	LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber
111	WHERE	111	WHERE
112	notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0	112	notforloan = 0 AND damaged = 0 AND itemlost = 0 AND withdrawn = 0
113	$sqldatewhere	113	$sqldatewhere
114	";	114	";
115		115

Lines 430-436 foreach my $code ( keys %$messages ) { Link Here

(-)a/circ/returns.pl (-1 / +1 lines)
430	elsif ( $code eq 'WasTransfered' ) {	430	elsif ( $code eq 'WasTransfered' ) {
431	; # FIXME... anything to do here?	431	; # FIXME... anything to do here?
432	}	432	}
433	elsif ( $code eq 'wthdrawn' ) {	433	elsif ( $code eq 'withdrawn' ) {
434	$err{withdrawn} = 1;	434	$err{withdrawn} = 1;
435	$exit_required_p = 1 if C4::Context->preference("BlockReturnOfWithdrawnItems");	435	$exit_required_p = 1 if C4::Context->preference("BlockReturnOfWithdrawnItems");
436	}	436	}

Lines 8-12 Items can be hidden according to values from the items table: Link Here

(-)a/docs/opac/OpacHiddenItems.txt (-1 / +1 lines)
8	field: [value1, value2, ...]	8	field: [value1, value2, ...]
9		9
10	Example :	10	Example :
11	wthdrawn: [0, 1]	11	withdrawn: [0, 1]
12	homebranch: [homebranch1, homebranch2]	12	homebranch: [homebranch1, homebranch2]

Lines 103-109 INSERT INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, man Link Here

(-)a/installer/data/Pg/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, '', '', '', NULL),	108	('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, '', '', '', NULL, 0, '', '', '', NULL),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 844-850 stack int default NULL, Link Here

(-)a/installer/data/Pg/kohastructure.sql (-2 / +2 lines)
844	notforloan int default NULL,	844	notforloan int default NULL,
845	damaged int default NULL,	845	damaged int default NULL,
846	itemlost int default NULL,	846	itemlost int default NULL,
847	wthdrawn int default NULL,	847	withdrawn int default NULL,
848	bulk varchar(30) default NULL,	848	bulk varchar(30) default NULL,
849	issues int default NULL,	849	issues int default NULL,
850	renewals int default NULL,	850	renewals int default NULL,
Lines 950-956 stack int default NULL, Link Here
950	notforloan int default NULL,	950	notforloan int default NULL,
951	damaged int default NULL,	951	damaged int default NULL,
952	itemlost int default NULL,	952	itemlost int default NULL,
953	wthdrawn int default NULL,	953	withdrawn int default NULL,
954	itemcallnumber varchar(30) default NULL,	954	itemcallnumber varchar(30) default NULL,
955	issues int default NULL,	955	issues int default NULL,
956	renewals int default NULL,	956	renewals int default NULL,

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', '');	103	('952', 'Standort- und Exemplarinformationen (KOHA)', 'Standort- und Exemplarinformationen (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Ausgeschieden', 'Ausgeschieden', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Verloren', 'Verloren', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('952', '2', 'Klassifikationsschema', 'Klassifikationsschema oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL),	108	('952', '2', 'Klassifikationsschema', 'Klassifikationsschema oder Aufstellungssystematik', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, '', '', '', NULL),
109	('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Beilagenotiz', 'Beilagenotiz', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942','c','Medientyp', 'Medientyp', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942','c','Medientyp', 'Medientyp', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942','n','OPAC-Anzeige unterdrücken', 'OPAC-Anzeige unterdrücken', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942','n','OPAC-Anzeige unterdrücken', 'OPAC-Anzeige unterdrücken', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942','s','Kennzeichen für Zeitschrift', 'Zeitschrift', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942','s','Kennzeichen für Zeitschrift', 'Zeitschrift', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Ausgeschieden','Ausgeschieden',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Ausgeschieden','Ausgeschieden',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Verloren','Verloren',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Verloren','Verloren',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('952','2','Klassifikation oder Aufstellungssystematik','Klassifikation oder Aufstellungssystematik',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL),	105	('952','2','Klassifikation oder Aufstellungssystematik','Klassifikation oder Aufstellungssystematik',0,0,'items.cn_source',10,'cn_source','','',NULL,0,'FA','',NULL,NULL),
106	('952','3','Beilagenotiz','Beilagenotiz',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL),	106	('952','3','Beilagenotiz','Beilagenotiz',0,0,'items.materials',10,'','','',NULL,0,'FA','',NULL,NULL),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 30-36 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here

(-)a/installer/data/mysql/de-DE/optional/auth_val.sql (-1 / +1 lines)
30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Nachschlagewerke');	30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Nachschlagewerke');
31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur');	31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur');
32		32
33	-- withdrawn status of an item, linked to items.wthdrawn	33	-- withdrawn status of an item, linked to items.withdrawn
34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden');	34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden');
35		35
36	-- loanability status of an item, linked to items.notforloan	36	-- loanability status of an item, linked to items.notforloan

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL),
108	('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),	108	('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),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('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),	105	('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),
106	('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),	106	('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),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 121-127 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (-1 / +1 lines)
121	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');	121	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
122		122
123	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	123	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
124	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),	124	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),
125	('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	125	('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
126	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),	126	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),
127	('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL),	127	('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL),

Lines 30-36 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here

(-)a/installer/data/mysql/en/optional/auth_val.sql (-1 / +1 lines)
30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');	30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');	31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
32		32
33	-- withdrawn status of an item, linked to items.wthdrawn	33	-- withdrawn status of an item, linked to items.withdrawn
34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');	34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
35		35
36	-- loanability status of an item, linked to items.notforloan	36	-- loanability status of an item, linked to items.notforloan

Lines 106-112 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
106	('952', 'INFORMACIÓN DE EJEMPLAR Y UBICACIÓN (KOHA)', 'INFORMACIÓN DE EJEMPLAR Y UBICACIÓN (KOHA)', 1, 0, '', '');	106	('952', 'INFORMACIÓN DE EJEMPLAR Y UBICACIÓN (KOHA)', 'INFORMACIÓN DE EJEMPLAR Y UBICACIÓN (KOHA)', 1, 0, '', '');
107		107
108	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	108	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
109	('952', '0', 'Suprimido', 'Suprimido', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	109	('952', '0', 'Suprimido', 'Suprimido', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
110	('952', '1', 'Estado de pérdida', 'Estado de pérdida', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL),	110	('952', '1', 'Estado de pérdida', 'Estado de pérdida', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, -5, '', '', '', NULL),
111	('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),	111	('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),
112	('952', '3', 'Materiales especializados (volumen obligatorio u otra parte)', 'Materiales especializados (volumen obligatorio u otra parte)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	112	('952', '3', 'Materiales especializados (volumen obligatorio u otra parte)', 'Materiales especializados (volumen obligatorio u otra parte)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('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),	105	('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),
106	('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),	106	('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),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 121-127 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (-1 / +1 lines)
121	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');	121	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
122		122
123	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	123	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
124	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),	124	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),
125	('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	125	('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
126	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),	126	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),
127	('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL),	127	('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL),

Lines 30-36 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here

(-)a/installer/data/mysql/es-ES/optional/auth_val.sql (-1 / +1 lines)
30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');	30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');	31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
32		32
33	-- withdrawn status of an item, linked to items.wthdrawn	33	-- withdrawn status of an item, linked to items.withdrawn
34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');	34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
35		35
36	-- loanability status of an item, linked to items.notforloan	36	-- loanability status of an item, linked to items.notforloan

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('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),	108	('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),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('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),	108	('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),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('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),	105	('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),
106	('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),	106	('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),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),




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.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');

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.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');

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.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');

Lines 36-42 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE', Link Here

(-)a/installer/data/mysql/it-IT/necessari/auth_val.sql (-1 / +1 lines)
36	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');	36	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');
37	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');	37	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
38		38
39	-- withdrawn status of an item, linked to items.wthdrawn	39	-- withdrawn status of an item, linked to items.withdrawn
40	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata');	40	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','0','Non ritirata');
41	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione');	41	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ritirata dalla circolazione');
42		42

Lines 51-57 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here

(-)a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql (-1 / +1 lines)
51	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Oppslagsverk');	51	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Oppslagsverk');
52	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur');	52	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur');
53		53
54	-- withdrawn status of an item, linked to items.wthdrawn	54	-- withdrawn status of an item, linked to items.withdrawn
55	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake');	55	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake');
56		56
57	-- loanability status of an item, linked to items.notforloan	57	-- loanability status of an item, linked to items.notforloan

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('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),	108	('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),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('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),	105	('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),
106	('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),	106	('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),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 970-976 INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r Link Here

(-)a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql (-1 / +1 lines)
970	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');	970	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');
971	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');	971	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');
972	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');	972	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');
973	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');	973	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');
974	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');	974	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');
975	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');	975	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');
976	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');	976	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');

Lines 89-95 INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r Link Here

(-)a/installer/data/mysql/nb-NO/marcflavour/normarc/Valgfritt/normarc_fastadd_framework.sql (-1 / +1 lines)
89	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');	89	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');
90	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');	90	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');
91	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');	91	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');
92	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');	92	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');
93	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');	93	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');
94	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');	94	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');
95	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');	95	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');

Lines 103-109 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-1 / +1 lines)
103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');	103	('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', '');
104		104
105	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	105	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
106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),	106	('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL),
107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	107	('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
108	('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),	108	('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),
109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),	109	('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, -1, '', '', '', NULL),

Lines 100-106 INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib Link Here

(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-1 / +1 lines)
100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),	100	('942', 'c', 'Koha [default] item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),	101	('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),	102	('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.wthdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),	103	('952','0','Withdrawn status','Withdrawn status',0,0,'items.withdrawn',10,'WITHDRAWN','','',NULL,0,'FA','',NULL,NULL),
104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),	104	('952','1','Lost status','Lost status',0,0,'items.itemlost',10,'LOST','','',NULL,0,'FA','',NULL,NULL),
105	('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),	105	('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),
106	('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),	106	('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),




		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

		('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.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),

Lines 118-124 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here

(-)a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql
118	-- ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');	118	-- ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
119		119
120	-- 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	120	-- 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

Lines 171-177 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here

(-) (-1 / +1 lines)
171	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');	171	('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', '');
172		172
173	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	173	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
174	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.wthdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),	174	('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL),
175	('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),	175	('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL),
176	('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),	176	('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),
177	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),	177	('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL),

Lines 28-34 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here

(-)a/installer/data/mysql/pl-PL/optional/auth_val.sql (-1 / +1 lines)
28	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');	28	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');	29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
30		30
31	-- withdrawn status of an item, linked to items.wthdrawn	31	-- withdrawn status of an item, linked to items.withdrawn
32	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');	32	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
33		33
34	-- loanability status of an item, linked to items.notforloan	34	-- loanability status of an item, linked to items.notforloan

Line 1 Link Here

(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt (-1 / +1 lines)
1	Статус изъятия экземпляра, связан с items.wthdrawn	1	Статус изъятия экземпляра, связан с items.withdrawn

Lines 786-792 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql (-1 / +1 lines)
786	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	786	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
787	('', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	787	('', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
788	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	788	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
789	('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	789	('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
790	('', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	790	('', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
791	('', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	791	('', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
792	('', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	792	('', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('AR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('AR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('AR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('AR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('AR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('AR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('AR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('AR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('AR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('AR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('BKS', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('BKS', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('BKS', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('BKS', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('BKS', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('BKS', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('BKS', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('BKS', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('BKS', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('BKS', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('CF', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('CF', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('CF', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('CF', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('CF', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('CF', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('CF', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('CF', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('CF', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('CF', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 23-29 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql (-1 / +1 lines)
23	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	23	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
24	('FA', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	24	('FA', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
25	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	25	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
26	('FA', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL),	26	('FA', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL),
27	('FA', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL),	27	('FA', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL),
28	('FA', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL),	28	('FA', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL),
29	('FA', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL),	29	('FA', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('IR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('IR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('IR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('IR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('IR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('IR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('IR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('IR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('IR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('IR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('KT', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('KT', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('KT', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('KT', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('KT', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('KT', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('KT', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('KT', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('KT', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('KT', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('SER', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('SER', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('SER', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('SER', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('SER', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('SER', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('SER', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('SER', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('SER', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('SER', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('SR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('SR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('SR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('SR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('SR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('SR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('SR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('SR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('SR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('SR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('VR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');	763	('VR', '952', '', 1, 'Данные о экземплярах и расположение (Koha)', '', '');
764	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	764	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
765	('VR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('VR', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('VR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('VR', '', '952', '1', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('VR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('VR', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('VR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('VR', '', '952', '3', 0, 0, 'Нумерация (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 95-101 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql (-1 / +1 lines)
95	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	95	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
96	('', '952', '', '', 'Данные о экземплярах и расположение (Koha)', '', '');	96	('', '952', '', '', 'Данные о экземплярах и расположение (Koha)', '', '');
97	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	97	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
98	('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL),	98	('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL),
99	('', '', '952', '1', 0, 0, 'Статус доступности', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	99	('', '', '952', '1', 0, 0, 'Статус доступности', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
100	('', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	100	('', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
101	('', '', '952', '3', 0, 0, 'Идентификация описываемого материала (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	101	('', '', '952', '3', 0, 0, 'Идентификация описываемого материала (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Line 1 Link Here

(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt (-1 / +1 lines)
1	Статус вилучення примірника, зв’язаний з items.wthdrawn	1	Статус вилучення примірника, зв’язаний з items.withdrawn

Lines 786-792 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql (-1 / +1 lines)
786	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	786	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
787	('', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	787	('', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
788	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	788	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
789	('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	789	('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
790	('', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	790	('', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
791	('', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	791	('', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
792	('', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	792	('', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_AR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('AR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('AR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('AR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('AR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('AR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('AR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('AR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('AR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('AR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('AR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_BKS_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('BKS', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('BKS', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('BKS', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('BKS', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('BKS', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('BKS', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('BKS', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('BKS', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('BKS', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('BKS', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_CF_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('CF', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('CF', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('CF', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('CF', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('CF', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('CF', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('CF', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('CF', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('CF', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('CF', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 23-29 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_FA_local.sql (-1 / +1 lines)
23	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	23	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
24	('FA', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	24	('FA', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
25	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	25	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
26	('FA', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL),	26	('FA', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', NULL, '', NULL, NULL),
27	('FA', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL),	27	('FA', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', NULL, '', NULL, NULL),
28	('FA', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL),	28	('FA', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', NULL, NULL),
29	('FA', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL),	29	('FA', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, 0, 'items.materials', '', '', NULL, '', NULL, NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_IR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('IR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('IR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('IR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('IR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('IR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('IR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('IR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('IR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('IR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('IR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_KT_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('KT', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('KT', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('KT', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('KT', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('KT', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('KT', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('KT', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('KT', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('KT', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('KT', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SER_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('SER', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('SER', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('SER', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('SER', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('SER', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('SER', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('SER', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('SER', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('SER', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('SER', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_SR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('SR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('SR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('SR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('SR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('SR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('SR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('SR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('SR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('SR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('SR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 762-768 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_bibliographic_VR_local.sql (-1 / +1 lines)
762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	762	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
763	('VR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');	763	('VR', '952', '', 1, 'Дані про примірники та розташування (Koha)', '', '');
764	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	764	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
765	('VR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WITHDRAWN', '', 0, '', '', NULL),	765	('VR', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL),
766	('VR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	766	('VR', '', '952', '1', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
767	('VR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	767	('VR', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
768	('VR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	768	('VR', '', '952', '3', 0, 0, 'Нумерація (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),

Lines 101-107 INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag Link Here

(-)a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql (-1 / +1 lines)
101	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES	101	INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES
102	('', '952', '', '', 'Дані про примірники та розташування (Koha)', '', '');	102	('', '952', '', '', 'Дані про примірники та розташування (Koha)', '', '');
103	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	103	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
104	('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.wthdrawn', 'WTHDRAWN', '', 0, '', '', NULL),	104	('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL),
105	('', '', '952', '1', 0, 0, 'Статус доступності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),	105	('', '', '952', '1', 0, 0, 'Статус доступності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL),
106	('', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),	106	('', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL),
107	('', '', '952', '3', 0, 0, 'Ідентифікація описуваного матеріалу (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),	107	('', '', '952', '3', 0, 0, 'Ідентифікація описуваного матеріалу (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL),




    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


Lines 81-87 items.cn_source Source of classification / shelving scheme Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/columns.def (-1 / +1 lines)
81	items.cn_sort Koha normalized classification for sorting	81	items.cn_sort Koha normalized classification for sorting
82	items.notforloan Not for loan	82	items.notforloan Not for loan
83	items.itemlost Lost status	83	items.itemlost Lost status
84	items.wthdrawn Withdrawn status	84	items.withdrawn Withdrawn status
85	items.itemcallnumber Call number	85	items.itemcallnumber Call number
86	items.issues Total checkouts	86	items.issues Total checkouts
87	items.renewals Total renewals	87	items.renewals Total renewals

Lines 434-440 function verify_images() { Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/detail.tt (-2 / +2 lines)
434	[% END %]	434	[% END %]
435	[% END %]	435	[% END %]
436		436
437	[% IF ( item.wthdrawn ) %]	437	[% IF ( item.withdrawn ) %]
438	<span class="wdn">Withdrawn</span>	438	<span class="wdn">Withdrawn</span>
439	[% END %]	439	[% END %]
440		440
Lines 484-490 function verify_images() { Link Here
484	[% END %]	484	[% END %]
485	[% END %]	485	[% END %]
486	[% END %]	486	[% END %]
487	[% UNLESS ( item.itemnotforloan or item.onloan or item.itemlost or item.wthdrawn or item.damaged or item.transfertwhen or item.reservedate ) %]	487	[% UNLESS ( item.itemnotforloan or item.onloan or item.itemlost or item.withdrawn or item.damaged or item.transfertwhen or item.reservedate ) %]
488	Available	488	Available
489	[% END %]	489	[% END %]
490		490




                [% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
                [% IF ( ITEM_DAT.itemlost ) %]Lost[% END %]
                [% IF ( ITEM_DAT.damaged ) %]Damaged[% END %]
                [% IF ( ITEM_DAT.withdrawn ) %]Withdrawn[% END %]
            )[% END %]</h4>

            <ol class="bibliodetails">

                            [% END %]
                        [% END %]
                        </select>
                        <input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" />
                        <input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />
                        <input type="submit" name="submit" class="submit" value="Set Status" /></form>
                    [% ELSE %]

                [% END %]
            [% END %]
                    </select>
                    <input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" />
                    <input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />
                    <input type="submit" name="submit" class="submit" value="Set Status" /></form>
                [% ELSE %]

                [% END %]
            </li>
            [% END %]
            <li><span class="label">Withdrawn?:</span>[% IF ( ITEM_DAT.withdrawn ) %]Yes[% ELSE %]No[% END %]
                [% IF ( CAN_user_circulate ) %]
                    <form action="updateitem.pl" method="post">
                    <input type="hidden" name="biblionumber" value="[% ITEM_DAT.biblionumber %]" />

                    <input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />
                    <input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />

            [% IF ( ITEM_DAT.withdrawn ) %]
                    <input type="hidden" name="withdrawn" value="0" />[% ELSE %]<input type="hidden" name="withdrawn" value="1" />
            [% END %]
            [% IF ( ITEM_DAT.withdrawn ) %]
                    <input type="submit" name="submit" class="submit" value="Restore" />[% ELSE %]<input type="submit" name="submit" class="submit" value="Withdraw" />
            [% END %]
                    </form>

Lines 564-570 var holdForPatron = function () { Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/results.tt (-1 / +1 lines)
564	[% IF ( other_items_loo.branchname ) %][% other_items_loo.branchname %][% END %]	564	[% IF ( other_items_loo.branchname ) %][% other_items_loo.branchname %][% END %]
565	[% IF ( other_items_loo.location ) %][% other_items_loo.location %][% END %]	565	[% IF ( other_items_loo.location ) %][% other_items_loo.location %][% END %]
566	[% IF ( other_items_loo.itemcallnumber ) %][<a href="/cgi-bin/koha/catalogue/search.pl?idx=callnum&q=[% other_items_loo.itemcallnumber \|url %]">[% other_items_loo.itemcallnumber %]</a>][% END %]	566	[% IF ( other_items_loo.itemcallnumber ) %][<a href="/cgi-bin/koha/catalogue/search.pl?idx=callnum&q=[% other_items_loo.itemcallnumber \|url %]">[% other_items_loo.itemcallnumber %]</a>][% END %]
567	[% IF ( other_items_loo.wthdrawn ) %](Withdrawn)[% END %]	567	[% IF ( other_items_loo.withdrawn ) %](Withdrawn)[% END %]
568	[% IF ( other_items_loo.itemlost ) %](Lost)[% END %]	568	[% IF ( other_items_loo.itemlost ) %](Lost)[% END %]
569	[% IF ( other_items_loo.damaged ) %](Damaged)[% END %]	569	[% IF ( other_items_loo.damaged ) %](Damaged)[% END %]
570	[% IF ( other_items_loo.intransit ) %](In transit)[% END %]	570	[% IF ( other_items_loo.intransit ) %](In transit)[% END %]

Lines 126-132 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbooks.tt (-1 / +1 lines)
126	[% END %]	126	[% END %]
127	<span class="unavailable">	127	<span class="unavailable">
128	[% IF ( resultsloo.onloancount ) %] Checked out ([% resultsloo.onloancount %]),<br /> [% END %]	128	[% IF ( resultsloo.onloancount ) %] Checked out ([% resultsloo.onloancount %]),<br /> [% END %]
129	[% IF ( resultsloo.wthdrawncount ) %] Withdrawn ([% resultsloo.wthdrawncount %]),<br /> [% END %]	129	[% IF ( resultsloo.withdrawncount ) %] Withdrawn ([% resultsloo.withdrawncount %]),<br /> [% END %]
130	[% IF ( resultsloo.itemlostcount ) %] Lost ([% resultsloo.itemlostcount %])<br />[% END %]	130	[% IF ( resultsloo.itemlostcount ) %] Lost ([% resultsloo.itemlostcount %])<br />[% END %]
131	[% IF ( resultsloo.orderedcount ) %] On order ([% resultsloo.orderedcount %])[% END %]	131	[% IF ( resultsloo.orderedcount ) %] On order ([% resultsloo.orderedcount %])[% END %]
132	</span>	132	</span>

Lines 11-17 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/includes/item-status.inc (-1 / +1 lines)
11	to [% item.transfertto %] since [% item.transfertwhen %]	11	to [% item.transfertto %] since [% item.transfertwhen %]
12	[% ELSIF ( item.waiting ) %]	12	[% ELSIF ( item.waiting ) %]
13	On hold	13	On hold
14	[% ELSIF ( item.wthdrawn ) %]	14	[% ELSIF ( item.withdrawn ) %]
15	Item withdrawn	15	Item withdrawn
16	[% ELSIF ( item.itemlost ) %]	16	[% ELSIF ( item.itemlost ) %]
17	[% av_lib_include = KohaAuthorisedValues.GetByCode( 'LOST', item.itemlost, 1 ) %]	17	[% av_lib_include = KohaAuthorisedValues.GetByCode( 'LOST', item.itemlost, 1 ) %]




    &lt;items&gt;
      &lt;item&gt;
        &lt;biblioitemnumber&gt;1&lt;/biblioitemnumber&gt;
        &lt;withdrawn&gt;0&lt;/withdrawn&gt;
        &lt;holdingbranchname&gt;Bibliothèque Jean Prunier&lt;/holdingbranchname&gt;
        &lt;notforloan&gt;0&lt;/notforloan&gt;
        &lt;replacementpricedate&gt;2008-08-20&lt;/replacementpricedate&gt;

    &lt;items&gt;
      &lt;item&gt;
        &lt;biblioitemnumber&gt;2&lt;/biblioitemnumber&gt;
        &lt;withdrawn&gt;0&lt;/withdrawn&gt;
        &lt;holdingbranchname&gt;Bibliothèque Jean Prunier&lt;/holdingbranchname&gt;
        &lt;notforloan&gt;0&lt;/notforloan&gt;
        &lt;replacementpricedate&gt;2008-08-20&lt;/replacementpricedate&gt;

      &lt;dateaccessioned&gt;2008-08-23&lt;/dateaccessioned&gt;
      &lt;onloan&gt;2008-09-17&lt;/onloan&gt;
      &lt;biblioitemnumber&gt;4483&lt;/biblioitemnumber&gt;
      &lt;withdrawn&gt;0&lt;/withdrawn&gt;
      &lt;notforloan&gt;0&lt;/notforloan&gt;
      &lt;replacementpricedate&gt;2008-08-23&lt;/replacementpricedate&gt;
      &lt;itemcallnumber&gt;RO STE&lt;/itemcallnumber&gt;

      &lt;notes&gt;La couv. porte en plus : "un guide simple et facile pour apprendre la guitare" | Glossaire. Index&lt;/notes&gt;
      &lt;onloan&gt;2008-09-25&lt;/onloan&gt;
      &lt;biblioitemnumber&gt;4486&lt;/biblioitemnumber&gt;
      &lt;withdrawn&gt;0&lt;/withdrawn&gt;
      &lt;notforloan&gt;0&lt;/notforloan&gt;
      &lt;replacementpricedate&gt;2008-08-23&lt;/replacementpricedate&gt;
      &lt;itemcallnumber&gt;787.87 BUC&lt;/itemcallnumber&gt;

Lines 259-265 function highlightOn() { Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results-grouped.tt (-1 / +1 lines)
259	[% END %]	259	[% END %]
260	<span class="unavailable">	260	<span class="unavailable">
261	[% IF ( GROUP_RESULT.onloancount ) %] Checked out ([% GROUP_RESULT.onloancount %]), [% END %]	261	[% IF ( GROUP_RESULT.onloancount ) %] Checked out ([% GROUP_RESULT.onloancount %]), [% END %]
262	[% IF ( GROUP_RESULT.wthdrawncount ) %] Withdrawn ([% GROUP_RESULT.wthdrawncount %]), [% END %]	262	[% IF ( GROUP_RESULT.withdrawncount ) %] Withdrawn ([% GROUP_RESULT.withdrawncount %]), [% END %]
263	[% IF ( GROUP_RESULT.itemlostcount ) %] Lost ([% GROUP_RESULT.itemlostcount %]),[% END %]	263	[% IF ( GROUP_RESULT.itemlostcount ) %] Lost ([% GROUP_RESULT.itemlostcount %]),[% END %]
264	[% IF ( GROUP_RESULT.damagedcount ) %] Damaged ([% GROUP_RESULT.damagedcount %]),[% END %]	264	[% IF ( GROUP_RESULT.damagedcount ) %] Damaged ([% GROUP_RESULT.damagedcount %]),[% END %]
265	[% IF ( GROUP_RESULT.orderedcount ) %] On order ([% GROUP_RESULT.orderedcount %]),[% END %]	265	[% IF ( GROUP_RESULT.orderedcount ) %] On order ([% GROUP_RESULT.orderedcount %]),[% END %]

Lines 560-566 $(document).ready(function(){ Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tt (-1 / +1 lines)
560	[% END %]	560	[% END %]
561	<span class="unavailable">	561	<span class="unavailable">
562	[% IF ( SEARCH_RESULT.onloancount ) %] Checked out ([% SEARCH_RESULT.onloancount %]), [% END %]	562	[% IF ( SEARCH_RESULT.onloancount ) %] Checked out ([% SEARCH_RESULT.onloancount %]), [% END %]
563	[% IF ( SEARCH_RESULT.wthdrawncount ) %] Withdrawn ([% SEARCH_RESULT.wthdrawncount %]), [% END %]	563	[% IF ( SEARCH_RESULT.withdrawncount ) %] Withdrawn ([% SEARCH_RESULT.withdrawncount %]), [% END %]
564	[% UNLESS ( SEARCH_RESULT.hidelostitems ) %][% IF ( SEARCH_RESULT.itemlostcount ) %] Lost ([% SEARCH_RESULT.itemlostcount %]),[% END %][% END %]	564	[% UNLESS ( SEARCH_RESULT.hidelostitems ) %][% IF ( SEARCH_RESULT.itemlostcount ) %] Lost ([% SEARCH_RESULT.itemlostcount %]),[% END %][% END %]
565	[% IF ( SEARCH_RESULT.damagedcount ) %] Damaged ([% SEARCH_RESULT.damagedcount %]),[% END %]	565	[% IF ( SEARCH_RESULT.damagedcount ) %] Damaged ([% SEARCH_RESULT.damagedcount %]),[% END %]
566	[% IF ( SEARCH_RESULT.orderedcount ) %] On order ([% SEARCH_RESULT.orderedcount %]),[% END %]	566	[% IF ( SEARCH_RESULT.orderedcount ) %] On order ([% SEARCH_RESULT.orderedcount %]),[% END %]

Lines 143-149 my @items = GetItemsInfo( $biblionumber ); Link Here

(-)a/opac/opac-ISBDdetail.pl (-1 / +1 lines)
143	my $itemtypes = GetItemTypes();	143	my $itemtypes = GetItemTypes();
144	for my $itm (@items) {	144	for my $itm (@items) {
145	$norequests = 0	145	$norequests = 0
146	if ( (not $itm->{'wthdrawn'} )	146	if ( (not $itm->{'withdrawn'} )
147	&& (not $itm->{'itemlost'} )	147	&& (not $itm->{'itemlost'} )
148	&& ($itm->{'itemnotforloan'}<0 \|\| not $itm->{'itemnotforloan'} )	148	&& ($itm->{'itemnotforloan'}<0 \|\| not $itm->{'itemnotforloan'} )
149	&& (not $itemtypes->{$itm->{'itype'}}->{notforloan} )	149	&& (not $itemtypes->{$itm->{'itype'}}->{notforloan} )

Lines 558-564 for my $itm (@items) { Link Here

(-)a/opac/opac-detail.pl (-1 / +1 lines)
558	$itm->{holds_count} = $item_reserves{ $itm->{itemnumber} };	558	$itm->{holds_count} = $item_reserves{ $itm->{itemnumber} };
559	$itm->{priority} = $priority{ $itm->{itemnumber} };	559	$itm->{priority} = $priority{ $itm->{itemnumber} };
560	$norequests = 0	560	$norequests = 0
561	if ( (not $itm->{'wthdrawn'} )	561	if ( (not $itm->{'withdrawn'} )
562	&& (not $itm->{'itemlost'} )	562	&& (not $itm->{'itemlost'} )
563	&& ($itm->{'itemnotforloan'}<0 \|\| not $itm->{'itemnotforloan'} )	563	&& ($itm->{'itemnotforloan'}<0 \|\| not $itm->{'itemnotforloan'} )
564	&& (not $itemtypes->{$itm->{'itype'}}->{notforloan} )	564	&& (not $itemtypes->{$itm->{'itype'}}->{notforloan} )

Lines 82-88 $dbh->do("INSERT INTO biblioitems (biblionumber, marcxml, itemtype) Link Here

(-)a/t/db_dependent/HoldsQueue.t (-1 / +1 lines)
82	my $biblioitemnumber = $dbh->selectrow_array("SELECT biblioitemnumber FROM biblioitems WHERE biblionumber = $biblionumber")	82	my $biblioitemnumber = $dbh->selectrow_array("SELECT biblioitemnumber FROM biblioitems WHERE biblionumber = $biblionumber")
83	or BAIL_OUT("Cannot find newly created biblioitems record");	83	or BAIL_OUT("Cannot find newly created biblioitems record");
84		84
85	my $items_insert_sth = $dbh->prepare("INSERT INTO items (biblionumber, biblioitemnumber, barcode, homebranch, holdingbranch, notforloan, damaged, itemlost, wthdrawn, onloan, itype)	85	my $items_insert_sth = $dbh->prepare("INSERT INTO items (biblionumber, biblioitemnumber, barcode, homebranch, holdingbranch, notforloan, damaged, itemlost, withdrawn, onloan, itype)
86	VALUES ($biblionumber, $biblioitemnumber, ?, ?, ?, 0, 0, 0, 0, NULL, '$itemtype')"); # CURRENT_DATE - 3)");	86	VALUES ($biblionumber, $biblioitemnumber, ?, ?, ?, 0, 0, 0, 0, NULL, '$itemtype')"); # CURRENT_DATE - 3)");
87	my $first_barcode = int(rand(1000000000000)); # XXX	87	my $first_barcode = int(rand(1000000000000)); # XXX
88	my $barcode = $first_barcode;	88	my $barcode = $first_barcode;

Lines 105-111 $contextmodule->mock('marcfromkohafield', sub { Link Here

(-)a/t/db_dependent/Search.t (-2 / +2 lines)
105	'items.restricted' => ['952', '5' ],	105	'items.restricted' => ['952', '5' ],
106	'items.stack' => ['952', 'j' ],	106	'items.stack' => ['952', 'j' ],
107	'items.uri' => ['952', 'u' ],	107	'items.uri' => ['952', 'u' ],
108	'items.wthdrawn' => ['952', '0' ]	108	'items.withdrawn' => ['952', '0' ]
109	}	109	}
110	);	110	);
111	return \%hash;	111	return \%hash;
Lines 167-173 $dbh->{mock_add_resultset} = { Link Here
167	[ 'homebranch' ], [ 'price' ], [ 'replacementprice' ],	167	[ 'homebranch' ], [ 'price' ], [ 'replacementprice' ],
168	[ 'replacementpricedate' ], [ 'datelastborrowed' ], [ 'datelastseen' ],	168	[ 'replacementpricedate' ], [ 'datelastborrowed' ], [ 'datelastseen' ],
169	[ 'stack' ], [ 'notforloan' ], [ 'damaged' ],	169	[ 'stack' ], [ 'notforloan' ], [ 'damaged' ],
170	[ 'itemlost' ], [ 'wthdrawn' ], [ 'itemcallnumber' ],	170	[ 'itemlost' ], [ 'withdrawn' ], [ 'itemcallnumber' ],
171	[ 'issues' ], [ 'renewals' ], [ 'reserves' ],	171	[ 'issues' ], [ 'renewals' ], [ 'reserves' ],
172	[ 'restricted' ], [ 'itemnotes' ], [ 'nonpublicnote' ],	172	[ 'restricted' ], [ 'itemnotes' ], [ 'nonpublicnote' ],
173	[ 'holdingbranch' ], [ 'paidfor' ], [ 'timestamp' ],	173	[ 'holdingbranch' ], [ 'paidfor' ], [ 'timestamp' ],




    my $item_mod_fixes_1 = {
        notforloan => undef,
        damaged    => 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->{'withdrawn'},   0, 'null withdrawn fixed during mod' );
    is( $item_mod_fixes_1->{'itemlost'},   0, 'null itemlost fixed during mod' );

}

    my $item_mod_fixes_2 = {
        notforloan => '',
        damaged    => '',
        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->{'withdrawn'},   0, 'empty withdrawn fixed during mod' );
    is( $item_mod_fixes_2->{'itemlost'},   0, 'empty itemlost fixed during mod' );

}

    my $item_mod_fixes_3 = {
        notforloan => 1,
        damaged    => 2,
        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->{'withdrawn'},   3, 'do not clobber withdrawn during mod' );
    is( $item_mod_fixes_3->{'itemlost'},   4, 'do not clobber itemlost during mod' );

}




    my $item_add_fixes_1 = {
        notforloan => undef,
        damaged    => 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->{'withdrawn'},   0, 'null withdrawn fixed during add' );
    is( $item_add_fixes_1->{'itemlost'},   0, 'null itemlost fixed during add' );
}


    my $item_add_fixes_2 = {
        notforloan => '',
        damaged    => '',
        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->{'withdrawn'},   0, 'empty withdrawn fixed during add' );
    is( $item_add_fixes_2->{'itemlost'},   0, 'empty itemlost fixed during add' );

}

    my $item_add_fixes_3 = {
        notforloan => 1,
        damaged    => 2,
        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->{'withdrawn'},   3, 'do not clobber withdrawn during mod' );
    is( $item_add_fixes_3->{'itemlost'},   4, 'do not clobber itemlost during mod' );

}




}

my $statuses = [];
for my $statfield (qw/items.notforloan items.itemlost items.withdrawn items.damaged/){
    my $hash = {};
    $hash->{fieldname} = $statfield;
    $hash->{authcode} = GetAuthValCode($statfield);

# 	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.withdrawn = 1";
    my $qwithdrawn = $dbh->prepare($strsth);
    my @errorloop;
    my $count=0;
    while (my $barcode=<$uploadbarcodes>){
        $barcode =~ s/\r?\n$//;
        if ($qwithdrawn->execute($barcode) &&$qwithdrawn->rows){
            push @errorloop, {'barcode'=>$barcode,'ERR_WTHDRAWN'=>1};
        }else{
            my $item = GetItem('', $barcode);

        }
    }
    $qonloan->finish;
    $qwithdrawn->finish;
    $template->param(date=>format_date($date),Number=>$count);
# 	$template->param(errorfile=>$errorfile) if ($errorfile);
    $template->param(errorloop=>\@errorloop) if (@errorloop);
- 

Return to bug 10550

Lines 564-570 sub itemissues { Link Here

(-)a/C4/Circulation.pm (-6 / +6 lines)
564	$data->{'borrower'} = $data2->{'borrowernumber'};	564	$data->{'borrower'} = $data2->{'borrowernumber'};
565	}	565	}
566	else {	566	else {
567	$data->{'date_due'} = ($data->{'wthdrawn'} eq '1') ? 'Cancelled' : 'Available';	567	$data->{'date_due'} = ($data->{'withdrawn'} eq '1') ? 'Cancelled' : 'Available';
568	}	568	}
569		569
570		570
Lines 873-879 sub CanBookBeIssued { Link Here
873	}	873	}
874	}	874	}
875	}	875	}
876	if ( $item->{'wthdrawn'} && $item->{'wthdrawn'} > 0 )	876	if ( $item->{'withdrawn'} && $item->{'withdrawn'} > 0 )
877	{	877	{
878	$issuingimpossible{WTHDRAWN} = 1;	878	$issuingimpossible{WTHDRAWN} = 1;
879	}	879	}
Lines 1671-1677 The book's home branch is a permanent collection. If you have borrowed Link Here
1671	this book, you are not allowed to return it. The value is the code for	1671	this book, you are not allowed to return it. The value is the code for
1672	the book's home branch.	1672	the book's home branch.
1673		1673
1674	=item C<wthdrawn>	1674	=item C<withdrawn>
1675		1675
1676	This book has been withdrawn/cancelled. The value should be ignored.	1676	This book has been withdrawn/cancelled. The value should be ignored.
1677		1677
Lines 1764-1771 sub AddReturn { Link Here
1764	return ( $doreturn, $messages, $issue, $borrower );	1764	return ( $doreturn, $messages, $issue, $borrower );
1765	}	1765	}
1766		1766
1767	if ( $item->{'wthdrawn'} ) { # book has been cancelled	1767	if ( $item->{'withdrawn'} ) { # book has been cancelled
1768	$messages->{'wthdrawn'} = 1;	1768	$messages->{'withdrawn'} = 1;
1769	$doreturn = 0 if C4::Context->preference("BlockReturnOfWithdrawnItems");	1769	$doreturn = 0 if C4::Context->preference("BlockReturnOfWithdrawnItems");
1770	}	1770	}
1771		1771
Lines 1876-1882 sub AddReturn { Link Here
1876	# find reserves.....	1876	# find reserves.....
1877	# if we don't have a reserve with the status W, we launch the Checkreserves routine	1877	# if we don't have a reserve with the status W, we launch the Checkreserves routine
1878	my ($resfound, $resrec);	1878	my ($resfound, $resrec);
1879	($resfound, $resrec, undef) = C4::Reserves::CheckReserves( $item->{'itemnumber'} ) unless ( $item->{'wthdrawn'} );	1879	($resfound, $resrec, undef) = C4::Reserves::CheckReserves( $item->{'itemnumber'} ) unless ( $item->{'withdrawn'} );
1880	if ($resfound) {	1880	if ($resfound) {
1881	$resrec->{'ResFound'} = $resfound;	1881	$resrec->{'ResFound'} = $resfound;
1882	$messages->{'ResFound'} = $resrec;	1882	$messages->{'ResFound'} = $resrec;

Lines 463-469 my %default_values_for_mod_from_marc = ( Link Here

(-)a/C4/Items.pm (-10 / +10 lines)
463	stack => undef,	463	stack => undef,
464	stocknumber => undef,	464	stocknumber => undef,
465	uri => undef,	465	uri => undef,
466	wthdrawn => 0,	466	withdrawn => 0,
467	);	467	);
468		468
469	sub ModItemFromMarc {	469	sub ModItemFromMarc {
Lines 1136-1142 sub GetItemsByBiblioitemnumber { Link Here
1136	$data->{'borrowernumber'} = $data2->{'borrowernumber'};	1136	$data->{'borrowernumber'} = $data2->{'borrowernumber'};
1137	}	1137	}
1138	else {	1138	else {
1139	# set date_due to blank, so in the template we check itemlost, and wthdrawn	1139	# set date_due to blank, so in the template we check itemlost, and withdrawn
1140	$data->{'date_due'} = '';	1140	$data->{'date_due'} = '';
1141	} # else	1141	} # else
1142	# Find the last 3 people who borrowed this item.	1142	# Find the last 3 people who borrowed this item.
Lines 1939-1945 Given an item hashref containing one or more Link Here
1939	columns to modify, fix up certain values.	1939	columns to modify, fix up certain values.
1940	Specifically, set to 0 any passed value	1940	Specifically, set to 0 any passed value
1941	of C<notforloan>, C<damaged>, C<itemlost>, or	1941	of C<notforloan>, C<damaged>, C<itemlost>, or
1942	C<wthdrawn> that is either undefined or	1942	C<withdrawn> that is either undefined or
1943	contains the empty string.	1943	contains the empty string.
1944		1944
1945	=cut	1945	=cut
Lines 1959-1967 sub _do_column_fixes_for_mod { Link Here
1959	(not defined $item->{'itemlost'} or $item->{'itemlost'} eq '')) {	1959	(not defined $item->{'itemlost'} or $item->{'itemlost'} eq '')) {
1960	$item->{'itemlost'} = 0;	1960	$item->{'itemlost'} = 0;
1961	}	1961	}
1962	if (exists $item->{'wthdrawn'} and	1962	if (exists $item->{'withdrawn'} and
1963	(not defined $item->{'wthdrawn'} or $item->{'wthdrawn'} eq '')) {	1963	(not defined $item->{'withdrawn'} or $item->{'withdrawn'} eq '')) {
1964	$item->{'wthdrawn'} = 0;	1964	$item->{'withdrawn'} = 0;
1965	}	1965	}
1966	if (exists $item->{'location'} && !exists $item->{'permanent_location'}) {	1966	if (exists $item->{'location'} && !exists $item->{'permanent_location'}) {
1967	$item->{'permanent_location'} = $item->{'location'};	1967	$item->{'permanent_location'} = $item->{'location'};
Lines 2035-2041 C<items.itemlost> Link Here
2035		2035
2036	=item *	2036	=item *
2037		2037
2038	C<items.wthdrawn>	2038	C<items.withdrawn>
2039		2039
2040	=back	2040	=back
2041		2041
Lines 2044-2050 C<items.wthdrawn> Link Here
2044	sub _set_defaults_for_add {	2044	sub _set_defaults_for_add {
2045	my $item = shift;	2045	my $item = shift;
2046	$item->{dateaccessioned} \|\|= C4::Dates->new->output('iso');	2046	$item->{dateaccessioned} \|\|= C4::Dates->new->output('iso');
2047	$item->{$_} \|\|= 0 for (qw( notforloan damaged itemlost wthdrawn));	2047	$item->{$_} \|\|= 0 for (qw( notforloan damaged itemlost withdrawn));
2048	}	2048	}
2049		2049
2050	=head2 _koha_new_item	2050	=head2 _koha_new_item
Lines 2076-2082 sub _koha_new_item { Link Here
2076	notforloan = ?,	2076	notforloan = ?,
2077	damaged = ?,	2077	damaged = ?,
2078	itemlost = ?,	2078	itemlost = ?,
2079	wthdrawn = ?,	2079	withdrawn = ?,
2080	itemcallnumber = ?,	2080	itemcallnumber = ?,
2081	coded_location_qualifier = ?,	2081	coded_location_qualifier = ?,
2082	restricted = ?,	2082	restricted = ?,
Lines 2118-2124 sub _koha_new_item { Link Here
2118	$item->{'notforloan'},	2118	$item->{'notforloan'},
2119	$item->{'damaged'},	2119	$item->{'damaged'},
2120	$item->{'itemlost'},	2120	$item->{'itemlost'},
2121	$item->{'wthdrawn'},	2121	$item->{'withdrawn'},
2122	$item->{'itemcallnumber'},	2122	$item->{'itemcallnumber'},
2123	$item->{'coded_location_qualifier'},	2123	$item->{'coded_location_qualifier'},
2124	$item->{'restricted'},	2124	$item->{'restricted'},

Lines 1815-1821 sub searchResults { Link Here

(-)a/C4/Search.pm (-8 / +8 lines)
1815	my $onloan_count = 0;	1815	my $onloan_count = 0;
1816	my $longoverdue_count = 0;	1816	my $longoverdue_count = 0;
1817	my $other_count = 0;	1817	my $other_count = 0;
1818	my $wthdrawn_count = 0;	1818	my $withdrawn_count = 0;
1819	my $itemlost_count = 0;	1819	my $itemlost_count = 0;
1820	my $hideatopac_count = 0;	1820	my $hideatopac_count = 0;
1821	my $itembinding_count = 0;	1821	my $itembinding_count = 0;
Lines 1902-1908 sub searchResults { Link Here
1902	# is item on the reserve shelf?	1902	# is item on the reserve shelf?
1903	my $reservestatus = '';	1903	my $reservestatus = '';
1904		1904
1905	unless ($item->{wthdrawn}	1905	unless ($item->{withdrawn}
1906	\|\| $item->{itemlost}	1906	\|\| $item->{itemlost}
1907	\|\| $item->{damaged}	1907	\|\| $item->{damaged}
1908	\|\| $item->{notforloan}	1908	\|\| $item->{notforloan}
Lines 1925-1947 sub searchResults { Link Here
1925	}	1925	}
1926		1926
1927	# item is withdrawn, lost, damaged, not for loan, reserved or in transit	1927	# item is withdrawn, lost, damaged, not for loan, reserved or in transit
1928	if ( $item->{wthdrawn}	1928	if ( $item->{withdrawn}
1929	\|\| $item->{itemlost}	1929	\|\| $item->{itemlost}
1930	\|\| $item->{damaged}	1930	\|\| $item->{damaged}
1931	\|\| $item->{notforloan}	1931	\|\| $item->{notforloan}
1932	\|\| $reservestatus eq 'Waiting'	1932	\|\| $reservestatus eq 'Waiting'
1933	\|\| ($transfertwhen ne ''))	1933	\|\| ($transfertwhen ne ''))
1934	{	1934	{
1935	$wthdrawn_count++ if $item->{wthdrawn};	1935	$withdrawn_count++ if $item->{withdrawn};
1936	$itemlost_count++ if $item->{itemlost};	1936	$itemlost_count++ if $item->{itemlost};
1937	$itemdamaged_count++ if $item->{damaged};	1937	$itemdamaged_count++ if $item->{damaged};
1938	$item_in_transit_count++ if $transfertwhen ne '';	1938	$item_in_transit_count++ if $transfertwhen ne '';
1939	$item_onhold_count++ if $reservestatus eq 'Waiting';	1939	$item_onhold_count++ if $reservestatus eq 'Waiting';
1940	$item->{status} = $item->{wthdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan};	1940	$item->{status} = $item->{withdrawn} . "-" . $item->{itemlost} . "-" . $item->{damaged} . "-" . $item->{notforloan};
1941		1941
1942	# can place hold on item ?	1942	# can place hold on item ?
1943	if ( !$item->{itemlost} ) {	1943	if ( !$item->{itemlost} ) {
1944	if ( !$item->{wthdrawn} ){	1944	if ( !$item->{withdrawn} ){
1945	if ( $item->{damaged} ){	1945	if ( $item->{damaged} ){
1946	if ( C4::Context->preference('AllowHoldsOnDamagedItems') ){	1946	if ( C4::Context->preference('AllowHoldsOnDamagedItems') ){
1947	# can place a hold on a damaged item if AllowHoldsOnDamagedItems is true	1947	# can place a hold on a damaged item if AllowHoldsOnDamagedItems is true
Lines 1960-1966 sub searchResults { Link Here
1960	$other_count++;	1960	$other_count++;
1961		1961
1962	my $key = $prefix . $item->{status};	1962	my $key = $prefix . $item->{status};
1963	foreach (qw(wthdrawn itemlost damaged branchname itemcallnumber)) {	1963	foreach (qw(withdrawn itemlost damaged branchname itemcallnumber)) {
1964	$other_items->{$key}->{$_} = $item->{$_};	1964	$other_items->{$key}->{$_} = $item->{$_};
1965	}	1965	}
1966	$other_items->{$key}->{intransit} = ( $transfertwhen ne '' ) ? 1 : 0;	1966	$other_items->{$key}->{intransit} = ( $transfertwhen ne '' ) ? 1 : 0;
Lines 2032-2038 sub searchResults { Link Here
2032	$oldbiblio->{onloanplural} = 1 if $onloan_count > 1;	2032	$oldbiblio->{onloanplural} = 1 if $onloan_count > 1;
2033	$oldbiblio->{othercount} = $other_count;	2033	$oldbiblio->{othercount} = $other_count;
2034	$oldbiblio->{otherplural} = 1 if $other_count > 1;	2034	$oldbiblio->{otherplural} = 1 if $other_count > 1;
2035	$oldbiblio->{wthdrawncount} = $wthdrawn_count;	2035	$oldbiblio->{withdrawncount} = $withdrawn_count;
2036	$oldbiblio->{itemlostcount} = $itemlost_count;	2036	$oldbiblio->{itemlostcount} = $itemlost_count;
2037	$oldbiblio->{damagedcount} = $itemdamaged_count;	2037	$oldbiblio->{damagedcount} = $itemdamaged_count;
2038	$oldbiblio->{intransitcount} = $item_in_transit_count;	2038	$oldbiblio->{intransitcount} = $item_in_transit_count;

Lines 37-43 my $itemnumber=$cgi->param('itemnumber'); Link Here

(-)a/catalogue/updateitem.pl (-4 / +4 lines)
37	my $biblioitemnumber=$cgi->param('biblioitemnumber');	37	my $biblioitemnumber=$cgi->param('biblioitemnumber');
38	my $itemlost=$cgi->param('itemlost');	38	my $itemlost=$cgi->param('itemlost');
39	my $itemnotes=$cgi->param('itemnotes');	39	my $itemnotes=$cgi->param('itemnotes');
40	my $wthdrawn=$cgi->param('wthdrawn');	40	my $withdrawn=$cgi->param('withdrawn');
41	my $damaged=$cgi->param('damaged');	41	my $damaged=$cgi->param('damaged');
42		42
43	my $confirm=$cgi->param('confirm');	43	my $confirm=$cgi->param('confirm');
Lines 47-53 my $dbh = C4::Context->dbh; Link Here
47	my $item_data_hashref = GetItem($itemnumber, undef);	47	my $item_data_hashref = GetItem($itemnumber, undef);
48		48
49	# make sure item statuses are set to 0 if empty or NULL	49	# make sure item statuses are set to 0 if empty or NULL
50	for ($damaged,$itemlost,$wthdrawn) {	50	for ($damaged,$itemlost,$withdrawn) {
51	if (!$_ or $_ eq "") {	51	if (!$_ or $_ eq "") {
52	$_ = 0;	52	$_ = 0;
53	}	53	}
Lines 62-69 if (defined $itemnotes) { # i.e., itemnotes parameter passed from form Link Here
62	}	62	}
63	} elsif ($itemlost ne $item_data_hashref->{'itemlost'}) {	63	} elsif ($itemlost ne $item_data_hashref->{'itemlost'}) {
64	$item_changes->{'itemlost'} = $itemlost;	64	$item_changes->{'itemlost'} = $itemlost;
65	} elsif ($wthdrawn ne $item_data_hashref->{'wthdrawn'}) {	65	} elsif ($withdrawn ne $item_data_hashref->{'withdrawn'}) {
66	$item_changes->{'wthdrawn'} = $wthdrawn;	66	$item_changes->{'withdrawn'} = $withdrawn;
67	} elsif ($damaged ne $item_data_hashref->{'damaged'}) {	67	} elsif ($damaged ne $item_data_hashref->{'damaged'}) {
68	$item_changes->{'damaged'} = $damaged;	68	$item_changes->{'damaged'} = $damaged;
69	} else {	69	} else {

Lines 2520-2526 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here

(-)a/installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql (-3 / +3 lines)
2520	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,'','');	2520	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,'','');
2521		2521
2522	-- 995	2522	-- 995
2523	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');	2523	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');
2524	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,'','');	2524	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,'','');
2525	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');	2525	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');
2526	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');	2526	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');
Lines 2578-2584 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here
2578	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,'','');	2578	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,'','');
2579		2579
2580	-- 995	2580	-- 995
2581	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');	2581	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');
2582	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,'','');	2582	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,'','');
2583	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');	2583	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');
2584	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');	2584	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');
Lines 2637-2643 insert into `marc_subfield_structure`(`tagfield`,`tagsubfield`,`liblibrarian`,` Link Here
2637	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,'','');	2637	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,'','');
2638		2638
2639	-- 995	2639	-- 995
2640	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');	2640	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');
2641	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,'','');	2641	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,'','');
2642	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');	2642	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');
2643	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');	2643	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');

Lines 866-872 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
866	`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7)	866	`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7)
867	`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4)	867	`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4)
868	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)	868	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
869	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)	869	`withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
870	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)	870	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
871	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)	871	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
872	`issues` smallint(6) default NULL, -- number of times this item has been checked out	872	`issues` smallint(6) default NULL, -- number of times this item has been checked out
Lines 1158-1164 CREATE TABLE `items` ( -- holdings/item information Link Here
1158	`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7)	1158	`notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining why this item is not for loan (MARC21 952$7)
1159	`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4)	1159	`damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this item as damaged (MARC21 952$4)
1160	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)	1160	`itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining this item as lost (MARC21 952$1)
1161	`wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)	1161	`withdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining this item as withdrawn (MARC21 952$0)
1162	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)	1162	`itemcallnumber` varchar(255) default NULL, -- call number for this item (MARC21 952$o)
1163	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)	1163	`coded_location_qualifier` varchar(10) default NULL, -- coded location qualifier(MARC21 952$f)
1164	`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued	1164	`issues` smallint(6) default NULL, -- number of times this item has been checked out/issued

Lines 7029-7034 INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ( Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+12 lines)
7029	SetVersion($DBversion);	7029	SetVersion($DBversion);
7030	}	7030	}
7031		7031
		7032	$DBversion = "3.13.00.XXX";
		7033	if ( CheckVersion($DBversion) ) {
		7034	$dbh->do(q{
		7035	ALTER TABLE items CHANGE wthdrawn withdrawn TINYINT( 1 ) NOT NULL DEFAULT '0'
		7036	});
		7037	$dbh->do(q{
		7038	ALTER TABLE deleteditems CHANGE wthdrawn withdrawn TINYINT( 1 ) NOT NULL DEFAULT '0'
		7039	});
		7040
		7041	print "Upgrade to $DBversion done (Bug 10550 - Fix database typo wthdrawn)\n";
		7042	SetVersion($DBversion);
		7043	}
7032		7044
7033	=head1 FUNCTIONS	7045	=head1 FUNCTIONS
7034		7046

Lines 64-70 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/catalogue/moredetail.tt (-7 / +7 lines)
64	[% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]	64	[% IF ( ITEM_DAT.notforloantext ) %][% ITEM_DAT.notforloantext %] [% END %]
65	[% IF ( ITEM_DAT.itemlost ) %]Lost[% END %]	65	[% IF ( ITEM_DAT.itemlost ) %]Lost[% END %]
66	[% IF ( ITEM_DAT.damaged ) %]Damaged[% END %]	66	[% IF ( ITEM_DAT.damaged ) %]Damaged[% END %]
67	[% IF ( ITEM_DAT.wthdrawn ) %]Withdrawn[% END %]	67	[% IF ( ITEM_DAT.withdrawn ) %]Withdrawn[% END %]
68	)[% END %]</h4>	68	)[% END %]</h4>
69		69
70	<ol class="bibliodetails">	70	<ol class="bibliodetails">
Lines 104-110 Link Here
104	[% END %]	104	[% END %]
105	[% END %]	105	[% END %]
106	</select>	106	</select>
107	<input type="hidden" name="wthdrawn" value="[% ITEM_DAT.wthdrawn %]" />	107	<input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" />
108	<input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />	108	<input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />
109	<input type="submit" name="submit" class="submit" value="Set Status" /></form>	109	<input type="submit" name="submit" class="submit" value="Set Status" /></form>
110	[% ELSE %]	110	[% ELSE %]
Lines 134-140 Link Here
134	[% END %]	134	[% END %]
135	[% END %]	135	[% END %]
136	</select>	136	</select>
137	<input type="hidden" name="wthdrawn" value="[% ITEM_DAT.wthdrawn %]" />	137	<input type="hidden" name="withdrawn" value="[% ITEM_DAT.withdrawn %]" />
138	<input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />	138	<input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />
139	<input type="submit" name="submit" class="submit" value="Set Status" /></form>	139	<input type="submit" name="submit" class="submit" value="Set Status" /></form>
140	[% ELSE %]	140	[% ELSE %]
Lines 147-153 Link Here
147	[% END %]	147	[% END %]
148	</li>	148	</li>
149	[% END %]	149	[% END %]
150	<li><span class="label">Withdrawn?:</span>[% IF ( ITEM_DAT.wthdrawn ) %]Yes[% ELSE %]No[% END %]	150	<li><span class="label">Withdrawn?:</span>[% IF ( ITEM_DAT.withdrawn ) %]Yes[% ELSE %]No[% END %]
151	[% IF ( CAN_user_circulate ) %]	151	[% IF ( CAN_user_circulate ) %]
152	<form action="updateitem.pl" method="post">	152	<form action="updateitem.pl" method="post">
153	<input type="hidden" name="biblionumber" value="[% ITEM_DAT.biblionumber %]" />	153	<input type="hidden" name="biblionumber" value="[% ITEM_DAT.biblionumber %]" />
Lines 156-165 Link Here
156	<input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />	156	<input type="hidden" name="itemlost" value="[% ITEM_DAT.itemlost %]" />
157	<input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />	157	<input type="hidden" name="damaged" value="[% ITEM_DAT.damaged %]" />
158		158
159	[% IF ( ITEM_DAT.wthdrawn ) %]	159	[% IF ( ITEM_DAT.withdrawn ) %]
160	<input type="hidden" name="wthdrawn" value="0" />[% ELSE %]<input type="hidden" name="wthdrawn" value="1" />	160	<input type="hidden" name="withdrawn" value="0" />[% ELSE %]<input type="hidden" name="withdrawn" value="1" />
161	[% END %]	161	[% END %]
162	[% IF ( ITEM_DAT.wthdrawn ) %]	162	[% IF ( ITEM_DAT.withdrawn ) %]
163	<input type="submit" name="submit" class="submit" value="Restore" />[% ELSE %]<input type="submit" name="submit" class="submit" value="Withdraw" />	163	<input type="submit" name="submit" class="submit" value="Restore" />[% ELSE %]<input type="submit" name="submit" class="submit" value="Withdraw" />
164	[% END %]	164	[% END %]
165	</form>	165	</form>

Lines 184-190 Link Here

(-)a/koha-tmpl/opac-tmpl/prog/en/modules/ilsdi.tt (-4 / +4 lines)
184	<items>	184	<items>
185	<item>	185	<item>
186	<biblioitemnumber>1</biblioitemnumber>	186	<biblioitemnumber>1</biblioitemnumber>
187	<wthdrawn>0</wthdrawn>	187	<withdrawn>0</withdrawn>
188	<holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname>	188	<holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname>
189	<notforloan>0</notforloan>	189	<notforloan>0</notforloan>
190	<replacementpricedate>2008-08-20</replacementpricedate>	190	<replacementpricedate>2008-08-20</replacementpricedate>
Lines 272-278 Link Here
272	<items>	272	<items>
273	<item>	273	<item>
274	<biblioitemnumber>2</biblioitemnumber>	274	<biblioitemnumber>2</biblioitemnumber>
275	<wthdrawn>0</wthdrawn>	275	<withdrawn>0</withdrawn>
276	<holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname>	276	<holdingbranchname>Bibliothèque Jean Prunier</holdingbranchname>
277	<notforloan>0</notforloan>	277	<notforloan>0</notforloan>
278	<replacementpricedate>2008-08-20</replacementpricedate>	278	<replacementpricedate>2008-08-20</replacementpricedate>
Lines 473-479 Link Here
473	<dateaccessioned>2008-08-23</dateaccessioned>	473	<dateaccessioned>2008-08-23</dateaccessioned>
474	<onloan>2008-09-17</onloan>	474	<onloan>2008-09-17</onloan>
475	<biblioitemnumber>4483</biblioitemnumber>	475	<biblioitemnumber>4483</biblioitemnumber>
476	<wthdrawn>0</wthdrawn>	476	<withdrawn>0</withdrawn>
477	<notforloan>0</notforloan>	477	<notforloan>0</notforloan>
478	<replacementpricedate>2008-08-23</replacementpricedate>	478	<replacementpricedate>2008-08-23</replacementpricedate>
479	<itemcallnumber>RO STE</itemcallnumber>	479	<itemcallnumber>RO STE</itemcallnumber>
Lines 511-517 Link Here
511	<notes>La couv. porte en plus : "un guide simple et facile pour apprendre la guitare" \| Glossaire. Index</notes>	511	<notes>La couv. porte en plus : "un guide simple et facile pour apprendre la guitare" \| Glossaire. Index</notes>
512	<onloan>2008-09-25</onloan>	512	<onloan>2008-09-25</onloan>
513	<biblioitemnumber>4486</biblioitemnumber>	513	<biblioitemnumber>4486</biblioitemnumber>
514	<wthdrawn>0</wthdrawn>	514	<withdrawn>0</withdrawn>
515	<notforloan>0</notforloan>	515	<notforloan>0</notforloan>
516	<replacementpricedate>2008-08-23</replacementpricedate>	516	<replacementpricedate>2008-08-23</replacementpricedate>
517	<itemcallnumber>787.87 BUC</itemcallnumber>	517	<itemcallnumber>787.87 BUC</itemcallnumber>

Lines 28-41 sub not_defined : Test( 4 ) { Link Here

(-)a/t/db_dependent/lib/KohaTest/Items/ColumnFixes.pm (-6 / +6 lines)
28	my $item_mod_fixes_1 = {	28	my $item_mod_fixes_1 = {
29	notforloan => undef,	29	notforloan => undef,
30	damaged => undef,	30	damaged => undef,
31	wthdrawn => undef,	31	withdrawn => undef,
32	itemlost => undef,	32	itemlost => undef,
33	};	33	};
34		34
35	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_1);	35	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_1);
36	is( $item_mod_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during mod' );	36	is( $item_mod_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during mod' );
37	is( $item_mod_fixes_1->{'damaged'}, 0, 'null damaged fixed during mod' );	37	is( $item_mod_fixes_1->{'damaged'}, 0, 'null damaged fixed during mod' );
38	is( $item_mod_fixes_1->{'wthdrawn'}, 0, 'null wthdrawn fixed during mod' );	38	is( $item_mod_fixes_1->{'withdrawn'}, 0, 'null withdrawn fixed during mod' );
39	is( $item_mod_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during mod' );	39	is( $item_mod_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during mod' );
40		40
41	}	41	}
Lines 45-58 sub empty : Test( 4 ) { Link Here
45	my $item_mod_fixes_2 = {	45	my $item_mod_fixes_2 = {
46	notforloan => '',	46	notforloan => '',
47	damaged => '',	47	damaged => '',
48	wthdrawn => '',	48	withdrawn => '',
49	itemlost => '',	49	itemlost => '',
50	};	50	};
51		51
52	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_2);	52	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_2);
53	is( $item_mod_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during mod' );	53	is( $item_mod_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during mod' );
54	is( $item_mod_fixes_2->{'damaged'}, 0, 'empty damaged fixed during mod' );	54	is( $item_mod_fixes_2->{'damaged'}, 0, 'empty damaged fixed during mod' );
55	is( $item_mod_fixes_2->{'wthdrawn'}, 0, 'empty wthdrawn fixed during mod' );	55	is( $item_mod_fixes_2->{'withdrawn'}, 0, 'empty withdrawn fixed during mod' );
56	is( $item_mod_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during mod' );	56	is( $item_mod_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during mod' );
57		57
58	}	58	}
Lines 62-75 sub not_clobbered : Test( 4 ) { Link Here
62	my $item_mod_fixes_3 = {	62	my $item_mod_fixes_3 = {
63	notforloan => 1,	63	notforloan => 1,
64	damaged => 2,	64	damaged => 2,
65	wthdrawn => 3,	65	withdrawn => 3,
66	itemlost => 4,	66	itemlost => 4,
67	};	67	};
68		68
69	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_3);	69	C4::Items::_do_column_fixes_for_mod($item_mod_fixes_3);
70	is( $item_mod_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' );	70	is( $item_mod_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' );
71	is( $item_mod_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' );	71	is( $item_mod_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' );
72	is( $item_mod_fixes_3->{'wthdrawn'}, 3, 'do not clobber wthdrawn during mod' );	72	is( $item_mod_fixes_3->{'withdrawn'}, 3, 'do not clobber withdrawn during mod' );
73	is( $item_mod_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' );	73	is( $item_mod_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' );
74		74
75	}	75	}

Lines 38-51 sub undefined : Test( 4 ) { Link Here

(-)a/t/db_dependent/lib/KohaTest/Items/SetDefaults.pm (-6 / +6 lines)
38	my $item_add_fixes_1 = {	38	my $item_add_fixes_1 = {
39	notforloan => undef,	39	notforloan => undef,
40	damaged => undef,	40	damaged => undef,
41	wthdrawn => undef,	41	withdrawn => undef,
42	itemlost => undef,	42	itemlost => undef,
43	};	43	};
44		44
45	C4::Items::_set_defaults_for_add($item_add_fixes_1);	45	C4::Items::_set_defaults_for_add($item_add_fixes_1);
46	is( $item_add_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during add' );	46	is( $item_add_fixes_1->{'notforloan'}, 0, 'null notforloan fixed during add' );
47	is( $item_add_fixes_1->{'damaged'}, 0, 'null damaged fixed during add' );	47	is( $item_add_fixes_1->{'damaged'}, 0, 'null damaged fixed during add' );
48	is( $item_add_fixes_1->{'wthdrawn'}, 0, 'null wthdrawn fixed during add' );	48	is( $item_add_fixes_1->{'withdrawn'}, 0, 'null withdrawn fixed during add' );
49	is( $item_add_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during add' );	49	is( $item_add_fixes_1->{'itemlost'}, 0, 'null itemlost fixed during add' );
50	}	50	}
51		51
Lines 54-67 sub empty_gets_fixed : Test( 4 ) { Link Here
54	my $item_add_fixes_2 = {	54	my $item_add_fixes_2 = {
55	notforloan => '',	55	notforloan => '',
56	damaged => '',	56	damaged => '',
57	wthdrawn => '',	57	withdrawn => '',
58	itemlost => '',	58	itemlost => '',
59	};	59	};
60		60
61	C4::Items::_set_defaults_for_add($item_add_fixes_2);	61	C4::Items::_set_defaults_for_add($item_add_fixes_2);
62	is( $item_add_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during add' );	62	is( $item_add_fixes_2->{'notforloan'}, 0, 'empty notforloan fixed during add' );
63	is( $item_add_fixes_2->{'damaged'}, 0, 'empty damaged fixed during add' );	63	is( $item_add_fixes_2->{'damaged'}, 0, 'empty damaged fixed during add' );
64	is( $item_add_fixes_2->{'wthdrawn'}, 0, 'empty wthdrawn fixed during add' );	64	is( $item_add_fixes_2->{'withdrawn'}, 0, 'empty withdrawn fixed during add' );
65	is( $item_add_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during add' );	65	is( $item_add_fixes_2->{'itemlost'}, 0, 'empty itemlost fixed during add' );
66		66
67	}	67	}
Lines 71-84 sub do_not_clobber : Test( 4 ) { Link Here
71	my $item_add_fixes_3 = {	71	my $item_add_fixes_3 = {
72	notforloan => 1,	72	notforloan => 1,
73	damaged => 2,	73	damaged => 2,
74	wthdrawn => 3,	74	withdrawn => 3,
75	itemlost => 4,	75	itemlost => 4,
76	};	76	};
77		77
78	C4::Items::_set_defaults_for_add($item_add_fixes_3);	78	C4::Items::_set_defaults_for_add($item_add_fixes_3);
79	is( $item_add_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' );	79	is( $item_add_fixes_3->{'notforloan'}, 1, 'do not clobber notforloan during mod' );
80	is( $item_add_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' );	80	is( $item_add_fixes_3->{'damaged'}, 2, 'do not clobber damaged during mod' );
81	is( $item_add_fixes_3->{'wthdrawn'}, 3, 'do not clobber wthdrawn during mod' );	81	is( $item_add_fixes_3->{'withdrawn'}, 3, 'do not clobber withdrawn during mod' );
82	is( $item_add_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' );	82	is( $item_add_fixes_3->{'itemlost'}, 4, 'do not clobber itemlost during mod' );
83		83
84	}	84	}

Lines 93-99 for my $fwk (keys %$frameworks){ Link Here

(-)a/tools/inventory.pl (-6 / +5 lines)
93	}	93	}
94		94
95	my $statuses = [];	95	my $statuses = [];
96	for my $statfield (qw/items.notforloan items.itemlost items.wthdrawn items.damaged/){	96	for my $statfield (qw/items.notforloan items.itemlost items.withdrawn items.damaged/){
97	my $hash = {};	97	my $hash = {};
98	$hash->{fieldname} = $statfield;	98	$hash->{fieldname} = $statfield;
99	$hash->{authcode} = GetAuthValCode($statfield);	99	$hash->{authcode} = GetAuthValCode($statfield);
Lines 143-155 if ($uploadbarcodes && length($uploadbarcodes)>0){ Link Here
143	# warn "$date";	143	# warn "$date";
144	my $strsth="select * from issues, items where items.itemnumber=issues.itemnumber and items.barcode =?";	144	my $strsth="select * from issues, items where items.itemnumber=issues.itemnumber and items.barcode =?";
145	my $qonloan = $dbh->prepare($strsth);	145	my $qonloan = $dbh->prepare($strsth);
146	$strsth="select * from items where items.barcode =? and items.wthdrawn = 1";	146	$strsth="select * from items where items.barcode =? and items.withdrawn = 1";
147	my $qwthdrawn = $dbh->prepare($strsth);	147	my $qwithdrawn = $dbh->prepare($strsth);
148	my @errorloop;	148	my @errorloop;
149	my $count=0;	149	my $count=0;
150	while (my $barcode=<$uploadbarcodes>){	150	while (my $barcode=<$uploadbarcodes>){
151	$barcode =~ s/\r?\n$//;	151	$barcode =~ s/\r?\n$//;
152	if ($qwthdrawn->execute($barcode) &&$qwthdrawn->rows){	152	if ($qwithdrawn->execute($barcode) &&$qwithdrawn->rows){
153	push @errorloop, {'barcode'=>$barcode,'ERR_WTHDRAWN'=>1};	153	push @errorloop, {'barcode'=>$barcode,'ERR_WTHDRAWN'=>1};
154	}else{	154	}else{
155	my $item = GetItem('', $barcode);	155	my $item = GetItem('', $barcode);
Lines 173-179 if ($uploadbarcodes && length($uploadbarcodes)>0){ Link Here
173	}	173	}
174	}	174	}
175	$qonloan->finish;	175	$qonloan->finish;
176	$qwthdrawn->finish;	176	$qwithdrawn->finish;
177	$template->param(date=>format_date($date),Number=>$count);	177	$template->param(date=>format_date($date),Number=>$count);
178	# $template->param(errorfile=>$errorfile) if ($errorfile);	178	# $template->param(errorfile=>$errorfile) if ($errorfile);
179	$template->param(errorloop=>\@errorloop) if (@errorloop);	179	$template->param(errorloop=>\@errorloop) if (@errorloop);
180	-