[Koha-patches] [PATCH] Bug 6716: Document patronimage table
Nicole C. Engard
nengard at bywatersolutions.com
Fri Jul 13 20:36:22 CEST 2012
---
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
More information about the Koha-patches
mailing list