Bugzilla – Attachment 181009 Details for
Bug 37901
Add ILL pseudonymization
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 37901: Preparation: db changes
Bug-37901-Preparation-db-changes.patch (text/plain), 2.46 KB, created by
Pedro Amorim
on 2025-04-16 15:43:36 UTC
(
hide
)
Description:
Bug 37901: Preparation: db changes
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2025-04-16 15:43:36 UTC
Size:
2.46 KB
patch
obsolete
>From c7753fa01b00425011c3ae8affcab495fc8c5a2b Mon Sep 17 00:00:00 2001 >From: Pedro Amorim <pedro.amorim@ptfs-europe.com> >Date: Mon, 3 Mar 2025 10:09:58 -0100 >Subject: [PATCH] Bug 37901: Preparation: db changes > >--- > installer/data/mysql/kohastructure.sql | 17 ++++++++--------- > 1 file changed, 8 insertions(+), 9 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 5440bd82fd2..b9d9796f44c 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5439,22 +5439,21 @@ CREATE TABLE `problem_reports` ( > /*!40101 SET character_set_client = @saved_cs_client */; > > -- >--- Table structure for table `pseudonymized_borrower_attributes` >+-- Table structure for table `pseudonymized_metadata_values` > -- > >-DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; >+DROP TABLE IF EXISTS `pseudonymized_metadata_values`; > /*!40101 SET @saved_cs_client = @@character_set_client */; > /*!40101 SET character_set_client = utf8 */; >-CREATE TABLE `pseudonymized_borrower_attributes` ( >+CREATE TABLE `pseudonymized_metadata_values` ( > `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', > `transaction_id` int(11) NOT NULL, >- `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', >- `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value', >+ `tablename` varchar(64) NOT NULL COMMENT 'Name of the related table', >+ `key` varchar(64) NOT NULL COMMENT 'key for the metadata', >+ `value` varchar(255) DEFAULT NULL COMMENT 'value for the metadata', > PRIMARY KEY (`id`), >- KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), >- KEY `anonymized_borrower_attributes_ibfk_2` (`code`), >- CONSTRAINT `anonymized_borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE, >- CONSTRAINT `pseudonymized_borrower_attributes_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >+ KEY `pseudonymized_metadata_values_ibfk_1` (`transaction_id`), >+ CONSTRAINT `pseudonymized_metadata_values_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >-- >2.39.5
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 37901
:
178356
|
178956
|
178957
|
178958
|
178959
|
178960
|
178961
|
178962
|
178963
|
178964
|
178965
|
178966
|
178967
|
178968
|
178980
|
178981
|
178982
|
178983
|
178984
|
178985
|
178986
|
178987
|
178988
|
178989
|
178990
|
178991
|
178992
|
181008
| 181009 |
181010
|
181011
|
181012
|
181013
|
181014
|
181015
|
181016
|
181017
|
181018
|
181019
|
181020