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

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

Return to bug 37901