Attachment 58950 Details for Bug 14570 – Bug 14570 - Update Schema

[patch] Bug 14570 - Update Schema

Bug-14570---Update-Schema.patch (text/plain), 6.95 KB, created by Kyle M Hall (khall) on 2017-01-13 11:51:06 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2017-01-13 11:51:06 UTC

Size: 6.95 KB

patch

obsolete

>From 9c9c87864a5e4491384b0b0e05cf284f6af509ff Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Mon, 9 Jan 2017 16:20:58 +0000
>Subject: [PATCH] Bug 14570 - Update Schema
>
>---
> Koha/Schema/Result/Borrower.pm             | 70 ++++++++++++++----------------
> Koha/Schema/Result/BorrowerModification.pm | 40 +----------------
> Koha/Schema/Result/Deletedborrower.pm      | 40 +----------------
> 3 files changed, 36 insertions(+), 114 deletions(-)
>
>diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
>index 1fe3988..3d357ee 100644
>--- a/Koha/Schema/Result/Borrower.pm
>+++ b/Koha/Schema/Result/Borrower.pm
>@@ -254,37 +254,11 @@ __PACKAGE__->table("borrowers");
>   is_nullable: 1
>   size: 255
> 
>-=head2 contactname
>-
>-  data_type: 'mediumtext'
>-  is_nullable: 1
>-
>-=head2 contactfirstname
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 contacttitle
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 guarantorid
>-
>-  data_type: 'integer'
>-  is_nullable: 1
>-
> =head2 borrowernotes
> 
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 relationship
>-
>-  data_type: 'varchar'
>-  is_nullable: 1
>-  size: 100
>-
> =head2 sex
> 
>   data_type: 'varchar'
>@@ -542,18 +516,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "debarredcomment",
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>-  "contactname",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "contactfirstname",
>-  { data_type => "text", is_nullable => 1 },
>-  "contacttitle",
>-  { data_type => "text", is_nullable => 1 },
>-  "guarantorid",
>-  { data_type => "integer", is_nullable => 1 },
>   "borrowernotes",
>   { data_type => "mediumtext", is_nullable => 1 },
>-  "relationship",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>   "sex",
>   { data_type => "varchar", is_nullable => 1, size => 1 },
>   "password",
>@@ -1138,6 +1102,36 @@ __PACKAGE__->has_many(
>   { cascade_copy => 0, cascade_delete => 0 },
> );
> 
>+=head2 relationships_guarantees
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Relationship>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "relationships_guarantees",
>+  "Koha::Schema::Result::Relationship",
>+  { "foreign.guarantee_id" => "self.borrowernumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
>+=head2 relationships_guarantors
>+
>+Type: has_many
>+
>+Related object: L<Koha::Schema::Result::Relationship>
>+
>+=cut
>+
>+__PACKAGE__->has_many(
>+  "relationships_guarantors",
>+  "Koha::Schema::Result::Relationship",
>+  { "foreign.guarantor_id" => "self.borrowernumber" },
>+  { cascade_copy => 0, cascade_delete => 0 },
>+);
>+
> =head2 reserves
> 
> Type: has_many
>@@ -1334,8 +1328,8 @@ Composing rels: L</aqorder_users> -> ordernumber
> __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:35
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lc6GQ2E7d+tyzTk3v2sWjQ
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 16:31:58
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gDowcouH821/r88EUCdq9Q
> 
> __PACKAGE__->belongs_to(
>     "guarantor",
>diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
>index af4895a..bffba37 100644
>--- a/Koha/Schema/Result/BorrowerModification.pm
>+++ b/Koha/Schema/Result/BorrowerModification.pm
>@@ -264,37 +264,11 @@ __PACKAGE__->table("borrower_modifications");
>   is_nullable: 1
>   size: 255
> 
>-=head2 contactname
>-
>-  data_type: 'mediumtext'
>-  is_nullable: 1
>-
>-=head2 contactfirstname
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 contacttitle
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 guarantorid
>-
>-  data_type: 'integer'
>-  is_nullable: 1
>-
> =head2 borrowernotes
> 
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 relationship
>-
>-  data_type: 'varchar'
>-  is_nullable: 1
>-  size: 100
>-
> =head2 sex
> 
>   data_type: 'varchar'
>@@ -521,18 +495,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "debarredcomment",
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>-  "contactname",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "contactfirstname",
>-  { data_type => "text", is_nullable => 1 },
>-  "contacttitle",
>-  { data_type => "text", is_nullable => 1 },
>-  "guarantorid",
>-  { data_type => "integer", is_nullable => 1 },
>   "borrowernotes",
>   { data_type => "mediumtext", is_nullable => 1 },
>-  "relationship",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>   "sex",
>   { data_type => "varchar", is_nullable => 1, size => 1 },
>   "password",
>@@ -590,8 +554,8 @@ __PACKAGE__->add_columns(
> __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 20:04:12
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IZNhBX5Bj+x4S8JCWG+7lA
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-09 16:20:34
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MlntmtWrUZQhQs5K9xCH8w
> 
> 
> # You can replace this text with custom content, and it will be preserved on regeneration
>diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
>index 937a4a4..d634d05 100644
>--- a/Koha/Schema/Result/Deletedborrower.pm
>+++ b/Koha/Schema/Result/Deletedborrower.pm
>@@ -252,37 +252,11 @@ __PACKAGE__->table("deletedborrowers");
>   is_nullable: 1
>   size: 255
> 
>-=head2 contactname
>-
>-  data_type: 'mediumtext'
>-  is_nullable: 1
>-
>-=head2 contactfirstname
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 contacttitle
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 guarantorid
>-
>-  data_type: 'integer'
>-  is_nullable: 1
>-
> =head2 borrowernotes
> 
>   data_type: 'mediumtext'
>   is_nullable: 1
> 
>-=head2 relationship
>-
>-  data_type: 'varchar'
>-  is_nullable: 1
>-  size: 100
>-
> =head2 sex
> 
>   data_type: 'varchar'
>@@ -527,18 +501,8 @@ __PACKAGE__->add_columns(
>   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
>   "debarredcomment",
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>-  "contactname",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "contactfirstname",
>-  { data_type => "text", is_nullable => 1 },
>-  "contacttitle",
>-  { data_type => "text", is_nullable => 1 },
>-  "guarantorid",
>-  { data_type => "integer", is_nullable => 1 },
>   "borrowernotes",
>   { data_type => "mediumtext", is_nullable => 1 },
>-  "relationship",
>-  { data_type => "varchar", is_nullable => 1, size => 100 },
>   "sex",
>   { data_type => "varchar", is_nullable => 1, size => 1 },
>   "password",
>@@ -604,8 +568,8 @@ __PACKAGE__->add_columns(
> );
> 
> 
>-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-13 17:32:29
>-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pcdyzQacTbFDJ9R1k0E8mA
>+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 16:31:58
>+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aww4S4vMbSwAvHi2GJW7AA
> 
> 
> # You can replace this text with custom code or comments, and it will be preserved on regeneration
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 14570: 52400 | 52401 | 52402 | 52403 | 52406 | 52407 | 58146 | 58147 | 58159 | 58202 | 58391 | 58399 | 58412 | 58688 | 58689 | 58739 | 58762 | 58763 | 58764 | 58834 | 58835 | 58836 | 58837 | 58838 | 58839 | 58949 | 58950 | 58951 | 58952 | 58953 | 58954 | 58972 | 58973 | 58974 | 58975 | 58976 | 58977 | 58978 | 58979 | 58980 | 62450 | 62451 | 62452 | 64124 | 64125 | 64126 | 71160 | 71161 | 71162 | 71163 | 73283 | 73284 | 73583 | 73584 | 74950 | 74951 | 74952 | 74953 | 74954 | 74976 | 74977 | 74978 | 74979 | 77029 | 77030 | 77031 | 77032 | 77033 | 77034 | 77040 | 77041 | 77042 | 77043 | 77044 | 77045 | 77046 | 77047 | 77048 | 77049 | 77067 | 77068 | 77069 | 77070 | 77071 | 77072 | 77073 | 77074 | 77075 | 77076 | 77077 | 77078 | 77290 | 77291 | 77346 | 77347 | 77348 | 80842 | 80849 | 81932 | 81933 | 85411 | 85412 | 85431 | 89889 | 89890 | 89891 | 89892 | 89909 | 89910 | 89911 | 89912 | 89921 | 89922 | 89929 | 90048 | 91231 | 91439 | 91440 | 91441 | 91442 | 91443 | 91444 | 91445 | 91694 | 91695 | 91696 | 91697 | 91698 | 91699 | 91700 | 92157 | 92158 | 92161 | 92162 | 92163 | 92180 | 92181 | 92182 | 92183 | 92232 | 92233 | 92234 | 92235 | 92277 | 92278 | 92279 | 92280 | 92281 | 92282 | 92283 | 92284 | 92285 | 92286 | 92287 | 92288 | 92289 | 92290 | 92291 | 92292 | 92298 | 92299 | 92300 | 92301 | 92302 | 92303 | 92304 | 92305 | 92306 | 92307 | 92308 | 92309 | 92310 | 92311 | 92312 | 92313 | 92314 | 92315 | 92316 | 92317 | 92318 | 92319 | 92320 | 92321 | 92322 | 92323 | 92324 | 92325 | 92346 | 92347 | 92348 | 92349 | 92350