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 3305-3310 CREATE TABLE `biblioimages` ( -- local cover images Link Here
3305
 `mimetype` varchar(15) NOT NULL, -- image type
3305
 `mimetype` varchar(15) NOT NULL, -- image type
3306
 `imagefile` mediumblob NOT NULL, -- image file contents
3306
 `imagefile` mediumblob NOT NULL, -- image file contents
3307
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
3307
 `thumbnail` mediumblob NOT NULL, -- thumbnail file contents
3308
 `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- image creation/update time
3308
 PRIMARY KEY (`imagenumber`),
3309
 PRIMARY KEY (`imagenumber`),
3309
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3310
 CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
3310
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3311
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3311
- 

Return to bug 22987