Bugzilla – Attachment 87218 Details for
Bug 22521
Convert fines handling to use 'status' instead of two accounttypes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22521: Update existing accounttypes
Bug-22521-Update-existing-accounttypes.patch (text/plain), 1.62 KB, created by
Martin Renvoize (ashimema)
on 2019-03-29 14:33:23 UTC
(
hide
)
Description:
Bug 22521: Update existing accounttypes
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-03-29 14:33:23 UTC
Size:
1.62 KB
patch
obsolete
>From 56ae88dc9e4eceaad7454a93a819f036a4247632 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Fri, 22 Mar 2019 11:46:36 +0000 >Subject: [PATCH] Bug 22521: Update existing accounttypes > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Signed-off-by: Josef Moravec <josef.moravec@gmail.com> >--- > .../data/mysql/atomicupdate/bug_22521.perl | 31 ++++++++++++++++++- > 1 file changed, 30 insertions(+), 1 deletion(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_22521.perl b/installer/data/mysql/atomicupdate/bug_22521.perl >index d6d5acf6ba..a631f4140f 100644 >--- a/installer/data/mysql/atomicupdate/bug_22521.perl >+++ b/installer/data/mysql/atomicupdate/bug_22521.perl >@@ -11,6 +11,35 @@ if ( CheckVersion($DBversion) ) { > ); > } > >+ $dbh->do(qq{ >+ UPDATE >+ accountlines >+ SET >+ accounttype = 'OVERDUE', >+ status = 'UNRETURNED' >+ WHERE >+ accounttype = 'FU'; >+ }); >+ >+ $dbh->do(qq{ >+ UPDATE >+ accountlines >+ SET >+ accounttype = 'OVERDUE', >+ status = 'FORGIVEN' >+ WHERE >+ accounttype = 'FFOR'; >+ }); >+ >+ $dbh->do(qq{ >+ UPDATE >+ accountlines >+ SET >+ accounttype = 'OVERDUE', >+ status = 'RETURNED' >+ WHERE >+ accounttype = 'F'; >+ }); > SetVersion($DBversion); >- print "Upgrade to $DBversion done (Bug 22521 - Update accountlines.accounttype to varchar(16))\n"; >+ print "Upgrade to $DBversion done (Bug 22521 - Update accountlines.accounttype to varchar(16), and map new statuses)\n"; > } >-- >2.20.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 22521
:
86808
|
86890
|
86891
|
86892
|
86893
|
86894
|
86895
|
86896
|
86897
|
86898
|
86899
|
86900
|
86901
|
86902
|
86918
|
86919
|
86920
|
86921
|
87063
|
87083
|
87084
|
87085
|
87086
|
87087
|
87097
|
87098
|
87099
|
87100
|
87101
|
87209
|
87210
|
87211
|
87212
|
87213
|
87214
|
87215
|
87216
|
87217
|
87218
|
87219
|
87220
|
87619
|
87620
|
87621
|
87622
|
87623
|
87624
|
87678
|
87679
|
87680
|
87681
|
87682
|
87683
|
87787
|
87788
|
87789
|
87790
|
87791
|
87792
|
87808
|
87809
|
87810
|
87811
|
87812
|
87813
|
87814
|
87850
|
87851
|
87852
|
87853
|
87854
|
87855
|
87856
|
87857
|
87858
|
87859
|
87860
|
87861
|
87862
|
87863
|
87864
|
87865
|
88064
|
88065
|
88066
|
88067
|
88068
|
88069
|
88070
|
88071
|
88149
|
88150
|
88151
|
88152
|
88153
|
88154
|
88155
|
88156
|
88286