From 562c28ea0ac694f37f302cd6c10f69abf26cbb42 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Sun, 3 Mar 2019 21:23:12 -0300 Subject: [PATCH] Bug 18235: Update facet_order default value in atomic update Signed-off-by: Josef Moravec --- .../data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 index a7d237a02d..6cf83ab947 100644 --- 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 @@ -1,4 +1,4 @@ -ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT '0' AFTER weight; +ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT NULL 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'; -- 2.11.0