[Koha-bugs] [Bug 35539] Remove unused columns from categories table

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Jan 2 13:49:40 CET 2024


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

--- Comment #9 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
Created attachment 160404
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=160404&action=edit
Bug 35539: Atomicupdate

Removal of 'bulk' column
Removal of 'finetype' column
Removal of 'issuelimit' column

Test plan, k-t-d:
1) Add data to the relevant columns, run the following mysql:
update categories set bulk = 1;
update categories set finetype = 1;
update categories set issuelimit = 1;
2) Run updatedatabase, notice it shows a warning and does not update the
database
3) Clean up the data, run the folllowing mysql:
update categories set bulk = null;
update categories set finetype = null;
update categories set issuelimit = null;
4) Run updatedatabase again, notice it updates the database as intended

Run:
t/db_dependent/Circulation/GetHardDueDate.t

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


More information about the Koha-bugs mailing list