Attachment #23776 for bug #11384

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

Lines 326-332 sub AddItemToCollection { Link Here

(-)a/C4/RotatingCollections.pm (-1 / +1 lines)
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

Lines 487-496 CREATE TABLE collections ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
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	--




   SetVersion ($DBversion);
}

$DBversion = "3.15.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q{
        ALTER TABLE collections_tracking CHANGE ctId collections_tracking_id integer(11) NOT NULL auto_increment;
    });
    print "Upgrade to $DBversion done (Bug 11384) - change name of collections_tracker.ctId column)\n";
    SetVersion($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)
- 

Return to bug 11384

Lines 7853-7858 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
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	-