Bugzilla – Attachment 85949 Details for
Bug 18925
Move maxissueqty and maxonsiteissueqty to circulation_rules
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 18925: Move existing rules
Bug-18925-Move-existing-rules.patch (text/plain), 1.93 KB, created by
Jonathan Druart
on 2019-03-02 17:15:37 UTC
(
hide
)
Description:
Bug 18925: Move existing rules
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2019-03-02 17:15:37 UTC
Size:
1.93 KB
patch
obsolete
>From 246512f72095121fd2361dc7ddb0c0d4f98dadb4 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Sat, 2 Mar 2019 13:45:14 -0300 >Subject: [PATCH] Bug 18925: Move existing rules > >--- > installer/data/mysql/atomicupdate/bug_18925.perl | 22 ++++++++++++++++++++++ > 1 file changed, 22 insertions(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_18925.perl b/installer/data/mysql/atomicupdate/bug_18925.perl >index 89d943f597..810901b026 100644 >--- a/installer/data/mysql/atomicupdate/bug_18925.perl >+++ b/installer/data/mysql/atomicupdate/bug_18925.perl >@@ -60,6 +60,28 @@ if( CheckVersion( $DBversion ) ) { > $dbh->do("ALTER TABLE default_branch_circ_rules DROP COLUMN maxissueqty, DROP COLUMN maxonsiteissueqty"); > } > >+ if ( column_exists( 'issuingrules', 'maxissueqty' ) ) { >+ $dbh->do(" >+ INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) >+ SELECT IF(categorycode='*', NULL, categorycode), >+ IF(branchcode='*', NULL, branchcode), >+ IF(itemtype='*', NULL, itemtype), >+ 'maxissueqty', >+ COALESCE( maxissueqty, '' ) >+ FROM issuingrules >+ "); >+ $dbh->do(" >+ INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) >+ SELECT IF(categorycode='*', NULL, categorycode), >+ IF(branchcode='*', NULL, branchcode), >+ IF(itemtype='*', NULL, itemtype), >+ 'maxonsiteissueqty', >+ COALESCE( maxonsiteissueqty, '' ) >+ FROM issuingrules >+ "); >+ $dbh->do("ALTER TABLE issuingrules DROP COLUMN maxissueqty, DROP COLUMN maxonsiteissueqty"); >+ } >+ > SetVersion( $DBversion ); > print "Upgrade to $DBversion done (Bug 18925 - Move maxissueqty and maxonsiteissueqty to circulation_rules)\n"; > } >-- >2.11.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 18925
:
65238
|
65239
|
65240
|
67024
|
67025
|
67026
|
67621
|
70992
|
70993
|
70994
|
70995
|
70996
|
71032
|
71033
|
71043
|
71044
|
71045
|
71046
|
71047
|
72225
|
72226
|
72227
|
72228
|
72229
|
77225
|
77226
|
77227
|
77228
|
77229
|
78881
|
78882
|
78883
|
78884
|
78885
|
78886
|
79642
|
79643
|
79644
|
79645
|
79646
|
81091
|
81092
|
81093
|
81094
|
81095
|
82927
|
82928
|
82929
|
82930
|
82931
|
85480
|
85481
|
85482
|
85483
|
85484
|
85485
|
85486
|
85939
|
85940
|
85941
|
85942
|
85943
|
85944
|
85945
|
85946
|
85947
|
85948
|
85949
|
85950
|
85951
|
85953
|
85954
|
85955
|
85956
|
85957
|
85958
|
85959
|
85960
|
85961
|
85962
|
85963
|
85964
|
85965
|
86068
|
86069
|
86070
|
86071
|
86072
|
86073
|
86074
|
86075
|
86076
|
86077
|
86078
|
86079
|
86080
|
86081
|
86121
|
86165
|
86206
|
86207