From e9ba16d7b03db7ccc398782bac992f837ee9e21d Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 7 Apr 2023 12:52:47 +0000 Subject: [PATCH] Bug 23486: DO NOT PUSH - Schema updates Note that the fields must be manually updated after generation as generated syntax us invalid: default_value: 'current_timestamp()' First occurence: default_value: 'current_timestamp' Second occurence: default_value => \"current_timestamp", Signed-off-by: David Nind --- Koha/Schema/Result/Borrower.pm | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 5576e8fcd2..3e4e1365f9 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -595,7 +595,8 @@ time of last change could be useful for synchronization with external systems (a data_type: 'datetime' datetime_undef_if_invalid: 1 - is_nullable: 1 + default_value: current_timestamp + is_nullable: 0 last time a patron has been seen (connected at the OPAC or staff interface) @@ -831,7 +832,8 @@ __PACKAGE__->add_columns( { data_type => "datetime", datetime_undef_if_invalid => 1, - is_nullable => 1, + default_value => \"current_timestamp", + is_nullable => 0, }, "lang", { @@ -2103,8 +2105,8 @@ Composing rels: L -> permission __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-06 15:46:57 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f6omVb7EtiysdaWTX3IRzg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-07 12:49:45 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r9V6UASBq4kq4qm6FZmcEA __PACKAGE__->has_many( "restrictions", -- 2.30.2