[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 #45 from Julian Maurice <julian.maurice at biblibre.com> ---
It looks like it doesn't work. I get the same error message, and I added a warn
below `# MariaDB specific drop` and it is not displayed.
DBI is not dying (RaiseError is set to 0 at the beginning of updatedatabase.pl)

Maybe the problem could be avoided by changing the other queries. Currently the
order is:
1. Drop check constraint
2. accounttype = NEW_CODE(accounttype)
3. credit_type_code = accounttype
4. Drop accounttype

Instead we can do:
1. credit_type_code = NEW_CODE(accounttype)
2. Drop accounttype

This way, no need to drop the check constraint first (because accounttype is
not changed), and it is dropped automatically when the column is removed.

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