Attachment 102664 Details for Bug 25037 – Bug 25037: Schema changes

[patch] Bug 25037: Schema changes

Bug-25037-Schema-changes.patch (text/plain), 3.34 KB, created by Lari Taskula on 2020-04-09 20:09:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

Created: 2020-04-09 20:09:03 UTC

Size: 3.34 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 25037: 102259 | 102260 | 102261 | 102262 | 102263 | 102264 | 102265 | 102266 | 102267 | 102268 | 102269 | 102272 | 102413 | 102414 | 102415 | 102416 | 102417 | 102418 | 102419 | 102420 | 102421 | 102422 | 102423 | 102424 | 102586 | 102587 | 102588 | 102589 | 102590 | 102591 | 102592 | 102593 | 102594 | 102595 | 102596 | 102597 | 102598 | 102599 | 102655 | 102656 | 102657 | 102658 | 102659 | 102660 | 102661 | 102662 | 102663 | 102664 | 102665 | 102666 | 102675 | 102676 | 104267 | 104268 | 105638 | 105780 | 105781 | 105782 | 105783 | 105784