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

(-)a/installer/data/mysql/atomicupdate/bug_20256.perl (+11 lines)
Line 0 Link Here
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
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 4203-4210 CREATE TABLE library_groups ( Link Here
4203
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
4203
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
4204
    description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
4204
    description MEDIUMTEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
4205
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4205
    ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4206
    ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group
4206
    ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
4207
    ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0, -- Use this group for staff side search groups
4207
     ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
4208
    ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0, -- Use this group for opac side search groups
4208
    created_on TIMESTAMP NULL,             -- Date and time of creation
4209
    created_on TIMESTAMP NULL,             -- Date and time of creation
4209
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
4210
    updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- Date and time of last
4210
    PRIMARY KEY id ( id ),
4211
    PRIMARY KEY id ( id ),
(-)a/installer/data/mysql/userpermissions.sql (-1 / +1 lines)
Lines 42-47 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
42
   ( 9, 'edit_items', 'Edit items'),
42
   ( 9, 'edit_items', 'Edit items'),
43
   ( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),
43
   ( 9, 'edit_items_restricted', 'Limit item modification to subfields defined in the SubfieldsToAllowForRestrictedEditing preference (please note that edit_item is still required)'),
44
   ( 9, 'delete_all_items', 'Delete all items at once'),
44
   ( 9, 'delete_all_items', 'Delete all items at once'),
45
   ( 9, 'edit_any_item', 'Edit any item reguardless of home library'),
45
   (10, 'writeoff', 'Write off fines and fees'),
46
   (10, 'writeoff', 'Write off fines and fees'),
46
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
47
   (10, 'remaining_permissions', 'Remaining permissions for managing fines and fees'),
47
   (11, 'currencies_manage', 'Manage currencies and exchange rates'),
48
   (11, 'currencies_manage', 'Manage currencies and exchange rates'),
48
- 

Return to bug 20256