Attachment 29933 Details for Bug 9303 – Bug 9303 [2] - relative's checkouts in the opac - Schema Updates

[patch] Bug 9303 [2] - relative's checkouts in the opac - Schema Updates

Bug-9303-2---relatives-checkouts-in-the-opac---Sch.patch (text/plain), 5.56 KB, created by Kyle M Hall (khall) on 2014-07-21 15:53:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2014-07-21 15:53:30 UTC

Size: 5.56 KB

patch

obsolete

>From de55592bd61a3735334ff8f8d8732665ac7f7892 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 21 Jul 2014 11:49:18 -0400
>Subject: [PATCH] Bug 9303 [2] - relative's checkouts in the opac - Schema Updates
>
>---
> Koha/Schema/Result/Borrower.pm        |   18 +++++++++++++++---
> Koha/Schema/Result/Deletedborrower.pm |   12 ++++++++++--
> Koha/Schema/Result/Issue.pm           |   24 ++++++++++++++++++++++--
> Koha/Schema/Result/OldIssue.pm        |   24 ++++++++++++++++++++++--
> 4 files changed, 69 insertions(+), 9 deletions(-)
>
>diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
>index b1f9e6f..9ac034f 100644
>--- a/Koha/Schema/Result/Borrower.pm
>+++ b/Koha/Schema/Result/Borrower.pm
>@@ -397,6 +397,12 @@ __PACKAGE__->table("borrowers");
>   default_value: 1
>   is_nullable: 0
> 
>+=head2 privacy_guarantor_checkouts
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -546,6 +552,8 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 50 },
>   "privacy",
>   { data_type => "integer", default_value => 1, is_nullable => 0 },
>+  "privacy_guarantor_checkouts",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
> );
> 
> =head1 PRIMARY KEY
>@@ -1072,9 +1080,13 @@ Composing rels: L</course_instructors> -> course
> __PACKAGE__->many_to_many("courses", "course_instructors", "course");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5cfpOojccKCoVRMj+0mWHg
>+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:43:41
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aT5LhZK5FpTxYKWL+jd7iw
> 
>+__PACKAGE__->belongs_to(
>+    "guarantor",
>+    "Koha::Schema::Result::Borrower",
>+    { borrowernumber => "guarantorid" },
>+);
> 
>-# You can replace this text with custom content, and it will be preserved on regeneration
> 1;
>diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
>index 9ede8ac..10a676d 100644
>--- a/Koha/Schema/Result/Deletedborrower.pm
>+++ b/Koha/Schema/Result/Deletedborrower.pm
>@@ -395,6 +395,12 @@ __PACKAGE__->table("deletedborrowers");
>   default_value: 1
>   is_nullable: 0
> 
>+=head2 privacy_relative_checkouts
>+
>+  data_type: 'tinyint'
>+  default_value: 0
>+  is_nullable: 0
>+
> =cut
> 
> __PACKAGE__->add_columns(
>@@ -532,11 +538,13 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 50 },
>   "privacy",
>   { data_type => "integer", default_value => 1, is_nullable => 0 },
>+  "privacy_relative_checkouts",
>+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yA/UeNpbYIUrX/iWsF0NLw
>+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:43:41
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XbtTcqznWs9nsQDB4QbMbw
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm
>index 2b3e3fd..6caade6 100644
>--- a/Koha/Schema/Result/Issue.pm
>+++ b/Koha/Schema/Result/Issue.pm
>@@ -23,6 +23,12 @@ __PACKAGE__->table("issues");
> 
> =head1 ACCESSORS
> 
>+=head2 issue_id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
> =head2 borrowernumber
> 
>   data_type: 'integer'
>@@ -92,6 +98,8 @@ __PACKAGE__->table("issues");
> =cut
> 
> __PACKAGE__->add_columns(
>+  "issue_id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>   "borrowernumber",
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>   "itemnumber",
>@@ -137,6 +145,18 @@ __PACKAGE__->add_columns(
>   },
> );
> 
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</issue_id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("issue_id");
>+
> =head1 RELATIONS
> 
> =head2 borrowernumber
>@@ -180,8 +200,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2SJJ3az4Ml9hKEQvNH3+Kw
>+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:43:41
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2W1fqwPnf7OFgJL3yzd8Fw
> 
> __PACKAGE__->belongs_to(
>     "borrower",
>diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm
>index e6d664b..9e313c1 100644
>--- a/Koha/Schema/Result/OldIssue.pm
>+++ b/Koha/Schema/Result/OldIssue.pm
>@@ -23,6 +23,12 @@ __PACKAGE__->table("old_issues");
> 
> =head1 ACCESSORS
> 
>+=head2 issue_id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
> =head2 borrowernumber
> 
>   data_type: 'integer'
>@@ -92,6 +98,8 @@ __PACKAGE__->table("old_issues");
> =cut
> 
> __PACKAGE__->add_columns(
>+  "issue_id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>   "borrowernumber",
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>   "itemnumber",
>@@ -137,6 +145,18 @@ __PACKAGE__->add_columns(
>   },
> );
> 
>+=head1 PRIMARY KEY
>+
>+=over 4
>+
>+=item * L</issue_id>
>+
>+=back
>+
>+=cut
>+
>+__PACKAGE__->set_primary_key("issue_id");
>+
> =head1 RELATIONS
> 
> =head2 borrowernumber
>@@ -180,8 +200,8 @@ __PACKAGE__->belongs_to(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgsDHihVYHrTycbaqoGbaQ
>+# Created by DBIx::Class::Schema::Loader v0.07040 @ 2014-07-21 11:43:41
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:254E5Y9hyKdEXLMZ9nbAwQ
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 9303: 22757 | 22770 | 22771 | 22772 | 22783 | 22789 | 22790 | 22809 | 22966 | 22967 | 22968 | 22974 | 22975 | 23086 | 23087 | 23088 | 23089 | 23090 | 23525 | 23526 | 23527 | 24009 | 24010 | 24011 | 24773 | 24774 | 24775 | 24776 | 25008 | 25584 | 25585 | 25586 | 27537 | 27538 | 27539 | 27540 | 27541 | 27542 | 27543 | 27698 | 27699 | 28153 | 28154 | 28155 | 28156 | 28157 | 28158 | 28159 | 28160 | 28161 | 28912 | 29171 | 29172 | 29215 | 29286 | 29287 | 29288 | 29289 | 29290 | 29299 | 29302 | 29303 | 29304 | 29932 | 29933 | 29934 | 29935 | 29936 | 29937 | 30287 | 30288 | 30289 | 30297 | 30298 | 30299 | 30300 | 32053 | 32054 | 32055 | 33049 | 34629 | 34630 | 34631 | 34632 | 34633 | 35519 | 35520 | 35521 | 35522 | 35523 | 35524 | 35525 | 35526 | 35527 | 35528 | 35529 | 35530 | 35531 | 35532 | 35678 | 35679 | 35680 | 35681 | 35682 | 35683 | 35684 | 35686 | 35687 | 35688 | 35689 | 35690 | 35691 | 35832 | 36287 | 36288 | 36289 | 37110 | 37111 | 37112 | 38264 | 38265 | 38266 | 38267 | 38328 | 38329 | 38330 | 38331 | 38446 | 38447 | 38448 | 38449 | 38450 | 38820 | 38821 | 38822 | 38823 | 38824 | 39042 | 39043 | 39044 | 39045 | 39046 | 39047 | 39048 | 39811 | 39817 | 39818 | 39819 | 39820 | 39821 | 39822 | 39823 | 44430 | 44431 | 44432 | 44433 | 44434 | 44435 | 44436 | 44511 | 44512 | 44513 | 44514 | 44515 | 44516 | 44517 | 46136 | 46137 | 46138 | 46139 | 46140 | 46141 | 46142