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

(-)a/installer/data/mysql/atomicupdate/bug_22774.perl (+18 lines)
Line 0 Link Here
1
$DBversion = '19.12.00.XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
4
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
5
    $dbh->do( q{
6
            INSERT IGNORE INTO systempreferences (variable,value,explanation,type) VALUES
7
                ('MaxTotalSuggestions','','Number of total suggestions','Free'),
8
                ('NumberOfSuggestionDays','','days','Free')
9
            });
10
    # or perform some test and warn
11
    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
12
    #    warn "There is something wrong";
13
    # }
14
15
    # Always end with this (adjust the bug info)
16
    SetVersion( $DBversion );
17
    print "Upgrade to $DBversion done (Bug 22774 - Limit Purchase Suggestion in a specified Time period)\n";
18
}
(-)a/installer/data/mysql/sysprefs.sql (+2 lines)
Lines 321-326 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
321
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
321
('maxRecordsForFacets','20',NULL,NULL,'Integer'),
322
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
322
('maxreserves','50','','Define maximum number of holds a patron can place','Integer'),
323
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
323
('MaxSearchResultsItemsPerRecordStatusCheck','20','','Max number of items per record for which to check transit and hold status','Integer'),
324
('MaxTotalSuggestions','',NULL,'Number of total suggestions','Free'),
325
('NumberOfSuggestionDays','',NULL,'days','Free'),
324
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
326
('MembershipExpiryDaysNotice','',NULL,'Send an account expiration notice that a patron\'s card is about to expire after','Integer'),
325
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
327
('MergeReportFields','',NULL,'Displayed fields for deleted MARC records after merge','Free'),
326
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
328
('minPasswordLength','3',NULL,'Specify the minimum length of a patron/staff password','free'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-1 / +8 lines)
Lines 710-715 OPAC: Link Here
710
            - pref: MaxOpenSuggestions
710
            - pref: MaxOpenSuggestions
711
              class: integer
711
              class: integer
712
            - "open suggestions. Leave empty for no limit. **Note: this setting does not affect anonymous suggestions"
712
            - "open suggestions. Leave empty for no limit. **Note: this setting does not affect anonymous suggestions"
713
        -
714
            - Number of total suggestions
715
            - pref: MaxTotalSuggestions
716
              class: integer
717
            - "for"
718
            - pref: NumberOfSuggestionDays
719
              class: integer
720
            - "days."
713
    Privacy:
721
    Privacy:
714
        -
722
        -
715
            - pref: AnonSuggestions
723
            - pref: AnonSuggestions
716
- 

Return to bug 22774