From ba97ff0200c3d932fb06b2be282eeedc477dc09e Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Fri, 13 Jul 2012 14:36:08 -0400 Subject: [PATCH] Bug 6716: Document patronimage table --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..fb82236 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -485,8 +485,8 @@ CREATE TABLE `branch_borrower_circ_rules` ( -- DROP TABLE IF EXISTS `default_borrower_circ_rules`; -CREATE TABLE `default_borrower_circ_rules` ( - `categorycode` VARCHAR(10) NOT NULL, +CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" + `categorycode` VARCHAR(10) NOT NULL, -- patron category this rul `maxissueqty` int(4) default NULL, PRIMARY KEY (`categorycode`), CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) @@ -1536,10 +1536,10 @@ CREATE TABLE `patroncards` ( -- DROP TABLE IF EXISTS `patronimage`; -CREATE TABLE `patronimage` ( - `cardnumber` varchar(16) NOT NULL, - `mimetype` varchar(15) NOT NULL, - `imagefile` mediumblob NOT NULL, +CREATE TABLE `patronimage` ( -- information related to patron images + `cardnumber` varchar(16) NOT NULL, -- the cardnumber of the patron this image is attached to (borrowers.cardnumber) + `mimetype` varchar(15) NOT NULL, -- the format of the image (png, jpg, etc) + `imagefile` mediumblob NOT NULL, -- the image PRIMARY KEY (`cardnumber`), CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 1.7.2.3