Bugzilla – Attachment 133892 Details for
Bug 30572
Field search_marc_to_field.sort needs syncing too
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 30572: Adjust search_marc_to_field.sort in kohastructure
Bug-30572-Adjust-searchmarctofieldsort-in-kohastru.patch (text/plain), 1.52 KB, created by
Martin Renvoize (ashimema)
on 2022-04-26 13:15:30 UTC
(
hide
)
Description:
Bug 30572: Adjust search_marc_to_field.sort in kohastructure
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2022-04-26 13:15:30 UTC
Size:
1.52 KB
patch
obsolete
>From 9cb83b1fe28e83e7bc44341e5f1418fd8568797b Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Thu, 21 Apr 2022 12:29:48 +0000 >Subject: [PATCH] Bug 30572: Adjust search_marc_to_field.sort in kohastructure > >Test plan: >New install or run kohastructure on empty database. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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 8f5f7b438f..cf489f2e59 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4581,7 +4581,7 @@ CREATE TABLE `search_marc_to_field` ( > `search_field_id` int(11) NOT NULL, > `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) DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t', >+ `sort` tinyint(1) DEFAULT 1 NOT NULL 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`), > 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, >-- >2.20.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 30572
:
133552
|
133553
|
133554
| 133892 |
133893
|
133894
|
134655