[Koha-bugs] [Bug 23805] Add a dedicated credit_types table

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

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

--- Comment #32 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
ALTER TABLE accountlines ADD CONSTRAINT `accountlines_check_type` CHECK
(accounttype IS NOT NULL OR debit_type_code IS NOT NULL)
 # Dropping the check constraint in accountlines
ALTER TABLE
            accountlines
          ADD CONSTRAINT
            `accountlines_check_type`
          CHECK (credit_type_code IS NOT NULL OR debit_type_code IS NOT NULL)
[...]
    # Adding a check constraints to accountlines
    $dbh->do(
        qq{
        ALTER TABLE accountlines ADD CONSTRAINT `accountlines_check_type` CHECK
(accounttype IS NOT NULL OR credit_type_code IS NOT NULL)
        }
    );

=> Come on, ADD is not dropping a constraint !

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