From caef11787de91d386ea52a3d8f8d551177387a54 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 21 Apr 2022 12:42:53 +0000 Subject: [PATCH] Bug 30572: Dbrev for search_marc_to_field.sort Content-Type: text/plain; charset=utf-8 Test plan: Run updatedatabase. Signed-off-by: Marcel de Rooy --- installer/data/mysql/atomicupdate/bug_30572.pl | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_30572.pl diff --git a/installer/data/mysql/atomicupdate/bug_30572.pl b/installer/data/mysql/atomicupdate/bug_30572.pl new file mode 100755 index 0000000000..6c47443e0f --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_30572.pl @@ -0,0 +1,14 @@ +use Modern::Perl; + +return { + bug_number => 30572, + description => "Adjust search_marc_to_field.sort", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + # Do you stuffs here + $dbh->do(q| +ALTER TABLE search_marc_to_field MODIFY COLUMN sort tinyint(1) DEFAULT 1 NOT NULL COMMENT 'Sort defaults to 1 (Yes) and creates sort fields in the index, 0 (no) will prevent this'; + |); + }, +}; -- 2.20.1