From 7498abb4d9387857aeb9013258894da3f981c6b0 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 7 May 2024 12:36:31 -0400 Subject: [PATCH] Bug 36755: Update kohastructure.sql Signed-off-by: Kyle M Hall --- installer/data/mysql/kohastructure.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e463e8d2f4f..92682436475 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1257,7 +1257,7 @@ DROP TABLE IF EXISTS `borrower_attribute_types_branches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `borrower_attribute_types_branches` ( - `bat_code` varchar(10) DEFAULT NULL, + `bat_code` varchar(64) DEFAULT NULL, `b_branchcode` varchar(10) DEFAULT NULL, KEY `bat_code` (`bat_code`), KEY `b_branchcode` (`b_branchcode`), @@ -1276,7 +1276,7 @@ DROP TABLE IF EXISTS `borrower_attributes`; CREATE TABLE `borrower_attributes` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', `borrowernumber` int(11) NOT NULL COMMENT 'foreign key from the borrowers table, defines which patron/borrower has this attribute', - `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', + `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', PRIMARY KEY (`id`), KEY `borrowernumber` (`borrowernumber`), @@ -5276,7 +5276,7 @@ DROP TABLE IF EXISTS `pseudonymized_borrower_attributes`; CREATE TABLE `pseudonymized_borrower_attributes` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row id field', `transaction_id` int(11) NOT NULL, - `code` varchar(10) NOT NULL COMMENT 'foreign key from the borrower_attribute_types table, defines which custom field this value was entered for', + `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', PRIMARY KEY (`id`), KEY `pseudonymized_borrower_attributes_ibfk_1` (`transaction_id`), -- 2.30.2