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

--- Comment #32 from Marcel de Rooy <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to