This patch adds db documentation to the biblioimages table. To test:
Apply patch Review kohastructure.sql to be sure that the documentation is there --- 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 8a8b70f..eb565d0 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3013,12 +3013,12 @@ CREATE TABLE transport_cost ( DROP TABLE IF EXISTS `biblioimages`; -CREATE TABLE `biblioimages` ( - `imagenumber` int(11) NOT NULL AUTO_INCREMENT, - `biblionumber` int(11) NOT NULL, - `mimetype` varchar(15) NOT NULL, - `imagefile` mediumblob NOT NULL, - `thumbnail` mediumblob NOT NULL, +CREATE TABLE `biblioimages` ( -- local cover images + `imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image + `biblionumber` int(11) NOT NULL, -- foreign key from biblio table to link to biblionumber + `mimetype` varchar(15) NOT NULL, -- image type + `imagefile` mediumblob NOT NULL, -- image file contents + `thumbnail` mediumblob NOT NULL, -- thumbnail file contents PRIMARY KEY (`imagenumber`), CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 1.7.2.3 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
