From 8917804a423032ebcd2c0fc6c0dd8958d005b0ad Mon Sep 17 00:00:00 2001 From: Joy Nelson Date: Fri, 8 May 2020 21:45:33 +0000 Subject: [PATCH] Bug 23081: followup remove atomicupdate file Signed-off-by: Joy Nelson --- .../bug_23081-change-default-of-issues-field.perl | 15 --------------- 1 file changed, 15 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_23081-change-default-of-issues-field.perl diff --git a/installer/data/mysql/atomicupdate/bug_23081-change-default-of-issues-field.perl b/installer/data/mysql/atomicupdate/bug_23081-change-default-of-issues-field.perl deleted file mode 100644 index 204d9999b3..0000000000 --- a/installer/data/mysql/atomicupdate/bug_23081-change-default-of-issues-field.perl +++ /dev/null @@ -1,15 +0,0 @@ -$DBversion = 'XXX'; # will be replaced by the RM -if( CheckVersion( $DBversion ) ) { - # you can use $dbh here like: - $dbh->do( "UPDATE items set issues=0 where issues is null" ); - $dbh->do( "UPDATE deleteditems set issues=0 where issues is null" ); - $dbh->do( "ALTER TABLE items ALTER issues set default 0" ); - $dbh->do( "ALTER TABLE deleteditems ALTER issues set default 0" ); - # or perform some test and warn - # if( !column_exists( 'biblio', 'biblionumber' ) ) { - # warn "There is something wrong"; - # } - - # Always end with this (adjust the bug info) - NewVersion( $DBversion, 23081, "Set default to 0 for items.issues"); -} -- 2.39.2