From 68a516a6219970fa6ea055d3f413faae516786d8 Mon Sep 17 00:00:00 2001 From: Zeno Tajoli 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 + +=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