View | Details | Raw Unified | Return to bug 34494
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/fix_tmp_holdsqueue.pl (+14 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "34494",
5
    description => "Fix tmp_holdsqueue for MySQL compatiability",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{
11
            ALTER TABLE tmp_holdsqueue CHANGE COLUMN itemnumber `itemnumber` int(11) NOT NULL
12
        });
13
    },
14
};
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 5870-5876 DROP TABLE IF EXISTS `tmp_holdsqueue`; Link Here
5870
/*!40101 SET character_set_client = utf8 */;
5870
/*!40101 SET character_set_client = utf8 */;
5871
CREATE TABLE `tmp_holdsqueue` (
5871
CREATE TABLE `tmp_holdsqueue` (
5872
  `biblionumber` int(11) DEFAULT NULL,
5872
  `biblionumber` int(11) DEFAULT NULL,
5873
  `itemnumber` int(11) DEFAULT NULL,
5873
  `itemnumber` int(11) NOT NULL,
5874
  `barcode` varchar(20) DEFAULT NULL,
5874
  `barcode` varchar(20) DEFAULT NULL,
5875
  `surname` longtext NOT NULL,
5875
  `surname` longtext NOT NULL,
5876
  `firstname` mediumtext DEFAULT NULL,
5876
  `firstname` mediumtext DEFAULT NULL,
5877
- 

Return to bug 34494