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 |
- |
|
|