From fffad12d214c20ad2a1147bebb69000b7a50a02d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 8 Mar 2017 15:25:55 -0300 Subject: [PATCH] Bug 18235: DB changes Signed-off-by: Nick Clemens Signed-off-by: Nicolas Legrand Signed-off-by: Josef Moravec --- .../atomicupdate/bug_18235-add-search_field-facet_order.sql | 10 ++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 11 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql diff --git a/installer/data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql b/installer/data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql new file mode 100644 index 0000000000..a7d237a02d --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql @@ -0,0 +1,10 @@ +ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT '0' AFTER weight; +UPDATE search_field SET facet_order=1 WHERE name='author'; +UPDATE search_field SET facet_order=2 WHERE name='itype'; +UPDATE search_field SET facet_order=3 WHERE name='location'; +UPDATE search_field SET facet_order=4 WHERE name='su-geo'; +UPDATE search_field SET facet_order=5 WHERE name='se'; +UPDATE search_field SET facet_order=6 WHERE name='subject'; +UPDATE search_field SET facet_order=7 WHERE name='ccode'; +UPDATE search_field SET facet_order=8 WHERE name='holdingbranch'; +UPDATE search_field SET facet_order=9 WHERE name='homebranch'; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index d20bc7eaee..b0f7f77ae9 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1458,6 +1458,7 @@ CREATE TABLE `search_field` ( `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display', `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum', 'isbn', 'stdno') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine', `weight` decimal(5,2) DEFAULT NULL, + `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted', PRIMARY KEY (`id`), UNIQUE KEY (`name` (191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 2.11.0