1 To make items reservable (and specailly to be able to fullfill reservation when doing checking, which is standard procedure
2 when items get from closed storage to pickup desk) we modified all notforloan values which we use (like "only for work in library") to use negative values:
4 mysql> update items set notforloan=-2 where notforloan=1 ;
5 Query OK, 99196 rows affected (8.04 sec)
6 Rows matched: 99196 Changed: 99196 Warnings: 0
8 mysql> update items set notforloan=-3 where notforloan=2 ;
9 Query OK, 151 rows affected (1.50 sec)
10 Rows matched: 151 Changed: 151 Warnings: 0
12 mysql> update items set notforloan=-4 where notforloan=3 ;
13 Query OK, 247 rows affected (1.61 sec)
14 Rows matched: 247 Changed: 247 Warnings: 0
16 This works because of koha feature that items from acquisitions have negative notforloan.