Bugzilla – Attachment 43717 Details for
Bug 14246
Add borrowernumber to koha_news
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
(fix) correct ALTER TABLE mysql syntax
fix-correct-ALTER-TABLE-mysql-syntax.patch (text/plain), 1.11 KB, created by
Nick Clemens (kidclamp)
on 2015-10-21 23:41:17 UTC
(
hide
)
Description:
(fix) correct ALTER TABLE mysql syntax
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2015-10-21 23:41:17 UTC
Size:
1.11 KB
patch
obsolete
>From f50c5933a770969f82f4264df9586839b67ec4f7 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] (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> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14246
:
39361
|
39413
|
39417
|
39439
|
39521
|
39745
|
39747
|
40125
|
43714
|
43715
|
43716
|
43717
|
43718
|
43719
|
43720
|
43721
|
43722
|
43723
|
43909
|
43910
|
43911
|
43912
|
43913