Bug 22782: DBIC update for SocialData

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 5ecbe281aff13e53d4fbc5064714de9209410358)
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

diff --git a/Koha/Schema/Result/SocialData.pm b/Koha/Schema/Result/SocialData.pm
index b2d835b..36cbfbb 100644 (file)
--- 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 8af494d..68bf6af 100644 (file)
--- 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,