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