Bugzilla – Attachment 182143 Details for
Bug 38330
Make bib-level suppression a biblio table field instead of part of a MARC tag
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38330: (QA follow-up) Add index to opac_suppressed
Bug-38330-QA-follow-up-Add-index-to-opacsuppressed.patch (text/plain), 2.02 KB, created by
David Cook
on 2025-05-09 03:18:55 UTC
(
hide
)
Description:
Bug 38330: (QA follow-up) Add index to opac_suppressed
Filename:
MIME Type:
Creator:
David Cook
Created:
2025-05-09 03:18:55 UTC
Size:
2.02 KB
patch
obsolete
>From b9e984dd112e8278621e469dedc92708eb717c6c Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@openfifth.co.uk> >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 <dcook@prosentient.com.au> >--- > 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
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 38330
:
175648
|
175649
|
175650
|
175651
|
175767
|
175768
|
175769
|
175770
|
179335
|
179336
|
179337
|
179338
|
179339
|
179340
|
179341
|
182094
|
182095
|
182096
|
182097
|
182098
|
182099
|
182100
|
182101
|
182102
|
182135
|
182136
|
182137
|
182138
|
182139
|
182140
|
182141
|
182142
| 182143 |
182144
|
182145