Bug 22824: Fix default values for YesNo
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 11 Feb 2021 11:31:05 +0000 (12:31 +0100)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 4 Mar 2021 15:18:42 +0000 (16:18 +0100)
commit83d07dec7f16fb2dedee1e257aa5d42a8523c068
treedc60f2de60e487b5ee86b3a1ca481bc00866b4ce
parent592ab10fe5085bddb078cf019a6fb5ce9a92dc73
Bug 22824: Fix default values for YesNo

select variable, value from systempreferences where type="YesNo" and ( ( value <>'1' and value <>'0' ) or value is null );

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/mandatory/sysprefs.sql