Bugzilla – Attachment 166311 Details for
Bug 36755
Increase length of 'code' column in borrower_attribute_types
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36755: Update kohastructure.sql
Bug-36755-Update-kohastructuresql.patch (text/plain), 2.43 KB, created by
Kyle M Hall (khall)
on 2024-05-07 16:37:34 UTC
(
hide
)
Description:
Bug 36755: Update kohastructure.sql
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2024-05-07 16:37:34 UTC
Size:
2.43 KB
patch
obsolete
>From 7498abb4d9387857aeb9013258894da3f981c6b0 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Tue, 7 May 2024 12:36:31 -0400 >Subject: [PATCH] Bug 36755: Update kohastructure.sql > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36755
:
166070
|
166071
|
166086
|
166087
|
166088
|
166309
|
166310
|
166311
|
166351
|
166352
|
166353