From 492e0b82ac8aad872c0c8a7f041c0578c502cced Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 8 May 2025 17:32:20 +0100 Subject: [PATCH] Bug 38330: (QA follow-up) Add index to opac_suppressed MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit As suggested by David, this one adds an index on the new column Signed-off-by: David Cook Signed-off-by: Tomás Cohen Arazi --- installer/data/mysql/atomicupdate/bug_38330.pl | 3 ++- installer/data/mysql/kohastructure.sql | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_38330.pl b/installer/data/mysql/atomicupdate/bug_38330.pl index 62d0a9ad5f..35f504fc05 100755 --- a/installer/data/mysql/atomicupdate/bug_38330.pl +++ b/installer/data/mysql/atomicupdate/bug_38330.pl @@ -12,7 +12,8 @@ return { $dbh->do( q{ ALTER TABLE `biblio` - ADD COLUMN `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC' AFTER `abstract`; + ADD COLUMN `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC' AFTER `abstract` + ADD INDEX `suppressedidx` (`opac_suppressed`); } ); diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 1a66e92c5e..fbc0c53dc1 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1112,7 +1112,8 @@ CREATE TABLE `biblio` ( `abstract` longtext DEFAULT NULL COMMENT 'summary from the MARC record (520$a in MARC21)', `opac_suppressed` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'whether the record should be suppressed in the OPAC', PRIMARY KEY (`biblionumber`), - KEY `blbnoidx` (`biblionumber`) + KEY `blbnoidx` (`biblionumber`), + KEY `suppressedidx` (`opac_suppressed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- 2.51.0