https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23805 --- Comment #32 from Marcel de Rooy <m.de.rooy@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.