Bugzilla – Attachment 31411 Details for
Bug 12395
Save order line's creator
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 12395: Update aqorders.created_by with aqbasket.authorisedby
Bug-12395-Update-aqorderscreatedby-with-aqbasketau.patch (text/plain), 1.15 KB, created by
Jonathan Druart
on 2014-09-05 15:24:34 UTC
(
hide
)
Description:
Bug 12395: Update aqorders.created_by with aqbasket.authorisedby
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2014-09-05 15:24:34 UTC
Size:
1.15 KB
patch
obsolete
>From 9fa6cf9e7fcd1b3c69c3fff3f1a7e7a3d4cf6fd4 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Fri, 5 Sep 2014 17:21:54 +0200 >Subject: [PATCH] Bug 12395: Update aqorders.created_by with > aqbasket.authorisedby > >Before this patch, the interface assumed the basket's creator was the >"authorisedby" person. > >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> >--- > installer/data/mysql/updatedatabase.pl | 5 +++++ > 1 file changed, 5 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 8bc143f..a52e6bd 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8711,6 +8711,11 @@ if ( CheckVersion($DBversion) ) { > ALTER TABLE aqorders > ADD COLUMN created_by int(11) NULL DEFAULT NULL AFTER quantityreceived > }); >+ $dbh->do(q{ >+ UPDATE aqorders, aqbasket >+ SET aqorders.created_by = aqbasket.authorisedby >+ WHERE aqorders.basketno = aqbasket.basketno >+ }); > print "Upgrade to $DBversion done (Bug 12395: Add aqorders.created_by column)\n"; > SetVersion ($DBversion); > } >-- >2.1.0
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 12395
:
28754
|
28943
|
30128
|
30129
|
31409
|
31410
|
31411
|
33837
|
33838
|
33839
|
35769
|
35770
|
35771
|
35772
|
35779
|
35780
|
35781
|
35782
|
35864
|
36063
|
36075
|
36076
|
36077
|
36078
|
36079
|
36080
|
40132
|
40133
|
40134
|
40135
|
40136
|
40137
|
40138
|
40139
|
40161
|
43951
|
45387
|
58745
|
58746
|
58747
|
58748
|
58749
|
58750
|
61383
|
61384
|
71344
|
71345
|
71346
|
71347
|
71348
|
71349
|
72720
|
72721
|
72722
|
72723
|
72724
|
72725
|
74207
|
74208
|
74209
|
74210
|
74211
|
74212
|
74276
|
74277
|
74278
|
74279
|
74280
|
74281
|
74282
|
75900
|
75901
|
75902
|
75903
|
75904
|
75905
|
75906
|
75907
|
76074
|
76075
|
76076
|
76077
|
76078
|
76079
|
76080
|
76081
|
76082
|
76083
|
76084
|
76085
|
76086
|
76087
|
76088
|
76089