From 1c41a8c0924b547dbd3fa82eba4628559f4a8abc Mon Sep 17 00:00:00 2001 From: Marcel de Rooy 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