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

(-)a/Koha/Template/Plugin/Koha.pm (+1 lines)
Lines 58-63 sub Version { Link Here
58
                            ? $development
58
                            ? $development
59
                            : undef
59
                            : undef
60
    };
60
    };
61
}
61
62
62
sub Find {
63
sub Find {
63
    my ( $self, $rs, $id ) = @_;
64
    my ( $self, $rs, $id ) = @_;
(-)a/installer/data/mysql/updatedatabase.pl (-8 / +10 lines)
Lines 9675-9694 if(CheckVersion($DBversion)) { Link Here
9675
    $dbh->do(q{
9675
    $dbh->do(q{
9676
        ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9676
        ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9677
    });
9677
    });
9678
9678
    $dbh->do(q{
9679
    $dbh->do(q{
9679
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9680
        ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy
9680
    });
9681
    });
9682
9681
    $dbh->do(q{
9683
    $dbh->do(q{
9682
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL PRIMARY KEY FIRST
9684
        ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9683
    });
9685
    });
9686
9684
    $dbh->do(q{
9687
    $dbh->do(q{
9685
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9688
        ALTER TABLE old_issues CHANGE issue_id issue_id INT( 11 ) NOT NULL
9686
    });
9689
    });
9690
9687
    $dbh->do(q{
9691
    $dbh->do(q{
9688
        ALTER TABLE issues
9692
        ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
9689
            DROP INDEX itemnumber_idx,
9690
            ADD UNIQUE itemnumber_idx ( itemnumber )
9691
    });
9693
    });
9694
9692
    $dbh->do(qq{
9695
    $dbh->do(qq{
9693
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9696
        UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC
9694
    });
9697
    });
Lines 9703-9709 if(CheckVersion($DBversion)) { Link Here
9703
    });
9706
    });
9704
9707
9705
    $dbh->do(q{
9708
    $dbh->do(q{
9706
        INSERT INTO systempreferences (variable, value, options, explanation, type )
9709
        INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type )
9707
        VALUES (
9710
        VALUES (
9708
            'AllowStaffToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
9711
            'AllowStaffToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
9709
            'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.',  'YesNo'
9712
            'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.',  'YesNo'
Lines 9711-9717 if(CheckVersion($DBversion)) { Link Here
9711
    });
9714
    });
9712
9715
9713
    $dbh->do(q{
9716
    $dbh->do(q{
9714
        INSERT INTO systempreferences (variable, value, options, explanation, type )
9717
        INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type )
9715
        VALUES (
9718
        VALUES (
9716
            'AllowPatronToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
9719
            'AllowPatronToSetCheckoutsVisibilityForGuarantor',  '0', NULL,
9717
            'If enabled, the patron can set checkouts to be visible to  his or her guarantor',  'YesNo'
9720
            'If enabled, the patron can set checkouts to be visible to  his or her guarantor',  'YesNo'
9718
- 

Return to bug 9303