From b6ba79d3eabdb6c6b739433405f8873c8b0d7fba 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. Had to generate under Debian, because Ubuntu's was broken by comparison. Signed-off-by: Chris Cormack --- Koha/Schema/Result/OpacNews.pm | 35 +++++++++++++++++++++++++++++++++-- 1 file changed, 33 insertions(+), 2 deletions(-) diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm index a3be8e8..8a42467 100644 --- a/Koha/Schema/Result/OpacNews.pm +++ b/Koha/Schema/Result/OpacNews.pm @@ -30,6 +30,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 +85,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", @@ -109,9 +118,31 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("idnew"); +=head1 RELATIONS + +=head2 branchcode + +Type: belongs_to + +Related object: L + +=cut + +__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.07025 @ 2014-02-16 23:15:22 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/q+riAqsYmCQkUCUL9MU7g # You can replace this text with custom content, and it will be preserved on regeneration -- 1.7.9.5