Attachment 68938 Details for Bug 17672 – Bug 17672 - Schema updates

[patch] Bug 17672 - Schema updates

Bug-17672---Schema-updates.patch (text/plain), 3.00 KB, created by Charles Farmer on 2017-11-03 20:25:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Charles Farmer

Created: 2017-11-03 20:25:30 UTC

Size: 3.00 KB

patch

obsolete

>From df7c3becc9ed9edc17bd9ff538853a0f7853e639 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Wed, 19 Jul 2017 13:14:05 +0000
>Subject: [PATCH] Bug 17672 - Schema updates
>
>Signed-off-by: Owen Leonard <oleonard@myacpl.org>
>
>Signed-off-by: Charles Farmer <charles.farmer@inLibro.com>
>---
> Koha/Schema/Result/Deleteditem.pm | 16 ++++++++++++++--
> Koha/Schema/Result/Item.pm        | 16 ++++++++++++++--
> 2 files changed, 28 insertions(+), 4 deletions(-)
>
>diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm
>index 38286e8..2882e0c 100644
>--- a/Koha/Schema/Result/Deleteditem.pm
>+++ b/Koha/Schema/Result/Deleteditem.pm
>@@ -111,6 +111,12 @@ __PACKAGE__->table("deleteditems");
>   default_value: 0
>   is_nullable: 0
> 
>+=head2 damaged_on
>+
>+  data_type: 'datetime'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
> =head2 itemlost
> 
>   data_type: 'tinyint'
>@@ -309,6 +315,12 @@ __PACKAGE__->add_columns(
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "damaged",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "damaged_on",
>+  {
>+    data_type => "datetime",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>   "itemlost",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "itemlost_on",
>@@ -395,8 +407,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("itemnumber");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 17:10:17
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:npNexLgE7AxLp6iVy1FxgQ
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-07-19 12:58:36
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Akw4lzQAume5Y/V0XapOkw
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm
>index ce85bd7..0ad9c53 100644
>--- a/Koha/Schema/Result/Item.pm
>+++ b/Koha/Schema/Result/Item.pm
>@@ -114,6 +114,12 @@ __PACKAGE__->table("items");
>   default_value: 0
>   is_nullable: 0
> 
>+=head2 damaged_on
>+
>+  data_type: 'datetime'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
> =head2 itemlost
> 
>   data_type: 'tinyint'
>@@ -323,6 +329,12 @@ __PACKAGE__->add_columns(
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "damaged",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>+  "damaged_on",
>+  {
>+    data_type => "datetime",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>   "itemlost",
>   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
>   "itemlost_on",
>@@ -675,8 +687,8 @@ __PACKAGE__->might_have(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vf1sBZrpUo0Cvi896fjNuA
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-07-19 12:58:36
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EI5X5etdx7PPQqA85x4/eQ
> 
> __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
> 
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 17672: 65099 | 65100 | 65551 | 65552 | 68937 | 68938 | 68939 | 71912 | 71913 | 71914