Bugzilla – Attachment 157737 Details for
Bug 27153
ElasticSearch should search keywords apostrophe blind
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27153: Adjust kohastructure for new primary key
Bug-27153-Adjust-kohastructure-for-new-primary-key.patch (text/plain), 1.52 KB, created by
Martin Renvoize (ashimema)
on 2023-10-24 11:37:20 UTC
(
hide
)
Description:
Bug 27153: Adjust kohastructure for new primary key
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2023-10-24 11:37:20 UTC
Size:
1.52 KB
patch
obsolete
>From 9a5d7f75a56c774e627b2dfabfcb6bdda16db791 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Tue, 5 Sep 2023 17:25:45 +0000 >Subject: [PATCH] Bug 27153: Adjust kohastructure for new primary key > >Signed-off-by: Danielle M Elder <danielle.elder@law.utexas.edu> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f90fc2341f2..394b57e48cc 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5398,7 +5398,7 @@ CREATE TABLE `search_marc_to_field` ( > `facet` tinyint(1) DEFAULT 0 COMMENT 'true if a facet field should be generated for this', > `suggestible` tinyint(1) DEFAULT 0 COMMENT 'true if this field can be used to generate suggestions for browse', > `sort` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this', >- PRIMARY KEY (`search_marc_map_id`,`search_field_id`), >+ PRIMARY KEY (`search_marc_map_id`,`search_field_id`,`filter`), > KEY `search_field_id` (`search_field_id`), > CONSTRAINT `search_marc_to_field_ibfk_1` FOREIGN KEY (`search_marc_map_id`) REFERENCES `search_marc_map` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT `search_marc_to_field_ibfk_2` FOREIGN KEY (`search_field_id`) REFERENCES `search_field` (`id`) ON DELETE CASCADE ON UPDATE CASCADE >-- >2.41.0
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 27153
:
114234
|
139969
|
155145
|
155146
|
155147
|
155148
|
155149
|
155230
|
155502
|
155508
|
155509
|
155510
|
155511
|
155512
|
155513
|
155514
|
155515
|
155516
|
155517
|
157732
|
157733
|
157734
|
157735
|
157736
| 157737