From fffd8229c2facef82d3650ecad979bf4113cb9b7 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Thu, 18 Oct 2018 10:30:27 +0000 Subject: [PATCH] Bug 21594 - description in api_keys table needs a DEFAULT value To test: 1 - You must have dev_install set in your koha-conf 2 - prove -v t/db_dependent/Koha/ApiKeys.t 3 - It fails 4 - prove -v t/db_dependent/Koha/Object.t 5 - It fails 6 - Apply patch 7 - Update database 8 - Re-run tests 9 - They pass? --- .../atomicupdate/bug21594_add_default_for_api_keys_description.perl | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug21594_add_default_for_api_keys_description.perl diff --git a/installer/data/mysql/atomicupdate/bug21594_add_default_for_api_keys_description.perl b/installer/data/mysql/atomicupdate/bug21594_add_default_for_api_keys_description.perl new file mode 100644 index 0000000..7006cd6 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug21594_add_default_for_api_keys_description.perl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; +if( CheckVersion( $DBversion ) ) { + $dbh->do( "ALTER TABLE api_keys CHANGE COLUMN description description VARCHAR(255) NOT NULL DEFAULT ''" ); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 21594 - description in api_keys table needs a DEFAULT value)\n"; +} -- 2.1.4