Bugzilla – Attachment 163408 Details for
Bug 31791
Add the ability to lock records to prevent modification through the Koha staff interface
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 31791: DB changes
Bug-31791-DB-changes.patch (text/plain), 2.39 KB, created by
Tomás Cohen Arazi (tcohen)
on 2024-03-19 11:39:41 UTC
(
hide
)
Description:
Bug 31791: DB changes
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2024-03-19 11:39:41 UTC
Size:
2.39 KB
patch
obsolete
>From 725f8ba6105f481e50803a62b60b87d4579fee7d Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >Date: Fri, 2 Feb 2024 16:24:58 -0300 >Subject: [PATCH] Bug 31791: DB changes > >Sponsored-by: ByWater Solutions >--- > .../data/mysql/atomicupdate/bug_31791.pl | 26 +++++++++++++++++++ > .../data/mysql/mandatory/userpermissions.sql | 2 ++ > 2 files changed, 28 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_31791.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_31791.pl b/installer/data/mysql/atomicupdate/bug_31791.pl >new file mode 100755 >index 00000000000..3d1998c55a1 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_31791.pl >@@ -0,0 +1,26 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "31791", >+ description => "Add the ability to lock record modification", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES >+ ( 9, 'edit_locked_records', 'Edit locked records'); >+ } >+ ); >+ say $out "Added new permission 'editcatalogue.edit_locked_records'"; >+ >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES >+ ( 9, 'set_record_sources', 'Set record source for records'); >+ } >+ ); >+ say $out "Added new permission 'editcatalogue.set_record_sources'"; >+ }, >+}; >diff --git a/installer/data/mysql/mandatory/userpermissions.sql b/installer/data/mysql/mandatory/userpermissions.sql >index 4b2e07b7dd2..c835d44d25d 100644 >--- a/installer/data/mysql/mandatory/userpermissions.sql >+++ b/installer/data/mysql/mandatory/userpermissions.sql >@@ -61,6 +61,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES > ( 9, 'manage_item_groups', 'Create, update and delete item groups, add or remove items from a item groups'), > ( 9, 'manage_item_editor_templates', 'Update and delete item editor template owned by others'), > ( 9, 'edit_any_item', 'Edit any item regardless of home library'), >+ ( 9, 'edit_locked_records', 'Edit locked records'), >+ ( 9, 'set_record_sources', 'Set record source'), > (10, 'payout', 'Perform account payout action'), > (10, 'refund', 'Perform account refund action'), > (10, 'discount', 'Perform account discount action'), >-- >2.44.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 31791
:
163371
|
163372
|
163373
|
163374
|
163375
|
163376
|
163377
|
163378
|
163405
|
163408
|
163410
|
163411
|
163413
|
163414
|
163415
|
163416
|
163426
|
163427
|
163428
|
163429
|
163430
|
163431
|
163432
|
163433
|
163434
|
163531
|
163532
|
163533
|
163534
|
163535
|
163536
|
163537
|
163538
|
163539
|
163545
|
164193
|
164194
|
164195
|
164196
|
164197
|
164696
|
164697
|
164698
|
164699
|
164700
|
164701
|
164702
|
164703
|
164704
|
164705
|
165044
|
165045
|
165046
|
165047
|
165048
|
165049
|
165050
|
165051
|
165052
|
165053
|
165697