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