]> git.koha-community.org Git - koha.git/commit
Bug 36687: Update itemtypes.notforloan to not allow NULL values and change to tinyint(1)
authorLucas Gass <lucas@bywatersolutions.com>
Wed, 24 Apr 2024 17:05:18 +0000 (17:05 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Fri, 24 May 2024 14:54:32 +0000 (16:54 +0200)
commit85e37d730fa94c3ff900d15c70db0b8ff379b1f0
tree5277996fa991b76d49f695d91b3c09f35048538f
parent76d5c1373240764fc80777beb053465d9687cc04
Bug 36687: Update itemtypes.notforloan to not allow NULL values and change to tinyint(1)

To test:
1. Have some itemtypes.notforloan values set to NULL.
2. APPLY PACTH, updatedatabase, restart_all
3. When you updatedatabase those values should be set to 0.
4. Try updating an itemtypes.notforloan value to NULL. You cannot.

Signed-off-by: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
(cherry picked from commit d267e2fe174506ed066b1810659bf9dcf87681b0)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/atomicupdate/bug_36687.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql