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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
Lines 1257-1263 DROP TABLE IF EXISTS `borrower_attribute_types_branches`; Link Here
1257
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1257
/*!40101 SET @saved_cs_client     = @@character_set_client */;
1258
/*!40101 SET character_set_client = utf8 */;
1258
/*!40101 SET character_set_client = utf8 */;
1259
CREATE TABLE `borrower_attribute_types_branches` (
1259
CREATE TABLE `borrower_attribute_types_branches` (
1260
  `bat_code` varchar(10) DEFAULT NULL,
1260
  `bat_code` varchar(64) DEFAULT NULL,
1261
  `b_branchcode` varchar(10) DEFAULT NULL,
1261
  `b_branchcode` varchar(10) DEFAULT NULL,
1262
  KEY `bat_code` (`bat_code`),
1262
  KEY `bat_code` (`bat_code`),
1263
  KEY `b_branchcode` (`b_branchcode`),
1263
  KEY `b_branchcode` (`b_branchcode`),
Lines 1276-1282 DROP TABLE IF EXISTS `borrower_attributes`; Link Here
1276
CREATE TABLE `borrower_attributes` (
1276
CREATE TABLE `borrower_attributes` (
1277
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
1277
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
1278
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute',
1278
  `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute',
1279
  `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
1279
  `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
1280
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
1280
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
1281
  PRIMARY KEY (`id`),
1281
  PRIMARY KEY (`id`),
1282
  KEY `borrowernumber` (`borrowernumber`),
1282
  KEY `borrowernumber` (`borrowernumber`),
Lines 5276-5282 DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; Link Here
5276
CREATE TABLE `pseudonymized_borrower_attributes` (
5276
CREATE TABLE `pseudonymized_borrower_attributes` (
5277
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5277
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field',
5278
  `transaction_id` int(11) NOT NULL,
5278
  `transaction_id` int(11) NOT NULL,
5279
  `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
5279
  `code` varchar(64) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for',
5280
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
5280
  `attribute` varchar(255) DEFAULT NULL COMMENT 'custom patron field value',
5281
  PRIMARY KEY (`id`),
5281
  PRIMARY KEY (`id`),
5282
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
5282
  KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`),
5283
- 

Return to bug 36755