From a10402086b573c6b00dcb02f9ef9e83faccdbf82 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 21 Aug 2011 08:55:33 -0400 Subject: [PATCH] Bug 6716: Documentation for the itemtypes table This patch defines the itemtypes table. The definiton for the summary field is a bit of guess based on the description in the staff client, and might need some clarification. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 370a2a4269..d0ebda9520 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1051,13 +1051,13 @@ CREATE TABLE `items` ( -- DROP TABLE IF EXISTS `itemtypes`; -CREATE TABLE `itemtypes` ( - `itemtype` varchar(10) NOT NULL default '', - `description` mediumtext, - `rentalcharge` double(16,4) default NULL, - `notforloan` smallint(6) default NULL, - `imageurl` varchar(200) default NULL, - `summary` text, +CREATE TABLE `itemtypes` ( -- defines the item types + `itemtype` varchar(10) NOT NULL default '', -- unique key, a code associated with the item type + `description` mediumtext, -- a plain text explanation of the item type + `rentalcharge` double(16,4) default NULL, -- the amount charged when this item is checked out/issued + `notforloan` smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan + `imageurl` varchar(200) default NULL, -- URL for the item type icon + `summary` text, -- information from the summary field, may include HTML PRIMARY KEY (`itemtype`), UNIQUE KEY `itemtype` (`itemtype`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.11.0