From 7f85ef6b50d022db515e591d1e1be684cf910a22 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 21 Apr 2022 12:29:48 +0000 Subject: [PATCH] Bug 30572: Adjust search_marc_to_field.sort in kohastructure Content-Type: text/plain; charset=utf-8 Test plan: New install or run kohastructure on empty database. Signed-off-by: Marcel de Rooy --- 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