From 69c7e03f7377925fed79706be929596f0830099e Mon Sep 17 00:00:00 2001
From: Mark Tompsett <mtompset@hotmail.com>
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.
---
 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<Koha::Schema::Result::Branch>
+
+=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.10.4