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 |
- |
|
|