Bugzilla – Attachment 107026 Details for
Bug 23091
Add options to charge new or restore forgiven overdues when a lost item is returned
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23091: Database update
Bug-23091-Database-update.patch (text/plain), 1.11 KB, created by
Martin Renvoize (ashimema)
on 2020-07-17 15:17:14 UTC
(
hide
)
Description:
Bug 23091: Database update
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2020-07-17 15:17:14 UTC
Size:
1.11 KB
patch
obsolete
>From 4fac686d7be9552da78e84291dbbc3702d9e7c0e Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Wed, 3 Jun 2020 16:01:39 +0100 >Subject: [PATCH] Bug 23091: Database update > >This patch updates the 'refund' circulation rule to be called >'lostreturn' and populates the value with 'refund' where appropriate. >--- > installer/data/mysql/atomicupdate/bug_23091.perl | 7 +++++++ > 1 file changed, 7 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_23091.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_23091.perl b/installer/data/mysql/atomicupdate/bug_23091.perl >new file mode 100644 >index 0000000000..a0b02d3556 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23091.perl >@@ -0,0 +1,7 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ $dbh->do( "UPDATE circulation_rules SET rule_name = 'lostreturn' WHERE rule_name = 'refund'" ); >+ $dbh->do( "UPDATE circulation_rules SET rule_value = 'refund' WHERE rule_name = 'lostreturn' AND rule_value = 1" ); >+ >+ NewVersion( $DBversion, 23091, "Update refund rules"); >+} >-- >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 23091
:
96217
|
105529
|
105530
|
105531
|
105544
|
105545
|
105546
|
105547
|
105567
|
105649
|
106871
|
106872
|
106873
|
106874
|
106875
|
106876
|
106906
|
106907
|
106908
|
106909
|
106910
|
106911
|
106912
|
106961
|
107026
|
107027
|
107028
|
107029
|
107030
|
107031
|
107032
|
107033
|
107034
|
107100
|
107101
|
107102
|
107103
|
107104
|
107105
|
107106
|
107107
|
107108
|
107335
|
107336
|
107337
|
107338
|
107339
|
107340
|
107341
|
107342
|
107343
|
108718
|
108719
|
108720
|
108721
|
108722
|
108723
|
108724
|
109571
|
109572
|
109573
|
109574
|
109575
|
109576
|
109577
|
110660
|
110661
|
110662
|
110663
|
110664
|
110665
|
110666
|
110667
|
110720
|
110721
|
110722
|
110723
|
110724
|
110725
|
110726
|
110727
|
111501
|
111502
|
111503
|
111504
|
111505
|
111506
|
111507
|
111508
|
111935
|
111936
|
111965
|
111979
|
111980
|
111981
|
111982
|
111983
|
111984
|
111985
|
111986
|
111987
|
111988
|
111989
|
113081
|
113082
|
113083
|
113084
|
113085
|
113086
|
113087
|
113088
|
113089
|
113090
|
113091