From 23b7f936fdc33aa8415bc9dd1fcbfa2b17187f08 Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Fri, 23 Feb 2018 08:49:30 +0100 Subject: [PATCH] Bug 17809: (follow-up) search in COUNTRY category --- installer/data/mysql/atomicupdate/bug_17809_pretty_red.perl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_17809_pretty_red.perl b/installer/data/mysql/atomicupdate/bug_17809_pretty_red.perl index 957bec7..4d0d2c7 100755 --- a/installer/data/mysql/atomicupdate/bug_17809_pretty_red.perl +++ b/installer/data/mysql/atomicupdate/bug_17809_pretty_red.perl @@ -11,6 +11,7 @@ if ( CheckVersion($DBversion) ) { my $number_er = $schema->resultset('AuthorisedValue')->search( { + category => 'COUNTRY', authorised_value => 'ER' } )->count; @@ -20,6 +21,7 @@ if ( CheckVersion($DBversion) ) { } my $number_cc = $schema->resultset('AuthorisedValue')->search( { + category => 'COUNTRY', authorised_value => 'CC' } )->count; @@ -29,6 +31,7 @@ if ( CheckVersion($DBversion) ) { } my $number_gq = $schema->resultset('AuthorisedValue')->search( { + category => 'COUNTRY', authorised_value => 'GQ' } )->count; @@ -37,6 +40,7 @@ if ( CheckVersion($DBversion) ) { } my $number_pk = $schema->resultset('AuthorisedValue')->search( { + category => 'COUNTRY', authorised_value => 'PK' } )->count; -- 2.7.4