Attachment #110836 for bug #26268

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_26268.perl (+10 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3
	4	if( !column_exists( 'items', 'paidfor' ) ) {
	5	$dbh->do(q\|ALTER TABLE items DROP COLUMN paidfor\|);
	6	$dbh->do(q\|ALTER TABLE deleteditems DROP COLUMN paidfor\|);
	7	}
	8
	9	NewVersion( $DBversion, 26268, "Remove items.paidfor field");
	10	}

Return to bug 26268

Lines 651-657 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 lines)
651	`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)	651	`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
652	`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)	652	`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
653	`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)	653	`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
654	`paidfor` LONGTEXT,
655	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered	654	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
656	`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)	655	`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
657	`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location	656	`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
Lines 860-866 CREATE TABLE `items` ( -- holdings/item information Link Here
860	`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)	859	`itemnotes` LONGTEXT, -- public notes on this item (MARC21 952$z)
861	`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)	860	`itemnotes_nonpublic` LONGTEXT default NULL, -- non-public notes on this item (MARC21 952$x)
862	`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)	861	`holdingbranch` varchar(10) default NULL, -- foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
863	`paidfor` LONGTEXT,
864	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered	862	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this item was last altered
865	`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)	863	`location` varchar(80) default NULL, -- authorized value for the shelving location for this item (MARC21 952$c)
866	`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location	864	`permanent_location` varchar(80) default NULL, -- linked to the CART and PROC temporary locations feature, stores the permanent shelving location
867	-