Bugzilla – Attachment 98001 Details for
Bug 24476
Allow patrons to opt-out of auto-renewal
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24476: DO NOT PUSH - Schema updates
Bug-24476-DO-NOT-PUSH---Schema-updates.patch (text/plain), 5.60 KB, created by
ByWater Sandboxes
on 2020-01-27 20:27:51 UTC
(
hide
)
Description:
Bug 24476: DO NOT PUSH - Schema updates
Filename:
MIME Type:
Creator:
ByWater Sandboxes
Created:
2020-01-27 20:27:51 UTC
Size:
5.60 KB
patch
obsolete
>From f7694f171552cbf6c7183d1b84d692ad32ab9dff Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Thu, 23 Jan 2020 17:38:28 +0000 >Subject: [PATCH] Bug 24476: DO NOT PUSH - Schema updates > >Signed-off-by: Andrew <andrew@bywatersolutions.com> >--- > Koha/Schema/Result/Borrower.pm | 19 ++++++++++++++----- > Koha/Schema/Result/BorrowerModification.pm | 16 ++++++++++++---- > Koha/Schema/Result/Deletedborrower.pm | 16 ++++++++++++---- > 3 files changed, 38 insertions(+), 13 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index f7224cc299..cdb2462de7 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -425,7 +425,7 @@ __PACKAGE__->table("borrowers"); > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 >- default_value: current_timestamp >+ default_value: 'current_timestamp()' > is_nullable: 0 > > =head2 lastseen >@@ -458,6 +458,12 @@ __PACKAGE__->table("borrowers"); > default_value: 0 > is_nullable: 0 > >+=head2 autorenewal >+ >+ data_type: 'tinyint' >+ default_value: 1 >+ is_nullable: 0 >+ > =cut > > __PACKAGE__->add_columns( >@@ -640,7 +646,7 @@ __PACKAGE__->add_columns( > { > data_type => "timestamp", > datetime_undef_if_invalid => 1, >- default_value => \"current_timestamp", >+ default_value => "current_timestamp()", > is_nullable => 0, > }, > "lastseen", >@@ -662,6 +668,8 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "anonymized", > { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "autorenewal", >+ { data_type => "tinyint", default_value => 1, is_nullable => 0 }, > ); > > =head1 PRIMARY KEY >@@ -1635,14 +1643,15 @@ Composing rels: L</aqorder_users> -> ordernumber > __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-10 14:31:00 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GjJLIOViIFRm185Yjl9vYA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-23 17:37:01 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+/fMiLexYzotvw+6ZDGKgw > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, > '+lost' => { is_boolean => 1 }, > '+gonenoaddress' => { is_boolean => 1 }, >- '+privacy_guarantor_fines' => { is_boolean => 1 } >+ '+privacy_guarantor_fines' => { is_boolean => 1 }, >+ '+autorenewal' => { is_boolean => 1 } > ); > > sub koha_objects_class { >diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm >index 3db708d3fc..ebbc5aa1a4 100644 >--- a/Koha/Schema/Result/BorrowerModification.pm >+++ b/Koha/Schema/Result/BorrowerModification.pm >@@ -27,7 +27,7 @@ __PACKAGE__->table("borrower_modifications"); > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 >- default_value: current_timestamp >+ default_value: 'current_timestamp()' > is_nullable: 0 > > =head2 verification_token >@@ -421,6 +421,12 @@ __PACKAGE__->table("borrower_modifications"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+=head2 autorenewal >+ >+ data_type: 'tinyint' >+ default_value: 1 >+ is_nullable: 0 >+ > =cut > > __PACKAGE__->add_columns( >@@ -428,7 +434,7 @@ __PACKAGE__->add_columns( > { > data_type => "timestamp", > datetime_undef_if_invalid => 1, >- default_value => \"current_timestamp", >+ default_value => "current_timestamp()", > is_nullable => 0, > }, > "verification_token", >@@ -593,6 +599,8 @@ __PACKAGE__->add_columns( > datetime_undef_if_invalid => 1, > is_nullable => 1, > }, >+ "autorenewal", >+ { data_type => "tinyint", default_value => 1, is_nullable => 0 }, > ); > > =head1 PRIMARY KEY >@@ -610,8 +618,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-22 16:54:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jkZUTN+mGIdp8ySV0BYNTw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-24 20:50:45 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7WfMeXobnCTp98TlYjtWLg > > sub koha_object_class { > 'Koha::Patron::Modification'; >diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm >index 1ba0873e2f..200c7e3b23 100644 >--- a/Koha/Schema/Result/Deletedborrower.pm >+++ b/Koha/Schema/Result/Deletedborrower.pm >@@ -422,7 +422,7 @@ __PACKAGE__->table("deletedborrowers"); > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 >- default_value: current_timestamp >+ default_value: 'current_timestamp()' > is_nullable: 0 > > =head2 lastseen >@@ -455,6 +455,12 @@ __PACKAGE__->table("deletedborrowers"); > default_value: 0 > is_nullable: 0 > >+=head2 autorenewal >+ >+ data_type: 'tinyint' >+ default_value: 1 >+ is_nullable: 0 >+ > =cut > > __PACKAGE__->add_columns( >@@ -625,7 +631,7 @@ __PACKAGE__->add_columns( > { > data_type => "timestamp", > datetime_undef_if_invalid => 1, >- default_value => \"current_timestamp", >+ default_value => "current_timestamp()", > is_nullable => 0, > }, > "lastseen", >@@ -647,11 +653,13 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "anonymized", > { data_type => "tinyint", default_value => 0, is_nullable => 0 }, >+ "autorenewal", >+ { data_type => "tinyint", default_value => 1, is_nullable => 0 }, > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK1jC6Wawwj8B2ch9KFByw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-23 17:37:01 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7DGOgltcqZKLv6u1BOnouw > > sub koha_objects_class { > 'Koha::Old::Patrons'; >-- >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 24476
:
97766
|
97767
|
97768
|
97769
|
97770
|
97831
|
97832
|
97833
|
97834
|
97835
|
97836
|
97923
|
97924
|
97925
|
97926
|
97927
|
97928
|
97997
|
97998
|
97999
|
98000
|
98001
|
98002
|
99793
|
99794
|
99795
|
99796
|
99797
|
99798
|
99799
|
99800
|
100022
|
100023
|
100024
|
100025
|
100026
|
100027
|
100028
|
100029
|
101385
|
101419
|
101420
|
101421
|
101422
|
101423
|
101424
|
101425
|
101426
|
101427
|
101511
|
101512
|
101513
|
101514
|
101515
|
101516
|
101517
|
101518
|
101519
|
101520
|
101521
|
101542