Attachment 109149 Details for Bug 21066 – DO_NOT_PUSH: DBIx schema changes

[patch] DO_NOT_PUSH: DBIx schema changes

DONOTPUSH-DBIx-schema-changes.patch (text/plain), 2.43 KB, created by Owen Leonard on 2020-08-26 12:08:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Owen Leonard

Created: 2020-08-26 12:08:25 UTC

Size: 2.43 KB

patch

obsolete

>From a1b49b42733e077fbe0a14d018c5cf0b95658250 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 4 Aug 2020 11:44:36 +0000
>Subject: [PATCH] DO_NOT_PUSH: DBIx schema changes
>
>https://bugs.koha-community.org/show_bug.cgi?id=21066
>
>Signed-off-by: Owen Leonard <oleonard@myacpl.org>
>---
> Koha/Schema/Result/OpacNews.pm | 34 +++++++++++++++++++++-------------
> 1 file changed, 21 insertions(+), 13 deletions(-)
>
>diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm
>index ee4bc3b4a6..af61a88901 100644
>--- a/Koha/Schema/Result/OpacNews.pm
>+++ b/Koha/Schema/Result/OpacNews.pm
>@@ -56,12 +56,11 @@ __PACKAGE__->table("opac_news");
>   is_nullable: 0
>   size: 50
> 
>-=head2 timestamp
>+=head2 publicationdate
> 
>-  data_type: 'timestamp'
>+  data_type: 'date'
>   datetime_undef_if_invalid: 1
>-  default_value: current_timestamp
>-  is_nullable: 0
>+  is_nullable: 1
> 
> =head2 expirationdate
> 
>@@ -80,6 +79,13 @@ __PACKAGE__->table("opac_news");
>   is_foreign_key: 1
>   is_nullable: 1
> 
>+=head2 updated_on
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  default_value: current_timestamp
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -98,19 +104,21 @@ __PACKAGE__->add_columns(
>   { data_type => "mediumtext", is_nullable => 0 },
>   "lang",
>   { data_type => "varchar", default_value => "", is_nullable => 0, size => 50 },
>-  "timestamp",
>-  {
>-    data_type => "timestamp",
>-    datetime_undef_if_invalid => 1,
>-    default_value => \"current_timestamp",
>-    is_nullable => 0,
>-  },
>+  "publicationdate",
>+  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "expirationdate",
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "number",
>   { data_type => "integer", is_nullable => 1 },
>   "borrowernumber",
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>+  "updated_on",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    default_value => \"current_timestamp",
>+    is_nullable => 0,
>+  },
> );
> 
> =head1 PRIMARY KEY
>@@ -168,8 +176,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-23 08:50:46
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Db/JtTOlAdb+83PKZhbFCQ
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-04 13:24:59
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HWEqEtcR/35q+tPIvTENIw
> 
> sub koha_object_class {
>     'Koha::NewsItem';
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 21066: 77037 | 77038 | 77039 | 107769 | 107770 | 107771 | 107772 | 107773 | 107774 | 107775 | 107776 | 109148 | 109149 | 109150 | 109151 | 109152 | 109153 | 109154 | 109192 | 109193 | 109194 | 109195 | 109196 | 109197 | 109198 | 109199 | 109354 | 109514 | 109515