Bugzilla – Attachment 83757 Details for
Bug 11879
Add a new field to patron record: main contact method
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 21753: DBRev 18.12.00.007
Bug-21753-DBRev-181200007.patch (text/plain), 3.81 KB, created by
José-Mario Monteiro-Santos
on 2019-01-09 16:47:07 UTC
(
hide
)
Description:
Bug 21753: DBRev 18.12.00.007
Filename:
MIME Type:
Creator:
José-Mario Monteiro-Santos
Created:
2019-01-09 16:47:07 UTC
Size:
3.81 KB
patch
obsolete
>From 565c2b91ead4f04cbcd7f1995e837d8ecb667ba6 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Fri, 4 Jan 2019 03:08:14 +0000 >Subject: [PATCH] Bug 21753: DBRev 18.12.00.007 > >Signed-off-by: Nick Clemens <nick@bywatersolutions.com> > >https://bugs.koha-community.org/show_bug.cgi?id=11879 >--- > Koha.pm | 2 +- > Koha/Schema/Result/Issuingrule.pm | 12 ++---------- > installer/data/mysql/atomicupdate/bug_21753.perl | 10 ---------- > installer/data/mysql/updatedatabase.pl | 9 +++++++++ > 4 files changed, 12 insertions(+), 21 deletions(-) > delete mode 100644 installer/data/mysql/atomicupdate/bug_21753.perl > >diff --git a/Koha.pm b/Koha.pm >index 7380682..f0c4c77 100644 >--- a/Koha.pm >+++ b/Koha.pm >@@ -29,7 +29,7 @@ use vars qw{ $VERSION }; > # - #4 : the developer version. The 4th number is the database subversion. > # used by developers when the database changes. updatedatabase take care of the changes itself > # and is automatically called by Auth.pm when needed. >-$VERSION = "18.12.00.006"; >+$VERSION = "18.12.00.007"; > > sub version { > return $VERSION; >diff --git a/Koha/Schema/Result/Issuingrule.pm b/Koha/Schema/Result/Issuingrule.pm >index db7dea1..187e463 100644 >--- a/Koha/Schema/Result/Issuingrule.pm >+++ b/Koha/Schema/Result/Issuingrule.pm >@@ -97,12 +97,6 @@ __PACKAGE__->table("issuingrules"); > data_type: 'integer' > is_nullable: 1 > >-=head2 chargename >- >- data_type: 'varchar' >- is_nullable: 1 >- size: 100 >- > =head2 maxissueqty > > data_type: 'integer' >@@ -261,8 +255,6 @@ __PACKAGE__->add_columns( > { data_type => "tinyint", default_value => 0, is_nullable => 0 }, > "accountsent", > { data_type => "integer", is_nullable => 1 }, >- "chargename", >- { data_type => "varchar", is_nullable => 1, size => 100 }, > "maxissueqty", > { data_type => "integer", is_nullable => 1 }, > "maxonsiteissueqty", >@@ -336,8 +328,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-11-08 17:41:17 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vOr4mEAacS5WKLQifgT8EA >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-01-04 03:06:35 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:slPyHZs0YvOKev3cAxdDJQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/installer/data/mysql/atomicupdate/bug_21753.perl b/installer/data/mysql/atomicupdate/bug_21753.perl >deleted file mode 100644 >index f5e5d44..0000000 >--- a/installer/data/mysql/atomicupdate/bug_21753.perl >+++ /dev/null >@@ -1,10 +0,0 @@ >-$DBversion = 'XXX'; # will be replaced by the RM >-if( CheckVersion( $DBversion ) ) { >- if( column_exists( 'issuingrules', 'chargename' ) ) { >- $dbh->do( "ALTER TABLE issuingrules DROP chargename" ); >- } >- >- # Always end with this (adjust the bug info) >- SetVersion( $DBversion ); >- print "Upgrade to $DBversion done (Bug 21753: Drop chargename from issuingrules )\n"; >-} >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 5b0399b..b4d246a 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -17235,6 +17235,15 @@ if( CheckVersion( $DBversion ) ) { > print "Upgrade to $DBversion done (Bug 21915 - Add a way to automatically reconcile balance for patrons)\n"; > } > >+$DBversion = '18.12.00.007'; >+if( CheckVersion( $DBversion ) ) { >+ if( column_exists( 'issuingrules', 'chargename' ) ) { >+ $dbh->do( "ALTER TABLE issuingrules DROP chargename" ); >+ } >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 21753: Drop chargename from issuingrules )\n"; >+} >+ > # SEE bug 13068 > # if there is anything in the atomicupdate, read and execute it. > >-- >2.7.4
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 11879
:
25745
|
25922
|
25941
|
31300
|
31301
|
31320
|
34351
|
34482
|
34502
|
34503
|
34571
|
34572
|
34573
|
41209
|
41220
|
41221
|
41222
|
46101
|
46284
|
46285
|
46286
|
48073
|
48074
|
48075
|
48076
|
48077
|
48078
|
48079
|
48556
|
48557
|
48558
|
48559
|
50433
|
52607
|
52608
|
52614
|
52615
|
52616
|
52617
|
52618
|
52619
|
52620
|
53229
|
53688
|
53695
|
53705
|
53707
|
53708
|
53709
|
53710
|
53711
|
53712
|
53713
|
55946
|
56285
|
56286
|
58580
|
58591
|
58592
|
58593
|
63238
|
63239
|
65811
|
65812
|
69028
|
69029
|
69050
|
71955
|
71956
|
71957
|
71958
|
72632
|
72633
|
72634
|
72635
|
73987
|
73988
|
73989
|
73990
|
74123
|
74124
|
74125
|
74126
|
74818
|
75652
|
83757
|
83758
|
84017
|
84018
|
84019
|
84020
|
84021
|
84022
|
88358
|
88359
|
88360
|
88361
|
88362
|
88363
|
88394
|
88395
|
88396
|
88397
|
88398
|
88399
|
88400
|
93850
|
93851
|
93852
|
93853
|
93854
|
93855
|
93856
|
93900
|
93901
|
94456
|
94457
|
94458
|
94459
|
94460
|
94461
|
94463
|
94464
|
94465
|
94466
|
94467
|
94468
|
96432
|
100817
|
100843
|
112062
|
112063
|
112064
|
112557
|
112559
|
112560
|
118959
|
118960
|
118961
|
118962
|
118985
|
118986
|
118987
|
118988
|
120947
|
120948
|
120949
|
120950
|
122778