Attachment #34599 for bug #13436

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

Lines 448-454 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
448	('UsageStatsID', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'),	448	('UsageStatsID', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'),
449	('UsageStatsLastUpdateTime', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'),	449	('UsageStatsLastUpdateTime', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'),
450	('UsageStatsLibraryName', '', NULL, 'The library name to be shown on Hea Koha community website', 'Free'),	450	('UsageStatsLibraryName', '', NULL, 'The library name to be shown on Hea Koha community website', 'Free'),
451	('UsageStatsLibraryType', 'public', 'public\|university', 'The library type to be shown on the Hea Koha community website', 'Choice'),	451	('UsageStatsLibraryType', 'public', 'public\|school\|academic\|research\|private\|societyAssociation\|corporate\|government\|religiousOrg\|subscription', 'The library type to be shown on the Hea Koha community website', 'Choice'),
452	('UsageStatsLibraryUrl', '', NULL, 'The library URL to be shown on Hea Koha community website', 'Free'),	452	('UsageStatsLibraryUrl', '', NULL, 'The library URL to be shown on Hea Koha community website', 'Free'),
453	('UseAuthoritiesForTracings','1','0','Use authority record numbers for subject tracings instead of heading strings.','YesNo'),	453	('UseAuthoritiesForTracings','1','0','Use authority record numbers for subject tracings instead of heading strings.','YesNo'),
454	('UseBranchTransferLimits','0','','If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),	454	('UseBranchTransferLimits','0','','If ON, Koha will will use the rules defined in branch_transfer_limits to decide if an item transfer should be allowed.','YesNo'),




    SetVersion ($DBversion);
}

$DBversion = "3.19.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do("
        UPDATE systempreferences
        SET options = 'public|school|academic|research|private|societyAssociation|corporate|government|religiousOrg|subscription'
        WHERE variable = 'UsageStatsLibraryType'
    ");
    if ( C4::Context->preference("UsageStatsLibraryType") eq "university" ) {
        C4::Context->set_preference("UsageStatsLibraryType", "academic")
    }
    print "Upgrade to $DBversion done (Bug 13436: Add more options to UsageStatsLibraryType)\n";
    SetVersion ($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 13436

Lines 9585-9590 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +14 lines)
9585	SetVersion ($DBversion);	9585	SetVersion ($DBversion);
9586	}	9586	}
9587		9587
		9588	$DBversion = "3.19.00.XXX";
		9589	if ( CheckVersion($DBversion) ) {
		9590	$dbh->do("
		9591	UPDATE systempreferences
		9592	SET options = 'public\|school\|academic\|research\|private\|societyAssociation\|corporate\|government\|religiousOrg\|subscription'
		9593	WHERE variable = 'UsageStatsLibraryType'
		9594	");
		9595	if ( C4::Context->preference("UsageStatsLibraryType") eq "university" ) {
		9596	C4::Context->set_preference("UsageStatsLibraryType", "academic")
		9597	}
		9598	print "Upgrade to $DBversion done (Bug 13436: Add more options to UsageStatsLibraryType)\n";
		9599	SetVersion ($DBversion);
		9600	}
		9601
9588	=head1 FUNCTIONS	9602	=head1 FUNCTIONS
9589		9603
9590	=head2 TableExists($table)	9604	=head2 TableExists($table)
9591	-