@@ -, +, @@ --- Koha/Schema/Result/Virtualshelve.pm | 4 ++++ installer/data/mysql/atomicupdate/bug_30418.pl | 6 +++--- 2 files changed, 7 insertions(+), 3 deletions(-) --- a/Koha/Schema/Result/Virtualshelve.pm +++ a/Koha/Schema/Result/Virtualshelve.pm @@ -237,5 +237,9 @@ __PACKAGE__->add_columns( '+allow_change_from_staff' => { is_boolean => 1 }, ); +__PACKAGE__->add_columns( + '+allow_change_from_permitted_staff' => { is_boolean => 1 }, +); + # You can replace this text with custom code or comments, and it will be preserved on regeneration 1; --- a/installer/data/mysql/atomicupdate/bug_30418.pl +++ a/installer/data/mysql/atomicupdate/bug_30418.pl @@ -7,10 +7,10 @@ return { my ($args) = @_; my ($dbh, $out) = @$args{qw(dbh out)}; - if( !column_exists( 'virtualshelves', 'allow_change_from_permitted_staff' ) ) { - $dbh->do(q{ALTER TABLE virtualshelves ADD COLUMN `allow_change_from_permitted_staff` tinyint(1) DEFAULT '0' COMMENT 'can staff with edit_public_list_contents permission change contents?'}); + if( !column_exists( 'virtualshelves', 'allow_change_from_permitted_staff' ) ) { + $dbh->do(q{ALTER TABLE virtualshelves ADD COLUMN `allow_change_from_permitted_staff` tinyint(1) DEFAULT '0' COMMENT 'can staff with edit_public_list_contents permission change contents?'}); } - $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (20, 'edit_public_list_contents', 'Edit public list contents') }); + $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (20, 'edit_public_list_contents', 'Edit public list contents') }); }, }; --