Attachment #23434 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 484-493 CREATE TABLE collections ( Link Here

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

Lines 7824-7829 if ( CheckVersion($DBversion) ) { Link Here

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