Attachment #93579 for bug #23049

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




        }
    );

    # Clean up MANUAL_INV
    $dbh->do(
        qq{
        DELETE FROM authorised_values WHERE category = 'MANUAL_INV'
        }
    );
    $dbh->do(
        qq{
        DELETE FROM authorised_value_categories WHERE category_name = 'MANUAL_INV'
        }
    );

    # Add new permission
    $dbh->do(
        q{

Lines 32-38 INSERT IGNORE INTO authorised_value_categories( category_name ) Link Here

(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 lines)
32	('NOT_LOAN'),	32	('NOT_LOAN'),
33	('CCODE'),	33	('CCODE'),
34	('LOC'),	34	('LOC'),
35	('MANUAL_INV'),
36	('BOR_NOTES'),	35	('BOR_NOTES'),
37	('OPAC_SUG'),	36	('OPAC_SUG'),
38	('SIP_MEDIA_TYPE'),	37	('SIP_MEDIA_TYPE'),

Lines 381-388 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt (-3 lines)
381	<p>Shelving location (usually appears when adding or editing an item). LOC maps to items.location in the Koha database.</p>	381	<p>Shelving location (usually appears when adding or editing an item). LOC maps to items.location in the Koha database.</p>
382	[% CASE 'LOST' %]	382	[% CASE 'LOST' %]
383	<p>Descriptions for the items marked as lost (appears when adding or editing an item)</p>	383	<p>Descriptions for the items marked as lost (appears when adding or editing an item)</p>
384	[% CASE 'MANUAL_INV' %]
385	<p>Values for manual invoicing types</p>
386	[% CASE 'NOT_LOAN' %]	384	[% CASE 'NOT_LOAN' %]
387	<p>Reasons why a title is not for loan</p>	385	<p>Reasons why a title is not for loan</p>
388	[% CASE 'OPAC_SUG' %]	386	[% CASE 'OPAC_SUG' %]
389	-

Return to bug 23049

Lines 97-102 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23049_debit.perl (+12 lines)
97	}	97	}
98	);	98	);
99		99
		100	# Clean up MANUAL_INV
		101	$dbh->do(
		102	qq{
		103	DELETE FROM authorised_values WHERE category = 'MANUAL_INV'
		104	}
		105	);
		106	$dbh->do(
		107	qq{
		108	DELETE FROM authorised_value_categories WHERE category_name = 'MANUAL_INV'
		109	}
		110	);
		111
100	# Add new permission	112	# Add new permission
101	$dbh->do(	113	$dbh->do(
102	q{	114	q{