Attachment 48780 Details for Bug 9805 – Bug 9805 - Update Schema

[patch] Bug 9805 - Update Schema

Bug-9805---Update-Schema.patch (text/plain), 4.08 KB, created by Kyle M Hall (khall) on 2016-03-08 13:01:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2016-03-08 13:01:34 UTC

Size: 4.08 KB

patch

obsolete

>From c8c0327bc497cd585f7306ccb04a47d1fe41e983 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Wed, 3 Feb 2016 16:54:10 +0000
>Subject: [PATCH] Bug 9805 - Update Schema
>
>---
> Koha/Schema/Result/DefaultBranchCircRule.pm | 34 +++++++++++++++++++++++++++--
> Koha/Schema/Result/DefaultCircRule.pm       | 34 +++++++++++++++++++++++++++--
> 2 files changed, 64 insertions(+), 4 deletions(-)
>
>diff --git a/Koha/Schema/Result/DefaultBranchCircRule.pm b/Koha/Schema/Result/DefaultBranchCircRule.pm
>index 5963b05..fc6650d 100644
>--- a/Koha/Schema/Result/DefaultBranchCircRule.pm
>+++ b/Koha/Schema/Result/DefaultBranchCircRule.pm
>@@ -45,12 +45,31 @@ __PACKAGE__->table("default_branch_circ_rules");
>   data_type: 'tinyint'
>   is_nullable: 1
> 
>+=head2 hold_fulfillment_policy
>+
>+  data_type: 'enum'
>+  default_value: 'any'
>+  extra: {list => ["any","homebranch","holdingbranch"]}
>+  is_nullable: 0
>+
> =head2 returnbranch
> 
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 15
> 
>+=head2 renew_lost_allowed
>+
>+  data_type: 'tinyint'
>+  default_value: 1
>+  is_nullable: 0
>+
>+=head2 renew_lost_found
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -62,8 +81,19 @@ __PACKAGE__->add_columns(
>   { data_type => "integer", is_nullable => 1 },
>   "holdallowed",
>   { data_type => "tinyint", is_nullable => 1 },
>+  "hold_fulfillment_policy",
>+  {
>+    data_type => "enum",
>+    default_value => "any",
>+    extra => { list => ["any", "homebranch", "holdingbranch"] },
>+    is_nullable => 0,
>+  },
>   "returnbranch",
>   { data_type => "varchar", is_nullable => 1, size => 15 },
>+  "renew_lost_allowed",
>+  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
>+  "renew_lost_found",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
> );
> 
> =head1 PRIMARY KEY
>@@ -96,8 +126,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-05-13 17:48:39
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p95r3cEx85NtMTEAgiRgBw
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-02-03 16:53:36
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UMfpRS3am8WbB58SosLdFg
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/DefaultCircRule.pm b/Koha/Schema/Result/DefaultCircRule.pm
>index 5e0f266..261b470 100644
>--- a/Koha/Schema/Result/DefaultCircRule.pm
>+++ b/Koha/Schema/Result/DefaultCircRule.pm
>@@ -45,12 +45,31 @@ __PACKAGE__->table("default_circ_rules");
>   data_type: 'integer'
>   is_nullable: 1
> 
>+=head2 hold_fulfillment_policy
>+
>+  data_type: 'enum'
>+  default_value: 'any'
>+  extra: {list => ["any","homebranch","holdingbranch"]}
>+  is_nullable: 0
>+
> =head2 returnbranch
> 
>   data_type: 'varchar'
>   is_nullable: 1
>   size: 15
> 
>+=head2 renew_lost_allowed
>+
>+  data_type: 'tinyint'
>+  default_value: 1
>+  is_nullable: 0
>+
>+=head2 renew_lost_found
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -67,8 +86,19 @@ __PACKAGE__->add_columns(
>   { data_type => "integer", is_nullable => 1 },
>   "holdallowed",
>   { data_type => "integer", is_nullable => 1 },
>+  "hold_fulfillment_policy",
>+  {
>+    data_type => "enum",
>+    default_value => "any",
>+    extra => { list => ["any", "homebranch", "holdingbranch"] },
>+    is_nullable => 0,
>+  },
>   "returnbranch",
>   { data_type => "varchar", is_nullable => 1, size => 15 },
>+  "renew_lost_allowed",
>+  { data_type => "tinyint", default_value => 1, is_nullable => 0 },
>+  "renew_lost_found",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
> );
> 
> =head1 PRIMARY KEY
>@@ -84,8 +114,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("singleton");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-05-13 17:48:39
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TLEpv+H3v7P3psVl+WMA0Q
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-02-03 16:53:36
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FkXFFUvTy1csd7lC7kuROA
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 9805: 16089 | 16090 | 16302 | 29214 | 37008 | 38430 | 38432 | 38433 | 45411 | 45412 | 45413 | 46539 | 46540 | 46541 | 47616 | 47617 | 47618 | 47619 | 48779 | 48780 | 48781 | 49091 | 49092 | 49093 | 49165 | 162473