[Koha-bugs] [Bug 36687] itemtypes.notforloan should be tinyint and NOT NULL

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36687 --- Comment #10 from Tomás Cohen Arazi <tomascohen@gmail.com> --- (In reply to Marcel de Rooy from comment #9)

(In reply to Lucas Gass from comment #0)

...

kohastructure says itemtypes.notforloan is "1 if the item is not for loan, 0 if the item is available for loan". It is also defined as smallint(6).

Unlike items.notforloan it cannot be any other value than 0 or 1.

I think this should be NOT NULL DEFAULT 0 and tinyint(1).

Seems wrong to me. We have several notforloan values. Not only 0 and 1.

This is itemtypes.notforloan. Which can only be set to 0 or 1 in the UI. See the attachment I'm uploading. -- You are receiving this mail because: You are watching all bug changes.