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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +11 lines)
Lines 17632-17637 if( CheckVersion( $DBversion ) ) { Link Here
17632
$DBversion = '18.12.00.024';
17632
$DBversion = '18.12.00.024';
17633
if ( CheckVersion($DBversion) ) {
17633
if ( CheckVersion($DBversion) ) {
17634
17634
17635
    # Fixup any pre-existing bad suggestedby, manageddate, accepteddate dates
17636
    $dbh->do(
17637
        "UPDATE suggestions SET suggesteddate = '1970-01-01' WHERE suggesteddate = '0000-00-00';"    
17638
    );
17639
    $dbh->do(
17640
        "UPDATE suggestions SET manageddate = '1970-01-01' WHERE manageddate = '0000-00-00';"    
17641
    );
17642
    $dbh->do(
17643
        "UPDATE suggestions SET accepteddate = '1970-01-01' WHERE accepteddate = '0000-00-00';"    
17644
    );
17645
17635
    # Add constraint for suggestedby
17646
    # Add constraint for suggestedby
17636
    unless ( foreign_key_exists( 'suggestions', 'suggestions_ibfk_suggestedby' ) )
17647
    unless ( foreign_key_exists( 'suggestions', 'suggestions_ibfk_suggestedby' ) )
17637
    {
17648
    {
17638
- 

Return to bug 24130