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

(-)a/installer/data/mysql/kohastructure.sql (-3 / +3 lines)
Lines 2695-2706 CREATE TABLE `fieldmapping` ( -- koha to keyword mapping Link Here
2695
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2695
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2696
2696
2697
--
2697
--
2698
-- Table structure for table `bibliocoverimage`
2698
-- Table structure for table `biblioimages`
2699
--
2699
--
2700
2700
2701
DROP TABLE IF EXISTS `bibliocoverimage`;
2701
DROP TABLE IF EXISTS `biblioimages`;
2702
2702
2703
CREATE TABLE `bibliocoverimage` (
2703
CREATE TABLE `biblioimages` (
2704
 `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
2704
 `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
2705
 `biblionumber` int(11) NOT NULL,
2705
 `biblionumber` int(11) NOT NULL,
2706
 `mimetype` varchar(15) NOT NULL,
2706
 `mimetype` varchar(15) NOT NULL,
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +19 lines)
Lines 4884-4889 Date due: <<issues.date_due>><br /> Link Here
4884
    SetVersion($DBversion);
4884
    SetVersion($DBversion);
4885
}
4885
}
4886
4886
4887
$DBversion = "3.07.00.XXX";
4888
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
4889
    $dbh->do(
4890
        q|CREATE TABLE `biblioimages` (
4891
          `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
4892
          `biblionumber` int(11) NOT NULL,
4893
          `mimetype` varchar(15) NOT NULL,
4894
          `imagefile` mediumblob NOT NULL,
4895
          `thumbnail` mediumblob NOT NULL,
4896
          PRIMARY KEY (`imagenumber`),
4897
          CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
4898
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
4899
    );
4900
    $dbh->do( q|DROP TABLE bibliocoverimage| );
4901
    print
4902
"Upgrade to $DBversion done (Correct table name for local cover images[please disregard any error messages])\n";
4903
    SetVersion($DBversion);
4904
}
4905
4887
=head1 FUNCTIONS
4906
=head1 FUNCTIONS
4888
4907
4889
=head2 DropAllForeignKeys($table)
4908
=head2 DropAllForeignKeys($table)
4890
- 

Return to bug 7587