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

--- Comment #55 from Martin Renvoize (ashimema) 
<[email protected]> ---
Created attachment 203514
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=203514&action=edit
Bug 42386: DB update - Migrate error_code ENUM to snake_case

Migrates the club_holds_to_patron_holds.error_code ENUM column from
camelCase values to snake_case, matching the new availability class
status codes.

The atomicupdate uses a 3-step approach:
1. Expand ENUM to accept both old and new values
2. UPDATE existing rows from old to new
3. Shrink ENUM to only snake_case values

Test plan:
1. Apply patch
2. Run:
   $ ktd --shell
   k$ updatedatabase
=> SUCCESS: ENUM migrated
3. Sign off :-D

Signed-off-by: Martin Renvoize <[email protected]>

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to