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

(-)a/installer/data/mysql/updatedatabase.pl (-9 / +24 lines)
Lines 20011-20024 if ( CheckVersion($DBversion) ) { Link Here
20011
    }
20011
    }
20012
20012
20013
    # Dropping the check constraint in accountlines
20013
    # Dropping the check constraint in accountlines
20014
    $dbh->do(
20014
    eval {
20015
        qq{
20015
        # MySQL Specific Drop
20016
          ALTER TABLE
20016
        $dbh->do(
20017
            accountlines
20017
          qq{
20018
          DROP CHECK
20018
            ALTER TABLE
20019
            `accountlines_check_type`
20019
              accountlines
20020
        }
20020
            DROP CHECK
20021
    );
20021
              `accountlines_check_type`
20022
          }
20023
        );
20024
    };
20025
    if ($@) {
20026
        # MariaDB Specific Drop
20027
        eval {
20028
            $dbh->do(
20029
              qq{
20030
                ALTER TABLE
20031
                  accountlines
20032
                DROP CONSTRAINT
20033
                  `accountlines_check_type`
20034
              }
20035
            );
20036
        };
20037
    }
20022
20038
20023
    # Update accountype 'C' to 'CREDIT'
20039
    # Update accountype 'C' to 'CREDIT'
20024
    $dbh->do(
20040
    $dbh->do(
20025
- 

Return to bug 23805