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

(-)a/installer/data/mysql/updatedatabase.pl (-5 / +13 lines)
Lines 23388-23397 if( CheckVersion( $DBversion ) ) { Link Here
23388
23388
23389
$DBversion = '20.06.00.069';
23389
$DBversion = '20.06.00.069';
23390
if( CheckVersion( $DBversion ) ) {
23390
if( CheckVersion( $DBversion ) ) {
23391
    $dbh->do( q|
23391
#    my ($count) = $dbh->selectrow_array(
23392
        INSERT IGNORE INTO circulation_rules (rule_name, rule_value)
23392
#        q|
23393
        VALUES ('unseen_renewals_allowed', '')
23393
#            SELECT COUNT(*)
23394
    | );
23394
#            FROM circulation_rules
23395
#            WHERE rule_name = 'unseen_renewals_allowed'
23396
#        |
23397
#    );
23398
#    if ($count == 0) {
23399
        $dbh->do( q|
23400
            INSERT INTO circulation_rules (rule_name, rule_value)
23401
            VALUES ('unseen_renewals_allowed', '')
23402
        | );
23403
#    }
23395
23404
23396
    if( !column_exists( 'issues', 'unseen_renewals' ) ) {
23405
    if( !column_exists( 'issues', 'unseen_renewals' ) ) {
23397
        $dbh->do( q| ALTER TABLE issues ADD unseen_renewals TINYINT(4) DEFAULT 0 NOT NULL AFTER renewals | );
23406
        $dbh->do( q| ALTER TABLE issues ADD unseen_renewals TINYINT(4) DEFAULT 0 NOT NULL AFTER renewals | );
23398
- 

Return to bug 24083