Attachment 44083 Details for Bug 7736 – 0005-EdifactEan_DBIx-update

[patch] 0005-EdifactEan_DBIx-update

0005-BUG-7736-Follow-up-modification-of-table-EdifactEan-.patch (text/plain), 2.32 KB, created by Zeno Tajoli on 2015-10-27 15:16:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Zeno Tajoli

Created: 2015-10-27 15:16:20 UTC

Size: 2.32 KB

patch

obsolete

>From 68a516a6219970fa6ea055d3f413faae516786d8 Mon Sep 17 00:00:00 2001
>From: Zeno Tajoli <z.tajoli@cineca.it>
>Date: Tue, 27 Oct 2015 15:36:21 +0100
>Subject: [PATCH 5/6] [BUG 7736] Follow-up: modification of table EdifactEan
> in DBIx files
>
>---
> Koha/Schema/Result/EdifactEan.pm |   41 +++++++++++++++++++++++++++++++++-----
> 1 file changed, 36 insertions(+), 5 deletions(-)
>
>diff --git a/Koha/Schema/Result/EdifactEan.pm b/Koha/Schema/Result/EdifactEan.pm
>index cdcc637..4fbeca4 100644
>--- a/Koha/Schema/Result/EdifactEan.pm
>+++ b/Koha/Schema/Result/EdifactEan.pm
>@@ -23,11 +23,18 @@ __PACKAGE__->table("edifact_ean");
> 
> =head1 ACCESSORS
> 
>+=head2 ee_id
>+
>+  data_type: 'integer'
>+  extra: {unsigned => 1}
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
> =head2 branchcode
> 
>   data_type: 'varchar'
>   is_foreign_key: 1
>-  is_nullable: 0
>+  is_nullable: 1
>   size: 10
> 
> =head2 ean
>@@ -46,14 +53,33 @@ __PACKAGE__->table("edifact_ean");
> =cut
> 
> __PACKAGE__->add_columns(
>+  "ee_id",
>+  {
>+    data_type => "integer",
>+    extra => { unsigned => 1 },
>+    is_auto_increment => 1,
>+    is_nullable => 0,
>+  },
>   "branchcode",
>-  { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
>+  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>   "ean",
>   { data_type => "varchar", is_nullable => 0, size => 15 },
>   "id_code_qualifier",
>   { data_type => "varchar", default_value => 14, is_nullable => 0, size => 3 },
> );
> 
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</ee_id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("ee_id");
>+
> =head1 RELATIONS
> 
> =head2 branchcode
>@@ -68,12 +94,17 @@ __PACKAGE__->belongs_to(
>   "branchcode",
>   "Koha::Schema::Result::Branch",
>   { branchcode => "branchcode" },
>-  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
>+  {
>+    is_deferrable => 1,
>+    join_type     => "LEFT",
>+    on_delete     => "RESTRICT",
>+    on_update     => "RESTRICT",
>+  },
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-23 15:58:26
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LrJt6g6ji7tXaCiX4thIxA
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-27 15:17:58
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nwcRXCDS8yWpKZtKHqK1Ig
> 
> 
> # You can replace this text with custom code or comments, and it will be preserved on regeneration
>-- 
>1.7.10.4
>

Actions: View | Diff | Splinter Review

Attachments on bug 7736: 8275 | 8276 | 8446 | 8635 | 10226 | 12398 | 12438 | 12467 | 13071 | 15304 | 15729 | 16538 | 16629 | 16649 | 16652 | 16667 | 16732 | 16761 | 16779 | 16792 | 16864 | 16865 | 16866 | 16867 | 16868 | 16869 | 16870 | 16871 | 16872 | 16873 | 16874 | 16882 | 16883 | 16884 | 16885 | 16886 | 17120 | 17121 | 20983 | 20984 | 21475 | 33953 | 33957 | 34332 | 34833 | 35030 | 35106 | 35716 | 35717 | 35718 | 36738 | 44079 | 44080 | 44081 | 44082 | 44083 | 44084 | 46996 | 47004 | 48623 | 48624 | 48625 | 48626 | 48971 | 48972 | 48973 | 48974 | 48975 | 48976 | 49037 | 49038 | 49039 | 49040 | 49041 | 49042 | 49307 | 49850 | 50002 | 50008