Attachment 26600 Details for Bug 7567 – Bug 7567 - Schema update for opac_news

[patch] Bug 7567 - Schema update for opac_news

Bug-7567---Schema-update-for-opacnews.patch (text/plain), 2.33 KB, created by Mark Tompsett on 2014-03-26 15:58:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2014-03-26 15:58:27 UTC

Size: 2.33 KB

patch

obsolete

>From b6ba79d3eabdb6c6b739433405f8873c8b0d7fba 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.
>
>Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
>---
> 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.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 7567: 22863 | 22917 | 22920 | 23350 | 23351 | 23352 | 23362 | 23368 | 23378 | 23383 | 23386 | 23474 | 23475 | 23501 | 23544 | 23547 | 23552 | 23553 | 23554 | 23559 | 23664 | 23703 | 23704 | 23705 | 25316 | 25317 | 25318 | 25319 | 25320 | 25321 | 25322 | 25323 | 25324 | 25325 | 25331 | 25332 | 25333 | 26510 | 26511 | 26590 | 26591 | 26592 | 26593 | 26594 | 26595 | 26596 | 26597 | 26598 | 26599 | 26600 | 26601 | 26602 | 26603 | 26604 | 26605 | 26606 | 26607 | 26608 | 26609 | 26610 | 26611 | 26612 | 26631 | 26632 | 26633 | 26634 | 26635 | 26636 | 26637 | 26638 | 26639 | 26640 | 26641 | 26642 | 26643 | 26644 | 26647