From 9be0e6f2a830a841339c12ed388204aae863635d Mon Sep 17 00:00:00 2001
From: Indranil Das Gupta <indradg@gmail.com>
Date: Sun, 14 Jun 2015 17:39:52 +0530
Subject: [PATCH] [PASSED QA] (fix) correct ALTER TABLE mysql syntax

Address bug 14246 comment 13 remark - correcting MySQL ALTER TABLE
syntax.

Signed-off-by: Nick Clemens <nick@quecheelibrary.org>

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql b/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql
index 0a9362a..aa42ec5 100644
--- a/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql
+++ b/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql
@@ -1,2 +1,2 @@
-ALTER TABLE `opac_news` ADD `borrowernumber` int(11) AFTER `number` default NULL;
+ALTER TABLE `opac_news` ADD `borrowernumber` int(11) default NULL AFTER `number`;
 ALTER TABLE `opac_news` ADD CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`(`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
-- 
1.9.1