Attachment 149274 Details for Bug 23486 – Bug 23486: DO NOT PUSH - Schema updates

[patch] Bug 23486: DO NOT PUSH - Schema updates

Bug-23486-DO-NOT-PUSH---Schema-updates.patch (text/plain), 1.74 KB, created by Nick Clemens (kidclamp) on 2023-04-07 13:09:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2023-04-07 13:09:19 UTC

Size: 1.74 KB

patch

obsolete

>From 046cc5f650ccd175dd8f28b8f55dfc75f82203de Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>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",
>---
> 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</user_permissions> -> 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

Actions: View | Diff | Splinter Review

Attachments on bug 23486: 131657 | 131658 | 132222 | 134540 | 134547 | 134549 | 134550 | 134551 | 134963 | 134964 | 148780 | 148781 | 149273 | 149274 | 150119 | 150120 | 171829 | 172820 | 172927 | 172928 | 174080 | 174081