From 846b927068f97505baf0f902ad2995fbca324b50 Mon Sep 17 00:00:00 2001 From: Indranil Das Gupta Date: Sun, 14 Jun 2015 17:39:52 +0530 Subject: [PATCH] (fix) correct ALTER TABLE mysql syntax Address bug 14246 comment 13 remark - correcting MySQL ALTER TABLE syntax. Signed-off-by: Nick Clemens Signed-off-by: Mark Tompsett --- 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; -- 2.1.4