From 5ab6d0ccd9ee8d50cc66b709e330c5200d7e2c03 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 | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3ed0717f7f..19ac147e7d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -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; -- 2.11.0