From 9933cc7b592e7a733c8eca9dddd45e850616b9fd Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 23 Mar 2020 11:48:47 +0000 Subject: [PATCH] Bug 24476: Schema changes Signed-off-by: Katrin Fischer Signed-off-by: Martin Renvoize --- Koha/Schema/Result/Borrower.pm | 16 ++++++++++++---- Koha/Schema/Result/Deletedborrower.pm | 16 ++++++++++++---- 2 files changed, 24 insertions(+), 8 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index dd305eca39..04ad9e17d4 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 autorenew_checkouts + + 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 }, + "autorenew_checkouts", + { data_type => "tinyint", default_value => 1, is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -1650,8 +1658,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-03 16:19:12 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+f1QrESEOMGM1coANPgWtQ +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-23 11:45:25 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SkCqcE0Wpja6r/hZ0yZLNA __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index 1ba0873e2f..7c076cf4a6 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 autorenew_checkouts + + 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 }, + "autorenew_checkouts", + { 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-03-23 11:45:25 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fVl4c/8pymGaZBDR3EOrNg sub koha_objects_class { 'Koha::Old::Patrons'; -- 2.39.5