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

(-)a/installer/data/mysql/atomicupdate/bug_XXXXX.perl (+13 lines)
Lines 40-45 if( CheckVersion( $DBversion ) ) { Link Here
40
        |);
40
        |);
41
    }
41
    }
42
42
43
    $dbh->do(q|
44
        INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
45
        VALUES ('Pseudonymization','1',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo')
46
    |);
47
    $dbh->do(q|
48
        INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
49
        ('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the anonymized_borrowers table','multiple'),
50
    |);
51
    $dbh->do(q|
52
        INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type)
53
        ('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the anonymized_transactions table','multiple'),
54
    |);
55
43
    # Always end with this (adjust the bug info)
56
    # Always end with this (adjust the bug info)
44
    SetVersion( $DBversion );
57
    SetVersion( $DBversion );
45
    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
58
    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
(-)a/installer/data/mysql/sysprefs.sql (+3 lines)
Lines 503-508 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
503
('PrivacyPolicyURL','',NULL,'This URL is used in messages about GDPR consents.', 'Free'),
503
('PrivacyPolicyURL','',NULL,'This URL is used in messages about GDPR consents.', 'Free'),
504
('ProcessingFeeNote', '', NULL, 'Set the text to be recorded in the column note, table accountlines when the processing fee (defined in item type) is applied', 'textarea'),
504
('ProcessingFeeNote', '', NULL, 'Set the text to be recorded in the column note, table accountlines when the processing fee (defined in item type) is applied', 'textarea'),
505
('ProtectSuperlibrarianPrivileges','1',NULL,'If enabled, non-superlibrarians cannot set superlibrarian privileges','YesNo'),
505
('ProtectSuperlibrarianPrivileges','1',NULL,'If enabled, non-superlibrarians cannot set superlibrarian privileges','YesNo'),
506
('Pseudonymization','1',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo'),
507
('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the anonymized_borrowers table','multiple'),
508
('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the anonymized_transactions table','multiple'),
506
('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'),
509
('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'),
507
('QueryAutoTruncate','1',NULL,'If ON, query truncation is enabled by default','YesNo'),
510
('QueryAutoTruncate','1',NULL,'If ON, query truncation is enabled by default','YesNo'),
508
('QueryFuzzy','1',NULL,'If ON, enables fuzzy option for searches','YesNo'),
511
('QueryFuzzy','1',NULL,'If ON, enables fuzzy option for searches','YesNo'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-1 / +33 lines)
Lines 257-259 Patrons: Link Here
257
         - days and remove anonymized patron accounts after
257
         - days and remove anonymized patron accounts after
258
         - pref: PatronRemovalDelay
258
         - pref: PatronRemovalDelay
259
         - "days.<br>IMPORTANT: No action is performed when these delays are empty (no text). But a zero value ('0') is interpreted as no delay (do it now)! The actions are performed by the cleanup database cron job."
259
         - "days.<br>IMPORTANT: No action is performed when these delays are empty (no text). But a zero value ('0') is interpreted as no delay (do it now)! The actions are performed by the cleanup database cron job."
260
- 
260
     -
261
         - pref: Pseudonymization
262
           choices:
263
               yes: Enable
264
               no: Disable
265
         - "pseudonymization to comply with GDPR for personal information."
266
         - "Patrons and transactions will be copied to a separate table for statistics purpose."
267
         - "<br/>Use the following fields for patrons:"
268
         - pref: PseudonymizationPatronFields
269
           multiple:
270
             title: "Patron's title"
271
             city: "City"
272
             state: "State"
273
             zipcode: "Zipcode"
274
             country: "Country"
275
             branchcode: "Patron's library"
276
             categorycode: "Patron's category"
277
             dateenrolled: "Date the patron was added to Koha"
278
             sex: "Patron's gender"
279
             sort1: "Sort1"
280
             sort2: "Sort2"
281
         - "<br/> And the following fields for the transactions:"
282
         - pref: PseudonymizationTransactionFields
283
           multiple:
284
             datetime: "Date and time of the transaction"
285
             branchcode: "Library where the transaction occurred"
286
             transaction_type: "Transaction type"
287
             itemnumber: "Itemnumber"
288
             itemtype: "Item type"
289
             holdingbranch: "Holding branch"
290
             location: "Location"
291
             itemcallnumber: "Item's callnumber"
292
             ccode: "Collection code"

Return to bug 24151