From cd147f78d7e5ce8b48afa021ffc4f2ede3ebb38f Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 10 May 2019 12:10:42 +0000 Subject: [PATCH] Bug 22782: DBIC update for SocialData Signed-off-by: Nick Clemens (cherry picked from commit 5ecbe281aff13e53d4fbc5064714de9209410358) Signed-off-by: Martin Renvoize --- Koha/Schema/Result/SocialData.pm | 7 ++++--- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 5 insertions(+), 4 deletions(-) diff --git a/Koha/Schema/Result/SocialData.pm b/Koha/Schema/Result/SocialData.pm index b2d835b0b0..36cbfbbe17 100644 --- a/Koha/Schema/Result/SocialData.pm +++ b/Koha/Schema/Result/SocialData.pm @@ -26,6 +26,7 @@ __PACKAGE__->table("social_data"); =head2 isbn data_type: 'varchar' + default_value: (empty string) is_nullable: 0 size: 30 @@ -64,7 +65,7 @@ __PACKAGE__->table("social_data"); __PACKAGE__->add_columns( "isbn", - { data_type => "varchar", is_nullable => 0, size => 30 }, + { data_type => "varchar", default_value => "", is_nullable => 0, size => 30 }, "num_critics", { data_type => "integer", is_nullable => 1 }, "num_critics_pro", @@ -92,8 +93,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("isbn"); -# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-13 15:24:28 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l44tYFEfIKX0xXzj6AHInQ +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-10 12:02:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zu/RochQZmZJZHQJnkLQvg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 8af494df13..68bf6af4b5 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3333,7 +3333,7 @@ CREATE TABLE `biblioimages` ( -- local cover images DROP TABLE IF EXISTS `social_data`; CREATE TABLE IF NOT EXISTS `social_data` ( - `isbn` VARCHAR(30), + `isbn` VARCHAR(30) NOT NULL DEFAULT '', `num_critics` INT, `num_critics_pro` INT, `num_quotations` INT, -- 2.39.5