Bugzilla – Attachment 101042 Details for
Bug 24151
Add a pseudonymization process for patrons and transactions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24151: Add new column borrower_attribute_types.keep_for_pseudonymization
Bug-24151-Add-new-column-borrowerattributetypeskee.patch (text/plain), 2.86 KB, created by
Jonathan Druart
on 2020-03-19 16:24:29 UTC
(
hide
)
Description:
Bug 24151: Add new column borrower_attribute_types.keep_for_pseudonymization
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-03-19 16:24:29 UTC
Size:
2.86 KB
patch
obsolete
>From 7032aa8659d0a5bb0ff509adb737a8eab4b826b5 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 27 Nov 2019 14:55:04 +0100 >Subject: [PATCH] Bug 24151: Add new column > borrower_attribute_types.keep_for_pseudonymization > >Sponsored-by: Association KohaLa - https://koha-fr.org/ > >Signed-off-by: Signed-off-by: Sonia Bouis <sonia.bouis@univ-lyon3.fr> >--- > Koha/Schema/Result/BorrowerAttributeType.pm | 4 ++++ > installer/data/mysql/atomicupdate/bug_24151.perl | 6 ++++++ > installer/data/mysql/kohastructure.sql | 1 + > 3 files changed, 11 insertions(+) > >diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm >index 46a86f07bc..08048b51d4 100644 >--- a/Koha/Schema/Result/BorrowerAttributeType.pm >+++ b/Koha/Schema/Result/BorrowerAttributeType.pm >@@ -165,6 +165,10 @@ __PACKAGE__->has_many( > # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-25 20:32:12 > # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsPR8PuUUZHFUkr3MIbTpw > >+__PACKAGE__->add_columns( >+ '+keep_for_pseudonymization' => { is_boolean => 1 }, >+); >+ > sub koha_object_class { > 'Koha::Patron::Attribute::Type'; > } >diff --git a/installer/data/mysql/atomicupdate/bug_24151.perl b/installer/data/mysql/atomicupdate/bug_24151.perl >index 9a97f808b7..62fd64db9e 100644 >--- a/installer/data/mysql/atomicupdate/bug_24151.perl >+++ b/installer/data/mysql/atomicupdate/bug_24151.perl >@@ -60,6 +60,12 @@ if( CheckVersion( $DBversion ) ) { > |); > } > >+ unless( column_exists('borrower_attribute_types', 'keep_for_pseudonymization') ) { >+ $dbh->do(q| >+ ALTER TABLE borrower_attribute_types ADD COLUMN `keep_for_pseudonymization` TINYINT(1) NOT NULL DEFAULT 0 AFTER `class` >+ |); >+ } >+ > # Always end with this (adjust the bug info) > SetVersion( $DBversion ); > print "Upgrade to $DBversion done (Bug 24151 - Add pseudonymized_transactions tables and sysprefs for Pseudonymization)\n"; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 2eeac18d25..9819e7d297 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -226,6 +226,7 @@ CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field > `display_checkout` tinyint(1) NOT NULL default 0,-- defines if this field displays in checkout screens > `category_code` VARCHAR(10) NULL DEFAULT NULL,-- defines a category for an attribute_type > `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type >+ `keep_for_pseudonymization` tinyint(1) NOT NULL default 0, -- defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no) > PRIMARY KEY (`code`), > KEY `auth_val_cat_idx` (`authorised_value_category`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >-- >2.20.1
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 24151
:
95959
|
95960
|
95961
|
95962
|
95963
|
95964
|
95965
|
95966
|
95967
|
95968
|
95969
|
95970
|
95971
|
95972
|
95973
|
95974
|
95975
|
95976
|
97240
|
97241
|
97242
|
97243
|
97244
|
97245
|
97246
|
97247
|
97248
|
97249
|
97250
|
97251
|
97252
|
101034
|
101035
|
101036
|
101037
|
101038
|
101039
|
101040
|
101041
|
101042
|
101043
|
101044
|
101045
|
101046
|
101047
|
101048
|
101049
|
105801
|
105802
|
105803
|
105804
|
105805
|
105806
|
105807
|
105808
|
105809
|
105810
|
105811
|
105812
|
105813
|
105814
|
105815
|
105816
|
106032
|
106033
|
106034
|
106035
|
106036
|
106037
|
106038
|
106039
|
106040
|
106041
|
106042
|
106043
|
106044
|
106045
|
106046
|
106047
|
106048
|
106049
|
106195
|
106255
|
107127
|
107225