Bugzilla – Attachment 166353 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), 3.29 KB, created by
Pedro Amorim
on 2024-05-08 08:23:52 UTC
(
hide
)
Description:
Bug 36755: Update kohastructure.sql
Filename:
MIME Type:
Creator:
Pedro Amorim
Created:
2024-05-08 08:23:52 UTC
Size:
3.29 KB
patch
obsolete
>From 90906d927049bed29b52d6c4320c38a1f876f840 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> > >PA amended: Squashed borrower_attribute_types table update > >Signed-off-by: Pedro Amorim <pedro.amorim@ptfs-europe.com> >--- > installer/data/mysql/kohastructure.sql | 8 ++++---- > 1 file changed, 4 insertions(+), 4 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 54f739f6c9..bd50369104 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1247,7 +1247,7 @@ DROP TABLE IF EXISTS `borrower_attribute_types`; > /*!40101 SET @saved_cs_client = @@character_set_client */; > /*!40101 SET character_set_client = utf8 */; > CREATE TABLE `borrower_attribute_types` ( >- `code` varchar(10) NOT NULL COMMENT 'unique key used to identify each custom field', >+ `code` varchar(64) NOT NULL COMMENT 'unique key used to identify each custom field', > `description` varchar(255) NOT NULL COMMENT 'description for each custom field', > `repeatable` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no)', > `unique_id` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if this value needs to be unique (1 for yes, 0 for no)', >@@ -1277,7 +1277,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`), >@@ -1296,7 +1296,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`), >@@ -5301,7 +5301,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.39.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