Bugzilla – Attachment 163776 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), 1.96 KB, created by
Lukas Koszyk
on 2024-03-25 10:10:42 UTC
(
hide
)
Description:
Bug 36396: DB changes
Filename:
MIME Type:
Creator:
Lukas Koszyk
Created:
2024-03-25 10:10:42 UTC
Size:
1.96 KB
patch
obsolete
>From bb56626f1d7633d41410cb25b63a728f50560dae 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> >--- > installer/data/mysql/atomicupdate/bug_36396.pl | 16 ++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 17 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 0000000000..925057902d >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_36396.pl >@@ -0,0 +1,16 @@ >+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 ea540c0819..5adf01e1c5 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5614,6 +5614,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.30.2
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