Lines 3275-3280
CREATE TABLE `biblioimages` ( -- local cover images
Link Here
|
3275 |
`mimetype` varchar(15) NOT NULL, -- image type |
3275 |
`mimetype` varchar(15) NOT NULL, -- image type |
3276 |
`imagefile` mediumblob NOT NULL, -- image file contents |
3276 |
`imagefile` mediumblob NOT NULL, -- image file contents |
3277 |
`thumbnail` mediumblob NOT NULL, -- thumbnail file contents |
3277 |
`thumbnail` mediumblob NOT NULL, -- thumbnail file contents |
|
|
3278 |
`timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- image creation/update time |
3278 |
PRIMARY KEY (`imagenumber`), |
3279 |
PRIMARY KEY (`imagenumber`), |
3279 |
CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
3280 |
CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
3280 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3281 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3281 |
- |
|
|