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)
committerKatrin Fischer <katrin.fischer@bsz-bw.de>
Wed, 8 May 2024 16:23:45 +0000 (18:23 +0200)
commitd267e2fe174506ed066b1810659bf9dcf87681b0
tree64e724d20a53b97e83045e5ef2b726b4deba112e
parenta459d5d6efd468f0da39c4819818b4bf7c4bdf2a
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>
installer/data/mysql/atomicupdate/bug_36687.pl [new file with mode: 0755]
installer/data/mysql/kohastructure.sql