From 5405f27d8333cd5894f6973a281808f190bbca55 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 26 Feb 2020 13:20:52 +0100 Subject: [PATCH] Bug 24722: Add atomicupdate file Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_24722.perl | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_24722.perl diff --git a/installer/data/mysql/atomicupdate/bug_24722.perl b/installer/data/mysql/atomicupdate/bug_24722.perl new file mode 100644 index 0000000000..9d8c65aaf6 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_24722.perl @@ -0,0 +1,9 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(q| + ALTER TABLE reserves MODIFY priority SMALLINT(6) NOT NULL + |); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 24722 - Enforce NOT NULL constraint for reserves.priority)\n"; +} -- 2.11.0