Bug 13023: Nonpublic note for items should be mapped to a database column like itemnotes
authorKyle M Hall <kyle@bywatersolutions.com>
Thu, 2 Oct 2014 14:11:32 +0000 (10:11 -0400)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Thu, 23 Apr 2015 15:46:47 +0000 (12:46 -0300)
commit5c5d24bc69d681914e50062f59a11508bba9a4ac
tree098ce28b85fdc579c0d6be3749d34e9de6f9038d
parent709488b8b68bdf544c484572b6028a53b03b6878
Bug 13023: Nonpublic note for items should be mapped to a database column like itemnotes

An item's public notes are mapped to a db column, but the librarian only
notes are not. We need to map these so in the future we may display them
in places other than the editor.

Test Plan:
1) Create an item with a non-public note
2) Apply this patch
3) Run updatedatabase
4) Update your frameworks to map your nonpublic item note to items.itemnotes_nonpublic
5) Run misc/batchRebuildItemsTables.pl
6) Inspect the database, note that your non-public note is now in
   items.itemnotes_nonpublic

Signed-off-by: Paola Rossi <paola.rossi@cineca.it>
Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl