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

[patch] Bug 18235: DB changes

Bug-18235-DB-changes.patch (text/plain), 2.18 KB, created by Jonathan Druart on 2017-12-04 18:30:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2017-12-04 18:30:29 UTC

Size: 2.18 KB

patch

obsolete

>From a87375b7888a39957447141b7e127beb4f202aa6 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>
>---
> installer/data/mysql/atomicupdate/bug_xxxxx.sql | 10 ++++++++++
> installer/data/mysql/kohastructure.sql          |  1 +
> 2 files changed, 11 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_xxxxx.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_xxxxx.sql b/installer/data/mysql/atomicupdate/bug_xxxxx.sql
>new file mode 100644
>index 0000000000..dbc93e7b5c
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_xxxxx.sql
>@@ -0,0 +1,10 @@
>+ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT '0' AFTER type;
>+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 4f2bd983b5..a2fbfb2c75 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1499,6 +1499,7 @@ CREATE TABLE `search_field` (
>   `name` varchar(255) NOT NULL COMMENT 'the name of the field as it will be stored in the search engine',
>   `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
>   `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
>+  `facet_order` TINYINT(4) DEFAULT NULL COMMENT 'the order place of the field in facet list if faceted',
>   PRIMARY KEY (`id`),
>   UNIQUE KEY (`name`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_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