Bugzilla – Attachment 187674 Details for
Bug 36033
Table pseudonymized_transactions needs more indexes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36033: Fix DB struct diff
Bug-36033-Fix-DB-struct-diff.patch (text/plain), 1.66 KB, created by
Jonathan Druart
on 2025-10-09 15:04:01 UTC
(
hide
)
Description:
Bug 36033: Fix DB struct diff
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2025-10-09 15:04:01 UTC
Size:
1.66 KB
patch
obsolete
>From 8a77b0938e96ce4448fb0e2413f546587775e22c Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 9 Oct 2025 16:52:08 +0200 >Subject: [PATCH] Bug 36033: Fix DB struct diff > >--- > installer/data/mysql/db_revs/250600011.pl | 5 +++++ > installer/data/mysql/kohastructure.sql | 4 ++-- > 2 files changed, 7 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/db_revs/250600011.pl b/installer/data/mysql/db_revs/250600011.pl >index a7cec777c74..3195b4d7455 100755 >--- a/installer/data/mysql/db_revs/250600011.pl >+++ b/installer/data/mysql/db_revs/250600011.pl >@@ -47,6 +47,11 @@ return { > ); > } > >+ unless ( index_exists( 'statistics', 'illrequest_idx' ) ) { >+ $dbh->do(q{ALTER TABLE `statistics` ADD INDEX `illrequest_idx` (`illrequest_id`)}); >+ >+ } >+ > my $reports = join( > "\n", > map( "\tReport ID: " >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f679c48b06c..b27b84701e8 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6124,11 +6124,11 @@ CREATE TABLE `statistics` ( > KEY `timeidx` (`datetime`), > KEY `branch_idx` (`branch`), > KEY `type_idx` (`type`), >- KEY `illrequest_idx` (`illrequest_id`), > KEY `itemnumber_idx` (`itemnumber`), > KEY `itemtype_idx` (`itemtype`), > KEY `borrowernumber_idx` (`borrowernumber`), >- KEY `ccode_idx` (`ccode`) >+ KEY `ccode_idx` (`ccode`), >+ KEY `illrequest_idx` (`illrequest_id`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >-- >2.34.1
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 36033
:
161879
|
161880
|
162012
|
163659
|
187674
|
187698