|
Lines 3367-3378
CREATE TABLE transport_cost (
Link Here
|
| 3367 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3367 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3368 |
|
3368 |
|
| 3369 |
-- |
3369 |
-- |
| 3370 |
-- Table structure for table `biblioimages` |
3370 |
-- Table structure for table `cover_images` |
| 3371 |
-- |
3371 |
-- |
| 3372 |
|
3372 |
|
| 3373 |
DROP TABLE IF EXISTS `biblioimages`; |
3373 |
DROP TABLE IF EXISTS `cover_images`; |
| 3374 |
|
3374 |
|
| 3375 |
CREATE TABLE `biblioimages` ( -- local cover images |
3375 |
CREATE TABLE `cover_images` ( -- local cover images |
| 3376 |
`imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image |
3376 |
`imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image |
| 3377 |
`biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber |
3377 |
`biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber |
| 3378 |
`itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber |
3378 |
`itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber |
| 3379 |
- |
|
|