View | Details | Raw Unified | Return to bug 10703
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 3013-3024 CREATE TABLE transport_cost ( Link Here
3013
3013
3014
DROP TABLE IF EXISTS `biblioimages`;
3014
DROP TABLE IF EXISTS `biblioimages`;
3015
3015
3016
CREATE TABLE `biblioimages` (
3016
CREATE TABLE `biblioimages` ( -- local cover images
3017
 `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
3017
 `imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image
3018
 `biblionumber` int(11) NOT NULL,
3018
 `biblionumber` int(11) NOT NULL, -- foreign key from biblio table to link to biblionumber
3019
 `mimetype` varchar(15) NOT NULL,
3019
 `mimetype` varchar(15) NOT NULL, -- image type
3020
 `imagefile` mediumblob NOT NULL,
3020
 `imagefile` mediumblob NOT NULL, -- image file contents
3021
 `thumbnail` mediumblob NOT NULL,
3021
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
3022
 PRIMARY KEY (`imagenumber`),
3022
 PRIMARY KEY (`imagenumber`),
3023
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3023
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3024
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3024
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3025
- 

Return to bug 10703