[Koha-bugs] [Bug 23081] Make items.issues and deleteditems.issues default to 0 instead of null

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23081

--- Comment #26 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
It looks like this database update might have created quite an issue. Some
libraries were looking at deleteditems.timestamp as deletion date, but the
database update here altered it, so now it's all update day... :(

$DBversion = '19.12.00.080';
if( CheckVersion( $DBversion ) ) {
     $dbh->do( "UPDATE items set issues=0 where issues is null" );
     $dbh->do( "UPDATE deleteditems set issues=0 where issues is null" );
     $dbh->do( "ALTER TABLE items ALTER issues set default 0" );
     $dbh->do( "ALTER TABLE deleteditems ALTER issues set default 0" );

    NewVersion( $DBversion, 23081, "Set default to 0 for items.issues");
}

-- 
You are receiving this mail because:
You are watching all bug changes.