Bugzilla – Attachment 40125 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.06 KB, created by
Indranil Das Gupta
on 2015-06-14 12:15:07 UTC
(
hide
)
Description:
(fix) correct ALTER TABLE mysql syntax
Filename:
MIME Type:
Creator:
Indranil Das Gupta
Created:
2015-06-14 12:15:07 UTC
Size:
1.06 KB
patch
obsolete
>From 7a12e90549309b8740738c44884844e4c0dea02f 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. >--- > 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