From 3f72fa15f23fb94eadbd5d3c450b9cc7851df6e5 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 30 Aug 2016 12:02:15 +0100 Subject: [PATCH] Bug 17216: Update DBIC schema for MSS Signed-off-by: Owen Leonard Signed-off-by: Katrin Fischer Signed-off-by: Brendan Gallagher --- Koha/Schema/Result/AuthorisedValueCategory.pm | 19 ++++++++++-- Koha/Schema/Result/MarcSubfieldStructure.pm | 31 ++++++++++++++++--- 2 files changed, 44 insertions(+), 6 deletions(-) diff --git a/Koha/Schema/Result/AuthorisedValueCategory.pm b/Koha/Schema/Result/AuthorisedValueCategory.pm index 596db1471d..7778ec25dc 100644 --- a/Koha/Schema/Result/AuthorisedValueCategory.pm +++ b/Koha/Schema/Result/AuthorisedValueCategory.pm @@ -81,9 +81,24 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 marc_subfield_structures -# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:54:19 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T8LzWM/O8zSGpRhTZbzvJA +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "marc_subfield_structures", + "Koha::Schema::Result::MarcSubfieldStructure", + { "foreign.authorised_value" => "self.category_name" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:31 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6vToj9pUcIv8Jio38rNE4g # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/MarcSubfieldStructure.pm b/Koha/Schema/Result/MarcSubfieldStructure.pm index 3054d8d00d..b7ebf1bc43 100644 --- a/Koha/Schema/Result/MarcSubfieldStructure.pm +++ b/Koha/Schema/Result/MarcSubfieldStructure.pm @@ -77,8 +77,9 @@ __PACKAGE__->table("marc_subfield_structure"); =head2 authorised_value data_type: 'varchar' + is_foreign_key: 1 is_nullable: 1 - size: 20 + size: 32 =head2 authtypecode @@ -152,7 +153,7 @@ __PACKAGE__->add_columns( "tab", { data_type => "tinyint", is_nullable => 1 }, "authorised_value", - { data_type => "varchar", is_nullable => 1, size => 20 }, + { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 32 }, "authtypecode", { data_type => "varchar", is_nullable => 1, size => 20 }, "value_builder", @@ -189,9 +190,31 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("frameworkcode", "tagfield", "tagsubfield"); +=head1 RELATIONS + +=head2 authorised_value + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "authorised_value", + "Koha::Schema::Result::AuthorisedValueCategory", + { category_name => "authorised_value" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "SET NULL", + 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:4JgqkPKFNSQ90hTeeb30ow +# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:32 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/gnyZuGje+sg82HfxMLI0g # You can replace this text with custom content, and it will be preserved on regeneration -- 2.39.5