Attachment 104783 Details for Bug 23727 – [19.11.x] Bug 23727: Update Schema

[patch] [19.11.x] Bug 23727: Update Schema

1911x-Bug-23727-Update-Schema.patch (text/plain), 3.26 KB, created by Kyle M Hall (khall) on 2020-05-12 13:52:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-05-12 13:52:50 UTC

Size: 3.26 KB

patch

obsolete

>From 8951e7e8324040b8e9a8b18d4673d0390b59c9bf Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Fri, 14 Feb 2020 08:45:11 -0500
>Subject: [PATCH] [19.11.x] Bug 23727: Update Schema
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> Koha/Schema/Result/CourseItem.pm | 68 +++++++++++++++++++++++++++++++-
> 1 file changed, 66 insertions(+), 2 deletions(-)
>
>diff --git a/Koha/Schema/Result/CourseItem.pm b/Koha/Schema/Result/CourseItem.pm
>index 9e1e5ef826..11acc20deb 100644
>--- a/Koha/Schema/Result/CourseItem.pm
>+++ b/Koha/Schema/Result/CourseItem.pm
>@@ -41,12 +41,36 @@ __PACKAGE__->table("course_items");
>   is_nullable: 1
>   size: 10
> 
>+=head2 itype_enabled
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+=head2 itype_storage
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 10
>+
> =head2 ccode
> 
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 80
> 
>+=head2 ccode_enabled
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+=head2 ccode_storage
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 80
>+
> =head2 holdingbranch
> 
>   data_type: 'varchar'
>@@ -54,12 +78,36 @@ __PACKAGE__->table("course_items");
>   is_nullable: 1
>   size: 10
> 
>+=head2 holdingbranch_enabled
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+=head2 holdingbranch_storage
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 10
>+
> =head2 location
> 
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 80
> 
>+=head2 location_enabled
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
>+=head2 location_storage
>+
>+  data_type: 'varchar'
>+  is_nullable: 1
>+  size: 80
>+
> =head2 enabled
> 
>   data_type: 'enum'
>@@ -83,12 +131,28 @@ __PACKAGE__->add_columns(
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
>   "itype",
>   { data_type => "varchar", is_nullable => 1, size => 10 },
>+  "itype_enabled",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "itype_storage",
>+  { data_type => "varchar", is_nullable => 1, size => 10 },
>   "ccode",
>   { data_type => "varchar", is_nullable => 1, size => 80 },
>+  "ccode_enabled",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "ccode_storage",
>+  { data_type => "varchar", is_nullable => 1, size => 80 },
>   "holdingbranch",
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>+  "holdingbranch_enabled",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "holdingbranch_storage",
>+  { data_type => "varchar", is_nullable => 1, size => 10 },
>   "location",
>   { data_type => "varchar", is_nullable => 1, size => 80 },
>+  "location_enabled",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "location_storage",
>+  { data_type => "varchar", is_nullable => 1, size => 80 },
>   "enabled",
>   {
>     data_type => "enum",
>@@ -184,8 +248,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-26 16:15:09
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0hBp2R7AMxgHLLZcG/676w
>+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-19 16:07:13
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8tTH0fAzewvaXRYs8+VZcg
> 
> 
> sub koha_objects_class {
>-- 
>2.24.2 (Apple Git-127)

Actions: View | Diff | Splinter Review

Attachments on bug 23727: 95104 | 98943 | 98944 | 98945 | 99269 | 99270 | 99271 | 99272 | 99273 | 99274 | 99275 | 99276 | 99277 | 99327 | 99328 | 99329 | 99330 | 99331 | 99332 | 99333 | 99334 | 99335 | 99336 | 103126 | 103127 | 103128 | 103131 | 103132 | 103133 | 103134 | 103135 | 103136 | 104782 | 104783 | 104784 | 104785 | 104786 | 104787