Attachment 108326 Details for Bug 19036 – Bug 19036: DBIC Schema Updates

[patch] Bug 19036: DBIC Schema Updates

Bug-19036-DBIC-Schema-Updates.patch (text/plain), 3.19 KB, created by Katrin Fischer on 2020-08-15 12:44:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2020-08-15 12:44:44 UTC

Size: 3.19 KB

patch

obsolete

>From 263abe41a3390024f550533fe702d4947806c6f6 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 25 Jun 2020 10:43:03 +0100
>Subject: [PATCH] Bug 19036: DBIC Schema Updates
>
>Dumped schema updates + manual addition of boolean flags
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> Koha/Schema/Result/AccountCreditType.pm | 18 +++++++++++++++---
> Koha/Schema/Result/Accountline.pm       | 14 ++++++++++++--
> 2 files changed, 27 insertions(+), 5 deletions(-)
>
>diff --git a/Koha/Schema/Result/AccountCreditType.pm b/Koha/Schema/Result/AccountCreditType.pm
>index 4ee8e86b3c..602b1fd7e9 100644
>--- a/Koha/Schema/Result/AccountCreditType.pm
>+++ b/Koha/Schema/Result/AccountCreditType.pm
>@@ -41,6 +41,14 @@ __PACKAGE__->table("account_credit_types");
>   default_value: 1
>   is_nullable: 0
> 
>+=head2 credit_number_enabled
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+Is autogeneration of credit number enabled for this credit type
>+
> =head2 is_system
> 
>   data_type: 'tinyint'
>@@ -62,6 +70,8 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 200 },
>   "can_be_added_manually",
>   { data_type => "tinyint", default_value => 1, is_nullable => 0 },
>+  "credit_number_enabled",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "is_system",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "archived",
>@@ -113,11 +123,13 @@ __PACKAGE__->has_many(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-20 14:48:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hdxcXxCqIDxwfSHjSr0VUg
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GESL9hjEPlrQBiuHO4haAw
> 
> __PACKAGE__->add_columns(
>-    '+is_system' => { is_boolean => 1 }
>+    '+is_system'             => { is_boolean => 1 },
>+    '+credit_number_enabled' => { is_boolean => 1 },
>+    '+archived'              => { is_boolean => 1 }
> );
> 
> sub koha_objects_class {
>diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm
>index 2b14943d34..3a5a48cb99 100644
>--- a/Koha/Schema/Result/Accountline.pm
>+++ b/Koha/Schema/Result/Accountline.pm
>@@ -77,6 +77,14 @@ __PACKAGE__->table("accountlines");
>   is_nullable: 1
>   size: 80
> 
>+=head2 credit_number
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 20
>+
>+autogenerated number for credits
>+
> =head2 status
> 
>   data_type: 'varchar'
>@@ -157,6 +165,8 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
>   "debit_type_code",
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 80 },
>+  "credit_number",
>+  { data_type => "varchar", is_nullable => 1, size => 20 },
>   "status",
>   { data_type => "varchar", is_nullable => 1, size => 16 },
>   "payment_type",
>@@ -367,8 +377,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-19 09:20:20
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BuE4CYsSH4BwXZoQKE2MWw
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I/S3NLbod+8BgBMcwYz+cA
> 
> =head2 library
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 19036: 99301 | 99302 | 99303 | 99676 | 101549 | 101550 | 101896 | 101897 | 106278 | 106279 | 106280 | 106281 | 106767 | 107872 | 107875 | 107877 | 108323 | 108324 | 108325 | 108326 | 108327 | 108328 | 108329 | 108525 | 108587 | 108733