From bdb157645538667cd23f8563ee6700e697a4adc8 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Wed, 10 Apr 2019 19:57:10 +0000
Subject: [PATCH] Bug 22600: Schema updates

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---
 Koha/Schema/Result/Accountline.pm | 20 ++++++++++++++++++--
 Koha/Schema/Result/Issue.pm       |  9 +++++----
 Koha/Schema/Result/OldIssue.pm    |  9 +++++----
 3 files changed, 28 insertions(+), 10 deletions(-)

diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm
index aa204d4fa1..3775f70b8b 100644
--- a/Koha/Schema/Result/Accountline.pm
+++ b/Koha/Schema/Result/Accountline.pm
@@ -69,6 +69,12 @@ __PACKAGE__->table("accountlines");
   is_nullable: 1
   size: 5
 
+=head2 status
+
+  data_type: 'varchar'
+  is_nullable: 1
+  size: 16
+
 =head2 payment_type
 
   data_type: 'varchar'
@@ -99,6 +105,12 @@ __PACKAGE__->table("accountlines");
   is_foreign_key: 1
   is_nullable: 1
 
+=head2 interface
+
+  data_type: 'varchar'
+  is_nullable: 0
+  size: 16
+
 =head2 branchcode
 
   data_type: 'varchar'
@@ -125,6 +137,8 @@ __PACKAGE__->add_columns(
   { data_type => "longtext", is_nullable => 1 },
   "accounttype",
   { data_type => "varchar", is_nullable => 1, size => 5 },
+  "status",
+  { data_type => "varchar", is_nullable => 1, size => 16 },
   "payment_type",
   { data_type => "varchar", is_nullable => 1, size => 80 },
   "amountoutstanding",
@@ -140,6 +154,8 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "manager_id",
   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
+  "interface",
+  { data_type => "varchar", is_nullable => 0, size => 16 },
   "branchcode",
   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
 );
@@ -269,8 +285,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-28 18:01:31
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6TVweDBJR9SEra68zHn8fQ
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OaHSR4SeurCr7h6nizbtBg
 
 sub koha_objects_class {
     'Koha::Account::Lines';
diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm
index a7277446c3..d464fbfcf3 100644
--- a/Koha/Schema/Result/Issue.pm
+++ b/Koha/Schema/Result/Issue.pm
@@ -68,7 +68,8 @@ __PACKAGE__->table("issues");
 =head2 renewals
 
   data_type: 'tinyint'
-  is_nullable: 1
+  default_value: 0
+  is_nullable: 0
 
 =head2 auto_renew
 
@@ -147,7 +148,7 @@ __PACKAGE__->add_columns(
     is_nullable => 1,
   },
   "renewals",
-  { data_type => "tinyint", is_nullable => 1 },
+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
   "auto_renew",
   { data_type => "tinyint", default_value => 0, is_nullable => 1 },
   "auto_renew_error",
@@ -248,8 +249,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mlcId4odhAFp3HHgV/+tg
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PUF5X7X9K44BC0d43Rat7w
 
 __PACKAGE__->add_columns(
     '+auto_renew'      => { is_boolean => 1 },
diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm
index df84a07e32..2d560896fe 100644
--- a/Koha/Schema/Result/OldIssue.pm
+++ b/Koha/Schema/Result/OldIssue.pm
@@ -67,7 +67,8 @@ __PACKAGE__->table("old_issues");
 =head2 renewals
 
   data_type: 'tinyint'
-  is_nullable: 1
+  default_value: 0
+  is_nullable: 0
 
 =head2 auto_renew
 
@@ -146,7 +147,7 @@ __PACKAGE__->add_columns(
     is_nullable => 1,
   },
   "renewals",
-  { data_type => "tinyint", is_nullable => 1 },
+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
   "auto_renew",
   { data_type => "tinyint", default_value => 0, is_nullable => 1 },
   "auto_renew_error",
@@ -233,8 +234,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1f688Osvh/sxg2P/qffZ2g
+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E2N2paWcCHg916100ry+2A
 
 __PACKAGE__->belongs_to(
     "borrower",
-- 
2.39.5