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

(-)a/installer/data/mysql/atomicupdate/bug_20256.perl (-1 / +8 lines)
Lines 2-7 $DBversion = 'XXX'; # will be replaced by the RM Link Here
2
if( CheckVersion( $DBversion ) ) {
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');" );
3
    $dbh->do( "INSERT IGNORE INTO permissions (module_bit, code, description) VALUES ( 9, 'edit_any_item', 'Edit any item reguardless of home library');" );
4
4
5
    $dbh->do(q{
6
        INSERT INTO user_permissions ( borrowernumber, module_bit, code )
7
        SELECT borrowernumber, '9', 'edit_any_item'
8
        FROM user_permissions
9
        WHERE module_bit = '9'
10
          AND code = 'edit_items'
11
    });
12
5
    if ( !column_exists( 'library_groups', 'ft_limit_item_editing' ) ) {
13
    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" );
14
        $dbh->do( "ALTER TABLE library_groups ADD COLUMN ft_limit_item_editing tinyint(1) NOT NULL DEFAULT 0 AFTER ft_hide_patron_info" );
7
    }
15
    }
8
- 

Return to bug 20256