From d135dccba8dc911b0a3b48694e05aed14dc94952 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Sun, 16 Feb 2014 22:40:28 -0500 Subject: [PATCH] Bug 7567 - Schema update for opac_news This was generated by: Reset hard to master. Restore old DB Apply the patches for 7567 ./installer/data/mysql/updatedatabase.pl ./misc/devel/update_dbix_class_files.pl -db_name=... -db_user=... -db_passwd=... git add Koha/Schema/Results/OpacNews.pm This should provide the necessary changes to the schema files for Koha 3.16 and forward. --- Koha/Schema/Result/OpacNews.pm | 46 +++++++++++++++++++++++++++------------- 1 file changed, 31 insertions(+), 15 deletions(-) diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm index a3be8e8..a59792f 100644 --- a/Koha/Schema/Result/OpacNews.pm +++ b/Koha/Schema/Result/OpacNews.pm @@ -1,21 +1,17 @@ -use utf8; package Koha::Schema::Result::OpacNews; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE -=head1 NAME - -Koha::Schema::Result::OpacNews - -=cut - use strict; use warnings; use base 'DBIx::Class::Core'; -=head1 TABLE: C + +=head1 NAME + +Koha::Schema::Result::OpacNews =cut @@ -30,6 +26,13 @@ __PACKAGE__->table("opac_news"); is_auto_increment: 1 is_nullable: 0 +=head2 branchcode + + data_type: 'varchar' + is_foreign_key: 1 + is_nullable: 1 + size: 10 + =head2 title data_type: 'varchar' @@ -78,6 +81,8 @@ __PACKAGE__->add_columns( is_auto_increment => 1, is_nullable => 0, }, + "branchcode", + { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "title", { data_type => "varchar", default_value => "", is_nullable => 0, size => 250 }, "new", @@ -96,22 +101,33 @@ __PACKAGE__->add_columns( "number", { data_type => "integer", is_nullable => 1 }, ); +__PACKAGE__->set_primary_key("idnew"); -=head1 PRIMARY KEY +=head1 RELATIONS -=over 4 +=head2 branchcode -=item * L +Type: belongs_to -=back +Related object: L =cut -__PACKAGE__->set_primary_key("idnew"); +__PACKAGE__->belongs_to( + "branchcode", + "Koha::Schema::Result::Branch", + { branchcode => "branchcode" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "CASCADE", + on_update => "CASCADE", + }, +); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0tkil0XyRwcT+abM2XoADw +# Created by DBIx::Class::Schema::Loader v0.07010 @ 2014-02-16 22:39:45 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fY5jhUWaod31rJ9mx4xYyw # You can replace this text with custom content, and it will be preserved on regeneration -- 1.7.9.5