Bugzilla – Attachment 43912 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]
[PASSED QA] (fix) correct ALTER TABLE mysql syntax
PASSED-QA-fix-correct-ALTER-TABLE-mysql-syntax.patch (text/plain), 1.23 KB, created by
Katrin Fischer
on 2015-10-24 11:31:31 UTC
(
hide
)
Description:
[PASSED QA] (fix) correct ALTER TABLE mysql syntax
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2015-10-24 11:31:31 UTC
Size:
1.23 KB
patch
obsolete
>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
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