Bugzilla – Attachment 180522 Details for
Bug 38457
Add additional fields support to debit types
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38457: Update record_id to VARCHAR(80)
Bug-38457-Update-recordid-to-VARCHAR80.patch (text/plain), 1.97 KB, created by
Laura Escamilla
on 2025-04-03 13:12:20 UTC
(
hide
)
Description:
Bug 38457: Update record_id to VARCHAR(80)
Filename:
MIME Type:
Creator:
Laura Escamilla
Created:
2025-04-03 13:12:20 UTC
Size:
1.97 KB
patch
obsolete
>From 2e0620cd9a16cb57940fd9c3528c77157f3ba0ba Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 20 Feb 2025 11:28:15 +0000 >Subject: [PATCH] Bug 38457: Update record_id to VARCHAR(80) > >This is required to allow for long primary keys from the >account_debit_types table. > >Signed-off-by: Laura_Escamilla <laura.escamilla@bywatersolutions.com> >--- > installer/data/mysql/atomicupdate/bug_38457.pl | 14 ++++++++++++++ > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 15 insertions(+), 1 deletion(-) > create mode 100755 installer/data/mysql/atomicupdate/bug_38457.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_38457.pl b/installer/data/mysql/atomicupdate/bug_38457.pl >new file mode 100755 >index 0000000000..4f7cb4f9ef >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_38457.pl >@@ -0,0 +1,14 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "38457", >+ description => "Add additional fields to debit types", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ $dbh->do(q{ ALTER TABLE additional_field_values MODIFY record_id VARCHAR(80) NOT NULL DEFAULT ''; }); >+ >+ say $out "Converted record_id to VARCHAR(80)"; >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 9b7dc7fc6e..77f2f29391 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -247,7 +247,7 @@ DROP TABLE IF EXISTS `additional_field_values`; > CREATE TABLE `additional_field_values` ( > `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', > `field_id` int(11) NOT NULL COMMENT 'foreign key references additional_fields(id)', >- `record_id` varchar(11) NOT NULL COMMENT 'record_id', >+ `record_id` varchar(80) NOT NULL COMMENT 'record_id', > `value` varchar(255) NOT NULL DEFAULT '' COMMENT 'value for this field', > PRIMARY KEY (`id`), > KEY `afv_fk` (`field_id`), >-- >2.39.5
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 38457
:
175630
|
175631
|
175633
|
176789
|
176790
|
176791
|
178394
|
178395
|
178396
|
178397
|
178398
|
180494
|
180495
|
180496
|
180497
|
180498
|
180519
|
180520
|
180521
|
180522
|
180523
|
182384
|
182385
|
182386
|
182387
|
182388
|
182575