From 4337d6a964d13733b78e1381405b02e5af9f1619 Mon Sep 17 00:00:00 2001
From: Lari Taskula <lari.taskula@hypernova.fi>
Date: Thu, 9 Apr 2020 19:47:13 +0000
Subject: [PATCH] Bug 25037: Schema changes

Sponsored-by: The National Library of Finland
---
 Koha/Schema/Result/Issue.pm    | 23 ++++++++++++++---------
 Koha/Schema/Result/OldIssue.pm | 23 ++++++++++++++---------
 2 files changed, 28 insertions(+), 18 deletions(-)

diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm
index 8bb16b6b92..fed067f64f 100644
--- a/Koha/Schema/Result/Issue.pm
+++ b/Koha/Schema/Result/Issue.pm
@@ -96,10 +96,11 @@ __PACKAGE__->table("issues");
   datetime_undef_if_invalid: 1
   is_nullable: 1
 
-=head2 onsite_checkout
+=head2 checkout_type
 
-  data_type: 'integer'
-  default_value: 0
+  data_type: 'enum'
+  default_value: 'CHECKOUT'
+  extra: {list => ["CHECKOUT","ONSITE"]}
   is_nullable: 0
 
 =head2 note
@@ -166,8 +167,13 @@ __PACKAGE__->add_columns(
     datetime_undef_if_invalid => 1,
     is_nullable => 1,
   },
-  "onsite_checkout",
-  { data_type => "integer", default_value => 0, is_nullable => 0 },
+  "checkout_type",
+  {
+    data_type => "enum",
+    default_value => "CHECKOUT",
+    extra => { list => ["CHECKOUT", "ONSITE"] },
+    is_nullable => 0,
+  },
   "note",
   { data_type => "longtext", is_nullable => 1 },
   "notedate",
@@ -264,12 +270,11 @@ __PACKAGE__->might_have(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-31 12:18:38
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QVmFa5b0Pe5OhUI92n9kzQ
+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-09 19:47:02
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GIV9oEe2GeiJ/zIg2kZlwA
 
 __PACKAGE__->add_columns(
-    '+auto_renew'      => { is_boolean => 1 },
-    '+onsite_checkout' => { is_boolean => 1 }
+    '+auto_renew'      => { is_boolean => 1 }
 );
 
 __PACKAGE__->belongs_to(
diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm
index f1ff5c2fa6..acf56ee4ae 100644
--- a/Koha/Schema/Result/OldIssue.pm
+++ b/Koha/Schema/Result/OldIssue.pm
@@ -95,10 +95,11 @@ __PACKAGE__->table("old_issues");
   datetime_undef_if_invalid: 1
   is_nullable: 1
 
-=head2 onsite_checkout
+=head2 checkout_type
 
-  data_type: 'integer'
-  default_value: 0
+  data_type: 'enum'
+  default_value: 'CHECKOUT'
+  extra: {list => ["CHECKOUT","ONSITE"]}
   is_nullable: 0
 
 =head2 note
@@ -165,8 +166,13 @@ __PACKAGE__->add_columns(
     datetime_undef_if_invalid => 1,
     is_nullable => 1,
   },
-  "onsite_checkout",
-  { data_type => "integer", default_value => 0, is_nullable => 0 },
+  "checkout_type",
+  {
+    data_type => "enum",
+    default_value => "CHECKOUT",
+    extra => { list => ["CHECKOUT", "ONSITE"] },
+    is_nullable => 0,
+  },
   "note",
   { data_type => "longtext", is_nullable => 1 },
   "notedate",
@@ -234,12 +240,11 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E2N2paWcCHg916100ry+2A
+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-09 19:47:02
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:J7jzh/kOsynQr52uSGxQ/A
 
 __PACKAGE__->add_columns(
-    '+auto_renew'      => { is_boolean => 1 },
-    '+onsite_checkout' => { is_boolean => 1 }
+    '+auto_renew'      => { is_boolean => 1 }
 );
 
 __PACKAGE__->belongs_to(
-- 
2.17.1