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

(-)a/installer/data/mysql/kohastructure.sql (-10 / +8 lines)
Lines 5441-5462 CREATE TABLE `problem_reports` ( Link Here
5441
/*!40101 SET character_set_client = @saved_cs_client */;
5441
/*!40101 SET character_set_client = @saved_cs_client */;
5442
5442
5443
--
5443
--
5444
-- Table structure for table `pseudonymized_borrower_attributes`
5444
-- Table structure for table `pseudonymized_metadata_values`
5445
--
5445
--
5446
5446
5447
DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`;
5447
DROP TABLE IF EXISTS `pseudonymized_metadata_values`;
5448
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5448
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5449
/*!40101 SET character_set_client = utf8mb4 */;
5449
/*!40101 SET character_set_client = utf8mb4 */;
5450
CREATE TABLE `pseudonymized_borrower_attributes` (
5450
CREATE TABLE `pseudonymized_metadata_values` (
5451
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5451
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5452
  `transaction_id` int(11) NOT NULL,
5452
  `transaction_id` int(11) NOT NULL,
5453
  `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
5453
  `tablename` varchar(64) NOT NULL COMMENT 'Name of the related table',
5454
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
5454
  `key` varchar(64) NOT NULL COMMENT 'key for the metadata',
5455
  `value` varchar(255) DEFAULT NULL COMMENT 'value for the metadata',
5455
  PRIMARY KEY (`id`),
5456
  PRIMARY KEY (`id`),
5456
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
5457
  KEY `pseudonymized_metadata_values_ibfk_1` (`transaction_id`),
5457
  KEY `anonymized_borrower_attributes_ibfk_2` (`code`),
5458
  CONSTRAINT `pseudonymized_metadata_values_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
5458
  CONSTRAINT `anonymized_borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `borrower_attribute_types` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
5459
  CONSTRAINT `pseudonymized_borrower_attributes_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `pseudonymized_transactions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
5460
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5459
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5461
/*!40101 SET character_set_client = @saved_cs_client */;
5460
/*!40101 SET character_set_client = @saved_cs_client */;
5462
5461
5463
- 

Return to bug 37901