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

(-)a/installer/data/mysql/atomicupdate/Bug-18595-1-Validate-days-in-advance.perl (-1 / +9 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    $dbh->do("UPDATE borrower_message_preferences SET days_in_advance=NULL WHERE days_in_advance IS NOT NULL AND message_attribute_id IN (SELECT message_attribute_id FROM message_attributes WHERE takes_days=0)");
5
6
    # Always end with this (adjust the bug info)
7
    SetVersion( $DBversion );
8
    print "Upgrade to $DBversion done (Bug 18595-1 - Validate days_in_advance values in borrower_message_preferences table)\n";
9
}

Return to bug 18595