From 58e7d0b44a85712e530b270f737f4de5f2b17ff7 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Wed, 5 Aug 2020 12:00:37 +1200 Subject: [PATCH] Bug 20882: DBIC Signed-off-by: Aleisha Amohia --- Koha/Schema/Result/Deleteditem.pm | 18 +++++++----------- Koha/Schema/Result/Item.pm | 16 ++++++---------- 2 files changed, 13 insertions(+), 21 deletions(-) diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 1998da7f3b..b7152d052c 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -156,8 +156,8 @@ __PACKAGE__->table("deleteditems"); =head2 issues data_type: 'smallint' - is_nullable: 0 default_value: 0 + is_nullable: 1 =head2 renewals @@ -245,9 +245,8 @@ __PACKAGE__->table("deleteditems"); =head2 uri - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 itype @@ -343,10 +342,7 @@ __PACKAGE__->add_columns( "coded_location_qualifier", { data_type => "varchar", is_nullable => 1, size => 10 }, "issues", - { data_type => "smallint", - is_nullable => 0, - default_value => 0, - }, + { data_type => "smallint", default_value => 0, is_nullable => 1 }, "renewals", { data_type => "smallint", is_nullable => 1 }, "reserves", @@ -383,7 +379,7 @@ __PACKAGE__->add_columns( "materials", { data_type => "mediumtext", is_nullable => 1 }, "uri", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "itype", { data_type => "varchar", is_nullable => 1, size => 10 }, "more_subfields_xml", @@ -411,9 +407,9 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-26 16:15:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L7G0HG5gvgyhfpKb7LcUFw +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-05 11:37:21 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PZThCm4mUZu0so1HSxpxGw -# You can replace this text with custom content, and it will be preserved on regeneration +# You can replace this text with custom code or comments, and it will be preserved on regeneration 1; diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index bc68901a10..ab3a653656 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -159,8 +159,8 @@ __PACKAGE__->table("items"); =head2 issues data_type: 'smallint' - is_nullable: 0 default_value: 0 + is_nullable: 1 =head2 renewals @@ -249,9 +249,8 @@ __PACKAGE__->table("items"); =head2 uri - data_type: 'varchar' + data_type: 'mediumtext' is_nullable: 1 - size: 255 =head2 itype @@ -357,10 +356,7 @@ __PACKAGE__->add_columns( "coded_location_qualifier", { data_type => "varchar", is_nullable => 1, size => 10 }, "issues", - { data_type => "smallint", - is_nullable => 0, - default_value => 0, - }, + { data_type => "smallint", default_value => 0, is_nullable => 1 }, "renewals", { data_type => "smallint", is_nullable => 1 }, "reserves", @@ -397,7 +393,7 @@ __PACKAGE__->add_columns( "materials", { data_type => "mediumtext", is_nullable => 1 }, "uri", - { data_type => "varchar", is_nullable => 1, size => 255 }, + { data_type => "mediumtext", is_nullable => 1 }, "itype", { data_type => "varchar", is_nullable => 1, size => 10 }, "more_subfields_xml", @@ -751,8 +747,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-10 14:31:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dqUjo9pJysKKBhF8PM5KnA +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-08-05 11:43:59 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HK4vgo7aA1pOjsp6avZrkA __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); -- 2.39.5