From bf4dc36b14a10946a62d7337ab49d7bf76916a46 Mon Sep 17 00:00:00 2001 From: pongtawat Date: Tue, 4 Apr 2017 23:06:45 +0700 Subject: [PATCH] Bug 18383 - Correct items.onloan schema comment Signed-off-by: Katrin Fischer Signed-off-by: Marcel de Rooy Amended to include items and deleteditems. Signed-off-by: Kyle M Hall (cherry picked from commit 69a24812eda9c10841d8f20ce4c689305703b6f0) Signed-off-by: Katrin Fischer --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 0fe971ce42..0a059372e0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -663,7 +663,7 @@ CREATE TABLE `deleteditems` ( `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location - `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out) + `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) @@ -906,7 +906,7 @@ CREATE TABLE `items` ( -- holdings/item information `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered `location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c) `permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location - `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out) + `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and due date for checked out) `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2) `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8) -- 2.39.5