From c7753fa01b00425011c3ae8affcab495fc8c5a2b Mon Sep 17 00:00:00 2001 From: Pedro Amorim 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