Bugzilla – Attachment 68559 Details for
Bug 7317
Add an Interlibrary Loan Module to Circulation and OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7317: DO NOT PUSH: Updated Schema Files.
Bug-7317-DO-NOT-PUSH-Updated-Schema-Files.patch (text/plain), 8.45 KB, created by
Benjamin Rokseth
on 2017-10-25 20:34:58 UTC
(
hide
)
Description:
Bug 7317: DO NOT PUSH: Updated Schema Files.
Filename:
MIME Type:
Creator:
Benjamin Rokseth
Created:
2017-10-25 20:34:58 UTC
Size:
8.45 KB
patch
obsolete
>From 2f19c2517a58eae27dc0adc4744ecf6abfdc10ea Mon Sep 17 00:00:00 2001 >From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> >Date: Tue, 21 Feb 2017 07:20:22 +0000 >Subject: [PATCH] Bug 7317: DO NOT PUSH: Updated Schema Files. > >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >Signed-off-by: Benjamin Rokseth <benjamin.rokseth@kul.oslo.kommune.no> >--- > Koha/Schema/Result/Borrower.pm | 15 ++ > Koha/Schema/Result/Branch.pm | 15 ++ > Koha/Schema/Result/Illrequest.pm | 239 ++++++++++++++++++++++++++++++ > Koha/Schema/Result/Illrequestattribute.pm | 97 ++++++++++++ > 4 files changed, 366 insertions(+) > create mode 100644 Koha/Schema/Result/Illrequest.pm > create mode 100644 Koha/Schema/Result/Illrequestattribute.pm > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index bac9989..c552bcf 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -1010,6 +1010,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illrequests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequests", >+ "Koha::Schema::Result::Illrequest", >+ { "foreign.borrowernumber" => "self.borrowernumber" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 issues > > Type: has_many >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index 58e1121..750a757 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -503,6 +503,21 @@ __PACKAGE__->has_many( > { cascade_copy => 0, cascade_delete => 0 }, > ); > >+=head2 illrequests >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequest> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequests", >+ "Koha::Schema::Result::Illrequest", >+ { "foreign.branchcode" => "self.branchcode" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ > =head2 items_holdingbranches > > Type: has_many >diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm >new file mode 100644 >index 0000000..f116bd4 >--- /dev/null >+++ b/Koha/Schema/Result/Illrequest.pm >@@ -0,0 +1,239 @@ >+use utf8; >+package Koha::Schema::Result::Illrequest; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Illrequest >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<illrequests> >+ >+=cut >+ >+__PACKAGE__->table("illrequests"); >+ >+=head1 ACCESSORS >+ >+=head2 illrequest_id >+ >+ data_type: 'bigint' >+ extra: {unsigned => 1} >+ is_auto_increment: 1 >+ is_nullable: 0 >+ >+=head2 borrowernumber >+ >+ data_type: 'integer' >+ is_foreign_key: 1 >+ is_nullable: 1 >+ >+=head2 biblio_id >+ >+ data_type: 'integer' >+ is_nullable: 1 >+ >+=head2 branchcode >+ >+ data_type: 'varchar' >+ is_foreign_key: 1 >+ is_nullable: 0 >+ size: 50 >+ >+=head2 status >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 placed >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 replied >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 updated >+ >+ data_type: 'timestamp' >+ datetime_undef_if_invalid: 1 >+ default_value: current_timestamp >+ is_nullable: 0 >+ >+=head2 completed >+ >+ data_type: 'date' >+ datetime_undef_if_invalid: 1 >+ is_nullable: 1 >+ >+=head2 medium >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 30 >+ >+=head2 accessurl >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 500 >+ >+=head2 cost >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 20 >+ >+=head2 notesopac >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 notesstaff >+ >+ data_type: 'text' >+ is_nullable: 1 >+ >+=head2 orderid >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 50 >+ >+=head2 backend >+ >+ data_type: 'varchar' >+ is_nullable: 1 >+ size: 20 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "illrequest_id", >+ { >+ data_type => "bigint", >+ extra => { unsigned => 1 }, >+ is_auto_increment => 1, >+ is_nullable => 0, >+ }, >+ "borrowernumber", >+ { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, >+ "biblio_id", >+ { data_type => "integer", is_nullable => 1 }, >+ "branchcode", >+ { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 }, >+ "status", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "placed", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "replied", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "updated", >+ { >+ data_type => "timestamp", >+ datetime_undef_if_invalid => 1, >+ default_value => \"current_timestamp", >+ is_nullable => 0, >+ }, >+ "completed", >+ { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, >+ "medium", >+ { data_type => "varchar", is_nullable => 1, size => 30 }, >+ "accessurl", >+ { data_type => "varchar", is_nullable => 1, size => 500 }, >+ "cost", >+ { data_type => "varchar", is_nullable => 1, size => 20 }, >+ "notesopac", >+ { data_type => "text", is_nullable => 1 }, >+ "notesstaff", >+ { data_type => "text", is_nullable => 1 }, >+ "orderid", >+ { data_type => "varchar", is_nullable => 1, size => 50 }, >+ "backend", >+ { data_type => "varchar", is_nullable => 1, size => 20 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</illrequest_id> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("illrequest_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 branchcode >+ >+Type: belongs_to >+ >+Related object: L<Koha::Schema::Result::Branch> >+ >+=cut >+ >+__PACKAGE__->belongs_to( >+ "branchcode", >+ "Koha::Schema::Result::Branch", >+ { branchcode => "branchcode" }, >+ { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, >+); >+ >+=head2 illrequestattributes >+ >+Type: has_many >+ >+Related object: L<Koha::Schema::Result::Illrequestattribute> >+ >+=cut >+ >+__PACKAGE__->has_many( >+ "illrequestattributes", >+ "Koha::Schema::Result::Illrequestattribute", >+ { "foreign.illrequest_id" => "self.illrequest_id" }, >+ { cascade_copy => 0, cascade_delete => 0 }, >+); >+ >+ >+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-21 07:18:52 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VBFScpVmjIug+7vhwJoTbA >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >diff --git a/Koha/Schema/Result/Illrequestattribute.pm b/Koha/Schema/Result/Illrequestattribute.pm >new file mode 100644 >index 0000000..43f00cd >--- /dev/null >+++ b/Koha/Schema/Result/Illrequestattribute.pm >@@ -0,0 +1,97 @@ >+use utf8; >+package Koha::Schema::Result::Illrequestattribute; >+ >+# Created by DBIx::Class::Schema::Loader >+# DO NOT MODIFY THE FIRST PART OF THIS FILE >+ >+=head1 NAME >+ >+Koha::Schema::Result::Illrequestattribute >+ >+=cut >+ >+use strict; >+use warnings; >+ >+use base 'DBIx::Class::Core'; >+ >+=head1 TABLE: C<illrequestattributes> >+ >+=cut >+ >+__PACKAGE__->table("illrequestattributes"); >+ >+=head1 ACCESSORS >+ >+=head2 illrequest_id >+ >+ data_type: 'bigint' >+ extra: {unsigned => 1} >+ is_foreign_key: 1 >+ is_nullable: 0 >+ >+=head2 type >+ >+ data_type: 'varchar' >+ is_nullable: 0 >+ size: 200 >+ >+=head2 value >+ >+ data_type: 'text' >+ is_nullable: 0 >+ >+=cut >+ >+__PACKAGE__->add_columns( >+ "illrequest_id", >+ { >+ data_type => "bigint", >+ extra => { unsigned => 1 }, >+ is_foreign_key => 1, >+ is_nullable => 0, >+ }, >+ "type", >+ { data_type => "varchar", is_nullable => 0, size => 200 }, >+ "value", >+ { data_type => "text", is_nullable => 0 }, >+); >+ >+=head1 PRIMARY KEY >+ >+=over 4 >+ >+=item * L</illrequest_id> >+ >+=item * L</type> >+ >+=back >+ >+=cut >+ >+__PACKAGE__->set_primary_key("illrequest_id", "type"); >+ >+=head1 RELATIONS >+ >+=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-02-21 07:18:52 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d/Zf7J6UksmbNBXbtcKz+g >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >2.1.4
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 7317
:
59893
|
59894
|
59895
|
59920
|
60485
|
60486
|
60487
|
60488
|
63081
|
63082
|
63083
|
63084
|
63085
|
63086
|
63087
|
63088
|
63089
|
63090
|
63113
|
63175
|
63176
|
63354
|
63421
|
63472
|
63475
|
65469
|
65470
|
65471
|
65472
|
65473
|
65474
|
65475
|
65476
|
66266
|
67242
|
67243
|
67244
|
67245
|
67246
|
67247
|
67248
|
67249
|
67250
|
67251
|
67252
|
67253
|
67254
|
67255
|
67256
|
67257
|
67258
|
67259
|
67260
|
67261
|
67262
|
67263
|
67264
|
67281
|
67282
|
67283
|
67284
|
67285
|
67286
|
67287
|
67288
|
67289
|
67290
|
67291
|
67292
|
67293
|
67294
|
67295
|
67296
|
67297
|
67298
|
67299
|
67300
|
67301
|
67302
|
67303
|
68185
|
68186
|
68328
|
68391
|
68406
|
68407
|
68408
|
68409
|
68418
|
68444
|
68445
|
68483
|
68484
|
68485
|
68487
|
68516
|
68517
|
68518
|
68519
|
68520
|
68521
|
68522
|
68523
|
68524
|
68525
|
68542
|
68543
|
68544
|
68545
|
68546
|
68547
|
68548
|
68549
|
68550
|
68551
|
68552
|
68558
| 68559 |
68560
|
68561
|
68562
|
68563
|
68564
|
68565
|
68566
|
68567
|
68858
|
68874
|
68877
|
68878
|
68885
|
68886
|
68921
|
68922
|
68926
|
68927
|
68928
|
68929
|
68931
|
68932
|
68933
|
68988
|
68989
|
68999
|
69000
|
69006
|
69008
|
69009
|
69012
|
69014
|
69044
|
69045
|
69046
|
69056
|
69059
|
69060
|
69061
|
69063
|
69064
|
69065
|
69066
|
69069
|
69070
|
69071
|
69074