@@ -, +, @@ --- Koha/Schema/Result/SocialData.pm | 7 ++++--- installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 5 insertions(+), 4 deletions(-) --- a/Koha/Schema/Result/SocialData.pm +++ a/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 --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -3311,7 +3311,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, --