Attachment 107524 Details for Bug 25089 – Bug 25089: Schema changes

[patch] Bug 25089: Schema changes

Bug-25089-Schema-changes.patch (text/plain), 2.08 KB, created by Lari Taskula on 2020-07-29 19:54:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

Created: 2020-07-29 19:54:43 UTC

Size: 2.08 KB

patch

obsolete

>From 65a3b38a29ce08e4fbe831b882477d191b4ccbcb Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@hypernova.fi>
>Date: Sun, 5 Apr 2020 14:16:17 +0000
>Subject: [PATCH] Bug 25089: Schema changes
>
>Sponsored-by: The National Library of Finland
>---
> Koha/Schema/Result/CirculationRule.pm | 26 +++++++++++++++++++++++---
> 1 file changed, 23 insertions(+), 3 deletions(-)
>
>diff --git a/Koha/Schema/Result/CirculationRule.pm b/Koha/Schema/Result/CirculationRule.pm
>index 80e6cc2d5a..6549238e99 100644
>--- a/Koha/Schema/Result/CirculationRule.pm
>+++ b/Koha/Schema/Result/CirculationRule.pm
>@@ -50,6 +50,12 @@ __PACKAGE__->table("circulation_rules");
>   is_nullable: 1
>   size: 10
> 
>+=head2 checkout_type
>+
>+  data_type: 'enum'
>+  extra: {list => ["CHECKOUT","ONSITE"]}
>+  is_nullable: 1
>+
> =head2 rule_name
> 
>   data_type: 'varchar'
>@@ -73,6 +79,12 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>   "itemtype",
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
>+  "checkout_type",
>+  {
>+    data_type => "enum",
>+    extra => { list => ["CHECKOUT", "ONSITE"] },
>+    is_nullable => 1,
>+  },
>   "rule_name",
>   { data_type => "varchar", is_nullable => 0, size => 32 },
>   "rule_value",
>@@ -103,6 +115,8 @@ __PACKAGE__->set_primary_key("id");
> 
> =item * L</itemtype>
> 
>+=item * L</checkout_type>
>+
> =item * L</rule_name>
> 
> =back
>@@ -111,7 +125,13 @@ __PACKAGE__->set_primary_key("id");
> 
> __PACKAGE__->add_unique_constraint(
>   "branchcode",
>-  ["branchcode", "categorycode", "itemtype", "rule_name"],
>+  [
>+    "branchcode",
>+    "categorycode",
>+    "itemtype",
>+    "checkout_type",
>+    "rule_name",
>+  ],
> );
> 
> =head1 RELATIONS
>@@ -177,8 +197,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-05 14:29:17
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QHMqvrtX0ohJe70PHUYZ0Q
>+# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-09 21:29:30
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k6fFSiRyYlY8mwHNNQ1u5A
> 
> sub koha_objects_class {
>     'Koha::CirculationRules';
>-- 
>2.17.1

Actions: View | Diff | Splinter Review

Attachments on bug 25089: 103046 | 103047 | 103048 | 103049 | 103050 | 103051 | 103052 | 103053 | 103054 | 103239 | 103240 | 103241 | 103242 | 103243 | 103244 | 103245 | 103246 | 103247 | 103248 | 103283 | 103284 | 103285 | 103286 | 103287 | 103288 | 103289 | 103290 | 103291 | 103292 | 103339 | 103340 | 103341 | 103342 | 103343 | 103344 | 103345 | 103346 | 103347 | 103348 | 103349 | 103351 | 103352 | 103353 | 103354 | 103355 | 103356 | 103357 | 103358 | 103359 | 103360 | 103361 | 103537 | 103538 | 103539 | 103540 | 103541 | 103542 | 103543 | 103544 | 103545 | 103546 | 103547 | 104274 | 104275 | 107523 | 107524 | 107525 | 107526 | 107527 | 107528 | 107529 | 107530 | 107531 | 107532 | 107533