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 487-496 CREATE TABLE collections ( Link Here
487
--
487
--
488
DROP TABLE IF EXISTS collections_tracking;
488
DROP TABLE IF EXISTS collections_tracking;
489
CREATE TABLE collections_tracking (
489
CREATE TABLE collections_tracking (
490
  ctId integer(11) NOT NULL auto_increment,
490
  collections_tracking_id integer(11) NOT NULL auto_increment,
491
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
491
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
492
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
492
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
493
  PRIMARY KEY (ctId)
493
  PRIMARY KEY (collections_tracking_id)
494
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
494
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
495
495
496
--
496
--
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
Lines 7853-7858 if ( CheckVersion($DBversion) ) { Link Here
7853
   SetVersion ($DBversion);
7853
   SetVersion ($DBversion);
7854
}
7854
}
7855
7855
7856
$DBversion = "3.15.00.XXX";
7857
if ( CheckVersion($DBversion) ) {
7858
    $dbh->do(q{
7859
        ALTER TABLE collections_tracking CHANGE ctId collections_tracking_id integer(11) NOT NULL auto_increment;
7860
    });
7861
    print "Upgrade to $DBversion done (Bug 11384) - change name of collections_tracker.ctId column)\n";
7862
    SetVersion($DBversion);
7863
}
7864
7856
=head1 FUNCTIONS
7865
=head1 FUNCTIONS
7857
7866
7858
=head2 TableExists($table)
7867
=head2 TableExists($table)
7859
- 

Return to bug 11384