Attachment 86342 Details for Bug 18235 – Bug 18235: DB changes

[patch] Bug 18235: DB changes

Bug-18235-DB-changes.patch (text/plain), 2.40 KB, created by Josef Moravec on 2019-03-08 08:11:06 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Josef Moravec

Created: 2019-03-08 08:11:06 UTC

Size: 2.40 KB

patch

obsolete

>From fffad12d214c20ad2a1147bebb69000b7a50a02d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 8 Mar 2017 15:25:55 -0300
>Subject: [PATCH] Bug 18235: DB changes
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>
>Signed-off-by: Nicolas Legrand <nicolas.legrand@bulac.fr>
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>---
> .../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

Actions: View | Diff | Splinter Review

Attachments on bug 18235: 60931 | 60932 | 60933 | 61528 | 61529 | 61530 | 64747 | 69485 | 69486 | 69487 | 72936 | 72937 | 72938 | 72999 | 73000 | 73001 | 73193 | 74642 | 74643 | 75995 | 75996 | 85212 | 85213 | 85214 | 85215 | 85216 | 85885 | 85886 | 85969 | 85970 | 85983 | 85984 | 85985 | 85986 | 85987 | 85988 | 85989 | 85990 | 85991 | 85992 | 86340 | 86341 | 86342 | 86343 | 86344 | 86345 | 86346 | 86347 | 86348 | 86349 | 86350 | 86944 | 86945 | 86946 | 86947 | 86948 | 86949 | 86950 | 86951 | 86952 | 86953 | 86954 | 86955 | 86956 | 87141