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 / +18 lines)
Lines 4892-4897 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
4892
    SetVersion($DBversion);
4892
    SetVersion($DBversion);
4893
}
4893
}
4894
4894
4895
$DBversion = "3.07.00.XXX";
4896
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
4897
    $dbh->do( q|DROP TABLE bibliocoverimage;| );
4898
    $dbh->do(
4899
        q|CREATE TABLE biblioimages (
4900
          imagenumber int(11) NOT NULL AUTO_INCREMENT,
4901
          biblionumber int(11) NOT NULL,
4902
          mimetype varchar(15) NOT NULL,
4903
          imagefile mediumblob NOT NULL,
4904
          thumbnail mediumblob NOT NULL,
4905
          PRIMARY KEY (imagenumber),
4906
          CONSTRAINT bibliocoverimage_fk1 FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
4907
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;|
4908
    );
4909
    print "Upgrade to $DBversion done (Correct table name for local cover images [please disregard any error messages])\n";
4910
    SetVersion($DBversion);
4911
}
4912
4895
=head1 FUNCTIONS
4913
=head1 FUNCTIONS
4896
4914
4897
=head2 DropAllForeignKeys($table)
4915
=head2 DropAllForeignKeys($table)
4898
- 

Return to bug 7587