From c424d0dded47d98072242db8b7a17d9be480e5fc 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 Test plan: Run updatedatabase. Signed-off-by: Marcel de Rooy Signed-off-by: Martin Renvoize --- 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