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

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

Return to bug 37901