From b9e984dd112e8278621e469dedc92708eb717c6c 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 As suggested by David, this one adds an index on the new column Signed-off-by: David Cook --- 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 83a6da3bd3..5ac74e1af3 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.39.5