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