Attachment 77039 Details for Bug 21066 – Bug 21066: DBIx changes for opac_news

[patch] Bug 21066: DBIx changes for opac_news

Bug-21066-DBIx-changes-for-opacnews.patch (text/plain), 2.48 KB, created by Marcel de Rooy on 2018-07-17 14:24:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2018-07-17 14:24:47 UTC

Size: 2.48 KB

patch

obsolete

>From 1c41a8c0924b547dbd3fa82eba4628559f4a8abc Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 17 Jul 2018 16:14:35 +0200
>Subject: [PATCH] Bug 21066: DBIx changes for opac_news
>Content-Type: text/plain; charset=utf-8
>
>---
> Koha/Schema/Result/OpacNews.pm | 40 ++++++++++++++++++++++++----------------
> 1 file changed, 24 insertions(+), 16 deletions(-)
>
>diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm
>index 2a4b80b..82a82e0 100644
>--- a/Koha/Schema/Result/OpacNews.pm
>+++ b/Koha/Schema/Result/OpacNews.pm
>@@ -57,13 +57,6 @@ __PACKAGE__->table("opac_news");
>   is_nullable: 0
>   size: 25
> 
>-=head2 timestamp
>-
>-  data_type: 'timestamp'
>-  datetime_undef_if_invalid: 1
>-  default_value: current_timestamp
>-  is_nullable: 0
>-
> =head2 expirationdate
> 
>   data_type: 'date'
>@@ -81,6 +74,19 @@ __PACKAGE__->table("opac_news");
>   is_foreign_key: 1
>   is_nullable: 1
> 
>+=head2 publisheddate
>+
>+  data_type: 'date'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 0
>+
>+=head2 updated_on
>+
>+  data_type: 'timestamp'
>+  datetime_undef_if_invalid: 1
>+  default_value: current_timestamp
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -99,19 +105,21 @@ __PACKAGE__->add_columns(
>   { accessor => undef, data_type => "text", is_nullable => 0 },
>   "lang",
>   { data_type => "varchar", default_value => "", is_nullable => 0, size => 25 },
>-  "timestamp",
>-  {
>-    data_type => "timestamp",
>-    datetime_undef_if_invalid => 1,
>-    default_value => \"current_timestamp",
>-    is_nullable => 0,
>-  },
>   "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 },
>+  "publisheddate",
>+  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
>+  "updated_on",
>+  {
>+    data_type => "timestamp",
>+    datetime_undef_if_invalid => 1,
>+    default_value => \"current_timestamp",
>+    is_nullable => 0,
>+  },
> );
> 
> =head1 PRIMARY KEY
>@@ -169,8 +177,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-21 19:50:05
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QivH1Daozdp0BttbPF6CkA
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-17 16:13:43
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Mq0JwpZ+lMxC++QToFKzZA
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>-- 
>2.1.4

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