Bugzilla – Attachment 80077 Details for
Bug 18591
Allow an arbitrary number of comments on ILLs
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Update Schema - DO NOT PUSH
Update-Schema---DO-NOT-PUSH.patch (text/plain), 4.88 KB, created by
Andrew Isherwood
on 2018-10-05 13:07:02 UTC
(
hide
)
Description:
Update Schema - DO NOT PUSH
Filename:
MIME Type:
Creator:
Andrew Isherwood
Created:
2018-10-05 13:07:02 UTC
Size:
4.88 KB
patch
obsolete
>From eb878d19d2642efd29e66b587a9c92ea417bc0c1 Mon Sep 17 00:00:00 2001 >From: Magnus Enger <magnus@libriotech.no> >Date: Sat, 11 Nov 2017 14:02:56 +0000 >Subject: [PATCH] Update Schema - DO NOT PUSH > >https://bugs.koha-community.org/show_bug.cgi?id=18591 >--- > Koha/Schema/Result/Borrower.pm | 15 +++++ > Koha/Schema/Result/Illcomment.pm | 137 +++++++++++++++++++++++++++++++++++++++ > Koha/Schema/Result/Illrequest.pm | 19 +++++- > 3 files changed, 169 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/Illcomment.pm > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 236c917912..be09ba6a23 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -1025,6 +1025,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illcomments >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illcomment> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illcomments", >+ "Koha::Schema::Result::Illcomment", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 illrequests > > Type: has_many >diff --git a/Koha/Schema/Result/Illcomment.pm b/Koha/Schema/Result/Illcomment.pm >new file mode 100644 >index 0000000000..76f150f7a1 >--- /dev/null >+++ b/Koha/Schema/Result/Illcomment.pm >@@ -0,0 +1,137 @@ >+use utf8; >+package Koha::Schema::Result::Illcomment; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Illcomment >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<illcomments> >+ >+=cut >+ >+__PACKAGE__->table("illcomments"); >+ >+=head1 ACCESSORS >+ >+=head2 illcomment_id >+ >+ data_type: 'integer' >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 illrequest_id >+ >+ data_type: 'bigint' >+ extra: {unsigned => 1} >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 comment >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 timestamp >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ default_value: current_timestamp >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "illcomment_id", >+ { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, >+ "illrequest_id", >+ { >+ data_type => "bigint", >+ extra => { unsigned => 1 }, >+ is_foreign_key => 1, >+ is_nullable => 0, >+ }, >+ "borrowernumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "comment", >+ { data_type => "text", is_nullable => 1 }, >+ "timestamp", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ default_value => \"current_timestamp", >+ is_nullable => 0, >+ }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</illcomment_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("illcomment_id"); >+ >+=head1 RELATIONS >+ >+=head2 borrowernumber >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Borrower> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "borrowernumber", >+ "Koha::Schema::Result::Borrower", >+ { borrowernumber => "borrowernumber" }, >+ { >+ is_deferrable => 1, >+ join_type => "LEFT", >+ on_delete => "CASCADE", >+ on_update => "CASCADE", >+ }, >+); >+ >+=head2 illrequest >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "illrequest", >+ "Koha::Schema::Result::Illrequest", >+ { illrequest_id => "illrequest_id" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-11 13:57:28 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jlDjszfw2Q5k5FDnDD9FQg >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm >index 1b207ff002..c6b689dc42 100644 >--- a/Koha/Schema/Result/Illrequest.pm >+++ b/Koha/Schema/Result/Illrequest.pm >@@ -215,6 +215,21 @@ __PACKAGE__->belongs_to( > { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, > ); > >+=head2 illcomments >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illcomment> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illcomments", >+ "Koha::Schema::Result::Illcomment", >+ { "foreign.illrequest_id" => "self.illrequest_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 illrequestattributes > > Type: has_many >@@ -231,8 +246,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rh8DSs3xj3KRmyd7WNGDAg >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-11 13:57:28 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rzJewf8BoBn9LieLzOa12w > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 18591
:
69234
|
69272
|
69273
|
69274
|
69275
|
74964
|
74965
|
74966
|
79518
|
79519
|
80077
|
80078
|
80079
|
80081
|
80084
|
80101
|
80102
|
80103
|
80104
|
80105
|
80227
|
80228
|
80229
|
80230