Bugzilla – Attachment 166246 Details for
Bug 36396
Link facet with authorised value category
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 36396: DB changes
Bug-36396-DB-changes.patch (text/plain), 2.05 KB, created by
Martin Renvoize (ashimema)
on 2024-05-07 10:21:25 UTC
(
hide
)
Description:
Bug 36396: DB changes
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-05-07 10:21:25 UTC
Size:
2.05 KB
patch
obsolete
>From 88da5f2cb8469436d46ab769e981413860b2aa4a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 21 Mar 2024 15:45:11 +0100 >Subject: [PATCH] Bug 36396: DB changes > >Add the new DB column search_field.authorised_value_category > >Sponsored-by: The Research University in the Helmholtz Association (KIT) >Signed-off-by: Lukas Koszyk <lukasz.koszyk@kit.edu> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > installer/data/mysql/atomicupdate/bug_36396.pl | 18 ++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 19 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_36396.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_36396.pl b/installer/data/mysql/atomicupdate/bug_36396.pl >new file mode 100755 >index 00000000000..ad78feb7da1 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_36396.pl >@@ -0,0 +1,18 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "36396", >+ description => "Link elastic facets with authorized value categories", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ $dbh->do( >+ q{ >+ ALTER TABLE search_field >+ ADD COLUMN `authorised_value_category` varchar(32) DEFAULT NULL >+ AFTER mandatory >+ } >+ ); >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 54f739f6c9e..5ddc93703b2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5653,6 +5653,7 @@ CREATE TABLE `search_field` ( > `staff_client` tinyint(1) NOT NULL DEFAULT 1, > `opac` tinyint(1) NOT NULL DEFAULT 1, > `mandatory` tinyint(1) DEFAULT NULL COMMENT 'if marked this field is not editable or removable', >+ `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'link to authorised value category', > PRIMARY KEY (`id`), > UNIQUE KEY `name` (`name`(191)) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >-- >2.45.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 36396
:
163685
|
163686
|
163687
|
163688
|
163689
|
163690
|
163705
|
163776
|
163777
|
163778
|
163779
|
163780
|
163781
|
163782
| 166246 |
166247
|
166248
|
166249
|
166250
|
166251
|
166252
|
166254
|
166258