From 96ff3cf7d44c19acae7b8ea2191ac157dcd81f14 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 31 Mar 2022 14:13:34 +0000 Subject: [PATCH] Bug 2222: Database revision Content-Type: text/plain; charset=utf-8 Test plan: Run updatedatabase.pl on existing data. Check database columns. Signed-off-by: Marcel de Rooy --- installer/data/mysql/atomicupdate/bug_2222.pl | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_2222.pl diff --git a/installer/data/mysql/atomicupdate/bug_2222.pl b/installer/data/mysql/atomicupdate/bug_2222.pl new file mode 100755 index 0000000000..a0cde9d278 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_2222.pl @@ -0,0 +1,15 @@ +use Modern::Perl; + +return { + bug_number => 2222, + description => "Remove auth_subfield_structure.frameworkcode", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + my $sql = q|ALTER TABLE auth_subfield_structure DROP COLUMN frameworkcode|; + if( column_exists( 'auth_subfield_structure', 'frameworkcode' ) ) { +warn "L11"; + $dbh->do($sql); + } + }, +}; -- 2.20.1