Attachment #114213 for bug #23207

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_23027.perl (+11 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	if( !column_exists( 'itemtypes', 'automatic_checkin' ) ) {
	4	$dbh->do(q{
	5	ALTER TABLE itemtypes ADD COLUMN `automatic_checkin` tinyint(1) NOT NULL DEFAULT 0 AFTER `searchcategory` -- 1 if automatic checkin is enabled for items of this type
	6	});
	7	}
	8
	9	# Always end with this (adjust the bug info)
	10	NewVersion( $DBversion, 23027, "Add automatic_checkin to itemtypes table");
	11	}

Lines 943-948 CREATE TABLE `itemtypes` ( -- defines the item types Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
943	sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype	943	sip_media_type VARCHAR(3) DEFAULT NULL, -- SIP2 protocol media type for this itemtype
944	hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC	944	hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
945	searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options	945	searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
		946	`automatic_checkin` tinyint(1) NOT NULL DEFAULT 0, -- 1 if automatic checkin is enabled for items of this type
946	PRIMARY KEY (`itemtype`),	947	PRIMARY KEY (`itemtype`),
947	CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE,	948	CONSTRAINT itemtypes_ibfk_1 FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE,
948	UNIQUE KEY `itemtype` (`itemtype`)	949	UNIQUE KEY `itemtype` (`itemtype`)
949	-

Return to bug 23207