From b0f9b34a542ea1d8a339a9170bff78e080aac009 Mon Sep 17 00:00:00 2001 From: Indranil Das Gupta Date: Sun, 14 Jun 2015 17:39:52 +0530 Subject: [PATCH] Bug 14246: (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 Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi --- 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 0a9362a36e..aa42ec50d4 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.39.5