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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx.perl (+9 lines)
Lines 17-20 if( CheckVersion( $DBversion ) ) { Link Here
17
    }
17
    }
18
18
19
    NewVersion( $DBversion, 'XXXXX', "Add the biblioimages.itemnumber column");
19
    NewVersion( $DBversion, 'XXXXX', "Add the biblioimages.itemnumber column");
20
21
    if( !TableExists('cover_images') ) {
22
        $dbh->do(q|
23
            ALTER TABLE biblioimages RENAME cover_images
24
        |);
25
    }
26
27
    # Always end with this (adjust the bug info)
28
    NewVersion( $DBversion, "XXXXX", "Rename table biblioimages with cover_images");
20
}
29
}
(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
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
- 

Return to bug 26145