From f50c5933a770969f82f4264df9586839b67ec4f7 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 --- 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