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