Bug 12365: (follow-up) Putting backticks in atomicupdate
authorAleisha Amohia <aleishaamohia@hotmail.com>
Thu, 18 Oct 2018 02:36:35 +0000 (02:36 +0000)
committerNick Clemens <nick@bywatersolutions.com>
Thu, 8 Nov 2018 11:43:12 +0000 (11:43 +0000)
Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Michal Denar <black23@gmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

installer/data/mysql/atomicupdate/bug_12365_-_add_note_column_to_issuingrules.perl

index 6b4d671..9b800db 100644 (file)
@@ -1,7 +1,7 @@
 $DBversion = 'XXX';
 if( CheckVersion( $DBversion ) ) {
     unless( column_exists( 'issuingrules', 'note' ) ) {
-        $dbh->do(q|ALTER TABLE issuingrules ADD note varchar(100) default NULL AFTER article_requests|);
+        $dbh->do(q|ALTER TABLE `issuingrules` ADD `note` varchar(100) default NULL AFTER `article_requests`|);
     }
 
     SetVersion( $DBversion );