From bf8a631fe36e91598e8ec1e6e92244bad5513071 Mon Sep 17 00:00:00 2001 From: Alex Sassmannshausen Date: Fri, 3 Feb 2017 18:00:01 +0100 Subject: [PATCH] DO NOT PUSH: Updated Schema files. * Koha/Schema/Result/Borrower.pm: New file. * Koha/Schema/Result/Branch.pm: New file. * Koha/Schema/Result/Illrequest.pm: New file. * Koha/Schema/Result/Illrequestattribute.pm: New file. https://bugs.koha-community.org/show_bug.cgi?id=7317 --- Koha/Schema/Result/Borrower.pm | 1374 +++++++++++++++++++++++++++++ Koha/Schema/Result/Branch.pm | 599 ++++++++++++- Koha/Schema/Result/Illrequest.pm | 239 +++++ Koha/Schema/Result/Illrequestattribute.pm | 97 ++ 4 files changed, 2307 insertions(+), 2 deletions(-) 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 1fe3988..97108a6 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -973,6 +973,1367 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 illrequests + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "illrequests", + "Koha::Schema::Result::Illrequest", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 issues + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "issues", + "Koha::Schema::Result::Issue", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 items_last_borrowers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "items_last_borrowers", + "Koha::Schema::Result::ItemsLastBorrower", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 message_queues + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "message_queues", + "Koha::Schema::Result::MessageQueue", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 messages + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "messages", + "Koha::Schema::Result::Message", + { "foreign.manager_id" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 old_issues + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "old_issues", + "Koha::Schema::Result::OldIssue", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 old_reserves + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "old_reserves", + "Koha::Schema::Result::OldReserve", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 opac_news + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "opac_news", + "Koha::Schema::Result::OpacNews", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 patron_list_patrons + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "patron_list_patrons", + "Koha::Schema::Result::PatronListPatron", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 patron_lists + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "patron_lists", + "Koha::Schema::Result::PatronList", + { "foreign.owner" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 patronimage + +Type: might_have + +Related object: L + +=cut + +__PACKAGE__->might_have( + "patronimage", + "Koha::Schema::Result::Patronimage", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 ratings + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "ratings", + "Koha::Schema::Result::Rating", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 reserves + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "reserves", + "Koha::Schema::Result::Reserve", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 reviews + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "reviews", + "Koha::Schema::Result::Review", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 sms_provider + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "sms_provider", + "Koha::Schema::Result::SmsProvider", + { id => "sms_provider_id" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "SET NULL", + on_update => "CASCADE", + }, +); + +=head2 subscriptionroutinglists + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "subscriptionroutinglists", + "Koha::Schema::Result::Subscriptionroutinglist", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 tags_all + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "tags_all", + "Koha::Schema::Result::TagAll", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 tags_approvals + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "tags_approvals", + "Koha::Schema::Result::TagsApproval", + { "foreign.approved_by" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 user_permissions + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "user_permissions", + "Koha::Schema::Result::UserPermission", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 virtualshelfcontents + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "virtualshelfcontents", + "Koha::Schema::Result::Virtualshelfcontent", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 virtualshelfshares + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "virtualshelfshares", + "Koha::Schema::Result::Virtualshelfshare", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 virtualshelves + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "virtualshelves", + "Koha::Schema::Result::Virtualshelve", + { "foreign.owner" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 basketnoes + +Type: many_to_many + +Composing rels: L -> basketno + +=cut + +__PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno"); + +=head2 budgets + +Type: many_to_many + +Composing rels: L -> budget + +=cut + +__PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget"); + +=head2 courses + +Type: many_to_many + +Composing rels: L -> course + +=cut + +__PACKAGE__->many_to_many("courses", "course_instructors", "course"); + +=head2 ordernumbers + +Type: many_to_many + +Composing rels: L -> ordernumber + +=cut + +__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); + + +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:55:44 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6poutI9U1NshzV7amXSl+g +# These lines were loaded from '/home/alex/src/koha/Koha/Schema/Result/Borrower.pm' found in @INC. +# They are now part of the custom portion of this file +# for you to hand-edit. If you do not either delete +# this section or remove that file from @INC, this section +# will be repeated redundantly when you re-create this +# file again via Loader! See skip_load_external to disable +# this feature. + +use utf8; +package Koha::Schema::Result::Borrower; + +# Created by DBIx::Class::Schema::Loader +# DO NOT MODIFY THE FIRST PART OF THIS FILE + +=head1 NAME + +Koha::Schema::Result::Borrower + +=cut + +use strict; +use warnings; + +use base 'DBIx::Class::Core'; + +=head1 TABLE: C + +=cut + +__PACKAGE__->table("borrowers"); + +=head1 ACCESSORS + +=head2 borrowernumber + + data_type: 'integer' + is_auto_increment: 1 + is_nullable: 0 + +=head2 cardnumber + + data_type: 'varchar' + is_nullable: 1 + size: 16 + +=head2 surname + + data_type: 'mediumtext' + is_nullable: 0 + +=head2 firstname + + data_type: 'text' + is_nullable: 1 + +=head2 title + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 othernames + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 initials + + data_type: 'text' + is_nullable: 1 + +=head2 streetnumber + + data_type: 'varchar' + is_nullable: 1 + size: 10 + +=head2 streettype + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 address + + data_type: 'mediumtext' + is_nullable: 0 + +=head2 address2 + + data_type: 'text' + is_nullable: 1 + +=head2 city + + data_type: 'mediumtext' + is_nullable: 0 + +=head2 state + + data_type: 'text' + is_nullable: 1 + +=head2 zipcode + + data_type: 'varchar' + is_nullable: 1 + size: 25 + +=head2 country + + data_type: 'text' + is_nullable: 1 + +=head2 email + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 phone + + data_type: 'text' + is_nullable: 1 + +=head2 mobile + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 fax + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 emailpro + + data_type: 'text' + is_nullable: 1 + +=head2 phonepro + + data_type: 'text' + is_nullable: 1 + +=head2 B_streetnumber + + accessor: 'b_streetnumber' + data_type: 'varchar' + is_nullable: 1 + size: 10 + +=head2 B_streettype + + accessor: 'b_streettype' + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 B_address + + accessor: 'b_address' + data_type: 'varchar' + is_nullable: 1 + size: 100 + +=head2 B_address2 + + accessor: 'b_address2' + data_type: 'text' + is_nullable: 1 + +=head2 B_city + + accessor: 'b_city' + data_type: 'mediumtext' + is_nullable: 1 + +=head2 B_state + + accessor: 'b_state' + data_type: 'text' + is_nullable: 1 + +=head2 B_zipcode + + accessor: 'b_zipcode' + data_type: 'varchar' + is_nullable: 1 + size: 25 + +=head2 B_country + + accessor: 'b_country' + data_type: 'text' + is_nullable: 1 + +=head2 B_email + + accessor: 'b_email' + data_type: 'text' + is_nullable: 1 + +=head2 B_phone + + accessor: 'b_phone' + data_type: 'mediumtext' + is_nullable: 1 + +=head2 dateofbirth + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +=head2 branchcode + + data_type: 'varchar' + default_value: (empty string) + is_foreign_key: 1 + is_nullable: 0 + size: 10 + +=head2 categorycode + + data_type: 'varchar' + default_value: (empty string) + is_foreign_key: 1 + is_nullable: 0 + size: 10 + +=head2 dateenrolled + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +=head2 dateexpiry + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +=head2 gonenoaddress + + data_type: 'tinyint' + is_nullable: 1 + +=head2 lost + + data_type: 'tinyint' + is_nullable: 1 + +=head2 debarred + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +=head2 debarredcomment + + data_type: 'varchar' + 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' + is_nullable: 1 + size: 1 + +=head2 password + + data_type: 'varchar' + is_nullable: 1 + size: 60 + +=head2 flags + + data_type: 'integer' + is_nullable: 1 + +=head2 userid + + data_type: 'varchar' + is_nullable: 1 + size: 75 + +=head2 opacnote + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 contactnote + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 sort1 + + data_type: 'varchar' + is_nullable: 1 + size: 80 + +=head2 sort2 + + data_type: 'varchar' + is_nullable: 1 + size: 80 + +=head2 altcontactfirstname + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 altcontactsurname + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 altcontactaddress1 + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 altcontactaddress2 + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 altcontactaddress3 + + data_type: 'varchar' + is_nullable: 1 + size: 255 + +=head2 altcontactstate + + data_type: 'text' + is_nullable: 1 + +=head2 altcontactzipcode + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 altcontactcountry + + data_type: 'text' + is_nullable: 1 + +=head2 altcontactphone + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 smsalertnumber + + data_type: 'varchar' + is_nullable: 1 + size: 50 + +=head2 sms_provider_id + + data_type: 'integer' + is_foreign_key: 1 + is_nullable: 1 + +=head2 privacy + + data_type: 'integer' + default_value: 1 + is_nullable: 0 + +=head2 privacy_guarantor_checkouts + + data_type: 'tinyint' + default_value: 0 + is_nullable: 0 + +=head2 checkprevcheckout + + data_type: 'varchar' + default_value: 'inherit' + is_nullable: 0 + size: 7 + +=head2 updated_on + + data_type: 'timestamp' + datetime_undef_if_invalid: 1 + default_value: current_timestamp + is_nullable: 0 + +=head2 lastseen + + data_type: 'datetime' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +=cut + +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, + "cardnumber", + { data_type => "varchar", is_nullable => 1, size => 16 }, + "surname", + { data_type => "mediumtext", is_nullable => 0 }, + "firstname", + { data_type => "text", is_nullable => 1 }, + "title", + { data_type => "mediumtext", is_nullable => 1 }, + "othernames", + { data_type => "mediumtext", is_nullable => 1 }, + "initials", + { data_type => "text", is_nullable => 1 }, + "streetnumber", + { data_type => "varchar", is_nullable => 1, size => 10 }, + "streettype", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "address", + { data_type => "mediumtext", is_nullable => 0 }, + "address2", + { data_type => "text", is_nullable => 1 }, + "city", + { data_type => "mediumtext", is_nullable => 0 }, + "state", + { data_type => "text", is_nullable => 1 }, + "zipcode", + { data_type => "varchar", is_nullable => 1, size => 25 }, + "country", + { data_type => "text", is_nullable => 1 }, + "email", + { data_type => "mediumtext", is_nullable => 1 }, + "phone", + { data_type => "text", is_nullable => 1 }, + "mobile", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "fax", + { data_type => "mediumtext", is_nullable => 1 }, + "emailpro", + { data_type => "text", is_nullable => 1 }, + "phonepro", + { data_type => "text", is_nullable => 1 }, + "B_streetnumber", + { + accessor => "b_streetnumber", + data_type => "varchar", + is_nullable => 1, + size => 10, + }, + "B_streettype", + { + accessor => "b_streettype", + data_type => "varchar", + is_nullable => 1, + size => 50, + }, + "B_address", + { + accessor => "b_address", + data_type => "varchar", + is_nullable => 1, + size => 100, + }, + "B_address2", + { accessor => "b_address2", data_type => "text", is_nullable => 1 }, + "B_city", + { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 }, + "B_state", + { accessor => "b_state", data_type => "text", is_nullable => 1 }, + "B_zipcode", + { + accessor => "b_zipcode", + data_type => "varchar", + is_nullable => 1, + size => 25, + }, + "B_country", + { accessor => "b_country", data_type => "text", is_nullable => 1 }, + "B_email", + { accessor => "b_email", data_type => "text", is_nullable => 1 }, + "B_phone", + { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 }, + "dateofbirth", + { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "branchcode", + { + data_type => "varchar", + default_value => "", + is_foreign_key => 1, + is_nullable => 0, + size => 10, + }, + "categorycode", + { + data_type => "varchar", + default_value => "", + is_foreign_key => 1, + is_nullable => 0, + size => 10, + }, + "dateenrolled", + { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "dateexpiry", + { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "gonenoaddress", + { data_type => "tinyint", is_nullable => 1 }, + "lost", + { data_type => "tinyint", is_nullable => 1 }, + "debarred", + { 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", + { data_type => "varchar", is_nullable => 1, size => 60 }, + "flags", + { data_type => "integer", is_nullable => 1 }, + "userid", + { data_type => "varchar", is_nullable => 1, size => 75 }, + "opacnote", + { data_type => "mediumtext", is_nullable => 1 }, + "contactnote", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "sort1", + { data_type => "varchar", is_nullable => 1, size => 80 }, + "sort2", + { data_type => "varchar", is_nullable => 1, size => 80 }, + "altcontactfirstname", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "altcontactsurname", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "altcontactaddress1", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "altcontactaddress2", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "altcontactaddress3", + { data_type => "varchar", is_nullable => 1, size => 255 }, + "altcontactstate", + { data_type => "text", is_nullable => 1 }, + "altcontactzipcode", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "altcontactcountry", + { data_type => "text", is_nullable => 1 }, + "altcontactphone", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "smsalertnumber", + { data_type => "varchar", is_nullable => 1, size => 50 }, + "sms_provider_id", + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, + "privacy", + { data_type => "integer", default_value => 1, is_nullable => 0 }, + "privacy_guarantor_checkouts", + { data_type => "tinyint", default_value => 0, is_nullable => 0 }, + "checkprevcheckout", + { + data_type => "varchar", + default_value => "inherit", + is_nullable => 0, + size => 7, + }, + "updated_on", + { + data_type => "timestamp", + datetime_undef_if_invalid => 1, + default_value => \"current_timestamp", + is_nullable => 0, + }, + "lastseen", + { + data_type => "datetime", + datetime_undef_if_invalid => 1, + is_nullable => 1, + }, +); + +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("borrowernumber"); + +=head1 UNIQUE CONSTRAINTS + +=head2 C + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]); + +=head2 C + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->add_unique_constraint("userid", ["userid"]); + +=head1 RELATIONS + +=head2 accountlines + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "accountlines", + "Koha::Schema::Result::Accountline", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 accountoffsets + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "accountoffsets", + "Koha::Schema::Result::Accountoffset", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 aqbasketusers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "aqbasketusers", + "Koha::Schema::Result::Aqbasketuser", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 aqbudgetborrowers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "aqbudgetborrowers", + "Koha::Schema::Result::Aqbudgetborrower", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 aqorder_users + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "aqorder_users", + "Koha::Schema::Result::AqorderUser", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 article_requests + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "article_requests", + "Koha::Schema::Result::ArticleRequest", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_attributes + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_attributes", + "Koha::Schema::Result::BorrowerAttribute", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_debarments + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_debarments", + "Koha::Schema::Result::BorrowerDebarment", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_files + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_files", + "Koha::Schema::Result::BorrowerFile", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_message_preferences + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_message_preferences", + "Koha::Schema::Result::BorrowerMessagePreference", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_syncs + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_syncs", + "Koha::Schema::Result::BorrowerSync", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branchcode + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "branchcode", + "Koha::Schema::Result::Branch", + { branchcode => "branchcode" }, + { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, +); + +=head2 categorycode + +Type: belongs_to + +Related object: L + +=cut + +__PACKAGE__->belongs_to( + "categorycode", + "Koha::Schema::Result::Category", + { categorycode => "categorycode" }, + { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" }, +); + +=head2 course_instructors + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "course_instructors", + "Koha::Schema::Result::CourseInstructor", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 creator_batches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "creator_batches", + "Koha::Schema::Result::CreatorBatch", + { "foreign.borrower_number" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 discharges + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "discharges", + "Koha::Schema::Result::Discharge", + { "foreign.borrower" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 hold_fill_targets + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "hold_fill_targets", + "Koha::Schema::Result::HoldFillTarget", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 housebound_profile + +Type: might_have + +Related object: L + +=cut + +__PACKAGE__->might_have( + "housebound_profile", + "Koha::Schema::Result::HouseboundProfile", + { "foreign.borrowernumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 housebound_role + +Type: might_have + +Related object: L + +=cut + +__PACKAGE__->might_have( + "housebound_role", + "Koha::Schema::Result::HouseboundRole", + { "foreign.borrowernumber_id" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 housebound_visit_chooser_brwnumbers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "housebound_visit_chooser_brwnumbers", + "Koha::Schema::Result::HouseboundVisit", + { "foreign.chooser_brwnumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 housebound_visit_deliverer_brwnumbers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "housebound_visit_deliverer_brwnumbers", + "Koha::Schema::Result::HouseboundVisit", + { "foreign.deliverer_brwnumber" => "self.borrowernumber" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 issues Type: has_many @@ -1348,3 +2709,16 @@ sub koha_objects_class { } 1; +# End of lines loaded from '/home/alex/src/koha/Koha/Schema/Result/Borrower.pm' + +__PACKAGE__->belongs_to( + "guarantor", + "Koha::Schema::Result::Borrower", + { borrowernumber => "guarantorid" }, +); + +sub koha_objects_class { + 'Koha::Patrons'; +} + +1; diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm index ec44cde..4bf0344 100644 --- a/Koha/Schema/Result/Branch.pm +++ b/Koha/Schema/Result/Branch.pm @@ -442,6 +442,576 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 illrequests + +Type: has_many + +Related object: L + +=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 + +Related object: L + +=cut + +__PACKAGE__->has_many( + "items_holdingbranches", + "Koha::Schema::Result::Item", + { "foreign.holdingbranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 items_homebranches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "items_homebranches", + "Koha::Schema::Result::Item", + { "foreign.homebranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 opac_news + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "opac_news", + "Koha::Schema::Result::OpacNews", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 reserves + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "reserves", + "Koha::Schema::Result::Reserve", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 transport_cost_frombranches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "transport_cost_frombranches", + "Koha::Schema::Result::TransportCost", + { "foreign.frombranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 transport_cost_tobranches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "transport_cost_tobranches", + "Koha::Schema::Result::TransportCost", + { "foreign.tobranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 categorycodes + +Type: many_to_many + +Composing rels: L -> categorycode + +=cut + +__PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); + + +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-02-03 16:55:44 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pWB4xcUOQAG7MrlZVbvwqw +# These lines were loaded from '/home/alex/src/koha/Koha/Schema/Result/Branch.pm' found in @INC. +# They are now part of the custom portion of this file +# for you to hand-edit. If you do not either delete +# this section or remove that file from @INC, this section +# will be repeated redundantly when you re-create this +# file again via Loader! See skip_load_external to disable +# this feature. + +use utf8; +package Koha::Schema::Result::Branch; + +# Created by DBIx::Class::Schema::Loader +# DO NOT MODIFY THE FIRST PART OF THIS FILE + +=head1 NAME + +Koha::Schema::Result::Branch + +=cut + +use strict; +use warnings; + +use base 'DBIx::Class::Core'; + +=head1 TABLE: C + +=cut + +__PACKAGE__->table("branches"); + +=head1 ACCESSORS + +=head2 branchcode + + data_type: 'varchar' + default_value: (empty string) + is_nullable: 0 + size: 10 + +=head2 branchname + + data_type: 'mediumtext' + is_nullable: 0 + +=head2 branchaddress1 + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchaddress2 + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchaddress3 + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchzip + + data_type: 'varchar' + is_nullable: 1 + size: 25 + +=head2 branchcity + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchstate + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchcountry + + data_type: 'text' + is_nullable: 1 + +=head2 branchphone + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchfax + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchemail + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchreplyto + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchreturnpath + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 branchurl + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 issuing + + data_type: 'tinyint' + is_nullable: 1 + +=head2 branchip + + data_type: 'varchar' + is_nullable: 1 + size: 15 + +=head2 branchprinter + + data_type: 'varchar' + is_nullable: 1 + size: 100 + +=head2 branchnotes + + data_type: 'mediumtext' + is_nullable: 1 + +=head2 opac_info + + data_type: 'text' + is_nullable: 1 + +=cut + +__PACKAGE__->add_columns( + "branchcode", + { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, + "branchname", + { data_type => "mediumtext", is_nullable => 0 }, + "branchaddress1", + { data_type => "mediumtext", is_nullable => 1 }, + "branchaddress2", + { data_type => "mediumtext", is_nullable => 1 }, + "branchaddress3", + { data_type => "mediumtext", is_nullable => 1 }, + "branchzip", + { data_type => "varchar", is_nullable => 1, size => 25 }, + "branchcity", + { data_type => "mediumtext", is_nullable => 1 }, + "branchstate", + { data_type => "mediumtext", is_nullable => 1 }, + "branchcountry", + { data_type => "text", is_nullable => 1 }, + "branchphone", + { data_type => "mediumtext", is_nullable => 1 }, + "branchfax", + { data_type => "mediumtext", is_nullable => 1 }, + "branchemail", + { data_type => "mediumtext", is_nullable => 1 }, + "branchreplyto", + { data_type => "mediumtext", is_nullable => 1 }, + "branchreturnpath", + { data_type => "mediumtext", is_nullable => 1 }, + "branchurl", + { data_type => "mediumtext", is_nullable => 1 }, + "issuing", + { data_type => "tinyint", is_nullable => 1 }, + "branchip", + { data_type => "varchar", is_nullable => 1, size => 15 }, + "branchprinter", + { data_type => "varchar", is_nullable => 1, size => 100 }, + "branchnotes", + { data_type => "mediumtext", is_nullable => 1 }, + "opac_info", + { data_type => "text", is_nullable => 1 }, +); + +=head1 PRIMARY KEY + +=over 4 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("branchcode"); + +=head1 RELATIONS + +=head2 aqbaskets + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "aqbaskets", + "Koha::Schema::Result::Aqbasket", + { "foreign.branch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 article_requests + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "article_requests", + "Koha::Schema::Result::ArticleRequest", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 authorised_values_branches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "authorised_values_branches", + "Koha::Schema::Result::AuthorisedValuesBranch", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrower_attribute_types_branches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrower_attribute_types_branches", + "Koha::Schema::Result::BorrowerAttributeTypesBranch", + { "foreign.b_branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 borrowers + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "borrowers", + "Koha::Schema::Result::Borrower", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branch_borrower_circ_rules + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "branch_borrower_circ_rules", + "Koha::Schema::Result::BranchBorrowerCircRule", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branch_item_rules + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "branch_item_rules", + "Koha::Schema::Result::BranchItemRule", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branchrelations + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "branchrelations", + "Koha::Schema::Result::Branchrelation", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branchtransfers_frombranches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "branchtransfers_frombranches", + "Koha::Schema::Result::Branchtransfer", + { "foreign.frombranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 branchtransfers_tobranches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "branchtransfers_tobranches", + "Koha::Schema::Result::Branchtransfer", + { "foreign.tobranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 categories_branches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "categories_branches", + "Koha::Schema::Result::CategoriesBranch", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 collections + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "collections", + "Koha::Schema::Result::Collection", + { "foreign.colBranchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 course_items + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "course_items", + "Koha::Schema::Result::CourseItem", + { "foreign.holdingbranch" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 creator_batches + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "creator_batches", + "Koha::Schema::Result::CreatorBatch", + { "foreign.branch_code" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 default_branch_circ_rule + +Type: might_have + +Related object: L + +=cut + +__PACKAGE__->might_have( + "default_branch_circ_rule", + "Koha::Schema::Result::DefaultBranchCircRule", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 edifact_eans + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "edifact_eans", + "Koha::Schema::Result::EdifactEan", + { "foreign.branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + +=head2 hold_fill_targets + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "hold_fill_targets", + "Koha::Schema::Result::HoldFillTarget", + { "foreign.source_branchcode" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 items_holdingbranches Type: has_many @@ -502,6 +1072,21 @@ __PACKAGE__->has_many( { cascade_copy => 0, cascade_delete => 0 }, ); +=head2 stockrotationstages + +Type: has_many + +Related object: L + +=cut + +__PACKAGE__->has_many( + "stockrotationstages", + "Koha::Schema::Result::Stockrotationstage", + { "foreign.branchcode_id" => "self.branchcode" }, + { cascade_copy => 0, cascade_delete => 0 }, +); + =head2 transport_cost_frombranches Type: has_many @@ -543,8 +1128,18 @@ Composing rels: L -> categorycode __PACKAGE__->many_to_many("categorycodes", "branchrelations", "categorycode"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/9YwsU+GXK+fzc6IX2Tj5g +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-12 17:01:45 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ug0wv4pEEOJ8q8WuD+HQVA + + +# You can replace this text with custom code or comments, and it will be preserved on regeneration + +sub koha_objects_class { + 'Koha::Libraries'; +} + +1; +# End of lines loaded from '/home/alex/src/koha/Koha/Schema/Result/Branch.pm' # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm new file mode 100644 index 0000000..81b3322 --- /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 + +=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 + +=back + +=cut + +__PACKAGE__->set_primary_key("illrequest_id"); + +=head1 RELATIONS + +=head2 borrowernumber + +Type: belongs_to + +Related object: L + +=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 + +=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 + +=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-03 16:31:16 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vb/fWCE2riLlSNJPS+KL7w + + +# 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..29598cc --- /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 + +=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 + +=item * L + +=back + +=cut + +__PACKAGE__->set_primary_key("illrequest_id", "type"); + +=head1 RELATIONS + +=head2 illrequest + +Type: belongs_to + +Related object: L + +=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-03 16:31:16 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2QDst/4XUeffLXHbVlOUVg + + +# You can replace this text with custom code or comments, and it will be preserved on regeneration +1; -- 2.1.4