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

(-)a/installer/data/mysql/atomicupdate/bug_22987.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        ALTER TABLE biblioimages
5
            ADD `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
6
                AFTER `thumbnail`;
7
    });
8
9
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug 22987 - Add biblioimages.timestamp)\n";
11
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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
- 

Return to bug 22987