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

(-)a/C4/RotatingCollections.pm (-1 / +1 lines)
Lines 326-332 sub AddItemToCollection { Link Here
326
  my $dbh = C4::Context->dbh;
326
  my $dbh = C4::Context->dbh;
327
327
328
  my $sth;
328
  my $sth;
329
  $sth = $dbh->prepare("INSERT INTO collections_tracking ( ctId, colId, itemnumber ) 
329
  $sth = $dbh->prepare("INSERT INTO collections_tracking ( collections_tracking_id, colId, itemnumber ) 
330
                        VALUES ( NULL, ?, ? )");
330
                        VALUES ( NULL, ?, ? )");
331
  $sth->execute( $colId, $itemnumber ) or return ( 0, 3, $sth->errstr() );
331
  $sth->execute( $colId, $itemnumber ) or return ( 0, 3, $sth->errstr() );
332
332
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 484-493 CREATE TABLE collections ( Link Here
484
--
484
--
485
DROP TABLE IF EXISTS collections_tracking;
485
DROP TABLE IF EXISTS collections_tracking;
486
CREATE TABLE collections_tracking (
486
CREATE TABLE collections_tracking (
487
  ctId integer(11) NOT NULL auto_increment,
487
  collections_tracking_id integer(11) NOT NULL auto_increment,
488
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
488
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
489
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
489
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
490
  PRIMARY KEY (ctId)
490
  PRIMARY KEY (collections_tracking_id)
491
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
491
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
492
492
493
--
493
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7824-7829 if ( CheckVersion($DBversion) ) { Link Here
7824
    SetVersion($DBversion);
7824
    SetVersion($DBversion);
7825
}
7825
}
7826
7826
7827
$DBversion = "3.15.00.XXX";
7828
if ( CheckVersion($DBversion) ) {
7829
    $dbh->do(q{
7830
        ALTER TABLE collections_tracking CHANGE ctId collections_tracking_id integer(11) NOT NULL auto_increment;
7831
    });
7832
    print "Upgrade to $DBversion done (Bug 11384) - change name of collections_tracker.ctId column)\n";
7833
    SetVersion($DBversion);
7834
}
7827
7835
7828
=head1 FUNCTIONS
7836
=head1 FUNCTIONS
7829
7837
7830
- 

Return to bug 11384