Bugzilla – Attachment 163685 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.91 KB, created by
Jonathan Druart
on 2024-03-22 10:36:08 UTC
(
hide
)
Description:
Bug 36396: DB changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2024-03-22 10:36:08 UTC
Size:
1.91 KB
patch
obsolete
>From 90a711428188399f4ad6ff5f47f12a2c9d71c47f 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) >--- > 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 00000000000..925057902d5 >--- /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 16310f0f449..55a3ea17934 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -5611,6 +5611,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.34.1
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