Attachment #108812 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 648-654 CREATE TABLE `deleteditems` ( Link Here

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