Attachment #108851 for bug #20256

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_20256.perl (+11 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	$dbh->do( "INSERT IGNORE INTO permissions (module_bit, code, description) VALUES ( 9, 'edit_any_item', 'Edit any item reguardless of home library');" );
	4
	5	if ( !column_exists( 'library_groups', 'ft_limit_item_editing' ) ) {
	6	$dbh->do( "ALTER TABLE library_groups ADD COLUMN ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0 AFTER ft_hide_patron_info" );
	7	}
	8
	9	SetVersion( $DBversion );
	10	print "Upgrade to $DBversion done (Bug 20256 - Add ability to limit editing of items to home library)\n";
	11	}

Lines 4363-4368 CREATE TABLE library_groups ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+1 lines)
4363	title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup	4363	title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup
4364	description MEDIUMTEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary	4364	description MEDIUMTEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary
4365	ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group	4365	ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
		4366	ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4366	ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups	4367	ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
4367	ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups	4368	ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
4368	ft_local_hold_group tinyint(1) NOT NULL DEFAULT 0, -- Use this group to identify libraries as pick up location for holds	4369	ft_local_hold_group tinyint(1) NOT NULL DEFAULT 0, -- Use this group to identify libraries as pick up location for holds

Lines 46-51 INSERT INTO permissions (module_bit, code, description) VALUES Link Here

(-)a/installer/data/mysql/userpermissions.sql (-1 / +1 lines)
46	( 9, 'edit_items', 'Edit items'),	46	( 9, 'edit_items', 'Edit items'),
47	( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),	47	( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),
48	( 9, 'delete_all_items', 'Delete all items at once'),	48	( 9, 'delete_all_items', 'Delete all items at once'),
		49	( 9, 'edit_any_item', 'Edit any item reguardless of home library'),
49	(10, 'payout', 'Perform account payout action'),	50	(10, 'payout', 'Perform account payout action'),
50	(10, 'refund', 'Perform account refund action'),	51	(10, 'refund', 'Perform account refund action'),
51	(10, 'discount', 'Perform account discount action'),	52	(10, 'discount', 'Perform account discount action'),
52	-

Return to bug 20256