From 7b3c61bd1ad51d6cc7e8c0f526747b91d3e1d12b Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 10 Feb 2019 01:36:20 +0100 Subject: [PATCH] Bug 20544: Wrong comment database documentation on itemnotes Fixes the comments in kohastructure.sql to state the right MARC21 fields for itemnotes (public and internal). To test: - Create a new Koha database and make sure it still installs - Read the patch and check comments are correct Signed-off-by: Martin Renvoize Signed-off-by: Josef Moravec --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 89e71c9..e91282b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -679,8 +679,8 @@ CREATE TABLE `deleteditems` ( `renewals` smallint(6) default NULL, -- number of times this item has been renewed `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) - `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) - `itemnotes_nonpublic` LONGTEXT default NULL, + `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) + `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) `paidfor` LONGTEXT, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered @@ -942,8 +942,8 @@ CREATE TABLE `items` ( -- holdings/item information `renewals` smallint(6) default NULL, -- number of times this item has been renewed `reserves` smallint(6) default NULL, -- number of times this item has been placed on hold/reserved `restricted` tinyint(1) default NULL, -- authorized value defining use restrictions for this item (MARC21 952$5) - `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$x) - `itemnotes_nonpublic` LONGTEXT default NULL, + `itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z) + `itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x) `holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) `paidfor` LONGTEXT, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered -- 2.1.4