Bugzilla – Attachment 115539 Details for
Bug 26995
Drop column relationship from borrower tables
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 26995: Update schema [DO NOT PUSH]
Bug-26995-Update-schema-DO-NOT-PUSH.patch (text/plain), 237.70 KB, created by
Kyle M Hall (khall)
on 2021-01-21 12:24:49 UTC
(
hide
)
Description:
Bug 26995: Update schema [DO NOT PUSH]
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2021-01-21 12:24:49 UTC
Size:
237.70 KB
patch
obsolete
>From 823b6f7ff94adf93a11a524d51435c00fcc8dc21 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Thu, 21 Jan 2021 06:57:42 -0500 >Subject: [PATCH] Bug 26995: Update schema [DO NOT PUSH] > >--- > Koha/Schema/Result/AccountCreditType.pm | 6 +- > Koha/Schema/Result/AccountDebitType.pm | 10 +- > Koha/Schema/Result/AccountOffset.pm | 14 +- > Koha/Schema/Result/AccountOffsetType.pm | 6 +- > Koha/Schema/Result/Accountline.pm | 8 +- > Koha/Schema/Result/ActionLog.pm | 20 ++- > Koha/Schema/Result/AdditionalField.pm | 16 +- > Koha/Schema/Result/AdditionalFieldValue.pm | 12 +- > Koha/Schema/Result/AdvancedEditorMacro.pm | 14 +- > Koha/Schema/Result/ApiKey.pm | 14 +- > Koha/Schema/Result/Aqbasket.pm | 36 +++- > Koha/Schema/Result/Aqbookseller.pm | 46 ++++- > Koha/Schema/Result/Aqbudget.pm | 34 +++- > Koha/Schema/Result/Aqbudgetperiod.pm | 22 ++- > Koha/Schema/Result/Aqcontact.pm | 30 +++- > Koha/Schema/Result/Aqinvoice.pm | 22 ++- > Koha/Schema/Result/AqinvoiceAdjustment.pm | 20 ++- > Koha/Schema/Result/Aqorder.pm | 98 ++++++++++- > Koha/Schema/Result/AqorderUser.pm | 8 +- > Koha/Schema/Result/AqordersClaim.pm | 10 +- > Koha/Schema/Result/AqordersItem.pm | 10 +- > Koha/Schema/Result/ArticleRequest.pm | 6 +- > Koha/Schema/Result/AuthorisedValue.pm | 16 +- > Koha/Schema/Result/Biblio.pm | 34 +++- > Koha/Schema/Result/BiblioFramework.pm | 8 +- > Koha/Schema/Result/Biblioitem.pm | 36 +++- > Koha/Schema/Result/Borrower.pm | 160 +++++++++++++++++- > Koha/Schema/Result/BorrowerAttribute.pm | 12 +- > Koha/Schema/Result/BorrowerAttributeType.pm | 30 +++- > Koha/Schema/Result/BorrowerDebarment.pm | 20 ++- > Koha/Schema/Result/BorrowerFile.pm | 18 +- > Koha/Schema/Result/BorrowerModification.pm | 14 +- > .../Schema/Result/BorrowerPasswordRecovery.pm | 10 +- > Koha/Schema/Result/Branch.pm | 50 +++++- > Koha/Schema/Result/Branchtransfer.pm | 22 ++- > Koha/Schema/Result/CashRegister.pm | 18 +- > Koha/Schema/Result/CashRegisterAction.pm | 14 +- > Koha/Schema/Result/Category.pm | 46 ++++- > Koha/Schema/Result/City.pm | 14 +- > Koha/Schema/Result/ClubHold.pm | 12 +- > Koha/Schema/Result/Collection.pm | 6 +- > Koha/Schema/Result/Course.pm | 24 ++- > Koha/Schema/Result/CourseInstructor.pm | 8 +- > Koha/Schema/Result/CourseItem.pm | 40 ++++- > Koha/Schema/Result/CourseReserve.pm | 12 +- > Koha/Schema/Result/CoverImage.pm | 18 +- > Koha/Schema/Result/Deletedbiblio.pm | 34 +++- > Koha/Schema/Result/Deletedbiblioitem.pm | 36 +++- > Koha/Schema/Result/Deletedborrower.pm | 160 +++++++++++++++++- > Koha/Schema/Result/Deleteditem.pm | 92 +++++++++- > Koha/Schema/Result/Desk.pm | 10 +- > Koha/Schema/Result/HouseboundProfile.pm | 20 ++- > Koha/Schema/Result/HouseboundRole.pm | 10 +- > Koha/Schema/Result/HouseboundVisit.pm | 16 +- > Koha/Schema/Result/Illcomment.pm | 14 +- > Koha/Schema/Result/Illrequest.pm | 38 ++++- > Koha/Schema/Result/Illrequestattribute.pm | 12 +- > Koha/Schema/Result/ImportBatch.pm | 30 +++- > Koha/Schema/Result/ImportBatchProfile.pm | 28 ++- > Koha/Schema/Result/ImportRecordMatch.pm | 10 +- > Koha/Schema/Result/Issue.pm | 40 ++++- > Koha/Schema/Result/Item.pm | 92 +++++++++- > Koha/Schema/Result/Itemtype.pm | 40 ++++- > Koha/Schema/Result/LanguageScriptBidi.pm | 8 +- > Koha/Schema/Result/LanguageSubtagRegistry.pm | 8 +- > Koha/Schema/Result/Letter.pm | 24 ++- > Koha/Schema/Result/LibraryGroup.pm | 26 ++- > Koha/Schema/Result/Linktracker.pm | 16 +- > Koha/Schema/Result/Localization.pm | 6 +- > Koha/Schema/Result/Message.pm | 18 +- > Koha/Schema/Result/MiscFile.pm | 20 ++- > Koha/Schema/Result/NeedMergeAuthority.pm | 14 +- > Koha/Schema/Result/OauthAccessToken.pm | 10 +- > Koha/Schema/Result/OldIssue.pm | 40 ++++- > Koha/Schema/Result/OldReserve.pm | 50 +++++- > Koha/Schema/Result/OpacNews.pm | 24 ++- > Koha/Schema/Result/Overduerule.pm | 28 ++- > Koha/Schema/Result/PatronConsent.pm | 6 +- > Koha/Schema/Result/PatronList.pm | 10 +- > Koha/Schema/Result/PatronListPatron.pm | 10 +- > Koha/Schema/Result/Patronimage.pm | 10 +- > Koha/Schema/Result/ProblemReport.pm | 24 ++- > .../Result/PseudonymizedBorrowerAttribute.pm | 10 +- > Koha/Schema/Result/Quote.pm | 12 +- > Koha/Schema/Result/Rating.pm | 10 +- > Koha/Schema/Result/RepeatableHoliday.pm | 18 +- > Koha/Schema/Result/ReportsDictionary.pm | 18 +- > Koha/Schema/Result/Reserve.pm | 44 ++++- > Koha/Schema/Result/ReturnClaim.pm | 28 ++- > Koha/Schema/Result/Review.pm | 16 +- > Koha/Schema/Result/SavedSql.pm | 20 ++- > Koha/Schema/Result/SearchHistory.pm | 20 ++- > Koha/Schema/Result/Serial.pm | 34 +++- > Koha/Schema/Result/SpecialHoliday.pm | 20 ++- > Koha/Schema/Result/Statistic.pm | 24 ++- > Koha/Schema/Result/Stockrotationitem.pm | 12 +- > Koha/Schema/Result/Stockrotationrota.pm | 14 +- > Koha/Schema/Result/Stockrotationstage.pm | 14 +- > Koha/Schema/Result/Subscription.pm | 56 +++++- > Koha/Schema/Result/Subscriptionroutinglist.pm | 12 +- > Koha/Schema/Result/Suggestion.pm | 68 +++++++- > Koha/Schema/Result/Systempreference.pm | 14 +- > Koha/Schema/Result/TagAll.pm | 16 +- > Koha/Schema/Result/TagsApproval.pm | 14 +- > Koha/Schema/Result/TagsIndex.pm | 10 +- > Koha/Schema/Result/Virtualshelfcontent.pm | 12 +- > Koha/Schema/Result/Virtualshelfshare.pm | 14 +- > Koha/Schema/Result/Virtualshelve.pm | 22 ++- > Koha/Schema/Result/Z3950server.pm | 40 ++++- > 109 files changed, 2490 insertions(+), 240 deletions(-) > >diff --git a/Koha/Schema/Result/AccountCreditType.pm b/Koha/Schema/Result/AccountCreditType.pm >index 602b1fd7e9..b71e3ba7f9 100644 >--- a/Koha/Schema/Result/AccountCreditType.pm >+++ b/Koha/Schema/Result/AccountCreditType.pm >@@ -61,6 +61,8 @@ Is autogeneration of credit number enabled for this credit type > default_value: 0 > is_nullable: 0 > >+boolean flag to denote if this till is archived or not >+ > =cut > > __PACKAGE__->add_columns( >@@ -123,8 +125,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GESL9hjEPlrQBiuHO4haAw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:68pbi2+RgkjSrfSudDNAfA > > __PACKAGE__->add_columns( > '+is_system' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/AccountDebitType.pm b/Koha/Schema/Result/AccountDebitType.pm >index 8772813c2e..56f732e826 100644 >--- a/Koha/Schema/Result/AccountDebitType.pm >+++ b/Koha/Schema/Result/AccountDebitType.pm >@@ -41,12 +41,16 @@ __PACKAGE__->table("account_debit_types"); > default_value: 1 > is_nullable: 0 > >+boolean flag to denote if this debit type is available for manual invoicing >+ > =head2 can_be_sold > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+boolean flag to denote if this debit type is available at point of sale >+ > =head2 default_amount > > data_type: 'decimal' >@@ -65,6 +69,8 @@ __PACKAGE__->table("account_debit_types"); > default_value: 0 > is_nullable: 0 > >+boolean flag to denote if this till is archived or not >+ > =cut > > __PACKAGE__->add_columns( >@@ -129,8 +135,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-17 12:22:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8FIMJZ+JAmqa+Dx7oymBjw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mAzmSdW6jeYlUOqv7lIr1Q > > __PACKAGE__->add_columns( > '+is_system' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/AccountOffset.pm b/Koha/Schema/Result/AccountOffset.pm >index 02751ae83a..5f65322b10 100644 >--- a/Koha/Schema/Result/AccountOffset.pm >+++ b/Koha/Schema/Result/AccountOffset.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("account_offsets"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for each offset >+ > =head2 credit_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+The id of the accountline the increased the patron's balance >+ > =head2 debit_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+The id of the accountline that decreased the patron's balance >+ > =head2 type > > data_type: 'varchar' >@@ -48,12 +54,16 @@ __PACKAGE__->table("account_offsets"); > is_nullable: 0 > size: 16 > >+The type of offset this is >+ > =head2 amount > > data_type: 'decimal' > is_nullable: 0 > size: [26,6] > >+The amount of the change >+ > =head2 created_on > > data_type: 'timestamp' >@@ -153,8 +163,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-20 16:27:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tPPrIug2c7PbDO7LCxCJAA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HZp7Ilze0sIkVqhsErC2kQ > > sub koha_object_class { > 'Koha::Account::Offset'; >diff --git a/Koha/Schema/Result/AccountOffsetType.pm b/Koha/Schema/Result/AccountOffsetType.pm >index fd62a02969..c61e44d70d 100644 >--- a/Koha/Schema/Result/AccountOffsetType.pm >+++ b/Koha/Schema/Result/AccountOffsetType.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("account_offset_types"); > is_nullable: 0 > size: 16 > >+The type of offset this is >+ > =cut > > __PACKAGE__->add_columns( >@@ -66,8 +68,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-20 16:27:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rPRWMfAfRke3jGG3iISi2A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IhGFWPAnwAb88g3BBUe01Q > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm >index 3a5a48cb99..5f21a0a14b 100644 >--- a/Koha/Schema/Result/Accountline.pm >+++ b/Koha/Schema/Result/Accountline.pm >@@ -97,6 +97,8 @@ autogenerated number for credits > is_nullable: 1 > size: 80 > >+optional authorised value PAYMENT_TYPE >+ > =head2 amountoutstanding > > data_type: 'decimal' >@@ -140,6 +142,8 @@ autogenerated number for credits > is_nullable: 1 > size: 10 > >+the branchcode of the library where a payment was made, a manual invoice created, etc. >+ > =cut > > __PACKAGE__->add_columns( >@@ -377,8 +381,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-06-25 09:19:20 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I/S3NLbod+8BgBMcwYz+cA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/Ve0Q3xBSkKamXG+2roUZw > > =head2 library > >diff --git a/Koha/Schema/Result/ActionLog.pm b/Koha/Schema/Result/ActionLog.pm >index 78236ea9eb..c48b0311fd 100644 >--- a/Koha/Schema/Result/ActionLog.pm >+++ b/Koha/Schema/Result/ActionLog.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("action_logs"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for each action >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -36,38 +38,52 @@ __PACKAGE__->table("action_logs"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time the action took place >+ > =head2 user > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+the staff member who performed the action (borrowers.borrowernumber) >+ > =head2 module > > data_type: 'mediumtext' > is_nullable: 1 > >+the module this action was taken against >+ > =head2 action > > data_type: 'mediumtext' > is_nullable: 1 > >+the action (includes things like DELETED, ADDED, MODIFY, etc) >+ > =head2 object > > data_type: 'integer' > is_nullable: 1 > >+the object that the action was taken against (could be a borrowernumber, itemnumber, etc) >+ > =head2 info > > data_type: 'mediumtext' > is_nullable: 1 > >+information about the action (usually includes SQL statement) >+ > =head2 interface > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+the context this action was taken in >+ > =cut > > __PACKAGE__->add_columns( >@@ -107,8 +123,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("action_id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VVXBchLYkj+S+lLhl7bKgw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AD9G0KiiFUmhsS9m8O1Z+w > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/AdditionalField.pm b/Koha/Schema/Result/AdditionalField.pm >index 6a9b1e54b2..afd2c2a31a 100644 >--- a/Koha/Schema/Result/AdditionalField.pm >+++ b/Koha/Schema/Result/AdditionalField.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("additional_fields"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key identifier >+ > =head2 tablename > > data_type: 'varchar' >@@ -36,6 +38,8 @@ __PACKAGE__->table("additional_fields"); > is_nullable: 0 > size: 255 > >+tablename of the new field >+ > =head2 name > > data_type: 'varchar' >@@ -43,6 +47,8 @@ __PACKAGE__->table("additional_fields"); > is_nullable: 0 > size: 255 > >+name of the field >+ > =head2 authorised_value_category > > data_type: 'varchar' >@@ -50,6 +56,8 @@ __PACKAGE__->table("additional_fields"); > is_nullable: 0 > size: 16 > >+is an authorised value category >+ > =head2 marcfield > > data_type: 'varchar' >@@ -57,12 +65,16 @@ __PACKAGE__->table("additional_fields"); > is_nullable: 0 > size: 16 > >+contains the marc field to copied into the record >+ > =head2 searchable > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+is the field searchable? >+ > =cut > > __PACKAGE__->add_columns( >@@ -126,8 +138,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-02 15:12:02 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vvz9GJNkU4K7bftDNuRHVA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0MjMrOzpCHJGtrwtLzF7Hw > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/AdditionalFieldValue.pm b/Koha/Schema/Result/AdditionalFieldValue.pm >index 9dd368d783..a4ce2786a0 100644 >--- a/Koha/Schema/Result/AdditionalFieldValue.pm >+++ b/Koha/Schema/Result/AdditionalFieldValue.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("additional_field_values"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key identifier >+ > =head2 field_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key references additional_fields(id) >+ > =head2 record_id > > data_type: 'integer' > is_nullable: 0 > >+record_id >+ > =head2 value > > data_type: 'varchar' >@@ -47,6 +53,8 @@ __PACKAGE__->table("additional_field_values"); > is_nullable: 0 > size: 255 > >+value for this field >+ > =cut > > __PACKAGE__->add_columns( >@@ -106,8 +114,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-02 15:12:02 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a9G6nhDU9dBDcRRN0vzkLA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nx5E23ZVUbLOGfBgLYIIQQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/AdvancedEditorMacro.pm b/Koha/Schema/Result/AdvancedEditorMacro.pm >index 7c5448bd94..88ff46ed2e 100644 >--- a/Koha/Schema/Result/AdvancedEditorMacro.pm >+++ b/Koha/Schema/Result/AdvancedEditorMacro.pm >@@ -29,29 +29,39 @@ __PACKAGE__->table("advanced_editor_macros"); > is_auto_increment: 1 > is_nullable: 0 > >+Unique ID of the macro >+ > =head2 name > > data_type: 'varchar' > is_nullable: 0 > size: 80 > >+Name of the macro >+ > =head2 macro > > data_type: 'longtext' > is_nullable: 1 > >+The macro code itself >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+ID of the borrower who created this macro >+ > =head2 shared > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+Bit to define if shared or private macro >+ > =cut > > __PACKAGE__->add_columns( >@@ -102,8 +112,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-02 15:01:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wx556VlgXYqdP2XyQ87Jzg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hE2MSdkkb71NoBpDM1jo5A > > __PACKAGE__->add_columns( > '+shared' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/ApiKey.pm b/Koha/Schema/Result/ApiKey.pm >index f8e091fbb7..538986cf9c 100644 >--- a/Koha/Schema/Result/ApiKey.pm >+++ b/Koha/Schema/Result/ApiKey.pm >@@ -29,30 +29,40 @@ __PACKAGE__->table("api_keys"); > is_nullable: 0 > size: 191 > >+API client ID >+ > =head2 secret > > data_type: 'varchar' > is_nullable: 0 > size: 191 > >+API client secret used for API authentication >+ > =head2 description > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+API client description >+ > =head2 patron_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+Foreign key to the borrowers table >+ > =head2 active > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+0 means this API key is revoked >+ > =cut > > __PACKAGE__->add_columns( >@@ -112,8 +122,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-04-14 14:48:10 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qnu4QSACpOSQaZgd52ozmw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wt1nC+nAMD9+zcNi9YbTEQ > > __PACKAGE__->add_columns( > '+active' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/Aqbasket.pm b/Koha/Schema/Result/Aqbasket.pm >index 60d5633a58..72a69c0ae4 100644 >--- a/Koha/Schema/Result/Aqbasket.pm >+++ b/Koha/Schema/Result/Aqbasket.pm >@@ -29,40 +29,54 @@ __PACKAGE__->table("aqbasket"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key, Koha defined number >+ > =head2 basketname > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+name given to the basket at creation >+ > =head2 note > > data_type: 'longtext' > is_nullable: 1 > >+the internal note added at basket creation >+ > =head2 booksellernote > > data_type: 'longtext' > is_nullable: 1 > >+the vendor note added at basket creation >+ > =head2 contractnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+links this basket to the aqcontract table (aqcontract.contractnumber) >+ > =head2 creationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the basket was created >+ > =head2 closedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the basket was closed >+ > =head2 booksellerid > > data_type: 'integer' >@@ -70,35 +84,47 @@ __PACKAGE__->table("aqbasket"); > is_foreign_key: 1 > is_nullable: 0 > >+the Koha assigned ID for the vendor (aqbooksellers.id) >+ > =head2 authorisedby > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+the borrowernumber of the person who created the basket >+ > =head2 booksellerinvoicenumber > > data_type: 'longtext' > is_nullable: 1 > >+appears to always be NULL >+ > =head2 basketgroupid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+links this basket to its group (aqbasketgroups.id) >+ > =head2 deliveryplace > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+basket delivery place >+ > =head2 billingplace > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+basket billing place >+ > =head2 branch > > data_type: 'varchar' >@@ -106,18 +132,24 @@ __PACKAGE__->table("aqbasket"); > is_nullable: 1 > size: 10 > >+basket branch >+ > =head2 is_standing > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+orders in this basket are standing >+ > =head2 create_items > > data_type: 'enum' > extra: {list => ["ordering","receiving","cataloguing"]} > is_nullable: 1 > >+when items should be created for orders in this basket >+ > =cut > > __PACKAGE__->add_columns( >@@ -309,8 +341,8 @@ Composing rels: L</aqbasketusers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSw/f4JmMBzEssEFRg2fAQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Alq0lbSwRP7DUVIHJoHZpQ > > __PACKAGE__->has_many( > "additional_field_values", >diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm >index a9bf2e51bd..b5429e8b6a 100644 >--- a/Koha/Schema/Result/Aqbookseller.pm >+++ b/Koha/Schema/Result/Aqbookseller.pm >@@ -29,63 +29,87 @@ __PACKAGE__->table("aqbooksellers"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique identifier assigned by Koha >+ > =head2 name > > data_type: 'longtext' > is_nullable: 0 > >+vendor name >+ > =head2 address1 > > data_type: 'longtext' > is_nullable: 1 > >+first line of vendor physical address >+ > =head2 address2 > > data_type: 'longtext' > is_nullable: 1 > >+second line of vendor physical address >+ > =head2 address3 > > data_type: 'longtext' > is_nullable: 1 > >+third line of vendor physical address >+ > =head2 address4 > > data_type: 'longtext' > is_nullable: 1 > >+fourth line of vendor physical address >+ > =head2 phone > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+vendor phone number >+ > =head2 accountnumber > > data_type: 'longtext' > is_nullable: 1 > >+vendor account number >+ > =head2 notes > > data_type: 'longtext' > is_nullable: 1 > >+order notes >+ > =head2 postal > > data_type: 'longtext' > is_nullable: 1 > >+vendor postal address (all lines) >+ > =head2 url > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+vendor web address >+ > =head2 active > > data_type: 'tinyint' > is_nullable: 1 > >+is this vendor active (1 for yes, 0 for no) >+ > =head2 listprice > > data_type: 'varchar' >@@ -93,6 +117,8 @@ __PACKAGE__->table("aqbooksellers"); > is_nullable: 1 > size: 10 > >+currency code for list prices >+ > =head2 invoiceprice > > data_type: 'varchar' >@@ -100,44 +126,60 @@ __PACKAGE__->table("aqbooksellers"); > is_nullable: 1 > size: 10 > >+currency code for invoice prices >+ > =head2 gstreg > > data_type: 'tinyint' > is_nullable: 1 > >+is your library charged tax (1 for yes, 0 for no) >+ > =head2 listincgst > > data_type: 'tinyint' > is_nullable: 1 > >+is tax included in list prices (1 for yes, 0 for no) >+ > =head2 invoiceincgst > > data_type: 'tinyint' > is_nullable: 1 > >+is tax included in invoice prices (1 for yes, 0 for no) >+ > =head2 tax_rate > > data_type: 'decimal' > is_nullable: 1 > size: [6,4] > >+the tax rate the library is charged >+ > =head2 discount > > data_type: 'float' > is_nullable: 1 > size: [6,4] > >+discount offered on all items ordered from this vendor >+ > =head2 fax > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+vendor fax number >+ > =head2 deliverytime > > data_type: 'integer' > is_nullable: 1 > >+vendor delivery time >+ > =cut > > __PACKAGE__->add_columns( >@@ -345,8 +387,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-17 08:54:13 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1lSFcy25po9EBzkNkjL5UA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rKz25TwTWSmdrEgVCrVbMQ > > __PACKAGE__->add_columns( > '+active' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm >index e645e55432..6c1cb826f2 100644 >--- a/Koha/Schema/Result/Aqbudget.pm >+++ b/Koha/Schema/Result/Aqbudget.pm >@@ -29,29 +29,39 @@ __PACKAGE__->table("aqbudgets"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique number assigned to each fund by Koha >+ > =head2 budget_parent_id > > data_type: 'integer' > is_nullable: 1 > >+if this fund is a child of another this will include the parent id (aqbudgets.budget_id) >+ > =head2 budget_code > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+code assigned to the fund by the user >+ > =head2 budget_name > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+name assigned to the fund by the user >+ > =head2 budget_branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+branch that this fund belongs to (branches.branchcode) >+ > =head2 budget_amount > > data_type: 'decimal' >@@ -59,6 +69,8 @@ __PACKAGE__->table("aqbudgets"); > is_nullable: 1 > size: [28,6] > >+total amount for this fund >+ > =head2 budget_encumb > > data_type: 'decimal' >@@ -66,6 +78,8 @@ __PACKAGE__->table("aqbudgets"); > is_nullable: 1 > size: [28,6] > >+budget warning at percentage >+ > =head2 budget_expend > > data_type: 'decimal' >@@ -73,11 +87,15 @@ __PACKAGE__->table("aqbudgets"); > is_nullable: 1 > size: [28,6] > >+budget warning at amount >+ > =head2 budget_notes > > data_type: 'longtext' > is_nullable: 1 > >+notes related to this fund >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -85,35 +103,47 @@ __PACKAGE__->table("aqbudgets"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this fund was last touched (created or modified) >+ > =head2 budget_period_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) >+ > =head2 sort1_authcat > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+statistical category for this fund >+ > =head2 sort2_authcat > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+second statistical category for this fund >+ > =head2 budget_owner_id > > data_type: 'integer' > is_nullable: 1 > >+borrowernumber of the person who owns this fund (borrowers.borrowernumber) >+ > =head2 budget_permission > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+level of permission for this fund (used only by the owner, only by the library, or anyone) >+ > =cut > > __PACKAGE__->add_columns( >@@ -319,8 +349,8 @@ Composing rels: L</aqbudgetborrowers> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kmzXRyD6aNqPr5C6u9GBHA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vmww5X6TKh/6iWnXt+xc1w > > __PACKAGE__->belongs_to( > "budget", >diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm >index 5ae2c98e81..03980ae568 100644 >--- a/Koha/Schema/Result/Aqbudgetperiod.pm >+++ b/Koha/Schema/Result/Aqbudgetperiod.pm >@@ -29,52 +29,70 @@ __PACKAGE__->table("aqbudgetperiods"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique number assigned by Koha >+ > =head2 budget_period_startdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+date when the budget starts >+ > =head2 budget_period_enddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+date when the budget ends >+ > =head2 budget_period_active > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+whether this budget is active or not (1 for yes, 0 for no) >+ > =head2 budget_period_description > > data_type: 'longtext' > is_nullable: 1 > >+description assigned to this budget >+ > =head2 budget_period_total > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+total amount available in this budget >+ > =head2 budget_period_locked > > data_type: 'tinyint' > is_nullable: 1 > >+whether this budget is locked or not (1 for yes, 0 for no) >+ > =head2 sort1_authcat > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+statistical category for this budget >+ > =head2 sort2_authcat > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+second statistical category for this budget >+ > =cut > > __PACKAGE__->add_columns( >@@ -128,8 +146,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-13 23:03:50 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0xS/Pc8hoKlNKfW9zDd4Gg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hWHx+2tHfiRhRqj3YchPnw > > sub koha_object_class { > 'Koha::Acquisition::Budget'; >diff --git a/Koha/Schema/Result/Aqcontact.pm b/Koha/Schema/Result/Aqcontact.pm >index 0de8efc761..a802259d39 100644 >--- a/Koha/Schema/Result/Aqcontact.pm >+++ b/Koha/Schema/Result/Aqcontact.pm >@@ -29,77 +29,103 @@ __PACKAGE__->table("aqcontacts"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique number assigned by Koha >+ > =head2 name > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+name of contact at vendor >+ > =head2 position > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+contact person's position >+ > =head2 phone > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+contact's phone number >+ > =head2 altphone > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+contact's alternate phone number >+ > =head2 fax > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+contact's fax number >+ > =head2 email > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+contact's email address >+ > =head2 notes > > data_type: 'longtext' > is_nullable: 1 > >+notes related to the contact >+ > =head2 orderacquisition > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+should this contact receive acquisition orders >+ > =head2 claimacquisition > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+should this contact receive acquisitions claims >+ > =head2 claimissues > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+should this contact receive serial claims >+ > =head2 acqprimary > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+is this the primary contact for acquisitions messages >+ > =head2 serialsprimary > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+is this the primary contact for serials messages >+ > =head2 booksellerid > > data_type: 'integer' >@@ -169,8 +195,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2x8Z9Db2oDULEODgLuw8Q >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:O7JzmE0CiJ7iDfvyCi4QrA > > __PACKAGE__->add_columns( > '+orderacquisition' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Aqinvoice.pm b/Koha/Schema/Result/Aqinvoice.pm >index fe1f8f265e..f0cc9ace89 100644 >--- a/Koha/Schema/Result/Aqinvoice.pm >+++ b/Koha/Schema/Result/Aqinvoice.pm >@@ -29,53 +29,71 @@ __PACKAGE__->table("aqinvoices"); > is_auto_increment: 1 > is_nullable: 0 > >+ID of the invoice, primary key >+ > =head2 invoicenumber > > data_type: 'longtext' > is_nullable: 0 > >+Name of invoice >+ > =head2 booksellerid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to aqbooksellers >+ > =head2 shipmentdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date of shipment >+ > =head2 billingdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date of billing >+ > =head2 closedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+invoice close date, NULL means the invoice is open >+ > =head2 shipmentcost > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+shipment cost >+ > =head2 shipmentcost_budgetid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key to aqbudgets, link the shipment cost to a budget >+ > =head2 message_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key to edifact invoice message >+ > =cut > > __PACKAGE__->add_columns( >@@ -199,8 +217,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mpdxTbkz/8WInG5Wp4q7Ug >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jOZUccjnTE+Tzd3ivMs6Uw > > sub koha_object_class { > 'Koha::Acquisition::Invoice'; >diff --git a/Koha/Schema/Result/AqinvoiceAdjustment.pm b/Koha/Schema/Result/AqinvoiceAdjustment.pm >index 16bc45acb2..65ca59f654 100644 >--- a/Koha/Schema/Result/AqinvoiceAdjustment.pm >+++ b/Koha/Schema/Result/AqinvoiceAdjustment.pm >@@ -29,41 +29,55 @@ __PACKAGE__->table("aqinvoice_adjustments"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key for adjustments >+ > =head2 invoiceid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to link an adjustment to an invoice >+ > =head2 adjustment > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+amount of adjustment >+ > =head2 reason > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+reason for adjustment defined by authorised values in ADJ_REASON category >+ > =head2 note > > data_type: 'mediumtext' > is_nullable: 1 > >+text to explain adjustment >+ > =head2 budget_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+optional link to budget to apply adjustment to >+ > =head2 encumber_open > > data_type: 'smallint' > default_value: 1 > is_nullable: 0 > >+whether or not to encumber the funds when invoice is still open, 1 = yes, 0 = no >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -71,6 +85,8 @@ __PACKAGE__->table("aqinvoice_adjustments"); > default_value: current_timestamp > is_nullable: 0 > >+timestamp of last adjustment to adjustment >+ > =cut > > __PACKAGE__->add_columns( >@@ -147,8 +163,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 17:32:57 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jl0qxkZWVs2D1pi3kaRjpg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L3lnMcRFhpTnAJCNPfZ45g > > sub koha_object_class { > 'Koha::Acquisition::Invoice::Adjustment'; >diff --git a/Koha/Schema/Result/Aqorder.pm b/Koha/Schema/Result/Aqorder.pm >index f873aa6da3..be330dd77a 100644 >--- a/Koha/Schema/Result/Aqorder.pm >+++ b/Koha/Schema/Result/Aqorder.pm >@@ -29,23 +29,31 @@ __PACKAGE__->table("aqorders"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique identifier assigned by Koha to each line >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+links the order to the biblio being ordered (biblio.biblionumber) >+ > =head2 entrydate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the bib was added to the basket >+ > =head2 quantity > > data_type: 'smallint' > is_nullable: 1 > >+the quantity ordered >+ > =head2 currency > > data_type: 'varchar' >@@ -53,92 +61,124 @@ __PACKAGE__->table("aqorders"); > is_nullable: 1 > size: 10 > >+the currency used for the purchase >+ > =head2 listprice > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the vendor price for this line item >+ > =head2 datereceived > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this order was received >+ > =head2 invoiceid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+id of invoice >+ > =head2 freight > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+shipping costs (not used) >+ > =head2 unitprice > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the actual cost entered when receiving this line item >+ > =head2 unitprice_tax_excluded > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the unit price excluding tax (on receiving) >+ > =head2 unitprice_tax_included > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the unit price including tax (on receiving) >+ > =head2 quantityreceived > > data_type: 'smallint' > default_value: 0 > is_nullable: 0 > >+the quantity that have been received so far >+ > =head2 created_by > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+the borrowernumber of order line's creator >+ > =head2 datecancellationprinted > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the line item was deleted >+ > =head2 cancellationreason > > data_type: 'mediumtext' > is_nullable: 1 > >+reason of cancellation >+ > =head2 order_internalnote > > data_type: 'longtext' > is_nullable: 1 > >+notes related to this order line, made for staff >+ > =head2 order_vendornote > > data_type: 'longtext' > is_nullable: 1 > >+notes related to this order line, made for vendor >+ > =head2 purchaseordernumber > > data_type: 'longtext' > is_nullable: 1 > >+not used? always NULL >+ > =head2 basketno > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+links this order line to a specific basket (aqbasket.basketno) >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -146,114 +186,152 @@ __PACKAGE__->table("aqorders"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this order line was last modified >+ > =head2 rrp > > data_type: 'decimal' > is_nullable: 1 > size: [13,2] > >+the retail cost for this line item >+ > =head2 replacementprice > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the replacement cost for this line item >+ > =head2 rrp_tax_excluded > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the replacement cost excluding tax >+ > =head2 rrp_tax_included > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the replacement cost including tax >+ > =head2 ecost > > data_type: 'decimal' > is_nullable: 1 > size: [13,2] > >+the replacement cost for this line item >+ > =head2 ecost_tax_excluded > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the estimated cost excluding tax >+ > =head2 ecost_tax_included > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the estimated cost including tax >+ > =head2 tax_rate_bak > > data_type: 'decimal' > is_nullable: 1 > size: [6,4] > >+the tax rate for this line item (%) >+ > =head2 tax_rate_on_ordering > > data_type: 'decimal' > is_nullable: 1 > size: [6,4] > >+the tax rate on ordering for this line item (%) >+ > =head2 tax_rate_on_receiving > > data_type: 'decimal' > is_nullable: 1 > size: [6,4] > >+the tax rate on receiving for this line item (%) >+ > =head2 tax_value_bak > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the tax value for this line item >+ > =head2 tax_value_on_ordering > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the tax value on ordering for this line item >+ > =head2 tax_value_on_receiving > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the tax value on receiving for this line item >+ > =head2 discount > > data_type: 'float' > is_nullable: 1 > size: [6,4] > >+the discount for this line item (%) >+ > =head2 budget_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the fund this order goes against (aqbudgets.budget_id) >+ > =head2 budgetdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+not used? always NULL >+ > =head2 sort1 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+statistical field >+ > =head2 sort2 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+second statistical field >+ > =head2 sort1_authcat > > data_type: 'varchar' >@@ -271,17 +349,23 @@ __PACKAGE__->table("aqorders"); > data_type: 'tinyint' > is_nullable: 1 > >+was this price uncertain (1 for yes, 0 for no) >+ > =head2 subscriptionid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+links this order line to a subscription (subscription.subscriptionid) >+ > =head2 parent_ordernumber > > data_type: 'integer' > is_nullable: 1 > >+ordernumber of parent order line, or same as ordernumber if no parent >+ > =head2 orderstatus > > data_type: 'varchar' >@@ -289,29 +373,39 @@ __PACKAGE__->table("aqorders"); > is_nullable: 1 > size: 16 > >+the current status for this line item. Can be 'new', 'ordered', 'partial', 'complete' or 'cancelled' >+ > =head2 line_item_id > > data_type: 'varchar' > is_nullable: 1 > size: 35 > >+Supplier's article id for Edifact orderline >+ > =head2 suppliers_reference_number > > data_type: 'varchar' > is_nullable: 1 > size: 35 > >+Suppliers unique edifact quote ref >+ > =head2 suppliers_reference_qualifier > > data_type: 'varchar' > is_nullable: 1 > size: 3 > >+Type of number above usually 'QLI' >+ > =head2 suppliers_report > > data_type: 'mediumtext' > is_nullable: 1 > >+reports received from suppliers >+ > =cut > > __PACKAGE__->add_columns( >@@ -660,8 +754,8 @@ Composing rels: L</aqorder_users> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-04 08:25:41 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Pf6reFaSldsjIA6XThbDFA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TfwIBYIVTqp9qOqenaoHxQ > > __PACKAGE__->belongs_to( > "basket", >diff --git a/Koha/Schema/Result/AqorderUser.pm b/Koha/Schema/Result/AqorderUser.pm >index 54750d4ce5..35c37ac5c4 100644 >--- a/Koha/Schema/Result/AqorderUser.pm >+++ b/Koha/Schema/Result/AqorderUser.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("aqorder_users"); > is_foreign_key: 1 > is_nullable: 0 > >+the order this patrons receive notifications from (aqorders.ordernumber) >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber) >+ > =cut > > __PACKAGE__->add_columns( >@@ -91,8 +95,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 11:50:38 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6mhRlYUeJnpQIJ2P9WTbHQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BHsb47cCXXZ1LO4vMV0T2g > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/AqordersClaim.pm b/Koha/Schema/Result/AqordersClaim.pm >index 3b86f6747c..6913b4748e 100644 >--- a/Koha/Schema/Result/AqordersClaim.pm >+++ b/Koha/Schema/Result/AqordersClaim.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("aqorders_claims"); > is_auto_increment: 1 > is_nullable: 0 > >+ID of the claims >+ > =head2 ordernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+order linked to this claim >+ > =head2 claimed_on > > data_type: 'timestamp' >@@ -42,6 +46,8 @@ __PACKAGE__->table("aqorders_claims"); > default_value: current_timestamp > is_nullable: 0 > >+Date of the claims >+ > =cut > > __PACKAGE__->add_columns( >@@ -88,8 +94,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-05-04 08:25:41 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YHD9b6rUAPUM5HzFg4k9Wg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cDtOodtFZfM/s/1DA/RFWA > > sub koha_object_class { > 'Koha::Acquisition::Order::Claim'; >diff --git a/Koha/Schema/Result/AqordersItem.pm b/Koha/Schema/Result/AqordersItem.pm >index ac99f2e10c..68c11cf8e1 100644 >--- a/Koha/Schema/Result/AqordersItem.pm >+++ b/Koha/Schema/Result/AqordersItem.pm >@@ -29,11 +29,15 @@ __PACKAGE__->table("aqorders_items"); > is_foreign_key: 1 > is_nullable: 0 > >+the order this item is attached to (aqorders.ordernumber) >+ > =head2 itemnumber > > data_type: 'integer' > is_nullable: 0 > >+the item number for this item (items.itemnumber) >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -41,6 +45,8 @@ __PACKAGE__->table("aqorders_items"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this order item was last touched >+ > =cut > > __PACKAGE__->add_columns( >@@ -87,8 +93,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hvDuLTY3idYc1ujykNDrPQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K/7cgnLhY6csXVYfo2rtkw > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/ArticleRequest.pm b/Koha/Schema/Result/ArticleRequest.pm >index b787c91eca..d5e273a330 100644 >--- a/Koha/Schema/Result/ArticleRequest.pm >+++ b/Koha/Schema/Result/ArticleRequest.pm >@@ -112,6 +112,8 @@ __PACKAGE__->table("article_requests"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Be careful with two timestamps in one table not allowing NULL >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -257,8 +259,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-02 09:44:27 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dhz1mVI7Z/6ibqaBZkPvUA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5gT5YreB/oDegz6Lgo8/xA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/AuthorisedValue.pm b/Koha/Schema/Result/AuthorisedValue.pm >index 90d754e595..6c59455949 100644 >--- a/Koha/Schema/Result/AuthorisedValue.pm >+++ b/Koha/Schema/Result/AuthorisedValue.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("authorised_values"); > is_auto_increment: 1 > is_nullable: 0 > >+unique key, used to identify the authorized value >+ > =head2 category > > data_type: 'varchar' >@@ -37,6 +39,8 @@ __PACKAGE__->table("authorised_values"); > is_nullable: 0 > size: 32 > >+key used to identify the authorized value category >+ > =head2 authorised_value > > data_type: 'varchar' >@@ -44,24 +48,32 @@ __PACKAGE__->table("authorised_values"); > is_nullable: 0 > size: 80 > >+code use to identify the authorized value >+ > =head2 lib > > data_type: 'varchar' > is_nullable: 1 > size: 200 > >+authorized value description as printed in the staff interface >+ > =head2 lib_opac > > data_type: 'varchar' > is_nullable: 1 > size: 200 > >+authorized value description as printed in the OPAC >+ > =head2 imageurl > > data_type: 'varchar' > is_nullable: 1 > size: 200 > >+authorized value URL >+ > =cut > > __PACKAGE__->add_columns( >@@ -161,8 +173,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07048 @ 2020-04-07 11:23:19 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6MjWlDqdpIOwsJlyjQawAg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mhh5q7kqI+gH2sbu8y9uQA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm >index fa3979886f..50d6a60741 100644 >--- a/Koha/Schema/Result/Biblio.pm >+++ b/Koha/Schema/Result/Biblio.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("biblio"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned to each bibliographic record >+ > =head2 frameworkcode > > data_type: 'varchar' >@@ -36,51 +38,71 @@ __PACKAGE__->table("biblio"); > is_nullable: 0 > size: 4 > >+foreign key from the biblio_framework table to identify which framework was used in cataloging this record >+ > =head2 author > > data_type: 'longtext' > is_nullable: 1 > >+statement of responsibility from MARC record (100$a in MARC21) >+ > =head2 title > > data_type: 'longtext' > is_nullable: 1 > >+title (without the subtitle) from the MARC record (245$a in MARC21) >+ > =head2 medium > > data_type: 'longtext' > is_nullable: 1 > >+medium from the MARC record (245$h in MARC21) >+ > =head2 subtitle > > data_type: 'longtext' > is_nullable: 1 > >+remainder of the title from the MARC record (245$b in MARC21) >+ > =head2 part_number > > data_type: 'longtext' > is_nullable: 1 > >+part number from the MARC record (245$n in MARC21) >+ > =head2 part_name > > data_type: 'longtext' > is_nullable: 1 > >+part name from the MARC record (245$p in MARC21) >+ > =head2 unititle > > data_type: 'longtext' > is_nullable: 1 > >+uniform title (without the subtitle) from the MARC record (240$a in MARC21) >+ > =head2 notes > > data_type: 'longtext' > is_nullable: 1 > >+values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) >+ > =head2 serial > > data_type: 'tinyint' > is_nullable: 1 > >+Boolean indicating whether biblio is for a serial >+ > =head2 seriestitle > > data_type: 'longtext' >@@ -91,6 +113,8 @@ __PACKAGE__->table("biblio"); > data_type: 'smallint' > is_nullable: 1 > >+publication or copyright date from the MARC record >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -98,17 +122,23 @@ __PACKAGE__->table("biblio"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this record was last touched >+ > =head2 datecreated > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+the date this record was added to Koha >+ > =head2 abstract > > data_type: 'longtext' > is_nullable: 1 > >+summary from the MARC record (520$a in MARC21) >+ > =cut > > __PACKAGE__->add_columns( >@@ -451,8 +481,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R4PNOXHa9cRIx/up7HWz4Q >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7g/qaNBJwsmAm6nh6mIr6A > > > __PACKAGE__->has_one( >diff --git a/Koha/Schema/Result/BiblioFramework.pm b/Koha/Schema/Result/BiblioFramework.pm >index 93ed47386b..b021aea927 100644 >--- a/Koha/Schema/Result/BiblioFramework.pm >+++ b/Koha/Schema/Result/BiblioFramework.pm >@@ -30,6 +30,8 @@ __PACKAGE__->table("biblio_framework"); > is_nullable: 0 > size: 4 > >+the unique code assigned to the framework >+ > =head2 frameworktext > > data_type: 'varchar' >@@ -37,6 +39,8 @@ __PACKAGE__->table("biblio_framework"); > is_nullable: 0 > size: 255 > >+the description/name given to the framework >+ > =cut > > __PACKAGE__->add_columns( >@@ -59,8 +63,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("frameworkcode"); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KY1w7J/5cBsz9VV7QEBKPw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r15t5YxeOpHFq6VRfEYYQg > > # FIXME This should not be needed, we need to add the FK at DB level > # It cannot be done now because the default framework (frameworkcode=='') >diff --git a/Koha/Schema/Result/Biblioitem.pm b/Koha/Schema/Result/Biblioitem.pm >index 49e52e7678..111afe453f 100644 >--- a/Koha/Schema/Result/Biblioitem.pm >+++ b/Koha/Schema/Result/Biblioitem.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("biblioitems"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key, unique identifier assigned by Koha >+ > =head2 biblionumber > > data_type: 'integer' >@@ -36,6 +38,8 @@ __PACKAGE__->table("biblioitems"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key linking this table to the biblio table >+ > =head2 volume > > data_type: 'longtext' >@@ -52,16 +56,22 @@ __PACKAGE__->table("biblioitems"); > is_nullable: 1 > size: 10 > >+biblio level item type (MARC21 942$c) >+ > =head2 isbn > > data_type: 'longtext' > is_nullable: 1 > >+ISBN (MARC21 020$a) >+ > =head2 issn > > data_type: 'longtext' > is_nullable: 1 > >+ISSN (MARC21 022$a) >+ > =head2 ean > > data_type: 'longtext' >@@ -78,6 +88,8 @@ __PACKAGE__->table("biblioitems"); > is_nullable: 1 > size: 255 > >+publisher (MARC21 260$b) >+ > =head2 volumedate > > data_type: 'date' >@@ -89,6 +101,8 @@ __PACKAGE__->table("biblioitems"); > data_type: 'mediumtext' > is_nullable: 1 > >+volume information (MARC21 362$a) >+ > =head2 collectiontitle > > data_type: 'longtext' >@@ -127,12 +141,16 @@ __PACKAGE__->table("biblioitems"); > is_nullable: 1 > size: 255 > >+illustrations (MARC21 300$b) >+ > =head2 pages > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+number of pages (MARC21 300$c) >+ > =head2 notes > > data_type: 'longtext' >@@ -144,29 +162,39 @@ __PACKAGE__->table("biblioitems"); > is_nullable: 1 > size: 255 > >+material size (MARC21 300$c) >+ > =head2 place > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+publication place (MARC21 260$a) >+ > =head2 lccn > > data_type: 'varchar' > is_nullable: 1 > size: 25 > >+library of congress control number (MARC21 010$a) >+ > =head2 url > > data_type: 'mediumtext' > is_nullable: 1 > >+url (MARC21 856$u) >+ > =head2 cn_source > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+classification source (MARC21 942$2) >+ > =head2 cn_class > > data_type: 'varchar' >@@ -191,12 +219,16 @@ __PACKAGE__->table("biblioitems"); > is_nullable: 1 > size: 255 > >+normalized version of the call number used for sorting >+ > =head2 agerestriction > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+target audience/age restriction from the bib record (MARC21 521$a) >+ > =head2 totalissues > > data_type: 'integer' >@@ -326,8 +358,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:ogVRTKNaUQSI3BE2xC2lww >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rDwWn5ndpGmmhgusk8SmAA > > __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" ); > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 08f974d0ff..5f92e2d56d 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -29,173 +29,237 @@ __PACKAGE__->table("borrowers"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key, Koha assigned ID number for patrons/borrowers >+ > =head2 cardnumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+unique key, library assigned ID number for patrons/borrowers >+ > =head2 surname > > data_type: 'longtext' > is_nullable: 1 > >+patron/borrower's last name (surname) >+ > =head2 firstname > > data_type: 'mediumtext' > is_nullable: 1 > >+patron/borrower's first name >+ > =head2 title > > data_type: 'longtext' > is_nullable: 1 > >+patron/borrower's title, for example: Mr. or Mrs. >+ > =head2 othernames > > data_type: 'longtext' > is_nullable: 1 > >+any other names associated with the patron/borrower >+ > =head2 initials > > data_type: 'mediumtext' > is_nullable: 1 > >+initials for your patron/borrower >+ > =head2 streetnumber > > data_type: 'tinytext' > is_nullable: 1 > >+the house number for your patron/borrower's primary address >+ > =head2 streettype > > data_type: 'tinytext' > is_nullable: 1 > >+the street type (Rd., Blvd, etc) for your patron/borrower's primary address >+ > =head2 address > > data_type: 'longtext' > is_nullable: 1 > >+the first address line for your patron/borrower's primary address >+ > =head2 address2 > > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for your patron/borrower's primary address >+ > =head2 city > > data_type: 'longtext' > is_nullable: 1 > >+the city or town for your patron/borrower's primary address >+ > =head2 state > > data_type: 'mediumtext' > is_nullable: 1 > >+the state or province for your patron/borrower's primary address >+ > =head2 zipcode > > data_type: 'tinytext' > is_nullable: 1 > >+the zip or postal code for your patron/borrower's primary address >+ > =head2 country > > data_type: 'mediumtext' > is_nullable: 1 > >+the country for your patron/borrower's primary address >+ > =head2 email > > data_type: 'longtext' > is_nullable: 1 > >+the primary email address for your patron/borrower's primary address >+ > =head2 phone > > data_type: 'mediumtext' > is_nullable: 1 > >+the primary phone number for your patron/borrower's primary address >+ > =head2 mobile > > data_type: 'tinytext' > is_nullable: 1 > >+the other phone number for your patron/borrower's primary address >+ > =head2 fax > > data_type: 'longtext' > is_nullable: 1 > >+the fax number for your patron/borrower's primary address >+ > =head2 emailpro > > data_type: 'mediumtext' > is_nullable: 1 > >+the secondary email addres for your patron/borrower's primary address >+ > =head2 phonepro > > data_type: 'mediumtext' > is_nullable: 1 > >+the secondary phone number for your patron/borrower's primary address >+ > =head2 B_streetnumber > > accessor: 'b_streetnumber' > data_type: 'tinytext' > is_nullable: 1 > >+the house number for your patron/borrower's alternate address >+ > =head2 B_streettype > > accessor: 'b_streettype' > data_type: 'tinytext' > is_nullable: 1 > >+the street type (Rd., Blvd, etc) for your patron/borrower's alternate address >+ > =head2 B_address > > accessor: 'b_address' > data_type: 'mediumtext' > is_nullable: 1 > >+the first address line for your patron/borrower's alternate address >+ > =head2 B_address2 > > accessor: 'b_address2' > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for your patron/borrower's alternate address >+ > =head2 B_city > > accessor: 'b_city' > data_type: 'longtext' > is_nullable: 1 > >+the city or town for your patron/borrower's alternate address >+ > =head2 B_state > > accessor: 'b_state' > data_type: 'mediumtext' > is_nullable: 1 > >+the state for your patron/borrower's alternate address >+ > =head2 B_zipcode > > accessor: 'b_zipcode' > data_type: 'tinytext' > is_nullable: 1 > >+the zip or postal code for your patron/borrower's alternate address >+ > =head2 B_country > > accessor: 'b_country' > data_type: 'mediumtext' > is_nullable: 1 > >+the country for your patron/borrower's alternate address >+ > =head2 B_email > > accessor: 'b_email' > data_type: 'mediumtext' > is_nullable: 1 > >+the patron/borrower's alternate email address >+ > =head2 B_phone > > accessor: 'b_phone' > data_type: 'longtext' > is_nullable: 1 > >+the patron/borrower's alternate phone number >+ > =head2 dateofbirth > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the patron/borrower's date of birth (YYYY-MM-DD) >+ > =head2 branchcode > > data_type: 'varchar' >@@ -204,6 +268,8 @@ __PACKAGE__->table("borrowers"); > is_nullable: 0 > size: 10 > >+foreign key from the branches table, includes the code of the patron/borrower's home branch >+ > =head2 categorycode > > data_type: 'varchar' >@@ -212,71 +278,89 @@ __PACKAGE__->table("borrowers"); > is_nullable: 0 > size: 10 > >+foreign key from the categories table, includes the code of the patron category >+ > =head2 dateenrolled > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron was added to Koha (YYYY-MM-DD) >+ > =head2 dateexpiry > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron/borrower's card is set to expire (YYYY-MM-DD) >+ > =head2 date_renewed > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron/borrower's card was last renewed >+ > =head2 gonenoaddress > > data_type: 'tinyint' > is_nullable: 1 > >+set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address >+ > =head2 lost > > data_type: 'tinyint' > is_nullable: 1 > >+set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card >+ > =head2 debarred > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) >+ > =head2 debarredcomment > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+comment on the stop of the patron >+ > =head2 contactname > > data_type: 'longtext' > is_nullable: 1 > >+used for children and profesionals to include surname or last name of guarantor or organization name >+ > =head2 contactfirstname > > data_type: 'mediumtext' > is_nullable: 1 > >+used for children to include first name of guarantor >+ > =head2 contacttitle > > data_type: 'mediumtext' > is_nullable: 1 > >+used for children to include title (Mr., Mrs., etc) of guarantor >+ > =head2 borrowernotes > > data_type: 'longtext' > is_nullable: 1 > >-=head2 relationship >- >- data_type: 'varchar' >- is_nullable: 1 >- size: 100 >+a note on the patron/borrower's account that is only visible in the staff interface > > =head2 sex > >@@ -284,121 +368,165 @@ __PACKAGE__->table("borrowers"); > is_nullable: 1 > size: 1 > >+patron/borrower's gender >+ > =head2 password > > data_type: 'varchar' > is_nullable: 1 > size: 60 > >+patron/borrower's Bcrypt encrypted password >+ > =head2 flags > > data_type: 'integer' > is_nullable: 1 > >+will include a number associated with the staff member's permissions >+ > =head2 userid > > data_type: 'varchar' > is_nullable: 1 > size: 75 > >+patron/borrower's opac and/or staff interface log in >+ > =head2 opacnote > > data_type: 'longtext' > is_nullable: 1 > >+a note on the patron/borrower's account that is visible in the OPAC and staff interface >+ > =head2 contactnote > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+a note related to the patron/borrower's alternate address >+ > =head2 sort1 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a field that can be used for any information unique to the library >+ > =head2 sort2 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a field that can be used for any information unique to the library >+ > =head2 altcontactfirstname > > data_type: 'mediumtext' > is_nullable: 1 > >+first name of alternate contact for the patron/borrower >+ > =head2 altcontactsurname > > data_type: 'mediumtext' > is_nullable: 1 > >+surname or last name of the alternate contact for the patron/borrower >+ > =head2 altcontactaddress1 > > data_type: 'mediumtext' > is_nullable: 1 > >+the first address line for the alternate contact for the patron/borrower >+ > =head2 altcontactaddress2 > > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for the alternate contact for the patron/borrower >+ > =head2 altcontactaddress3 > > data_type: 'mediumtext' > is_nullable: 1 > >+the city for the alternate contact for the patron/borrower >+ > =head2 altcontactstate > > data_type: 'mediumtext' > is_nullable: 1 > >+the state for the alternate contact for the patron/borrower >+ > =head2 altcontactzipcode > > data_type: 'mediumtext' > is_nullable: 1 > >+the zipcode for the alternate contact for the patron/borrower >+ > =head2 altcontactcountry > > data_type: 'mediumtext' > is_nullable: 1 > >+the country for the alternate contact for the patron/borrower >+ > =head2 altcontactphone > > data_type: 'mediumtext' > is_nullable: 1 > >+the phone number for the alternate contact for the patron/borrower >+ > =head2 smsalertnumber > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) >+ > =head2 sms_provider_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+the provider of the mobile phone number defined in smsalertnumber >+ > =head2 privacy > > data_type: 'integer' > default_value: 1 > is_nullable: 0 > >+patron/borrower's privacy settings related to their checkout history >+ > =head2 privacy_guarantor_fines > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+controls if relatives can see this patron's fines >+ > =head2 privacy_guarantor_checkouts > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+controls if relatives can see this patron's checkouts >+ > =head2 checkprevcheckout > > data_type: 'varchar' >@@ -406,6 +534,8 @@ __PACKAGE__->table("borrowers"); > is_nullable: 0 > size: 7 > >+produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -413,12 +543,16 @@ __PACKAGE__->table("borrowers"); > default_value: current_timestamp > is_nullable: 0 > >+time of last change could be useful for synchronization with external systems (among others) >+ > =head2 lastseen > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+last time a patron has been seen (connected at the OPAC or staff interface) >+ > =head2 lang > > data_type: 'varchar' >@@ -426,29 +560,39 @@ __PACKAGE__->table("borrowers"); > is_nullable: 0 > size: 25 > >+lang to use to send notices to this patron >+ > =head2 login_attempts > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+number of failed login attemps >+ > =head2 overdrive_auth_token > > data_type: 'mediumtext' > is_nullable: 1 > >+persist OverDrive auth token >+ > =head2 anonymized > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+flag for data anonymization >+ > =head2 autorenew_checkouts > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+flag for allowing auto-renewal >+ > =cut > > __PACKAGE__->add_columns( >@@ -554,8 +698,6 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "borrowernotes", > { data_type => "longtext", is_nullable => 1 }, >- "relationship", >- { data_type => "varchar", is_nullable => 1, size => 100 }, > "sex", > { data_type => "varchar", is_nullable => 1, size => 1 }, > "password", >@@ -1713,8 +1855,8 @@ Composing rels: L</aqorder_users> -> ordernumber > __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-09 19:12:25 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kp53XFs7tFIpzNSqm/WY8w >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p19R3ym2b7Es0K4bGRlYOw > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/BorrowerAttribute.pm b/Koha/Schema/Result/BorrowerAttribute.pm >index 2a8398ad68..9f32ece8a0 100644 >--- a/Koha/Schema/Result/BorrowerAttribute.pm >+++ b/Koha/Schema/Result/BorrowerAttribute.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("borrower_attributes"); > is_auto_increment: 1 > is_nullable: 0 > >+Row id field >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the borrowers table, defines which patron/borrower has this attribute >+ > =head2 code > > data_type: 'varchar' >@@ -42,12 +46,16 @@ __PACKAGE__->table("borrower_attributes"); > is_nullable: 0 > size: 10 > >+foreign key from the borrower_attribute_types table, defines which custom field this value was entered for >+ > =head2 attribute > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+custom patron field value >+ > =cut > > __PACKAGE__->add_columns( >@@ -106,8 +114,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-08 04:41:27 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EarETnedFsmRmAAJAUrKGg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TJaujD5jDExU+B8X9ALeww > > =head2 borrower_attribute_types > >diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm >index 1d807f5081..ea343e4b4c 100644 >--- a/Koha/Schema/Result/BorrowerAttributeType.pm >+++ b/Koha/Schema/Result/BorrowerAttributeType.pm >@@ -29,60 +29,80 @@ __PACKAGE__->table("borrower_attribute_types"); > is_nullable: 0 > size: 10 > >+unique key used to identify each custom field >+ > =head2 description > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+description for each custom field >+ > =head2 repeatable > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines whether one patron/borrower can have multiple values for this custom field (1 for yes, 0 for no) >+ > =head2 unique_id > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this value needs to be unique (1 for yes, 0 for no) >+ > =head2 opac_display > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this field is visible to patrons on their account in the OPAC (1 for yes, 0 for no) >+ > =head2 opac_editable > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this field is editable by patrons on their account in the OPAC (1 for yes, 0 for no) >+ > =head2 staff_searchable > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this field is searchable via the patron search in the staff interface (1 for yes, 0 for no) >+ > =head2 authorised_value_category > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+foreign key from authorised_values that links this custom field to an authorized value category >+ > =head2 display_checkout > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this field displays in checkout screens >+ > =head2 category_code > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+defines a category for an attribute_type >+ > =head2 class > > data_type: 'varchar' >@@ -90,18 +110,24 @@ __PACKAGE__->table("borrower_attribute_types"); > is_nullable: 0 > size: 255 > >+defines a class for an attribute_type >+ > =head2 keep_for_pseudonymization > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if this field is copied to anonymized_borrower_attributes (1 for yes, 0 for no) >+ > =head2 mandatory > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+defines if the attribute is mandatory or not >+ > =cut > > __PACKAGE__->add_columns( >@@ -193,8 +219,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 12:40:43 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+5TTNyiyjJkADhbkSLvGLw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:30 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6AOwZeATSu2jBEaTiZ7tpQ > > __PACKAGE__->add_columns( > '+keep_for_pseudonymization' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/BorrowerDebarment.pm b/Koha/Schema/Result/BorrowerDebarment.pm >index 0a603de58a..243f4afaec 100644 >--- a/Koha/Schema/Result/BorrowerDebarment.pm >+++ b/Koha/Schema/Result/BorrowerDebarment.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("borrower_debarments"); > is_auto_increment: 1 > is_nullable: 0 > >+unique key for the restriction >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key for borrowers.borrowernumber for patron who is restricted >+ > =head2 expiration > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+expiration date of the restriction >+ > =head2 type > > data_type: 'enum' >@@ -48,16 +54,22 @@ __PACKAGE__->table("borrower_debarments"); > extra: {list => ["SUSPENSION","OVERDUES","MANUAL","DISCHARGE"]} > is_nullable: 0 > >+type of restriction >+ > =head2 comment > > data_type: 'mediumtext' > is_nullable: 1 > >+comments about the restriction >+ > =head2 manager_id > > data_type: 'integer' > is_nullable: 1 > >+foreign key for borrowers.borrowernumber for the librarian managing the restriction >+ > =head2 created > > data_type: 'timestamp' >@@ -65,12 +77,16 @@ __PACKAGE__->table("borrower_debarments"); > default_value: current_timestamp > is_nullable: 0 > >+date the restriction was added >+ > =head2 updated > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the restriction was updated >+ > =cut > > __PACKAGE__->add_columns( >@@ -136,8 +152,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:J9J1ReRLqhVasOQXvde2Uw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VgmNUSJuF4edkufZh/+r5Q > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/BorrowerFile.pm b/Koha/Schema/Result/BorrowerFile.pm >index 6f0982d519..6b2e48a05a 100644 >--- a/Koha/Schema/Result/BorrowerFile.pm >+++ b/Koha/Schema/Result/BorrowerFile.pm >@@ -29,35 +29,47 @@ __PACKAGE__->table("borrower_files"); > is_auto_increment: 1 > is_nullable: 0 > >+unique key >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key linking to the patron via the borrowernumber >+ > =head2 file_name > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+file name >+ > =head2 file_type > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+type of file >+ > =head2 file_description > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+description given to the file >+ > =head2 file_content > > data_type: 'longblob' > is_nullable: 0 > >+the file >+ > =head2 date_uploaded > > data_type: 'timestamp' >@@ -65,6 +77,8 @@ __PACKAGE__->table("borrower_files"); > default_value: current_timestamp > is_nullable: 0 > >+date and time the file was added >+ > =cut > > __PACKAGE__->add_columns( >@@ -119,8 +133,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sbkf7bvdO4CgmiBLgIwYQg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W42furxlvGDZDwgtppaavw > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm >index f11d0880b7..731f2879a8 100644 >--- a/Koha/Schema/Result/BorrowerModification.pm >+++ b/Koha/Schema/Result/BorrowerModification.pm >@@ -295,12 +295,6 @@ __PACKAGE__->table("borrower_modifications"); > data_type: 'longtext' > is_nullable: 1 > >-=head2 relationship >- >- data_type: 'varchar' >- is_nullable: 1 >- size: 100 >- > =head2 sex > > data_type: 'varchar' >@@ -421,6 +415,8 @@ __PACKAGE__->table("borrower_modifications"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+data processing consent >+ > =cut > > __PACKAGE__->add_columns( >@@ -545,8 +541,6 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "borrowernotes", > { data_type => "longtext", is_nullable => 1 }, >- "relationship", >- { data_type => "varchar", is_nullable => 1, size => 100 }, > "sex", > { data_type => "varchar", is_nullable => 1, size => 1 }, > "password", >@@ -610,8 +604,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 08:12:55 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eK1U1HkJyF1dL9WpcrkxdA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vzqe4y1VKlPzSCi8dc72GQ > > sub koha_object_class { > 'Koha::Patron::Modification'; >diff --git a/Koha/Schema/Result/BorrowerPasswordRecovery.pm b/Koha/Schema/Result/BorrowerPasswordRecovery.pm >index c7f567d102..d06e5a6237 100644 >--- a/Koha/Schema/Result/BorrowerPasswordRecovery.pm >+++ b/Koha/Schema/Result/BorrowerPasswordRecovery.pm >@@ -28,12 +28,16 @@ __PACKAGE__->table("borrower_password_recovery"); > data_type: 'integer' > is_nullable: 0 > >+the user asking a password recovery >+ > =head2 uuid > > data_type: 'varchar' > is_nullable: 0 > size: 128 > >+a unique string to identify a password recovery attempt >+ > =head2 valid_until > > data_type: 'timestamp' >@@ -41,6 +45,8 @@ __PACKAGE__->table("borrower_password_recovery"); > default_value: current_timestamp > is_nullable: 0 > >+a time limit on the password recovery attempt >+ > =cut > > __PACKAGE__->add_columns( >@@ -70,8 +76,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2016-01-22 10:16:52 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c4ehAGqOD6YHpGg85BX8YQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/KE+MtQb53sAtv1PLOH6xw > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index 04a4a11eb6..de3d023eea 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -30,121 +30,167 @@ __PACKAGE__->table("branches"); > is_nullable: 0 > size: 10 > >+a unique key assigned to each branch >+ > =head2 branchname > > data_type: 'longtext' > is_nullable: 0 > >+the name of your library or branch >+ > =head2 branchaddress1 > > data_type: 'longtext' > is_nullable: 1 > >+the first address line of for your library or branch >+ > =head2 branchaddress2 > > data_type: 'longtext' > is_nullable: 1 > >+the second address line of for your library or branch >+ > =head2 branchaddress3 > > data_type: 'longtext' > is_nullable: 1 > >+the third address line of for your library or branch >+ > =head2 branchzip > > data_type: 'varchar' > is_nullable: 1 > size: 25 > >+the zip or postal code for your library or branch >+ > =head2 branchcity > > data_type: 'longtext' > is_nullable: 1 > >+the city or province for your library or branch >+ > =head2 branchstate > > data_type: 'longtext' > is_nullable: 1 > >+the state for your library or branch >+ > =head2 branchcountry > > data_type: 'mediumtext' > is_nullable: 1 > >+the county for your library or branch >+ > =head2 branchphone > > data_type: 'longtext' > is_nullable: 1 > >+the primary phone for your library or branch >+ > =head2 branchfax > > data_type: 'longtext' > is_nullable: 1 > >+the fax number for your library or branch >+ > =head2 branchemail > > data_type: 'longtext' > is_nullable: 1 > >+the primary email address for your library or branch >+ > =head2 branchillemail > > data_type: 'longtext' > is_nullable: 1 > >+the ILL staff email address for your library or branch >+ > =head2 branchreplyto > > data_type: 'longtext' > is_nullable: 1 > >+the email to be used as a Reply-To >+ > =head2 branchreturnpath > > data_type: 'longtext' > is_nullable: 1 > >+the email to be used as Return-Path >+ > =head2 branchurl > > data_type: 'longtext' > is_nullable: 1 > >+the URL for your library or branch's website >+ > =head2 issuing > > data_type: 'tinyint' > is_nullable: 1 > >+unused in Koha >+ > =head2 branchip > > data_type: 'varchar' > is_nullable: 1 > size: 15 > >+the IP address for your library or branch >+ > =head2 branchnotes > > data_type: 'longtext' > is_nullable: 1 > >+notes related to your library or branch >+ > =head2 opac_info > > data_type: 'mediumtext' > is_nullable: 1 > >+HTML that displays in OPAC >+ > =head2 geolocation > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+geolocation of your library >+ > =head2 marcorgcode > > data_type: 'varchar' > is_nullable: 1 > size: 16 > >+MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode >+ > =head2 pickup_location > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+the ability to act as a pickup location >+ > =cut > > __PACKAGE__->add_columns( >@@ -841,8 +887,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pOqM3Rfe/H4J+m1XxVfaUQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FUQJRPdycQ8UH7ddEp/ZmQ > > __PACKAGE__->add_columns( > '+pickup_location' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/Branchtransfer.pm b/Koha/Schema/Result/Branchtransfer.pm >index 7fc813e507..6d0cb0a828 100644 >--- a/Koha/Schema/Result/Branchtransfer.pm >+++ b/Koha/Schema/Result/Branchtransfer.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("branchtransfers"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key >+ > =head2 itemnumber > > data_type: 'integer' >@@ -36,6 +38,8 @@ __PACKAGE__->table("branchtransfers"); > is_foreign_key: 1 > is_nullable: 0 > >+the itemnumber that it is in transit (items.itemnumber) >+ > =head2 daterequested > > data_type: 'timestamp' >@@ -43,12 +47,16 @@ __PACKAGE__->table("branchtransfers"); > default_value: current_timestamp > is_nullable: 0 > >+the date the transfer was requested >+ > =head2 datesent > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the transfer was initialized >+ > =head2 frombranch > > data_type: 'varchar' >@@ -57,12 +65,16 @@ __PACKAGE__->table("branchtransfers"); > is_nullable: 0 > size: 10 > >+the branch the transfer is coming from >+ > =head2 datearrived > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the transfer arrived at its destination >+ > =head2 tobranch > > data_type: 'varchar' >@@ -71,17 +83,23 @@ __PACKAGE__->table("branchtransfers"); > is_nullable: 0 > size: 10 > >+the branch the transfer was going to >+ > =head2 comments > > data_type: 'longtext' > is_nullable: 1 > >+any comments related to the transfer >+ > =head2 reason > > data_type: 'enum' > extra: {list => ["Manual","StockrotationAdvance","StockrotationRepatriation","ReturnToHome","ReturnToHolding","RotatingCollection","Reserve","LostReserve","CancelReserve"]} > is_nullable: 1 > >+what triggered the transfer >+ > =cut > > __PACKAGE__->add_columns( >@@ -211,8 +229,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-20 12:30:59 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G5GZTxF8X/mcIKXmuGVWIQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IEqGHqb6OH7sn8Cf1ea64Q > > sub koha_object_class { > 'Koha::Item::Transfer'; >diff --git a/Koha/Schema/Result/CashRegister.pm b/Koha/Schema/Result/CashRegister.pm >index 6cb01e7848..3c9e664b72 100644 >--- a/Koha/Schema/Result/CashRegister.pm >+++ b/Koha/Schema/Result/CashRegister.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("cash_registers"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for each account register >+ > =head2 name > > data_type: 'varchar' > is_nullable: 0 > size: 24 > >+the user friendly identifier for each account register >+ > =head2 description > > data_type: 'longtext' > is_nullable: 0 > >+the user friendly description for each account register >+ > =head2 branch > > data_type: 'varchar' >@@ -47,24 +53,32 @@ __PACKAGE__->table("cash_registers"); > is_nullable: 0 > size: 10 > >+the foreign key the library this account register belongs >+ > =head2 branch_default > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+boolean flag to denote that this till is the branch default >+ > =head2 starting_float > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the starting float this account register should be assigned >+ > =head2 archived > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+boolean flag to denote if this till is archived or not >+ > =cut > > __PACKAGE__->add_columns( >@@ -160,8 +174,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zP8my0Zp5bSARTBfws4n1A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hg0mW8a2VRb6Pm5FfcnuQw > > __PACKAGE__->add_columns( > '+archived' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/CashRegisterAction.pm b/Koha/Schema/Result/CashRegisterAction.pm >index 6643a73a85..8409c0eba2 100644 >--- a/Koha/Schema/Result/CashRegisterAction.pm >+++ b/Koha/Schema/Result/CashRegisterAction.pm >@@ -29,30 +29,40 @@ __PACKAGE__->table("cash_register_actions"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for each account register action >+ > =head2 code > > data_type: 'varchar' > is_nullable: 0 > size: 24 > >+action code denoting the type of action recorded (enum), >+ > =head2 register_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+id of cash_register this action belongs to, >+ > =head2 manager_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+staff member performing the action >+ > =head2 amount > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+amount recorded in action (signed) >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -127,8 +137,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-23 13:21:03 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Oaee+hS82IEJHHBGuOXDtw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:skIDbja7UDxRbMZ0zqMgDQ > > sub koha_objects_class { > 'Koha::Cash::Register::Actions'; >diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm >index 0fdac2cc7c..b34f435e7a 100644 >--- a/Koha/Schema/Result/Category.pm >+++ b/Koha/Schema/Result/Category.pm >@@ -30,38 +30,52 @@ __PACKAGE__->table("categories"); > is_nullable: 0 > size: 10 > >+unique primary key used to idenfity the patron category >+ > =head2 description > > data_type: 'longtext' > is_nullable: 1 > >+description of the patron category >+ > =head2 enrolmentperiod > > data_type: 'smallint' > is_nullable: 1 > >+number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) >+ > =head2 enrolmentperioddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron is enrolled until (will be NULL if enrolmentperiod is set) >+ > =head2 upperagelimit > > data_type: 'smallint' > is_nullable: 1 > >+age limit for the patron >+ > =head2 dateofbirthrequired > > data_type: 'tinyint' > is_nullable: 1 > >+the minimum age required for the patron category >+ > =head2 finetype > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+unused in Koha >+ > =head2 bulk > > data_type: 'tinyint' >@@ -73,28 +87,38 @@ __PACKAGE__->table("categories"); > is_nullable: 1 > size: [28,6] > >+enrollment fee for the patron >+ > =head2 overduenoticerequired > > data_type: 'tinyint' > is_nullable: 1 > >+are overdue notices sent to this patron category (1 for yes, 0 for no) >+ > =head2 issuelimit > > data_type: 'smallint' > is_nullable: 1 > >+unused in Koha >+ > =head2 reservefee > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+cost to place holds >+ > =head2 hidelostitems > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+are lost items shown to this category (1 for yes, 0 for no) >+ > =head2 category_type > > data_type: 'varchar' >@@ -102,6 +126,8 @@ __PACKAGE__->table("categories"); > is_nullable: 0 > size: 1 > >+type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) >+ > =head2 BlockExpiredPatronOpacActions > > accessor: 'block_expired_patron_opac_actions' >@@ -109,6 +135,8 @@ __PACKAGE__->table("categories"); > default_value: -1 > is_nullable: 0 > >+wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions >+ > =head2 default_privacy > > data_type: 'enum' >@@ -116,6 +144,8 @@ __PACKAGE__->table("categories"); > extra: {list => ["default","never","forever"]} > is_nullable: 0 > >+Default privacy setting for this patron category >+ > =head2 checkprevcheckout > > data_type: 'varchar' >@@ -123,31 +153,43 @@ __PACKAGE__->table("categories"); > is_nullable: 0 > size: 7 > >+produce a warning for this patron category if this item has previously been checked out to this patron if 'yes', not if 'no', defer to syspref setting if 'inherit'. >+ > =head2 reset_password > > data_type: 'tinyint' > is_nullable: 1 > >+if patrons of this category can do the password reset flow, >+ > =head2 change_password > > data_type: 'tinyint' > is_nullable: 1 > >+if patrons of this category can change their passwords in the OAPC >+ > =head2 min_password_length > > data_type: 'smallint' > is_nullable: 1 > >+set minimum password length for patrons in this category >+ > =head2 require_strong_password > > data_type: 'tinyint' > is_nullable: 1 > >+set required password strength for patrons in this category >+ > =head2 exclude_from_local_holds_priority > > data_type: 'tinyint' > is_nullable: 1 > >+Exclude patrons of this category from local holds priority >+ > =cut > > __PACKAGE__->add_columns( >@@ -302,8 +344,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-09-18 09:33:32 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ab4IZUfNu63C/SWLPXlMNg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K1jfTo+O5QHkRxrss9Xs3Q > > __PACKAGE__->add_columns( > '+exclude_from_local_holds_priority' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/City.pm b/Koha/Schema/Result/City.pm >index f95b63076d..9d561bbee7 100644 >--- a/Koha/Schema/Result/City.pm >+++ b/Koha/Schema/Result/City.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("cities"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier added by Koha >+ > =head2 city_name > > data_type: 'varchar' >@@ -36,24 +38,32 @@ __PACKAGE__->table("cities"); > is_nullable: 0 > size: 100 > >+name of the city >+ > =head2 city_state > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+name of the state/province >+ > =head2 city_country > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+name of the country >+ > =head2 city_zipcode > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+zip or postal code >+ > =cut > > __PACKAGE__->add_columns( >@@ -82,8 +92,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("cityid"); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zEjfS65sp13yF7dH8/ojZQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YFqwNwP1HDwU1TcJyn1SQw > > sub koha_objects_class { > 'Koha::Cities'; >diff --git a/Koha/Schema/Result/ClubHold.pm b/Koha/Schema/Result/ClubHold.pm >index fca4b51046..39538cc498 100644 >--- a/Koha/Schema/Result/ClubHold.pm >+++ b/Koha/Schema/Result/ClubHold.pm >@@ -35,18 +35,24 @@ __PACKAGE__->table("club_holds"); > is_foreign_key: 1 > is_nullable: 0 > >+id for the club the hold was generated for >+ > =head2 biblio_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+id for the bibliographic record the hold has been placed against >+ > =head2 item_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+If item-level, the id for the item the hold has been placed agains >+ > =head2 date_created > > data_type: 'timestamp' >@@ -54,6 +60,8 @@ __PACKAGE__->table("club_holds"); > default_value: current_timestamp > is_nullable: 0 > >+Timestamp for the placed hold >+ > =cut > > __PACKAGE__->add_columns( >@@ -154,8 +162,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-01 07:08:47 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FYGXVx1P2R+dGbeP1xshPA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NE3PDCJ01WPZr5THKRrhiQ > > sub koha_objects_class { > 'Koha::Club::Holds'; >diff --git a/Koha/Schema/Result/Collection.pm b/Koha/Schema/Result/Collection.pm >index f8c3d8e46b..0b39d0ddeb 100644 >--- a/Koha/Schema/Result/Collection.pm >+++ b/Koha/Schema/Result/Collection.pm >@@ -52,6 +52,8 @@ __PACKAGE__->table("collections"); > is_nullable: 1 > size: 10 > >+'branchcode for branch where item should be held.' >+ > =cut > > __PACKAGE__->add_columns( >@@ -117,8 +119,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nx6GPmSO3ckjDmF7dz0DKA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:csLFex12w89wWao3pJikFA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Course.pm b/Koha/Schema/Result/Course.pm >index cd1ede28e3..d3b56279d8 100644 >--- a/Koha/Schema/Result/Course.pm >+++ b/Koha/Schema/Result/Course.pm >@@ -29,52 +29,70 @@ __PACKAGE__->table("courses"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id for the course >+ > =head2 department > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+the authorised value for the DEPARTMENT >+ > =head2 course_number > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+the 'course number' assigned to a course >+ > =head2 section > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+the 'section' of a course >+ > =head2 course_name > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+the name of the course >+ > =head2 term > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+the authorised value for the TERM >+ > =head2 staff_note > > data_type: 'longtext' > is_nullable: 1 > >+the text of the staff only note >+ > =head2 public_note > > data_type: 'longtext' > is_nullable: 1 > >+the text of the public / opac note >+ > =head2 students_count > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+how many students will be taking this course/section >+ > =head2 enabled > > data_type: 'enum' >@@ -82,6 +100,8 @@ __PACKAGE__->table("courses"); > extra: {list => ["yes","no"]} > is_nullable: 0 > >+determines whether the course is active >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -181,8 +201,8 @@ Composing rels: L</course_instructors> -> borrowernumber > __PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o0EBOuJCHxH5IG/PgsJfxg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ePAT/DLyVd0BklkxL6q3Jg > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/CourseInstructor.pm b/Koha/Schema/Result/CourseInstructor.pm >index 15ec47ee52..d01f4d33b0 100644 >--- a/Koha/Schema/Result/CourseInstructor.pm >+++ b/Koha/Schema/Result/CourseInstructor.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("course_instructors"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to link to courses.course_id >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to link to borrowers.borrowernumber for instructor information >+ > =cut > > __PACKAGE__->add_columns( >@@ -91,8 +95,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:7vP3bJ0YA6LEepYOaNg++A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:srMXE9huuvvZXpiLXkHMuA > > sub koha_objects_class { > 'Koha::Course::Instructors'; >diff --git a/Koha/Schema/Result/CourseItem.pm b/Koha/Schema/Result/CourseItem.pm >index 495cf77964..05f574ac45 100644 >--- a/Koha/Schema/Result/CourseItem.pm >+++ b/Koha/Schema/Result/CourseItem.pm >@@ -29,48 +29,64 @@ __PACKAGE__->table("course_items"); > is_auto_increment: 1 > is_nullable: 0 > >+course item id >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+items.itemnumber for the item on reserve >+ > =head2 itype > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+new itemtype for the item to have while on reserve (optional) >+ > =head2 itype_enabled > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+indicates if itype should be changed while on course reserve >+ > =head2 itype_storage > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+a place to store the itype when item is on course reserve >+ > =head2 ccode > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+new category code for the item to have while on reserve (optional) >+ > =head2 ccode_enabled > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+indicates if ccode should be changed while on course reserve >+ > =head2 ccode_storage > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a place to store the ccode when item is on course reserve >+ > =head2 homebranch > > data_type: 'varchar' >@@ -78,12 +94,16 @@ __PACKAGE__->table("course_items"); > is_nullable: 1 > size: 10 > >+new home branch for the item to have while on reserve (optional) >+ > =head2 homebranch_enabled > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+indicates if homebranch should be changed while on course reserve >+ > =head2 homebranch_storage > > data_type: 'varchar' >@@ -91,6 +111,8 @@ __PACKAGE__->table("course_items"); > is_nullable: 1 > size: 10 > >+a place to store the homebranch when item is on course reserve >+ > =head2 holdingbranch > > data_type: 'varchar' >@@ -98,36 +120,48 @@ __PACKAGE__->table("course_items"); > is_nullable: 1 > size: 10 > >+new holding branch for the item to have while on reserve (optional) >+ > =head2 holdingbranch_enabled > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+indicates if itype should be changed while on course reserve >+ > =head2 holdingbranch_storage > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+a place to store the holdingbranch when item is on course reserve >+ > =head2 location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+new shelving location for the item to have while on reseve (optional) >+ > =head2 location_enabled > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+indicates if itype should be changed while on course reserve >+ > =head2 location_storage > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a place to store the location when the item is on course reserve >+ > =head2 enabled > > data_type: 'enum' >@@ -135,6 +169,8 @@ __PACKAGE__->table("course_items"); > extra: {list => ["yes","no"]} > is_nullable: 0 > >+if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no' >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -314,8 +350,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-04-24 10:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cXNlGAgIZMs+Id7/FJSBRQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:D5zO+P3v2EPLTS6dde4YMw > > __PACKAGE__->add_columns( > '+itype_enabled' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/CourseReserve.pm b/Koha/Schema/Result/CourseReserve.pm >index 8bb41cbb23..2a3616cfab 100644 >--- a/Koha/Schema/Result/CourseReserve.pm >+++ b/Koha/Schema/Result/CourseReserve.pm >@@ -35,22 +35,30 @@ __PACKAGE__->table("course_reserves"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to link to courses.course_id >+ > =head2 ci_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to link to courses_items.ci_id >+ > =head2 staff_note > > data_type: 'longtext' > is_nullable: 1 > >+staff only note >+ > =head2 public_note > > data_type: 'longtext' > is_nullable: 1 > >+public, OPAC visible note >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -141,8 +149,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8SDdUrbxKuAwp6rgn85RmA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jPqC4AvNvugDK1fZIssJyw > > sub koha_objects_class { > 'Koha::Course::Reserves'; >diff --git a/Koha/Schema/Result/CoverImage.pm b/Koha/Schema/Result/CoverImage.pm >index d8e9854132..61d15a5ca8 100644 >--- a/Koha/Schema/Result/CoverImage.pm >+++ b/Koha/Schema/Result/CoverImage.pm >@@ -29,34 +29,46 @@ __PACKAGE__->table("cover_images"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for the image >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from biblio table to link to biblionumber >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from item table to link to itemnumber >+ > =head2 mimetype > > data_type: 'varchar' > is_nullable: 0 > size: 15 > >+image type >+ > =head2 imagefile > > data_type: 'mediumblob' > is_nullable: 0 > >+image file contents >+ > =head2 thumbnail > > data_type: 'mediumblob' > is_nullable: 0 > >+thumbnail file contents >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -64,6 +76,8 @@ __PACKAGE__->table("cover_images"); > default_value: current_timestamp > is_nullable: 0 > >+image creation/update time >+ > =cut > > __PACKAGE__->add_columns( >@@ -143,8 +157,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F8pfwsORemCIxoVAPIohXw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LdHgdqpdXRqSSklRec/2Uw > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Deletedbiblio.pm b/Koha/Schema/Result/Deletedbiblio.pm >index 5d02066493..cc16cca535 100644 >--- a/Koha/Schema/Result/Deletedbiblio.pm >+++ b/Koha/Schema/Result/Deletedbiblio.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("deletedbiblio"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned to each bibliographic record >+ > =head2 frameworkcode > > data_type: 'varchar' >@@ -36,51 +38,71 @@ __PACKAGE__->table("deletedbiblio"); > is_nullable: 0 > size: 4 > >+foriegn key from the biblio_framework table to identify which framework was used in cataloging this record >+ > =head2 author > > data_type: 'longtext' > is_nullable: 1 > >+statement of responsibility from MARC record (100$a in MARC21) >+ > =head2 title > > data_type: 'longtext' > is_nullable: 1 > >+title (without the subtitle) from the MARC record (245$a in MARC21) >+ > =head2 medium > > data_type: 'longtext' > is_nullable: 1 > >+medium from the MARC record (245$h in MARC21) >+ > =head2 subtitle > > data_type: 'longtext' > is_nullable: 1 > >+remainder of the title from the MARC record (245$b in MARC21) >+ > =head2 part_number > > data_type: 'longtext' > is_nullable: 1 > >+part number from the MARC record (245$n in MARC21) >+ > =head2 part_name > > data_type: 'longtext' > is_nullable: 1 > >+part name from the MARC record (245$p in MARC21) >+ > =head2 unititle > > data_type: 'longtext' > is_nullable: 1 > >+uniform title (without the subtitle) from the MARC record (240$a in MARC21) >+ > =head2 notes > > data_type: 'longtext' > is_nullable: 1 > >+values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) >+ > =head2 serial > > data_type: 'tinyint' > is_nullable: 1 > >+Boolean indicating whether biblio is for a serial >+ > =head2 seriestitle > > data_type: 'longtext' >@@ -91,6 +113,8 @@ __PACKAGE__->table("deletedbiblio"); > data_type: 'smallint' > is_nullable: 1 > >+publication or copyright date from the MARC record >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -98,17 +122,23 @@ __PACKAGE__->table("deletedbiblio"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this record was last touched >+ > =head2 datecreated > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+the date this record was added to Koha >+ > =head2 abstract > > data_type: 'longtext' > is_nullable: 1 > >+summary from the MARC record (520$a in MARC21) >+ > =cut > > __PACKAGE__->add_columns( >@@ -181,8 +211,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-08-05 13:53:34 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FQaznWmkfR2Ge5NG8lDmSw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rE4YoB/41fCiKbzQaUR8XQ > > sub koha_objects_class { > 'Koha::Old::Biblios'; >diff --git a/Koha/Schema/Result/Deletedbiblioitem.pm b/Koha/Schema/Result/Deletedbiblioitem.pm >index e2849ecd99..faa03ed201 100644 >--- a/Koha/Schema/Result/Deletedbiblioitem.pm >+++ b/Koha/Schema/Result/Deletedbiblioitem.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("deletedbiblioitems"); > default_value: 0 > is_nullable: 0 > >+primary key, unique identifier assigned by Koha >+ > =head2 biblionumber > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+foreign key linking this table to the biblio table >+ > =head2 volume > > data_type: 'longtext' >@@ -51,16 +55,22 @@ __PACKAGE__->table("deletedbiblioitems"); > is_nullable: 1 > size: 10 > >+biblio level item type (MARC21 942$c) >+ > =head2 isbn > > data_type: 'longtext' > is_nullable: 1 > >+ISBN (MARC21 020$a) >+ > =head2 issn > > data_type: 'longtext' > is_nullable: 1 > >+ISSN (MARC21 022$a) >+ > =head2 ean > > data_type: 'longtext' >@@ -77,6 +87,8 @@ __PACKAGE__->table("deletedbiblioitems"); > is_nullable: 1 > size: 255 > >+publisher (MARC21 260$b) >+ > =head2 volumedate > > data_type: 'date' >@@ -88,6 +100,8 @@ __PACKAGE__->table("deletedbiblioitems"); > data_type: 'mediumtext' > is_nullable: 1 > >+volume information (MARC21 362$a) >+ > =head2 collectiontitle > > data_type: 'longtext' >@@ -126,12 +140,16 @@ __PACKAGE__->table("deletedbiblioitems"); > is_nullable: 1 > size: 255 > >+illustrations (MARC21 300$b) >+ > =head2 pages > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+number of pages (MARC21 300$c) >+ > =head2 notes > > data_type: 'longtext' >@@ -143,29 +161,39 @@ __PACKAGE__->table("deletedbiblioitems"); > is_nullable: 1 > size: 255 > >+material size (MARC21 300$c) >+ > =head2 place > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+publication place (MARC21 260$a) >+ > =head2 lccn > > data_type: 'varchar' > is_nullable: 1 > size: 25 > >+library of congress control number (MARC21 010$a) >+ > =head2 url > > data_type: 'mediumtext' > is_nullable: 1 > >+url (MARC21 856$u) >+ > =head2 cn_source > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+classification source (MARC21 942$2) >+ > =head2 cn_class > > data_type: 'varchar' >@@ -190,12 +218,16 @@ __PACKAGE__->table("deletedbiblioitems"); > is_nullable: 1 > size: 255 > >+normalized version of the call number used for sorting >+ > =head2 agerestriction > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+target audience/age restriction from the bib record (MARC21 521$a) >+ > =head2 totalissues > > data_type: 'integer' >@@ -288,8 +320,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("biblioitemnumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLYBa1Ea8Jau2Wy6U+wyQw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QmikL038NhPIMxp1MrZsbg > > sub koha_objects_class { > 'Koha::Old::Biblioitems'; >diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm >index d091fe98bd..c59bd07883 100644 >--- a/Koha/Schema/Result/Deletedborrower.pm >+++ b/Koha/Schema/Result/Deletedborrower.pm >@@ -29,173 +29,237 @@ __PACKAGE__->table("deletedborrowers"); > default_value: 0 > is_nullable: 0 > >+primary key, Koha assigned ID number for patrons/borrowers >+ > =head2 cardnumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+unique key, library assigned ID number for patrons/borrowers >+ > =head2 surname > > data_type: 'longtext' > is_nullable: 1 > >+patron/borrower's last name (surname) >+ > =head2 firstname > > data_type: 'mediumtext' > is_nullable: 1 > >+patron/borrower's first name >+ > =head2 title > > data_type: 'longtext' > is_nullable: 1 > >+patron/borrower's title, for example: Mr. or Mrs. >+ > =head2 othernames > > data_type: 'longtext' > is_nullable: 1 > >+any other names associated with the patron/borrower >+ > =head2 initials > > data_type: 'mediumtext' > is_nullable: 1 > >+initials for your patron/borrower >+ > =head2 streetnumber > > data_type: 'tinytext' > is_nullable: 1 > >+the house number for your patron/borrower's primary address >+ > =head2 streettype > > data_type: 'tinytext' > is_nullable: 1 > >+the street type (Rd., Blvd, etc) for your patron/borrower's primary address >+ > =head2 address > > data_type: 'longtext' > is_nullable: 1 > >+the first address line for your patron/borrower's primary address >+ > =head2 address2 > > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for your patron/borrower's primary address >+ > =head2 city > > data_type: 'longtext' > is_nullable: 1 > >+the city or town for your patron/borrower's primary address >+ > =head2 state > > data_type: 'mediumtext' > is_nullable: 1 > >+the state or province for your patron/borrower's primary address >+ > =head2 zipcode > > data_type: 'tinytext' > is_nullable: 1 > >+the zip or postal code for your patron/borrower's primary address >+ > =head2 country > > data_type: 'mediumtext' > is_nullable: 1 > >+the country for your patron/borrower's primary address >+ > =head2 email > > data_type: 'longtext' > is_nullable: 1 > >+the primary email address for your patron/borrower's primary address >+ > =head2 phone > > data_type: 'mediumtext' > is_nullable: 1 > >+the primary phone number for your patron/borrower's primary address >+ > =head2 mobile > > data_type: 'tinytext' > is_nullable: 1 > >+the other phone number for your patron/borrower's primary address >+ > =head2 fax > > data_type: 'longtext' > is_nullable: 1 > >+the fax number for your patron/borrower's primary address >+ > =head2 emailpro > > data_type: 'mediumtext' > is_nullable: 1 > >+the secondary email addres for your patron/borrower's primary address >+ > =head2 phonepro > > data_type: 'mediumtext' > is_nullable: 1 > >+the secondary phone number for your patron/borrower's primary address >+ > =head2 B_streetnumber > > accessor: 'b_streetnumber' > data_type: 'tinytext' > is_nullable: 1 > >+the house number for your patron/borrower's alternate address >+ > =head2 B_streettype > > accessor: 'b_streettype' > data_type: 'tinytext' > is_nullable: 1 > >+the street type (Rd., Blvd, etc) for your patron/borrower's alternate address >+ > =head2 B_address > > accessor: 'b_address' > data_type: 'mediumtext' > is_nullable: 1 > >+the first address line for your patron/borrower's alternate address >+ > =head2 B_address2 > > accessor: 'b_address2' > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for your patron/borrower's alternate address >+ > =head2 B_city > > accessor: 'b_city' > data_type: 'longtext' > is_nullable: 1 > >+the city or town for your patron/borrower's alternate address >+ > =head2 B_state > > accessor: 'b_state' > data_type: 'mediumtext' > is_nullable: 1 > >+the state for your patron/borrower's alternate address >+ > =head2 B_zipcode > > accessor: 'b_zipcode' > data_type: 'tinytext' > is_nullable: 1 > >+the zip or postal code for your patron/borrower's alternate address >+ > =head2 B_country > > accessor: 'b_country' > data_type: 'mediumtext' > is_nullable: 1 > >+the country for your patron/borrower's alternate address >+ > =head2 B_email > > accessor: 'b_email' > data_type: 'mediumtext' > is_nullable: 1 > >+the patron/borrower's alternate email address >+ > =head2 B_phone > > accessor: 'b_phone' > data_type: 'longtext' > is_nullable: 1 > >+the patron/borrower's alternate phone number >+ > =head2 dateofbirth > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the patron/borrower's date of birth (YYYY-MM-DD) >+ > =head2 branchcode > > data_type: 'varchar' >@@ -203,6 +267,8 @@ __PACKAGE__->table("deletedborrowers"); > is_nullable: 0 > size: 10 > >+foreign key from the branches table, includes the code of the patron/borrower's home branch >+ > =head2 categorycode > > data_type: 'varchar' >@@ -210,71 +276,89 @@ __PACKAGE__->table("deletedborrowers"); > is_nullable: 0 > size: 10 > >+foreign key from the categories table, includes the code of the patron category >+ > =head2 dateenrolled > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron was added to Koha (YYYY-MM-DD) >+ > =head2 dateexpiry > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron/borrower's card is set to expire (YYYY-MM-DD) >+ > =head2 date_renewed > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the patron/borrower's card was last renewed >+ > =head2 gonenoaddress > > data_type: 'tinyint' > is_nullable: 1 > >+set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address >+ > =head2 lost > > data_type: 'tinyint' > is_nullable: 1 > >+set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card >+ > =head2 debarred > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD) >+ > =head2 debarredcomment > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+comment on the stop of patron >+ > =head2 contactname > > data_type: 'longtext' > is_nullable: 1 > >+used for children and profesionals to include surname or last name of guarantor or organization name >+ > =head2 contactfirstname > > data_type: 'mediumtext' > is_nullable: 1 > >+used for children to include first name of guarantor >+ > =head2 contacttitle > > data_type: 'mediumtext' > is_nullable: 1 > >+used for children to include title (Mr., Mrs., etc) of guarantor >+ > =head2 borrowernotes > > data_type: 'longtext' > is_nullable: 1 > >-=head2 relationship >- >- data_type: 'varchar' >- is_nullable: 1 >- size: 100 >+a note on the patron/borrower's account that is only visible in the staff interface > > =head2 sex > >@@ -282,120 +366,164 @@ __PACKAGE__->table("deletedborrowers"); > is_nullable: 1 > size: 1 > >+patron/borrower's gender >+ > =head2 password > > data_type: 'varchar' > is_nullable: 1 > size: 60 > >+patron/borrower's encrypted password >+ > =head2 flags > > data_type: 'integer' > is_nullable: 1 > >+will include a number associated with the staff member's permissions >+ > =head2 userid > > data_type: 'varchar' > is_nullable: 1 > size: 75 > >+patron/borrower's opac and/or staff interface log in >+ > =head2 opacnote > > data_type: 'longtext' > is_nullable: 1 > >+a note on the patron/borrower's account that is visible in the OPAC and staff interface >+ > =head2 contactnote > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+a note related to the patron/borrower's alternate address >+ > =head2 sort1 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a field that can be used for any information unique to the library >+ > =head2 sort2 > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+a field that can be used for any information unique to the library >+ > =head2 altcontactfirstname > > data_type: 'mediumtext' > is_nullable: 1 > >+first name of alternate contact for the patron/borrower >+ > =head2 altcontactsurname > > data_type: 'mediumtext' > is_nullable: 1 > >+surname or last name of the alternate contact for the patron/borrower >+ > =head2 altcontactaddress1 > > data_type: 'mediumtext' > is_nullable: 1 > >+the first address line for the alternate contact for the patron/borrower >+ > =head2 altcontactaddress2 > > data_type: 'mediumtext' > is_nullable: 1 > >+the second address line for the alternate contact for the patron/borrower >+ > =head2 altcontactaddress3 > > data_type: 'mediumtext' > is_nullable: 1 > >+the city for the alternate contact for the patron/borrower >+ > =head2 altcontactstate > > data_type: 'mediumtext' > is_nullable: 1 > >+the state for the alternate contact for the patron/borrower >+ > =head2 altcontactzipcode > > data_type: 'mediumtext' > is_nullable: 1 > >+the zipcode for the alternate contact for the patron/borrower >+ > =head2 altcontactcountry > > data_type: 'mediumtext' > is_nullable: 1 > >+the country for the alternate contact for the patron/borrower >+ > =head2 altcontactphone > > data_type: 'mediumtext' > is_nullable: 1 > >+the phone number for the alternate contact for the patron/borrower >+ > =head2 smsalertnumber > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on) >+ > =head2 sms_provider_id > > data_type: 'integer' > is_nullable: 1 > >+the provider of the mobile phone number defined in smsalertnumber >+ > =head2 privacy > > data_type: 'integer' > default_value: 1 > is_nullable: 0 > >+patron/borrower's privacy settings related to their checkout history KEY `borrowernumber` (`borrowernumber`), >+ > =head2 privacy_guarantor_fines > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+controls if relatives can see this patron's fines >+ > =head2 privacy_guarantor_checkouts > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+controls if relatives can see this patron's checkouts >+ > =head2 checkprevcheckout > > data_type: 'varchar' >@@ -403,6 +531,8 @@ __PACKAGE__->table("deletedborrowers"); > is_nullable: 0 > size: 7 > >+produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -410,12 +540,16 @@ __PACKAGE__->table("deletedborrowers"); > default_value: current_timestamp > is_nullable: 0 > >+time of last change could be useful for synchronization with external systems (among others) >+ > =head2 lastseen > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+last time a patron has been seen (connected at the OPAC or staff interface) >+ > =head2 lang > > data_type: 'varchar' >@@ -423,29 +557,39 @@ __PACKAGE__->table("deletedborrowers"); > is_nullable: 0 > size: 25 > >+lang to use to send notices to this patron >+ > =head2 login_attempts > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+number of failed login attemps >+ > =head2 overdrive_auth_token > > data_type: 'mediumtext' > is_nullable: 1 > >+persist OverDrive auth token >+ > =head2 anonymized > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+flag for data anonymization >+ > =head2 autorenew_checkouts > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+flag for allowing auto-renewal >+ > =cut > > __PACKAGE__->add_columns( >@@ -539,8 +683,6 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "borrowernotes", > { data_type => "longtext", is_nullable => 1 }, >- "relationship", >- { data_type => "varchar", is_nullable => 1, size => 100 }, > "sex", > { data_type => "varchar", is_nullable => 1, size => 1 }, > "password", >@@ -623,8 +765,8 @@ __PACKAGE__->add_columns( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-07-20 10:54:51 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4xYIkJhZWN+O/s8cMYbJmw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UyLvm5ZrVFTPYwsI0yzNfQ > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm >index fbed06c6ce..e6922c92c6 100644 >--- a/Koha/Schema/Result/Deleteditem.pm >+++ b/Koha/Schema/Result/Deleteditem.pm >@@ -29,71 +29,95 @@ __PACKAGE__->table("deleteditems"); > default_value: 0 > is_nullable: 0 > >+primary key and unique identifier added by Koha >+ > =head2 biblionumber > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+foreign key from biblio table used to link this item to the right bib record >+ > =head2 biblioitemnumber > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+foreign key from the biblioitems table to link to item to additional information >+ > =head2 barcode > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+item barcode (MARC21 952$p) >+ > =head2 dateaccessioned > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was acquired or added to Koha (MARC21 952$d) >+ > =head2 booksellerid > > data_type: 'longtext' > is_nullable: 1 > >+where the item was purchased (MARC21 952$e) >+ > =head2 homebranch > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the branches table for the library that owns this item (MARC21 952$a) >+ > =head2 price > > data_type: 'decimal' > is_nullable: 1 > size: [8,2] > >+purchase price (MARC21 952$g) >+ > =head2 replacementprice > > data_type: 'decimal' > is_nullable: 1 > size: [8,2] > >+cost the library charges to replace the item if it has been marked lost (MARC21 952$v) >+ > =head2 replacementpricedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the price is effective from (MARC21 952$w) >+ > =head2 datelastborrowed > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was last checked out >+ > =head2 datelastseen > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was last see (usually the last time the barcode was scanned or inventory was done) >+ > =head2 stack > > data_type: 'tinyint' >@@ -105,91 +129,123 @@ __PACKAGE__->table("deleteditems"); > default_value: 0 > is_nullable: 0 > >+authorized value defining why this item is not for loan (MARC21 952$7) >+ > =head2 damaged > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as damaged (MARC21 952$4) >+ > =head2 damaged_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as damaged, NULL if not damaged >+ > =head2 itemlost > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as lost (MARC21 952$1) >+ > =head2 itemlost_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as lost, NULL if not lost >+ > =head2 withdrawn > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as withdrawn (MARC21 952$0) >+ > =head2 withdrawn_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as withdrawn, NULL if not withdrawn >+ > =head2 itemcallnumber > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+call number for this item (MARC21 952$o) >+ > =head2 coded_location_qualifier > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+coded location qualifier(MARC21 952$f) >+ > =head2 issues > > data_type: 'smallint' > default_value: 0 > is_nullable: 1 > >+number of times this item has been checked out >+ > =head2 renewals > > data_type: 'smallint' > is_nullable: 1 > >+number of times this item has been renewed >+ > =head2 reserves > > data_type: 'smallint' > is_nullable: 1 > >+number of times this item has been placed on hold/reserved >+ > =head2 restricted > > data_type: 'tinyint' > is_nullable: 1 > >+authorized value defining use restrictions for this item (MARC21 952$5) >+ > =head2 itemnotes > > data_type: 'longtext' > is_nullable: 1 > >+public notes on this item (MARC21 952$z) >+ > =head2 itemnotes_nonpublic > > data_type: 'longtext' > is_nullable: 1 > >+non-public notes on this item (MARC21 952$x) >+ > =head2 holdingbranch > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -197,91 +253,123 @@ __PACKAGE__->table("deleteditems"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this item was last altered >+ > =head2 location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+authorized value for the shelving location for this item (MARC21 952$c) >+ > =head2 permanent_location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+linked to the CART and PROC temporary locations feature, stores the permanent shelving location >+ > =head2 onloan > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+defines if item is checked out (NULL for not checked out, and due date for checked out) >+ > =head2 cn_source > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+classification source used on this item (MARC21 952$2) >+ > =head2 cn_sort > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+normalized form of the call number (MARC21 952$o) used for sorting >+ > =head2 ccode > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+authorized value for the collection code associated with this item (MARC21 952$8) >+ > =head2 materials > > data_type: 'mediumtext' > is_nullable: 1 > >+materials specified (MARC21 952$3) >+ > =head2 uri > > data_type: 'mediumtext' > is_nullable: 1 > >+URL for the item (MARC21 952$u) >+ > =head2 itype > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the itemtypes table defining the type for this item (MARC21 952$y) >+ > =head2 more_subfields_xml > > data_type: 'longtext' > is_nullable: 1 > >+additional 952 subfields in XML format >+ > =head2 enumchron > > data_type: 'mediumtext' > is_nullable: 1 > >+serial enumeration/chronology for the item (MARC21 952$h) >+ > =head2 copynumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+copy number (MARC21 952$t) >+ > =head2 stocknumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+inventory number (MARC21 952$i) >+ > =head2 new_status > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. >+ > =head2 exclude_from_local_holds_priority > > data_type: 'tinyint' > is_nullable: 1 > >+Exclude this item from local holds priority >+ > =cut > > __PACKAGE__->add_columns( >@@ -407,8 +495,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("itemnumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-30 15:31:01 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1l4g7uiQo9gkdrWbNxAsJg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kwBP6OCpv5LAt5GWGlrTgw > > __PACKAGE__->add_columns( > '+exclude_from_local_holds_priority' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Desk.pm b/Koha/Schema/Result/Desk.pm >index 9201a9315e..2aee4fc909 100644 >--- a/Koha/Schema/Result/Desk.pm >+++ b/Koha/Schema/Result/Desk.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("desks"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier >+ > =head2 desk_name > > data_type: 'varchar' >@@ -36,6 +38,8 @@ __PACKAGE__->table("desks"); > is_nullable: 0 > size: 100 > >+name of the desk >+ > =head2 branchcode > > data_type: 'varchar' >@@ -43,6 +47,8 @@ __PACKAGE__->table("desks"); > is_nullable: 0 > size: 10 > >+library the desk is located at >+ > =cut > > __PACKAGE__->add_columns( >@@ -99,8 +105,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Weoxj3CBeajLEzx9DBX1ag >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JGE5AStMT8DONyO4EHWtTg > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/HouseboundProfile.pm b/Koha/Schema/Result/HouseboundProfile.pm >index 0406e9f7a2..dfb8f20c6d 100644 >--- a/Koha/Schema/Result/HouseboundProfile.pm >+++ b/Koha/Schema/Result/HouseboundProfile.pm >@@ -29,41 +29,57 @@ __PACKAGE__->table("housebound_profile"); > is_foreign_key: 1 > is_nullable: 0 > >+Number of the borrower associated with this profile. >+ > =head2 day > > data_type: 'mediumtext' > is_nullable: 0 > >+The preferred day of the week for delivery. >+ > =head2 frequency > > data_type: 'mediumtext' > is_nullable: 0 > >+The Authorised_Value definining the pattern for delivery. >+ > =head2 fav_itemtypes > > data_type: 'mediumtext' > is_nullable: 1 > >+Free text describing preferred itemtypes. >+ > =head2 fav_subjects > > data_type: 'mediumtext' > is_nullable: 1 > >+Free text describing preferred subjects. >+ > =head2 fav_authors > > data_type: 'mediumtext' > is_nullable: 1 > >+Free text describing preferred authors. >+ > =head2 referral > > data_type: 'mediumtext' > is_nullable: 1 > >+Free text indicating how the borrower was added to the service. >+ > =head2 notes > > data_type: 'mediumtext' > is_nullable: 1 > >+Free text for additional notes. >+ > =cut > > __PACKAGE__->add_columns( >@@ -130,8 +146,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:ESpGqu3oX9qad3elnDvOiw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Kn8ysQJBBMF8hNU8sRrlig > > sub koha_object_class { > 'Koha::Patron::HouseboundProfile'; >diff --git a/Koha/Schema/Result/HouseboundRole.pm b/Koha/Schema/Result/HouseboundRole.pm >index 7c1489ed33..679faf5558 100644 >--- a/Koha/Schema/Result/HouseboundRole.pm >+++ b/Koha/Schema/Result/HouseboundRole.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("housebound_role"); > is_foreign_key: 1 > is_nullable: 0 > >+borrowernumber link >+ > =head2 housebound_chooser > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+set to 1 to indicate this patron is a housebound chooser volunteer >+ > =head2 housebound_deliverer > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+set to 1 to indicate this patron is a housebound deliverer volunteer >+ > =cut > > __PACKAGE__->add_columns( >@@ -82,8 +88,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-21 18:20:25 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SU7khVgiUf1OVvaFpKaFPA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VDQ+m99d4dXk8GOeXxSELQ > > sub koha_object_class { > 'Koha::Patron::HouseboundRole'; >diff --git a/Koha/Schema/Result/HouseboundVisit.pm b/Koha/Schema/Result/HouseboundVisit.pm >index 4f3b402bc4..e560a8750e 100644 >--- a/Koha/Schema/Result/HouseboundVisit.pm >+++ b/Koha/Schema/Result/HouseboundVisit.pm >@@ -29,36 +29,48 @@ __PACKAGE__->table("housebound_visit"); > is_auto_increment: 1 > is_nullable: 0 > >+ID of the visit. >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+Number of the borrower, & the profile, linked to this visit. >+ > =head2 appointment_date > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Date of visit. >+ > =head2 day_segment > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+Rough time frame: 'morning', 'afternoon' 'evening' >+ > =head2 chooser_brwnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+Number of the borrower to choose items for delivery. >+ > =head2 deliverer_brwnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+Number of the borrower to deliver items. >+ > =cut > > __PACKAGE__->add_columns( >@@ -146,8 +158,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-25 13:21:23 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5zyc7l2BtF5cgpZeKbJNZg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Prm180VwMowL77YrM+1z+g > > sub koha_object_class { > 'Koha::Patron::HouseboundVisit'; >diff --git a/Koha/Schema/Result/Illcomment.pm b/Koha/Schema/Result/Illcomment.pm >index 04a04370c4..2c3d52ba0f 100644 >--- a/Koha/Schema/Result/Illcomment.pm >+++ b/Koha/Schema/Result/Illcomment.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("illcomments"); > is_auto_increment: 1 > is_nullable: 0 > >+Unique ID of the comment >+ > =head2 illrequest_id > > data_type: 'bigint' >@@ -36,17 +38,23 @@ __PACKAGE__->table("illcomments"); > is_foreign_key: 1 > is_nullable: 0 > >+ILL request number >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+Link to the user who made the comment (could be librarian, patron or ILL partner library) >+ > =head2 comment > > data_type: 'text' > is_nullable: 1 > >+The text of the comment >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -54,6 +62,8 @@ __PACKAGE__->table("illcomments"); > default_value: current_timestamp > is_nullable: 0 > >+Date and time when the comment was made >+ > =cut > > __PACKAGE__->add_columns( >@@ -129,8 +139,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-26 19:57:17 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JJC9ohn0V61+WzMppDKUJw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QM8yi8lNH5hbnbhqaeIy2g > > > # 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 >index 4260a8d2df..ad7fe80c66 100644 >--- a/Koha/Schema/Result/Illrequest.pm >+++ b/Koha/Schema/Result/Illrequest.pm >@@ -30,17 +30,23 @@ __PACKAGE__->table("illrequests"); > is_auto_increment: 1 > is_nullable: 0 > >+ILL request number >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+Patron associated with request >+ > =head2 biblio_id > > data_type: 'integer' > is_nullable: 1 > >+Potential bib linked to request >+ > =head2 branchcode > > data_type: 'varchar' >@@ -48,12 +54,16 @@ __PACKAGE__->table("illrequests"); > is_nullable: 0 > size: 50 > >+The branch associated with the request >+ > =head2 status > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+Current Koha status of request >+ > =head2 status_alias > > data_type: 'varchar' >@@ -61,18 +71,24 @@ __PACKAGE__->table("illrequests"); > is_nullable: 1 > size: 80 > >+Foreign key to relevant authorised_values.authorised_value >+ > =head2 placed > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Date the request was placed >+ > =head2 replied > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Last API response >+ > =head2 updated > > data_type: 'timestamp' >@@ -86,52 +102,70 @@ __PACKAGE__->table("illrequests"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Date the request was completed >+ > =head2 medium > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+The Koha request type >+ > =head2 accessurl > > data_type: 'varchar' > is_nullable: 1 > size: 500 > >+Potential URL for accessing item >+ > =head2 cost > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+Quotes cost of request >+ > =head2 price_paid > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+Final cost of request >+ > =head2 notesopac > > data_type: 'mediumtext' > is_nullable: 1 > >+Patron notes attached to request >+ > =head2 notesstaff > > data_type: 'mediumtext' > is_nullable: 1 > >+Staff notes attached to request >+ > =head2 orderid > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+Backend id attached to request >+ > =head2 backend > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+The backend used to create request >+ > =cut > > __PACKAGE__->add_columns( >@@ -283,8 +317,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-22 14:32:49 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I6fY8XRfEmRxSzOeVT9Krw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GNYtw75SblcxetqJ0Jb7xA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Illrequestattribute.pm b/Koha/Schema/Result/Illrequestattribute.pm >index 7fa897c3e9..0740c35c69 100644 >--- a/Koha/Schema/Result/Illrequestattribute.pm >+++ b/Koha/Schema/Result/Illrequestattribute.pm >@@ -30,23 +30,31 @@ __PACKAGE__->table("illrequestattributes"); > is_foreign_key: 1 > is_nullable: 0 > >+ILL request number >+ > =head2 type > > data_type: 'varchar' > is_nullable: 0 > size: 200 > >+API ILL property name >+ > =head2 value > > data_type: 'mediumtext' > is_nullable: 0 > >+API ILL property value >+ > =head2 readonly > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+Is this attribute read only >+ > =cut > > __PACKAGE__->add_columns( >@@ -97,8 +105,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-05-17 09:17:53 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sFY1giVMz5AkXCPidhyGjw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f9g81zrH/C/Bg0Z1XkcF1g > > __PACKAGE__->add_columns( > '+readonly' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/ImportBatch.pm b/Koha/Schema/Result/ImportBatch.pm >index 829297596c..fe1d983e2c 100644 >--- a/Koha/Schema/Result/ImportBatch.pm >+++ b/Koha/Schema/Result/ImportBatch.pm >@@ -29,11 +29,15 @@ __PACKAGE__->table("import_batches"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier and primary key >+ > =head2 matcher_id > > data_type: 'integer' > is_nullable: 1 > >+the id of the match rule used (matchpoints.matcher_id) >+ > =head2 template_id > > data_type: 'integer' >@@ -51,12 +55,16 @@ __PACKAGE__->table("import_batches"); > default_value: 0 > is_nullable: 0 > >+number of records in the file >+ > =head2 num_items > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+number of items in the file >+ > =head2 upload_timestamp > > data_type: 'timestamp' >@@ -64,6 +72,8 @@ __PACKAGE__->table("import_batches"); > default_value: current_timestamp > is_nullable: 0 > >+date and time the file was uploaded >+ > =head2 overlay_action > > data_type: 'enum' >@@ -71,6 +81,8 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["replace","create_new","use_template","ignore"]} > is_nullable: 0 > >+how to handle duplicate records >+ > =head2 nomatch_action > > data_type: 'enum' >@@ -78,6 +90,8 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["create_new","ignore"]} > is_nullable: 0 > >+how to handle records where no match is found >+ > =head2 item_action > > data_type: 'enum' >@@ -85,6 +99,8 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["always_add","add_only_for_matches","add_only_for_new","ignore","replace"]} > is_nullable: 0 > >+what to do with item records >+ > =head2 import_status > > data_type: 'enum' >@@ -92,6 +108,8 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["staging","staged","importing","imported","reverting","reverted","cleaned"]} > is_nullable: 0 > >+the status of the imported file >+ > =head2 batch_type > > data_type: 'enum' >@@ -99,6 +117,8 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["batch","z3950","webservice"]} > is_nullable: 0 > >+where this batch has come from >+ > =head2 record_type > > data_type: 'enum' >@@ -106,17 +126,23 @@ __PACKAGE__->table("import_batches"); > extra: {list => ["biblio","auth","holdings"]} > is_nullable: 0 > >+type of record in the batch >+ > =head2 file_name > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+the name of the file uploaded >+ > =head2 comments > > data_type: 'longtext' > is_nullable: 1 > >+any comments added when the file was uploaded >+ > =head2 profile_id > > data_type: 'integer' >@@ -263,8 +289,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-06 13:52:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nnGJ0Nvgiz123+ic7v0GqQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JAr+Z5i1SrCL1TITWad58g > > =head2 koha_object_class > >diff --git a/Koha/Schema/Result/ImportBatchProfile.pm b/Koha/Schema/Result/ImportBatchProfile.pm >index fb309cde71..d4bbacbc74 100644 >--- a/Koha/Schema/Result/ImportBatchProfile.pm >+++ b/Koha/Schema/Result/ImportBatchProfile.pm >@@ -29,68 +29,92 @@ __PACKAGE__->table("import_batch_profiles"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier and primary key >+ > =head2 name > > data_type: 'varchar' > is_nullable: 0 > size: 100 > >+name of this profile >+ > =head2 matcher_id > > data_type: 'integer' > is_nullable: 1 > >+the id of the match rule used (matchpoints.matcher_id) >+ > =head2 template_id > > data_type: 'integer' > is_nullable: 1 > >+the id of the marc modification template >+ > =head2 overlay_action > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+how to handle duplicate records >+ > =head2 nomatch_action > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+how to handle records where no match is found >+ > =head2 item_action > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+what to do with item records >+ > =head2 parse_items > > data_type: 'tinyint' > is_nullable: 1 > >+should items be parsed >+ > =head2 record_type > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+type of record in the batch >+ > =head2 encoding > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+file encoding >+ > =head2 format > > data_type: 'varchar' > is_nullable: 1 > size: 50 > >+marc format >+ > =head2 comments > > data_type: 'longtext' > is_nullable: 1 > >+any comments added when the file was uploaded >+ > =cut > > __PACKAGE__->add_columns( >@@ -164,8 +188,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-06 13:52:29 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kThbQZTT2c0fuWAGgvoDLQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SsG6P/HVwk5ffR0kx6rpNA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/ImportRecordMatch.pm b/Koha/Schema/Result/ImportRecordMatch.pm >index 0ea5d56914..bcce7e319f 100644 >--- a/Koha/Schema/Result/ImportRecordMatch.pm >+++ b/Koha/Schema/Result/ImportRecordMatch.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("import_record_matches"); > is_foreign_key: 1 > is_nullable: 0 > >+the id given to the imported bib record (import_records.import_record_id) >+ > =head2 candidate_match_id > > data_type: 'integer' > is_nullable: 0 > >+the biblio the imported record matches (biblio.biblionumber) >+ > =head2 score > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+the match score >+ > =cut > > __PACKAGE__->add_columns( >@@ -69,8 +75,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:hJW36EeP+H8+0/Ij3iuIFw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DQgMbHk2TGPgbka2NJEDKQ > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm >index 24f69275d7..bf95c39cc1 100644 >--- a/Koha/Schema/Result/Issue.pm >+++ b/Koha/Schema/Result/Issue.pm >@@ -29,72 +29,96 @@ __PACKAGE__->table("issues"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key for issues table >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the borrowers table for the patron this item was checked out to >+ > =head2 issuer_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the borrowers table for the user who checked out this item >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the items table for the item that was checked out >+ > =head2 date_due > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+datetime the item is due (yyyy-mm-dd hh:mm::ss) >+ > =head2 branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key, linking to the branches table for the location the item was checked out >+ > =head2 returndate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was returned, will be NULL until moved to old_issues >+ > =head2 lastreneweddate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was last renewed >+ > =head2 renewals > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+lists the number of times the item was renewed >+ > =head2 unseen_renewals > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+lists the number of consecutive times the item was renewed without being seen >+ > =head2 auto_renew > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+automatic renewal >+ > =head2 auto_renew_error > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+automatic renewal error >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -102,34 +126,46 @@ __PACKAGE__->table("issues"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this record was last touched >+ > =head2 issuedate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was checked out or issued >+ > =head2 onsite_checkout > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+in house use flag >+ > =head2 note > > data_type: 'longtext' > is_nullable: 1 > >+issue note text >+ > =head2 notedate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+datetime of issue note (yyyy-mm-dd hh:mm::ss) >+ > =head2 noteseen > > data_type: 'integer' > is_nullable: 1 > >+describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null >+ > =cut > > __PACKAGE__->add_columns( >@@ -300,8 +336,8 @@ __PACKAGE__->might_have( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SbeR9Pgvk2sMd+dYPAiCeA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UZCAInCKLuz8hLkUsgL5wQ > > __PACKAGE__->add_columns( > '+auto_renew' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm >index cd22433ad2..802782e06a 100644 >--- a/Koha/Schema/Result/Item.pm >+++ b/Koha/Schema/Result/Item.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("items"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key and unique identifier added by Koha >+ > =head2 biblionumber > > data_type: 'integer' >@@ -36,6 +38,8 @@ __PACKAGE__->table("items"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from biblio table used to link this item to the right bib record >+ > =head2 biblioitemnumber > > data_type: 'integer' >@@ -43,23 +47,31 @@ __PACKAGE__->table("items"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the biblioitems table to link to item to additional information >+ > =head2 barcode > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+item barcode (MARC21 952$p) >+ > =head2 dateaccessioned > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was acquired or added to Koha (MARC21 952$d) >+ > =head2 booksellerid > > data_type: 'longtext' > is_nullable: 1 > >+where the item was purchased (MARC21 952$e) >+ > =head2 homebranch > > data_type: 'varchar' >@@ -67,36 +79,48 @@ __PACKAGE__->table("items"); > is_nullable: 1 > size: 10 > >+foreign key from the branches table for the library that owns this item (MARC21 952$a) >+ > =head2 price > > data_type: 'decimal' > is_nullable: 1 > size: [8,2] > >+purchase price (MARC21 952$g) >+ > =head2 replacementprice > > data_type: 'decimal' > is_nullable: 1 > size: [8,2] > >+cost the library charges to replace the item if it has been marked lost (MARC21 952$v) >+ > =head2 replacementpricedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the price is effective from (MARC21 952$w) >+ > =head2 datelastborrowed > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was last checked out/issued >+ > =head2 datelastseen > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was last see (usually the last time the barcode was scanned or inventory was done) >+ > =head2 stack > > data_type: 'tinyint' >@@ -108,85 +132,115 @@ __PACKAGE__->table("items"); > default_value: 0 > is_nullable: 0 > >+authorized value defining why this item is not for loan (MARC21 952$7) >+ > =head2 damaged > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as damaged (MARC21 952$4) >+ > =head2 damaged_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as damaged, NULL if not damaged >+ > =head2 itemlost > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as lost (MARC21 952$1) >+ > =head2 itemlost_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as lost, NULL if not lost >+ > =head2 withdrawn > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+authorized value defining this item as withdrawn (MARC21 952$0) >+ > =head2 withdrawn_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time an item was last marked as withdrawn, NULL if not withdrawn >+ > =head2 itemcallnumber > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+call number for this item (MARC21 952$o) >+ > =head2 coded_location_qualifier > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+coded location qualifier(MARC21 952$f) >+ > =head2 issues > > data_type: 'smallint' > default_value: 0 > is_nullable: 1 > >+number of times this item has been checked out/issued >+ > =head2 renewals > > data_type: 'smallint' > is_nullable: 1 > >+number of times this item has been renewed >+ > =head2 reserves > > data_type: 'smallint' > is_nullable: 1 > >+number of times this item has been placed on hold/reserved >+ > =head2 restricted > > data_type: 'tinyint' > is_nullable: 1 > >+authorized value defining use restrictions for this item (MARC21 952$5) >+ > =head2 itemnotes > > data_type: 'longtext' > is_nullable: 1 > >+public notes on this item (MARC21 952$z) >+ > =head2 itemnotes_nonpublic > > data_type: 'longtext' > is_nullable: 1 > >+non-public notes on this item (MARC21 952$x) >+ > =head2 holdingbranch > > data_type: 'varchar' >@@ -194,6 +248,8 @@ __PACKAGE__->table("items"); > is_nullable: 1 > size: 10 > >+foreign key from the branches table for the library that is currently in possession item (MARC21 952$b) >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -201,91 +257,123 @@ __PACKAGE__->table("items"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this item was last altered >+ > =head2 location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+authorized value for the shelving location for this item (MARC21 952$c) >+ > =head2 permanent_location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+linked to the CART and PROC temporary locations feature, stores the permanent shelving location >+ > =head2 onloan > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+defines if item is checked out (NULL for not checked out, and due date for checked out) >+ > =head2 cn_source > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+classification source used on this item (MARC21 952$2) >+ > =head2 cn_sort > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+normalized form of the call number (MARC21 952$o) used for sorting >+ > =head2 ccode > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+authorized value for the collection code associated with this item (MARC21 952$8) >+ > =head2 materials > > data_type: 'mediumtext' > is_nullable: 1 > >+materials specified (MARC21 952$3) >+ > =head2 uri > > data_type: 'mediumtext' > is_nullable: 1 > >+URL for the item (MARC21 952$u) >+ > =head2 itype > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the itemtypes table defining the type for this item (MARC21 952$y) >+ > =head2 more_subfields_xml > > data_type: 'longtext' > is_nullable: 1 > >+additional 952 subfields in XML format >+ > =head2 enumchron > > data_type: 'mediumtext' > is_nullable: 1 > >+serial enumeration/chronology for the item (MARC21 952$h) >+ > =head2 copynumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+copy number (MARC21 952$t) >+ > =head2 stocknumber > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+inventory number (MARC21 952$i) >+ > =head2 new_status > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob. >+ > =head2 exclude_from_local_holds_priority > > data_type: 'tinyint' > is_nullable: 1 > >+Exclude this item from local holds priority >+ > =cut > > __PACKAGE__->add_columns( >@@ -762,8 +850,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-10-12 09:13:32 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pmAVO6LxCb6wAJvfh+rndw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GopLobaZCA20jNnT9qoNHw > > __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); > >diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm >index 3a4c46ae1d..10b5333b31 100644 >--- a/Koha/Schema/Result/Itemtype.pm >+++ b/Koha/Schema/Result/Itemtype.pm >@@ -30,6 +30,8 @@ __PACKAGE__->table("itemtypes"); > is_nullable: 0 > size: 10 > >+unique key, a code associated with the item type >+ > =head2 parent_type > > data_type: 'varchar' >@@ -37,75 +39,101 @@ __PACKAGE__->table("itemtypes"); > is_nullable: 1 > size: 10 > >+unique key, a code associated with the item type >+ > =head2 description > > data_type: 'longtext' > is_nullable: 1 > >+a plain text explanation of the item type >+ > =head2 rentalcharge > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the amount charged when this item is checked out/issued >+ > =head2 rentalcharge_daily > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the amount charged for each day between checkout date and due date >+ > =head2 rentalcharge_daily_calendar > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+controls if the daily rental fee is calculated directly or using finesCalendar >+ > =head2 rentalcharge_hourly > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+the amount charged for each hour between checkout date and due date >+ > =head2 rentalcharge_hourly_calendar > > data_type: 'tinyint' > default_value: 1 > is_nullable: 0 > >+controls if the hourly rental fee is calculated directly or using finesCalendar >+ > =head2 defaultreplacecost > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+default replacement cost >+ > =head2 processfee > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+default text be recorded in the column note when the processing fee is applied >+ > =head2 notforloan > > data_type: 'smallint' > is_nullable: 1 > >+1 if the item is not for loan, 0 if the item is available for loan >+ > =head2 imageurl > > data_type: 'varchar' > is_nullable: 1 > size: 200 > >+URL for the item type icon >+ > =head2 summary > > data_type: 'mediumtext' > is_nullable: 1 > >+information from the summary field, may include HTML >+ > =head2 checkinmsg > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+message that is displayed when an item with the given item type is checked in >+ > =head2 checkinmsgtype > > data_type: 'char' >@@ -113,24 +141,32 @@ __PACKAGE__->table("itemtypes"); > is_nullable: 0 > size: 16 > >+type (CSS class) for the checkinmsg, can be 'alert' or 'message' >+ > =head2 sip_media_type > > data_type: 'varchar' > is_nullable: 1 > size: 3 > >+SIP2 protocol media type for this itemtype >+ > =head2 hideinopac > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Hide the item type from the search options in OPAC >+ > =head2 searchcategory > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+Group this item type with others with the same value on OPAC search options >+ > =cut > > __PACKAGE__->add_columns( >@@ -287,8 +323,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-08-13 08:14:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5RxmTmtrwJJhTZMur1N05A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ySigxOH7NOKTJVVABRM2dA > > __PACKAGE__->add_columns( > '+rentalcharge_hourly_calendar' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/LanguageScriptBidi.pm b/Koha/Schema/Result/LanguageScriptBidi.pm >index 7272374da4..aea7c38e13 100644 >--- a/Koha/Schema/Result/LanguageScriptBidi.pm >+++ b/Koha/Schema/Result/LanguageScriptBidi.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("language_script_bidi"); > is_nullable: 1 > size: 25 > >+script subtag, Arab, Hebr, etc. >+ > =head2 bidi > > data_type: 'varchar' > is_nullable: 1 > size: 3 > >+rtl ltr >+ > =cut > > __PACKAGE__->add_columns( >@@ -45,8 +49,8 @@ __PACKAGE__->add_columns( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TBR2kCdB/nvEcdDo8I4rQA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XWgChkbVuJUVI3XA7bLukA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/LanguageSubtagRegistry.pm b/Koha/Schema/Result/LanguageSubtagRegistry.pm >index b93780295c..088ca43065 100644 >--- a/Koha/Schema/Result/LanguageSubtagRegistry.pm >+++ b/Koha/Schema/Result/LanguageSubtagRegistry.pm >@@ -35,12 +35,16 @@ __PACKAGE__->table("language_subtag_registry"); > is_nullable: 1 > size: 25 > >+language-script-region-variant-extension-privateuse >+ > =head2 description > > data_type: 'varchar' > is_nullable: 1 > size: 25 > >+only one of the possible descriptions for ease of reference, see language_descriptions for the complete list >+ > =head2 added > > data_type: 'date' >@@ -81,8 +85,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rauj/sMGM6sskKuMC/XRcQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0iEdEFKPcFdTsPE9Gi0XOA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Letter.pm b/Koha/Schema/Result/Letter.pm >index 42fd22a793..ba5bc6f2b4 100644 >--- a/Koha/Schema/Result/Letter.pm >+++ b/Koha/Schema/Result/Letter.pm >@@ -30,6 +30,8 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 20 > >+Koha module that triggers this notice or slip >+ > =head2 code > > data_type: 'varchar' >@@ -37,6 +39,8 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 20 > >+unique identifier for this notice or slip >+ > =head2 branchcode > > data_type: 'varchar' >@@ -44,6 +48,8 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 10 > >+the branch this notice or slip is used at (branches.branchcode) >+ > =head2 name > > data_type: 'varchar' >@@ -51,12 +57,16 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 100 > >+plain text name for this notice or slip >+ > =head2 is_html > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+does this notice or slip use HTML (1 for yes, 0 for no) >+ > =head2 title > > data_type: 'varchar' >@@ -64,11 +74,15 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 200 > >+subject line of the notice >+ > =head2 content > > data_type: 'mediumtext' > is_nullable: 1 > >+body text for the notice or slip >+ > =head2 message_transport_type > > data_type: 'varchar' >@@ -77,6 +91,8 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 20 > >+transport type for this notice >+ > =head2 lang > > data_type: 'varchar' >@@ -84,6 +100,8 @@ __PACKAGE__->table("letter"); > is_nullable: 0 > size: 25 > >+lang of the notice >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -91,6 +109,8 @@ __PACKAGE__->table("letter"); > default_value: current_timestamp > is_nullable: 0 > >+last modification >+ > =cut > > __PACKAGE__->add_columns( >@@ -170,8 +190,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-30 15:33:05 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gjuJZIDufXefljX+aP2TPg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/YnudVRAGDv9Ornd02Z3tw > > sub koha_object_class { > 'Koha::Notice::Template'; >diff --git a/Koha/Schema/Result/LibraryGroup.pm b/Koha/Schema/Result/LibraryGroup.pm >index 6ffb7a8ac4..fb5dadbebd 100644 >--- a/Koha/Schema/Result/LibraryGroup.pm >+++ b/Koha/Schema/Result/LibraryGroup.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("library_groups"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id for each group >+ > =head2 parent_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+if this is a child group, the id of the parent group >+ > =head2 branchcode > > data_type: 'varchar' >@@ -42,47 +46,63 @@ __PACKAGE__->table("library_groups"); > is_nullable: 1 > size: 10 > >+The branchcode of a branch belonging to the parent group >+ > =head2 title > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+Short description of the goup >+ > =head2 description > > data_type: 'mediumtext' > is_nullable: 1 > >+Longer explanation of the group, if necessary >+ > =head2 ft_hide_patron_info > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Turn on the feature 'Hide patron's info' for this group >+ > =head2 ft_search_groups_opac > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Use this group for staff side search groups >+ > =head2 ft_search_groups_staff > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Use this group for opac side search groups >+ > =head2 ft_local_hold_group > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Use this group to identify libraries as pick up location for holds >+ > =head2 created_on > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Date and time of creation >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -90,6 +110,8 @@ __PACKAGE__->table("library_groups"); > default_value: current_timestamp > is_nullable: 0 > >+Date and time of last >+ > =cut > > __PACKAGE__->add_columns( >@@ -224,8 +246,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-30 15:43:39 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qg0Ckj0ZBRjSaQgEcvxSZA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M88qvFivMH/m7Jp+gy9stw > > sub koha_object_class { > 'Koha::Library::Group'; >diff --git a/Koha/Schema/Result/Linktracker.pm b/Koha/Schema/Result/Linktracker.pm >index d36c177a09..5d480b43fc 100644 >--- a/Koha/Schema/Result/Linktracker.pm >+++ b/Koha/Schema/Result/Linktracker.pm >@@ -29,32 +29,44 @@ __PACKAGE__->table("linktracker"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key identifier >+ > =head2 biblionumber > > data_type: 'integer' > is_nullable: 1 > >+biblionumber of the record the link is from >+ > =head2 itemnumber > > data_type: 'integer' > is_nullable: 1 > >+itemnumber if applicable that the link was from >+ > =head2 borrowernumber > > data_type: 'integer' > is_nullable: 1 > >+borrowernumber who clicked the link >+ > =head2 url > > data_type: 'mediumtext' > is_nullable: 1 > >+the link itself >+ > =head2 timeclicked > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date and time the link was clicked >+ > =cut > > __PACKAGE__->add_columns( >@@ -89,8 +101,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MSNByG1qh/5CpRYTcLv/gA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hvFaGAQ5h4gEAk2zggg2XA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Localization.pm b/Koha/Schema/Result/Localization.pm >index dec7ebff50..72f3ca366d 100644 >--- a/Koha/Schema/Result/Localization.pm >+++ b/Koha/Schema/Result/Localization.pm >@@ -47,6 +47,8 @@ __PACKAGE__->table("localization"); > is_nullable: 0 > size: 25 > >+could be a foreign key >+ > =head2 translation > > data_type: 'mediumtext' >@@ -98,8 +100,8 @@ __PACKAGE__->set_primary_key("localization_id"); > __PACKAGE__->add_unique_constraint("entity_code_lang", ["entity", "code", "lang"]); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4642LmshpGd3JW7YxM5pIA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3m5AhwkBUV0eL112dIW8ng > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Message.pm b/Koha/Schema/Result/Message.pm >index 4f4237ed6b..a8c9efc4ca 100644 >--- a/Koha/Schema/Result/Message.pm >+++ b/Koha/Schema/Result/Message.pm >@@ -29,29 +29,39 @@ __PACKAGE__->table("messages"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key linking this message to the borrowers table >+ > =head2 branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key linking the message to the branches table >+ > =head2 message_type > > data_type: 'varchar' > is_nullable: 0 > size: 1 > >+whether the message is for the librarians (L) or the patron (B) >+ > =head2 message > > data_type: 'mediumtext' > is_nullable: 0 > >+the text of the message >+ > =head2 message_date > > data_type: 'timestamp' >@@ -59,12 +69,16 @@ __PACKAGE__->table("messages"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time the message was written >+ > =head2 manager_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+creator of message >+ > =cut > > __PACKAGE__->add_columns( >@@ -139,8 +153,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-02-15 13:15:09 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kYM+0CFPm/wdNp7EosdlRw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EDJMOeEw3pPEpeUXVHo7dQ > > sub koha_object_class { > 'Koha::Patron::Message'; >diff --git a/Koha/Schema/Result/MiscFile.pm b/Koha/Schema/Result/MiscFile.pm >index c194ce0fa0..01bd03ec42 100644 >--- a/Koha/Schema/Result/MiscFile.pm >+++ b/Koha/Schema/Result/MiscFile.pm >@@ -29,40 +29,54 @@ __PACKAGE__->table("misc_files"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id for the file record >+ > =head2 table_tag > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+usually table name, or arbitrary unique tag >+ > =head2 record_id > > data_type: 'integer' > is_nullable: 0 > >+record id from the table this file is associated to >+ > =head2 file_name > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+file name >+ > =head2 file_type > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+MIME type of the file >+ > =head2 file_description > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+description given to the file >+ > =head2 file_content > > data_type: 'longblob' > is_nullable: 0 > >+file content >+ > =head2 date_uploaded > > data_type: 'timestamp' >@@ -70,6 +84,8 @@ __PACKAGE__->table("misc_files"); > default_value: current_timestamp > is_nullable: 0 > >+date and time the file was added >+ > =cut > > __PACKAGE__->add_columns( >@@ -109,8 +125,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("file_id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-05-25 21:17:02 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VWGyKXxK0dqymMsEGCjJxg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1ew2RboOyOxRy2vR+nqFJA > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/NeedMergeAuthority.pm b/Koha/Schema/Result/NeedMergeAuthority.pm >index a4e4795e11..076252163d 100644 >--- a/Koha/Schema/Result/NeedMergeAuthority.pm >+++ b/Koha/Schema/Result/NeedMergeAuthority.pm >@@ -29,21 +29,29 @@ __PACKAGE__->table("need_merge_authorities"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id >+ > =head2 authid > > data_type: 'bigint' > is_nullable: 0 > >+reference to original authority record >+ > =head2 authid_new > > data_type: 'bigint' > is_nullable: 1 > >+reference to optional new authority record >+ > =head2 reportxml > > data_type: 'mediumtext' > is_nullable: 1 > >+xml showing original reporting tag >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -51,6 +59,8 @@ __PACKAGE__->table("need_merge_authorities"); > default_value: current_timestamp > is_nullable: 0 > >+date and time last modified >+ > =head2 done > > data_type: 'tinyint' >@@ -92,8 +102,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7LzwIYvExKvNgr8/HDZlsg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iJYZ7R+5yHKLG5U3xvI7vw > > sub koha_object_class { > 'Koha::Authority::MergeRequest'; >diff --git a/Koha/Schema/Result/OauthAccessToken.pm b/Koha/Schema/Result/OauthAccessToken.pm >index 6e14006d0c..c15f99dc85 100644 >--- a/Koha/Schema/Result/OauthAccessToken.pm >+++ b/Koha/Schema/Result/OauthAccessToken.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("oauth_access_tokens"); > is_nullable: 0 > size: 191 > >+generarated access token >+ > =head2 client_id > > data_type: 'varchar' > is_nullable: 0 > size: 191 > >+the client id the access token belongs to >+ > =head2 expires > > data_type: 'integer' > is_nullable: 0 > >+expiration time in seconds >+ > =cut > > __PACKAGE__->add_columns( >@@ -64,8 +70,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("access_token"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-05-09 12:50:58 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M6tueO6jmJwgmwMrqO1L0Q >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qP6pU3XXXz5PFHJXHnRxLg > > sub koha_object_class { > 'Koha::OAuthAccessToken'; >diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm >index f39389a49a..f2a4121673 100644 >--- a/Koha/Schema/Result/OldIssue.pm >+++ b/Koha/Schema/Result/OldIssue.pm >@@ -28,72 +28,96 @@ __PACKAGE__->table("old_issues"); > data_type: 'integer' > is_nullable: 0 > >+primary key for issues table >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the borrowers table for the patron this item was checked out to >+ > =head2 issuer_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the borrowers table for the user who checked out this item >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key, linking this to the items table for the item that was checked out >+ > =head2 date_due > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item is due (yyyy-mm-dd) >+ > =head2 branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key, linking to the branches table for the location the item was checked out >+ > =head2 returndate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was returned >+ > =head2 lastreneweddate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was last renewed >+ > =head2 renewals > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+lists the number of times the item was renewed >+ > =head2 unseen_renewals > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+lists the number of consecutive times the item was renewed without being seen >+ > =head2 auto_renew > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+automatic renewal >+ > =head2 auto_renew_error > > data_type: 'varchar' > is_nullable: 1 > size: 32 > >+automatic renewal error >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -101,34 +125,46 @@ __PACKAGE__->table("old_issues"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this record was last touched >+ > =head2 issuedate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the item was checked out or issued >+ > =head2 onsite_checkout > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+in house use flag >+ > =head2 note > > data_type: 'longtext' > is_nullable: 1 > >+issue note text >+ > =head2 notedate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+datetime of issue note (yyyy-mm-dd hh:mm::ss) >+ > =head2 noteseen > > data_type: 'integer' > is_nullable: 1 > >+describes whether checkout note has been seen 1, not been seen 0 or doesn't exist null >+ > =cut > > __PACKAGE__->add_columns( >@@ -270,8 +306,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-11-11 14:23:25 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TvYB0Fiet6DBvDkRf/BRAg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:B5UJmyy6RttUfrn6Yfl+7w > > __PACKAGE__->add_columns( > '+auto_renew' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm >index a65cef0814..adf72dd95e 100644 >--- a/Koha/Schema/Result/OldReserve.pm >+++ b/Koha/Schema/Result/OldReserve.pm >@@ -28,76 +28,102 @@ __PACKAGE__->table("old_reserves"); > data_type: 'integer' > is_nullable: 0 > >+primary key >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the borrowers table defining which patron this hold is for >+ > =head2 reservedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the hold was places >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the biblio table defining which bib record this hold is on >+ > =head2 branchcode > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the branches table defining which branch the patron wishes to pick this hold up at >+ > =head2 desk_id > > data_type: 'integer' > is_nullable: 1 > >+foreign key from the desks table defining which desk the patron should pick this hold up at >+ > =head2 notificationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+currently unused >+ > =head2 reminderdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+currently unused >+ > =head2 cancellationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this hold was cancelled >+ > =head2 cancellation_reason > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+optional authorised value CANCELLATION_REASON >+ > =head2 reservenotes > > data_type: 'longtext' > is_nullable: 1 > >+notes related to this hold >+ > =head2 priority > > data_type: 'smallint' > default_value: 1 > is_nullable: 0 > >+where in the queue the patron sits >+ > =head2 found > > data_type: 'varchar' > is_nullable: 1 > size: 1 > >+a one letter code defining what the status is of the hold is after it has been confirmed >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -105,24 +131,32 @@ __PACKAGE__->table("old_reserves"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this hold was last updated >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with >+ > =head2 waitingdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was marked as waiting for the patron at the library >+ > =head2 expirationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) >+ > =head2 lowestPriority > > accessor: 'lowest_priority' >@@ -130,18 +164,24 @@ __PACKAGE__->table("old_reserves"); > default_value: 0 > is_nullable: 0 > >+has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) >+ > =head2 suspend > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+in this hold suspended (1 for yes, 0 for no) >+ > =head2 suspend_until > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this hold is suspended until (NULL for infinitely) >+ > =head2 itemtype > > data_type: 'varchar' >@@ -149,18 +189,24 @@ __PACKAGE__->table("old_reserves"); > is_nullable: 1 > size: 10 > >+If record level hold, the optional itemtype of the item the patron is requesting >+ > =head2 item_level_hold > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Is the hpld placed at item level >+ > =head2 non_priority > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Is this a non priority hold >+ > =cut > > __PACKAGE__->add_columns( >@@ -321,8 +367,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7weIpuc0RpZ/MxFn94E8dg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UH6coasIQnguSLtDdr6HEg > > __PACKAGE__->belongs_to( > "item", >diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm >index 2f4964ddbc..42b9cfc5e3 100644 >--- a/Koha/Schema/Result/OpacNews.pm >+++ b/Koha/Schema/Result/OpacNews.pm >@@ -30,6 +30,8 @@ __PACKAGE__->table("opac_news"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for the news article >+ > =head2 branchcode > > data_type: 'varchar' >@@ -37,6 +39,8 @@ __PACKAGE__->table("opac_news"); > is_nullable: 1 > size: 10 > >+branch code users to create branch specific news, NULL is every branch. >+ > =head2 title > > data_type: 'varchar' >@@ -44,11 +48,15 @@ __PACKAGE__->table("opac_news"); > is_nullable: 0 > size: 250 > >+title of the news article >+ > =head2 content > > data_type: 'mediumtext' > is_nullable: 0 > >+the body of your news article >+ > =head2 lang > > data_type: 'varchar' >@@ -56,12 +64,16 @@ __PACKAGE__->table("opac_news"); > is_nullable: 0 > size: 50 > >+location for the article (koha is the staff interface, slip is the circulation receipt and language codes are for the opac) >+ > =head2 published_on > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+publication date >+ > =head2 updated_on > > data_type: 'timestamp' >@@ -69,23 +81,31 @@ __PACKAGE__->table("opac_news"); > default_value: current_timestamp > is_nullable: 0 > >+last modification >+ > =head2 expirationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the article is set to expire or no longer be visible >+ > =head2 number > > data_type: 'integer' > is_nullable: 1 > >+the order in which this article appears in that specific location >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+The user who created the news article >+ > =cut > > __PACKAGE__->add_columns( >@@ -176,8 +196,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-02 12:50:13 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKAwgZM6jqOTbksraZb21w >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d05UDcRR2JQeyM7yLPxRWw > > sub koha_object_class { > 'Koha::NewsItem'; >diff --git a/Koha/Schema/Result/Overduerule.pm b/Koha/Schema/Result/Overduerule.pm >index 1d248ed394..12d1b10f9b 100644 >--- a/Koha/Schema/Result/Overduerule.pm >+++ b/Koha/Schema/Result/Overduerule.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("overduerules"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for the overduerules >+ > =head2 branchcode > > data_type: 'varchar' >@@ -36,6 +38,8 @@ __PACKAGE__->table("overduerules"); > is_nullable: 0 > size: 10 > >+foreign key from the branches table to define which branch this rule is for (if blank it's all libraries) >+ > =head2 categorycode > > data_type: 'varchar' >@@ -43,17 +47,23 @@ __PACKAGE__->table("overduerules"); > is_nullable: 0 > size: 10 > >+foreign key from the categories table to define which patron category this rule is for >+ > =head2 delay1 > > data_type: 'integer' > is_nullable: 1 > >+number of days after the item is overdue that the first notice is sent >+ > =head2 letter1 > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+foreign key from the letter table to define which notice should be sent as the first notice >+ > =head2 debarred1 > > data_type: 'varchar' >@@ -61,11 +71,15 @@ __PACKAGE__->table("overduerules"); > is_nullable: 1 > size: 1 > >+is the patron restricted when the first notice is sent (1 for yes, 0 for no) >+ > =head2 delay2 > > data_type: 'integer' > is_nullable: 1 > >+number of days after the item is overdue that the second notice is sent >+ > =head2 debarred2 > > data_type: 'varchar' >@@ -73,29 +87,39 @@ __PACKAGE__->table("overduerules"); > is_nullable: 1 > size: 1 > >+is the patron restricted when the second notice is sent (1 for yes, 0 for no) >+ > =head2 letter2 > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+foreign key from the letter table to define which notice should be sent as the second notice >+ > =head2 delay3 > > data_type: 'integer' > is_nullable: 1 > >+number of days after the item is overdue that the third notice is sent >+ > =head2 letter3 > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+foreign key from the letter table to define which notice should be sent as the third notice >+ > =head2 debarred3 > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+is the patron restricted when the third notice is sent (1 for yes, 0 for no) >+ > =cut > > __PACKAGE__->add_columns( >@@ -171,8 +195,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 12:00:28 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Opfa1YZ3IeQRRbyrbKAkNQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xf0rcjwRs7RNXYRGwmXVpg > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/PatronConsent.pm b/Koha/Schema/Result/PatronConsent.pm >index bf0d6e1510..7009581542 100644 >--- a/Koha/Schema/Result/PatronConsent.pm >+++ b/Koha/Schema/Result/PatronConsent.pm >@@ -41,6 +41,8 @@ __PACKAGE__->table("patron_consent"); > extra: {list => ["GDPR_PROCESSING"]} > is_nullable: 1 > >+allows for future extension >+ > =head2 given_on > > data_type: 'datetime' >@@ -110,8 +112,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:as3b13eS31zkIPr9uxP7+A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ru+EK+OWW8yuZKiKnUq8RQ > > sub koha_object_class { > 'Koha::Patron::Consent'; >diff --git a/Koha/Schema/Result/PatronList.pm b/Koha/Schema/Result/PatronList.pm >index f755f85585..7d077667de 100644 >--- a/Koha/Schema/Result/PatronList.pm >+++ b/Koha/Schema/Result/PatronList.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("patron_lists"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier >+ > =head2 name > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+the list's name >+ > =head2 owner > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+borrowernumber of the list creator >+ > =head2 shared > > data_type: 'tinyint' >@@ -105,8 +111,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-18 16:54:33 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ulv0BHLlcWdeLgD6qPxmUQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZAHlIRS467WC+83XxPZTDQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/PatronListPatron.pm b/Koha/Schema/Result/PatronListPatron.pm >index 441d7a443c..7744756c54 100644 >--- a/Koha/Schema/Result/PatronListPatron.pm >+++ b/Koha/Schema/Result/PatronListPatron.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("patron_list_patrons"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier >+ > =head2 patron_list_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the list this entry is part of >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the borrower that is part of this list >+ > =cut > > __PACKAGE__->add_columns( >@@ -97,8 +103,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 21:34:14 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0gmBJbxnHkobBAazvKnY7g >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dyC7iyqeTGsX0CC6QfOjnw > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Patronimage.pm b/Koha/Schema/Result/Patronimage.pm >index 30cf1e0dcc..cc5a65c032 100644 >--- a/Koha/Schema/Result/Patronimage.pm >+++ b/Koha/Schema/Result/Patronimage.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("patronimage"); > is_foreign_key: 1 > is_nullable: 0 > >+the borrowernumber of the patron this image is attached to (borrowers.borrowernumber) >+ > =head2 mimetype > > data_type: 'varchar' > is_nullable: 0 > size: 15 > >+the format of the image (png, jpg, etc) >+ > =head2 imagefile > > data_type: 'mediumblob' > is_nullable: 0 > >+the image >+ > =cut > > __PACKAGE__->add_columns( >@@ -81,8 +87,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uuRGyWlemwOH1PCkvhqxdQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2QK5jUqVIi7JAyucjFkf2g > > sub koha_object_class { > 'Koha::Patron::Image'; >diff --git a/Koha/Schema/Result/ProblemReport.pm b/Koha/Schema/Result/ProblemReport.pm >index 5df3c7a065..37195a71d6 100644 >--- a/Koha/Schema/Result/ProblemReport.pm >+++ b/Koha/Schema/Result/ProblemReport.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("problem_reports"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 title > > data_type: 'varchar' >@@ -36,6 +38,8 @@ __PACKAGE__->table("problem_reports"); > is_nullable: 0 > size: 40 > >+report subject line >+ > =head2 content > > data_type: 'varchar' >@@ -43,6 +47,8 @@ __PACKAGE__->table("problem_reports"); > is_nullable: 0 > size: 255 > >+report message content >+ > =head2 borrowernumber > > data_type: 'integer' >@@ -50,6 +56,8 @@ __PACKAGE__->table("problem_reports"); > is_foreign_key: 1 > is_nullable: 0 > >+the user who created the problem report >+ > =head2 branchcode > > data_type: 'varchar' >@@ -58,17 +66,23 @@ __PACKAGE__->table("problem_reports"); > is_nullable: 0 > size: 10 > >+borrower's branch >+ > =head2 username > > data_type: 'varchar' > is_nullable: 1 > size: 75 > >+OPAC username >+ > =head2 problempage > > data_type: 'text' > is_nullable: 1 > >+page the user triggered the problem report form from >+ > =head2 recipient > > data_type: 'enum' >@@ -76,6 +90,8 @@ __PACKAGE__->table("problem_reports"); > extra: {list => ["admin","library"]} > is_nullable: 0 > >+the 'to-address' of the problem report >+ > =head2 created_on > > data_type: 'timestamp' >@@ -83,6 +99,8 @@ __PACKAGE__->table("problem_reports"); > default_value: current_timestamp > is_nullable: 0 > >+timestamp of report submission >+ > =head2 status > > data_type: 'varchar' >@@ -90,6 +108,8 @@ __PACKAGE__->table("problem_reports"); > is_nullable: 0 > size: 6 > >+status of the report. New, Viewed, Closed >+ > =cut > > __PACKAGE__->add_columns( >@@ -181,8 +201,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-03 12:13:26 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ho9ENAxH51/ZlZO9KD4KOQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TMIbQ+WlM2C8Hq988zPa5g > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm >index 788de88ecc..de2ddef87f 100644 >--- a/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm >+++ b/Koha/Schema/Result/PseudonymizedBorrowerAttribute.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("pseudonymized_borrower_attributes"); > is_auto_increment: 1 > is_nullable: 0 > >+Row id field >+ > =head2 transaction_id > > data_type: 'integer' >@@ -42,12 +44,16 @@ __PACKAGE__->table("pseudonymized_borrower_attributes"); > is_nullable: 0 > size: 10 > >+foreign key from the borrower_attribute_types table, defines which custom field this value was entered for >+ > =head2 attribute > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+custom patron field value >+ > =cut > > __PACKAGE__->add_columns( >@@ -106,8 +112,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-11 17:12:17 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q6CTb8kq83p1bEM+ilfAww >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bw3EfLDrcITA2jekO9T/5w > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Quote.pm b/Koha/Schema/Result/Quote.pm >index 99bcb14f7c..56477f21e9 100644 >--- a/Koha/Schema/Result/Quote.pm >+++ b/Koha/Schema/Result/Quote.pm >@@ -29,22 +29,30 @@ __PACKAGE__->table("quotes"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id for the quote >+ > =head2 source > > data_type: 'mediumtext' > is_nullable: 1 > >+source/credit for the quote >+ > =head2 text > > data_type: 'longtext' > is_nullable: 0 > >+text of the quote >+ > =head2 timestamp > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date and time that the quote last appeared in the opac >+ > =cut > > __PACKAGE__->add_columns( >@@ -75,8 +83,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-02-19 11:09:24 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CdcbCjhjmsLLDQ1AAOja7Q >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pwVJXk++6BSpyLpW/xgG0g > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Rating.pm b/Koha/Schema/Result/Rating.pm >index a8fe6e436b..4979cc91e3 100644 >--- a/Koha/Schema/Result/Rating.pm >+++ b/Koha/Schema/Result/Rating.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("ratings"); > is_foreign_key: 1 > is_nullable: 0 > >+the borrowernumber of the patron who left this rating (borrowers.borrowernumber) >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the biblio this rating is for (biblio.biblionumber) >+ > =head2 rating_value > > data_type: 'tinyint' > is_nullable: 0 > >+the rating, from 1 to 5 >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -112,8 +118,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YT3jPQbA2TBuOuUXfEt7gQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8pZz4cHTRRbwCBNoOI1M6w > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/RepeatableHoliday.pm b/Koha/Schema/Result/RepeatableHoliday.pm >index f89f10a2f4..14b4d5327b 100644 >--- a/Koha/Schema/Result/RepeatableHoliday.pm >+++ b/Koha/Schema/Result/RepeatableHoliday.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("repeatable_holidays"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 branchcode > > data_type: 'varchar' >@@ -36,21 +38,29 @@ __PACKAGE__->table("repeatable_holidays"); > is_nullable: 0 > size: 10 > >+foreign key from the branches table, defines which branch this closing is for >+ > =head2 weekday > > data_type: 'smallint' > is_nullable: 1 > >+day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on >+ > =head2 day > > data_type: 'smallint' > is_nullable: 1 > >+day of the month this closing is on >+ > =head2 month > > data_type: 'smallint' > is_nullable: 1 > >+month this closing is in >+ > =head2 title > > data_type: 'varchar' >@@ -58,11 +68,15 @@ __PACKAGE__->table("repeatable_holidays"); > is_nullable: 0 > size: 50 > >+title of this closing >+ > =head2 description > > data_type: 'mediumtext' > is_nullable: 0 > >+description for this closing >+ > =cut > > __PACKAGE__->add_columns( >@@ -112,8 +126,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bBw2WEvzF5sX+AOteNsPPQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SJGTXe8M997nUa9YbCsvqA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/ReportsDictionary.pm b/Koha/Schema/Result/ReportsDictionary.pm >index e81b1aa52c..8dbdb5d0a4 100644 >--- a/Koha/Schema/Result/ReportsDictionary.pm >+++ b/Koha/Schema/Result/ReportsDictionary.pm >@@ -29,40 +29,54 @@ __PACKAGE__->table("reports_dictionary"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 name > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+name for this definition >+ > =head2 description > > data_type: 'mediumtext' > is_nullable: 1 > >+description for this definition >+ > =head2 date_created > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date and time this definition was created >+ > =head2 date_modified > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date and time this definition was last modified >+ > =head2 saved_sql > > data_type: 'mediumtext' > is_nullable: 1 > >+SQL snippet for us in reports >+ > =head2 report_area > > data_type: 'varchar' > is_nullable: 1 > size: 6 > >+Koha module this definition is for Circulation, Catalog, Patrons, Acquistions, Accounts) >+ > =cut > > __PACKAGE__->add_columns( >@@ -103,8 +117,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0akgYM7kqiLxz95xUCdrdQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e/jY0HOiZ1WNTjL+B7Te4A > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm >index 491e200f19..a2ab929fa7 100644 >--- a/Koha/Schema/Result/Reserve.pm >+++ b/Koha/Schema/Result/Reserve.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("reserves"); > is_auto_increment: 1 > is_nullable: 0 > >+primary key >+ > =head2 borrowernumber > > data_type: 'integer' >@@ -36,12 +38,16 @@ __PACKAGE__->table("reserves"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the borrowers table defining which patron this hold is for >+ > =head2 reservedate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the hold was placed >+ > =head2 biblionumber > > data_type: 'integer' >@@ -49,6 +55,8 @@ __PACKAGE__->table("reserves"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the biblio table defining which bib record this hold is on >+ > =head2 branchcode > > data_type: 'varchar' >@@ -56,53 +64,71 @@ __PACKAGE__->table("reserves"); > is_nullable: 1 > size: 10 > >+foreign key from the branches table defining which branch the patron wishes to pick this hold up at >+ > =head2 desk_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the desks table defining which desk the patron should pick this hold up at >+ > =head2 notificationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+currently unused >+ > =head2 reminderdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+currently unused >+ > =head2 cancellationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this hold was cancelled >+ > =head2 cancellation_reason > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+optional authorised value CANCELLATION_REASON >+ > =head2 reservenotes > > data_type: 'longtext' > is_nullable: 1 > >+notes related to this hold >+ > =head2 priority > > data_type: 'smallint' > default_value: 1 > is_nullable: 0 > >+where in the queue the patron sits >+ > =head2 found > > data_type: 'varchar' > is_nullable: 1 > size: 1 > >+a one letter code defining what the status is of the hold is after it has been confirmed >+ > =head2 timestamp > > data_type: 'timestamp' >@@ -110,24 +136,32 @@ __PACKAGE__->table("reserves"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time this hold was last updated >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with >+ > =head2 waitingdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the item was marked as waiting for the patron at the library >+ > =head2 expirationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) >+ > =head2 lowestPriority > > accessor: 'lowest_priority' >@@ -154,18 +188,24 @@ __PACKAGE__->table("reserves"); > is_nullable: 1 > size: 10 > >+If record level hold, the optional itemtype of the item the patron is requesting >+ > =head2 item_level_hold > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Is the hpld placed at item level >+ > =head2 non_priority > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Is this a non priority hold >+ > =cut > > __PACKAGE__->add_columns( >@@ -381,8 +421,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-11-06 11:00:40 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ue2kNBP+lq8+9NthPiYrrw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uxMjobQcBjW3Xw7iK14wHg > > __PACKAGE__->belongs_to( > "item", >diff --git a/Koha/Schema/Result/ReturnClaim.pm b/Koha/Schema/Result/ReturnClaim.pm >index f088a80fd6..3a6ea8e55e 100644 >--- a/Koha/Schema/Result/ReturnClaim.pm >+++ b/Koha/Schema/Result/ReturnClaim.pm >@@ -29,71 +29,95 @@ __PACKAGE__->table("return_claims"); > is_auto_increment: 1 > is_nullable: 0 > >+Unique ID of the return claim >+ > =head2 itemnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+ID of the item >+ > =head2 issue_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+ID of the checkout that triggered the claim >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+ID of the patron >+ > =head2 notes > > data_type: 'mediumtext' > is_nullable: 1 > >+Notes about the claim >+ > =head2 created_on > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Time and date the claim was created >+ > =head2 created_by > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+ID of the staff member that registered the claim >+ > =head2 updated_on > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Time and date of the latest change on the claim (notes) >+ > =head2 updated_by > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+ID of the staff member that updated the claim >+ > =head2 resolution > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+Resolution code (RETURN_CLAIM_RESOLUTION AVs) >+ > =head2 resolved_on > > data_type: 'timestamp' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+Time and date the claim was resolved >+ > =head2 resolved_by > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+ID of the staff member that resolved the claim >+ > =cut > > __PACKAGE__->add_columns( >@@ -274,8 +298,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-31 12:18:39 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a1MJxAPCP8yuYvzkXp5q8w >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sgKOmqHean67iIbRFjtvRw > > sub koha_objects_class { > 'Koha::Checkouts::ReturnClaims'; >diff --git a/Koha/Schema/Result/Review.pm b/Koha/Schema/Result/Review.pm >index 6c628b41c2..1db5fa7758 100644 >--- a/Koha/Schema/Result/Review.pm >+++ b/Koha/Schema/Result/Review.pm >@@ -29,35 +29,47 @@ __PACKAGE__->table("reviews"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier for this comment >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the borrowers table defining which patron left this comment >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key from the biblio table defining which bibliographic record this comment is for >+ > =head2 review > > data_type: 'mediumtext' > is_nullable: 1 > >+the body of the comment >+ > =head2 approved > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+whether this comment has been approved by a librarian (1 for yes, 0 for no) >+ > =head2 datereviewed > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date the comment was left >+ > =cut > > __PACKAGE__->add_columns( >@@ -134,8 +146,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gEngecP849wzHprYW7H2tw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:31 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dGBh60T7gmxyAlwRtteI5A > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/SavedSql.pm b/Koha/Schema/Result/SavedSql.pm >index 833c4fe21f..5864ef99a0 100644 >--- a/Koha/Schema/Result/SavedSql.pm >+++ b/Koha/Schema/Result/SavedSql.pm >@@ -29,28 +29,38 @@ __PACKAGE__->table("saved_sql"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id and primary key assigned by Koha >+ > =head2 borrowernumber > > data_type: 'integer' > is_nullable: 1 > >+the staff member who created this report (borrowers.borrowernumber) >+ > =head2 date_created > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this report was created >+ > =head2 last_modified > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this report was last edited >+ > =head2 savedsql > > data_type: 'mediumtext' > is_nullable: 1 > >+the SQL for this report >+ > =head2 last_run > > data_type: 'datetime' >@@ -64,17 +74,23 @@ __PACKAGE__->table("saved_sql"); > is_nullable: 0 > size: 255 > >+the name of this report >+ > =head2 type > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+always 1 for tabular >+ > =head2 notes > > data_type: 'mediumtext' > is_nullable: 1 > >+the notes or description given to this report >+ > =head2 cache_expiry > > data_type: 'integer' >@@ -170,8 +186,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5y8Rbrui2vN4CmNMMoB9Yg > > __PACKAGE__->add_columns( > '+public' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/SearchHistory.pm b/Koha/Schema/Result/SearchHistory.pm >index e2886df82c..e42f9b34fa 100644 >--- a/Koha/Schema/Result/SearchHistory.pm >+++ b/Koha/Schema/Result/SearchHistory.pm >@@ -29,28 +29,38 @@ __PACKAGE__->table("search_history"); > is_auto_increment: 1 > is_nullable: 0 > >+search history id >+ > =head2 userid > > data_type: 'integer' > is_nullable: 0 > >+the patron who performed the search (borrowers.borrowernumber) >+ > =head2 sessionid > > data_type: 'varchar' > is_nullable: 0 > size: 32 > >+a system generated session id >+ > =head2 query_desc > > data_type: 'varchar' > is_nullable: 0 > size: 255 > >+the search that was performed >+ > =head2 query_cgi > > data_type: 'mediumtext' > is_nullable: 0 > >+the string to append to the search url to rerun the search >+ > =head2 type > > data_type: 'varchar' >@@ -58,11 +68,15 @@ __PACKAGE__->table("search_history"); > is_nullable: 0 > size: 16 > >+search type, must be 'biblio' or 'authority' >+ > =head2 total > > data_type: 'integer' > is_nullable: 0 > >+the total of results found >+ > =head2 time > > data_type: 'timestamp' >@@ -70,6 +84,8 @@ __PACKAGE__->table("search_history"); > default_value: current_timestamp > is_nullable: 0 > >+the date and time the search was run >+ > =cut > > __PACKAGE__->add_columns( >@@ -114,8 +130,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d+Qf8sL7wLldvw2qPLoBgQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g+8YtQUhvGiVO/d7Za5KOQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Serial.pm b/Koha/Schema/Result/Serial.pm >index e3bcadbf6f..04b48c62b7 100644 >--- a/Koha/Schema/Result/Serial.pm >+++ b/Koha/Schema/Result/Serial.pm >@@ -29,18 +29,24 @@ __PACKAGE__->table("serial"); > is_auto_increment: 1 > is_nullable: 0 > >+unique key for the issue >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key for the biblio.biblionumber that this issue is attached to >+ > =head2 subscriptionid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key to the subscription.subscriptionid that this issue is part of >+ > =head2 serialseq > > data_type: 'varchar' >@@ -48,70 +54,94 @@ __PACKAGE__->table("serial"); > is_nullable: 0 > size: 100 > >+issue information (volume, number, etc) >+ > =head2 serialseq_x > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+first part of issue information >+ > =head2 serialseq_y > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+second part of issue information >+ > =head2 serialseq_z > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+third part of issue information >+ > =head2 status > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+status code for this issue (see manual for full descriptions) >+ > =head2 planneddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date expected >+ > =head2 notes > > data_type: 'mediumtext' > is_nullable: 1 > >+notes >+ > =head2 publisheddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date published >+ > =head2 publisheddatetext > > data_type: 'varchar' > is_nullable: 1 > size: 100 > >+date published (descriptive) >+ > =head2 claimdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date claimed >+ > =head2 claims_count > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+number of claims made related to this issue >+ > =head2 routingnotes > > data_type: 'mediumtext' > is_nullable: 1 > >+notes from the routing list >+ > =cut > > __PACKAGE__->add_columns( >@@ -207,8 +237,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ktCCJzkgRUFpYu857WQONA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:u6geU3+R9sLPWS2BNbjLpg > > > # You can replace this text with custom code or comments, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/SpecialHoliday.pm b/Koha/Schema/Result/SpecialHoliday.pm >index f398f209f9..eb8b389ffb 100644 >--- a/Koha/Schema/Result/SpecialHoliday.pm >+++ b/Koha/Schema/Result/SpecialHoliday.pm >@@ -29,6 +29,8 @@ __PACKAGE__->table("special_holidays"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 branchcode > > data_type: 'varchar' >@@ -36,30 +38,40 @@ __PACKAGE__->table("special_holidays"); > is_nullable: 0 > size: 10 > >+foreign key from the branches table, defines which branch this closing is for >+ > =head2 day > > data_type: 'smallint' > default_value: 0 > is_nullable: 0 > >+day of the month this closing is on >+ > =head2 month > > data_type: 'smallint' > default_value: 0 > is_nullable: 0 > >+month this closing is in >+ > =head2 year > > data_type: 'smallint' > default_value: 0 > is_nullable: 0 > >+year this closing is in >+ > =head2 isexception > > data_type: 'smallint' > default_value: 1 > is_nullable: 0 > >+is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) >+ > =head2 title > > data_type: 'varchar' >@@ -67,11 +79,15 @@ __PACKAGE__->table("special_holidays"); > is_nullable: 0 > size: 50 > >+title for this closing >+ > =head2 description > > data_type: 'mediumtext' > is_nullable: 0 > >+description of this closing >+ > =cut > > __PACKAGE__->add_columns( >@@ -123,8 +139,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-01-20 13:57:27 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cj8Oveni0l6kAR/azmw4SA >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUbFprptkxnsy744QuTiJA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Statistic.pm b/Koha/Schema/Result/Statistic.pm >index 4396e4f799..843dd27b2c 100644 >--- a/Koha/Schema/Result/Statistic.pm >+++ b/Koha/Schema/Result/Statistic.pm >@@ -29,57 +29,77 @@ __PACKAGE__->table("statistics"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date and time of the transaction >+ > =head2 branch > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key, branch where the transaction occurred >+ > =head2 value > > data_type: 'double precision' > is_nullable: 1 > size: [16,4] > >+monetary value associated with the transaction >+ > =head2 type > > data_type: 'varchar' > is_nullable: 1 > size: 16 > >+transaction type (localuse, issue, return, renew, writeoff, payment) >+ > =head2 other > > data_type: 'longtext' > is_nullable: 1 > >+used by SIP >+ > =head2 itemnumber > > data_type: 'integer' > is_nullable: 1 > >+foreign key from the items table, links transaction to a specific item >+ > =head2 itemtype > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+foreign key from the itemtypes table, links transaction to a specific item type >+ > =head2 location > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+authorized value for the shelving location for this item (MARC21 952$c) >+ > =head2 borrowernumber > > data_type: 'integer' > is_nullable: 1 > >+foreign key from the borrowers table, links transaction to a specific borrower >+ > =head2 ccode > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+foreign key from the items table, links transaction to a specific collection code >+ > =cut > > __PACKAGE__->add_columns( >@@ -110,8 +130,8 @@ __PACKAGE__->add_columns( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-18 10:07:43 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dzoFXsATo16GZERh8LYT2A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HLDGH51Urg5Ke0u6VHNxNQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Stockrotationitem.pm b/Koha/Schema/Result/Stockrotationitem.pm >index 1289f97497..d3f2b11922 100644 >--- a/Koha/Schema/Result/Stockrotationitem.pm >+++ b/Koha/Schema/Result/Stockrotationitem.pm >@@ -29,24 +29,32 @@ __PACKAGE__->table("stockrotationitems"); > is_foreign_key: 1 > is_nullable: 0 > >+Itemnumber to link to a stage & rota >+ > =head2 stage_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+stage ID to link the item to >+ > =head2 indemand > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Should this item be skipped for rotation? >+ > =head2 fresh > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Flag showing item is only just added to rota >+ > =cut > > __PACKAGE__->add_columns( >@@ -105,8 +113,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gkOISrUyWYqUHtmqe7ZHug >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xk/EKJHnfn16eEEGRFefTw > > __PACKAGE__->add_columns( > '+indemand' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Stockrotationrota.pm b/Koha/Schema/Result/Stockrotationrota.pm >index a719635624..cf71db0c41 100644 >--- a/Koha/Schema/Result/Stockrotationrota.pm >+++ b/Koha/Schema/Result/Stockrotationrota.pm >@@ -29,29 +29,39 @@ __PACKAGE__->table("stockrotationrotas"); > is_auto_increment: 1 > is_nullable: 0 > >+Stockrotation rota ID >+ > =head2 title > > data_type: 'varchar' > is_nullable: 0 > size: 100 > >+Title for this rota >+ > =head2 description > > data_type: 'text' > is_nullable: 0 > >+Description for this rota >+ > =head2 cyclical > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Should items on this rota keep cycling? >+ > =head2 active > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+Is this rota currently active? >+ > =cut > > __PACKAGE__->add_columns( >@@ -97,8 +107,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lTIDZ+w+46Kniub5Tqpqlg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:woyzTbETJhCWaWLruQSnYA > > __PACKAGE__->add_columns( > '+cyclical' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/Stockrotationstage.pm b/Koha/Schema/Result/Stockrotationstage.pm >index 845a712b33..8eaeb9d503 100644 >--- a/Koha/Schema/Result/Stockrotationstage.pm >+++ b/Koha/Schema/Result/Stockrotationstage.pm >@@ -29,17 +29,23 @@ __PACKAGE__->table("stockrotationstages"); > is_auto_increment: 1 > is_nullable: 0 > >+Unique stage ID >+ > =head2 position > > data_type: 'integer' > is_nullable: 0 > >+The position of this stage within its rota >+ > =head2 rota_id > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+The rota this stage belongs to >+ > =head2 branchcode_id > > data_type: 'varchar' >@@ -47,12 +53,16 @@ __PACKAGE__->table("stockrotationstages"); > is_nullable: 0 > size: 10 > >+Branch this stage relates to >+ > =head2 duration > > data_type: 'integer' > default_value: 4 > is_nullable: 0 > >+The number of days items shoud occupy this stage >+ > =cut > > __PACKAGE__->add_columns( >@@ -128,8 +138,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SKkedF8PL3DWma8kv8yYmg >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2WGw2w91CdR9RoY+vzY7xw > > # We use DBIx::Class::Ordered to handle stages manipulation. > __PACKAGE__->load_components(qw( Ordered )); >diff --git a/Koha/Schema/Result/Subscription.pm b/Koha/Schema/Result/Subscription.pm >index c002d81853..14ea7656c0 100644 >--- a/Koha/Schema/Result/Subscription.pm >+++ b/Koha/Schema/Result/Subscription.pm >@@ -29,12 +29,16 @@ __PACKAGE__->table("subscription"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key for biblio.biblionumber that this subscription is attached to >+ > =head2 subscriptionid > > data_type: 'integer' > is_auto_increment: 1 > is_nullable: 0 > >+unique key for this subscription >+ > =head2 librarian > > data_type: 'varchar' >@@ -42,18 +46,24 @@ __PACKAGE__->table("subscription"); > is_nullable: 1 > size: 100 > >+the librarian's username from borrowers.userid >+ > =head2 startdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+start date for this subscription >+ > =head2 aqbooksellerid > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+foreign key for aqbooksellers.id to link to the vendor >+ > =head2 cost > > data_type: 'integer' >@@ -72,24 +82,32 @@ __PACKAGE__->table("subscription"); > default_value: 0 > is_nullable: 1 > >+subscription length in weeks (will not be filled in if monthlength or numberlength is set) >+ > =head2 monthlength > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+subscription length in weeks (will not be filled in if weeklength or numberlength is set) >+ > =head2 numberlength > > data_type: 'integer' > default_value: 0 > is_nullable: 1 > >+subscription length in weeks (will not be filled in if monthlength or weeklength is set) >+ > =head2 periodicity > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+frequency type links to subscription_frequencies.id >+ > =head2 countissuesperunit > > data_type: 'integer' >@@ -101,6 +119,8 @@ __PACKAGE__->table("subscription"); > data_type: 'longtext' > is_nullable: 1 > >+notes >+ > =head2 status > > data_type: 'varchar' >@@ -108,6 +128,8 @@ __PACKAGE__->table("subscription"); > is_nullable: 0 > size: 100 > >+status of this subscription >+ > =head2 lastvalue1 > > data_type: 'integer' >@@ -147,17 +169,23 @@ __PACKAGE__->table("subscription"); > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+first issue received date >+ > =head2 manualhistory > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+yes or no to managing the history manually >+ > =head2 irregularity > > data_type: 'mediumtext' > is_nullable: 1 > >+any irregularities in the subscription >+ > =head2 skip_serialseq > > data_type: 'tinyint' >@@ -176,12 +204,16 @@ __PACKAGE__->table("subscription"); > is_foreign_key: 1 > is_nullable: 1 > >+the numbering pattern used links to subscription_numberpatterns.id >+ > =head2 locale > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+for foreign language subscriptions to display months, seasons, etc correctly >+ > =head2 distributedto > > data_type: 'mediumtext' >@@ -197,6 +229,8 @@ __PACKAGE__->table("subscription"); > data_type: 'mediumtext' > is_nullable: 1 > >+default call number >+ > =head2 location > > data_type: 'varchar' >@@ -204,6 +238,8 @@ __PACKAGE__->table("subscription"); > is_nullable: 1 > size: 80 > >+default shelving location (items.location) >+ > =head2 branchcode > > data_type: 'varchar' >@@ -211,6 +247,8 @@ __PACKAGE__->table("subscription"); > is_nullable: 0 > size: 10 > >+default branches (items.homebranch) >+ > =head2 lastbranch > > data_type: 'varchar' >@@ -223,42 +261,56 @@ __PACKAGE__->table("subscription"); > default_value: 0 > is_nullable: 0 > >+does receiving this serial create an item record >+ > =head2 staffdisplaycount > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+how many issues to show to the staff >+ > =head2 opacdisplaycount > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+how many issues to show to the public >+ > =head2 graceperiod > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+grace period in days >+ > =head2 enddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+subscription end date >+ > =head2 closed > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+yes / no if the subscription is closed >+ > =head2 reneweddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date of last renewal for the subscription >+ > =head2 itemtype > > data_type: 'varchar' >@@ -497,8 +549,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Bw7XzPSvv9fjc9F6+uIBUw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ur0DNjmTa/pSquXKgyjF4A > > __PACKAGE__->has_many( > "additional_field_values", >diff --git a/Koha/Schema/Result/Subscriptionroutinglist.pm b/Koha/Schema/Result/Subscriptionroutinglist.pm >index e218257986..18c88403e7 100644 >--- a/Koha/Schema/Result/Subscriptionroutinglist.pm >+++ b/Koha/Schema/Result/Subscriptionroutinglist.pm >@@ -29,23 +29,31 @@ __PACKAGE__->table("subscriptionroutinglist"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the borrowers table, defines with patron is on the routing list >+ > =head2 ranking > > data_type: 'integer' > is_nullable: 1 > >+where the patron stands in line to receive the serial >+ > =head2 subscriptionid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key from the subscription table, defines which subscription this routing list is for >+ > =cut > > __PACKAGE__->add_columns( >@@ -120,8 +128,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AK595c56vgTa7ZjwZjberw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ULAuyH4sJu6Uc7TlOepGbg > > sub koha_object_class { > 'Koha::Subscription::Routinglist'; >diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm >index e493474c57..6c025d878f 100644 >--- a/Koha/Schema/Result/Suggestion.pm >+++ b/Koha/Schema/Result/Suggestion.pm >@@ -29,66 +29,88 @@ __PACKAGE__->table("suggestions"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned automatically by Koha >+ > =head2 suggestedby > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrowernumber for the person making the suggestion, foreign key linking to the borrowers table >+ > =head2 suggesteddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+date the suggestion was submitted >+ > =head2 managedby > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table >+ > =head2 manageddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the suggestion was updated >+ > =head2 acceptedby > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table >+ > =head2 accepteddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the suggestion was marked as accepted >+ > =head2 rejectedby > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table >+ > =head2 rejecteddate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date the suggestion was marked as rejected >+ > =head2 lastmodificationby > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrowernumber for the librarian who edit the suggestion for the last time >+ > =head2 lastmodificationdate > > data_type: 'date' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date of the last modification >+ > =head2 STATUS > > accessor: 'status' >@@ -97,40 +119,54 @@ __PACKAGE__->table("suggestions"); > is_nullable: 0 > size: 10 > >+suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category) >+ > =head2 archived > > data_type: 'tinyint' > default_value: 0 > is_nullable: 0 > >+is the suggestion archived? >+ > =head2 note > > data_type: 'longtext' > is_nullable: 1 > >+note entered on the suggestion >+ > =head2 author > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+author of the suggested item >+ > =head2 title > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+title of the suggested item >+ > =head2 copyrightdate > > data_type: 'smallint' > is_nullable: 1 > >+copyright date of the suggested item >+ > =head2 publishercode > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+publisher of the suggested item >+ > =head2 date > > data_type: 'timestamp' >@@ -138,6 +174,8 @@ __PACKAGE__->table("suggestions"); > default_value: current_timestamp > is_nullable: 0 > >+date and time the suggestion was updated >+ > =head2 volumedesc > > data_type: 'varchar' >@@ -156,34 +194,46 @@ __PACKAGE__->table("suggestions"); > is_nullable: 1 > size: 255 > >+publication place of the suggested item >+ > =head2 isbn > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+isbn of the suggested item >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key linking the suggestion to the biblio table after the suggestion has been ordered >+ > =head2 reason > > data_type: 'mediumtext' > is_nullable: 1 > >+reason for accepting or rejecting the suggestion >+ > =head2 patronreason > > data_type: 'mediumtext' > is_nullable: 1 > >+reason for making the suggestion >+ > =head2 budgetid > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key linking the suggested budget to the aqbudgets table >+ > =head2 branchcode > > data_type: 'varchar' >@@ -191,40 +241,54 @@ __PACKAGE__->table("suggestions"); > is_nullable: 1 > size: 10 > >+foreign key linking the suggested branch to the branches table >+ > =head2 collectiontitle > > data_type: 'mediumtext' > is_nullable: 1 > >+collection name for the suggested item >+ > =head2 itemtype > > data_type: 'varchar' > is_nullable: 1 > size: 30 > >+suggested item type >+ > =head2 quantity > > data_type: 'smallint' > is_nullable: 1 > >+suggested quantity to be purchased >+ > =head2 currency > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+suggested currency for the suggested price >+ > =head2 price > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+suggested price >+ > =head2 total > > data_type: 'decimal' > is_nullable: 1 > size: [28,6] > >+suggested total cost (price*quantity updated for currency) >+ > =cut > > __PACKAGE__->add_columns( >@@ -484,8 +548,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-14 20:04:28 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BrvQGdgqpODl23IfwbqdUw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HRkzAEJtBU4CwHugS216wA > > __PACKAGE__->belongs_to( > "suggester", >diff --git a/Koha/Schema/Result/Systempreference.pm b/Koha/Schema/Result/Systempreference.pm >index 2ff374e5ca..5526bf481e 100644 >--- a/Koha/Schema/Result/Systempreference.pm >+++ b/Koha/Schema/Result/Systempreference.pm >@@ -30,27 +30,37 @@ __PACKAGE__->table("systempreferences"); > is_nullable: 0 > size: 50 > >+system preference name >+ > =head2 value > > data_type: 'mediumtext' > is_nullable: 1 > >+system preference values >+ > =head2 options > > data_type: 'longtext' > is_nullable: 1 > >+options for multiple choice system preferences >+ > =head2 explanation > > data_type: 'mediumtext' > is_nullable: 1 > >+descriptive text for the system preference >+ > =head2 type > > data_type: 'varchar' > is_nullable: 1 > size: 20 > >+type of question this preference asks (multiple choice, plain text, yes or no, etc) >+ > =cut > > __PACKAGE__->add_columns( >@@ -79,8 +89,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("variable"); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QI7OL4VHrXe8FridIOCZ4A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tpbJjLaoOVKAoTFG7iTMFg > > sub koha_object_class { > 'Koha::Config::SysPref'; >diff --git a/Koha/Schema/Result/TagAll.pm b/Koha/Schema/Result/TagAll.pm >index fbb8894886..4e644dcfdc 100644 >--- a/Koha/Schema/Result/TagAll.pm >+++ b/Koha/Schema/Result/TagAll.pm >@@ -29,35 +29,47 @@ __PACKAGE__->table("tags_all"); > is_auto_increment: 1 > is_nullable: 0 > >+unique id and primary key >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+the patron who added the tag (borrowers.borrowernumber) >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the bib record this tag was left on (biblio.biblionumber) >+ > =head2 term > > data_type: 'varchar' > is_nullable: 0 > size: 191 > >+the tag >+ > =head2 language > > data_type: 'integer' > is_nullable: 1 > >+the language the tag was left in >+ > =head2 date_created > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+the date the tag was added >+ > =cut > > __PACKAGE__->add_columns( >@@ -129,8 +141,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-15 13:30:04 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3pY7wv0IRmQBSqr+EghQvw >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xpyAfLcSzJ1a4p/Rk2KNyg > > sub koha_object_class { > 'Koha::Tag'; >diff --git a/Koha/Schema/Result/TagsApproval.pm b/Koha/Schema/Result/TagsApproval.pm >index 92b54b708d..188de12b8a 100644 >--- a/Koha/Schema/Result/TagsApproval.pm >+++ b/Koha/Schema/Result/TagsApproval.pm >@@ -29,30 +29,40 @@ __PACKAGE__->table("tags_approval"); > is_nullable: 0 > size: 191 > >+the tag >+ > =head2 approved > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+whether the tag is approved or not (1=yes, 0=pending, -1=rejected) >+ > =head2 date_approved > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+the date this tag was approved >+ > =head2 approved_by > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+the librarian who approved the tag (borrowers.borrowernumber) >+ > =head2 weight_total > > data_type: 'integer' > default_value: 1 > is_nullable: 0 > >+the total number of times this tag was used >+ > =cut > > __PACKAGE__->add_columns( >@@ -122,8 +132,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-01-18 08:31:57 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4cvTasSpJ2c1vvVVe/R3UQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zHEk9DLVYdYoLbtEZXVFQw > > sub koha_object_class { > 'Koha::Tags::Approval'; >diff --git a/Koha/Schema/Result/TagsIndex.pm b/Koha/Schema/Result/TagsIndex.pm >index acc98067ad..0d2a29f5f7 100644 >--- a/Koha/Schema/Result/TagsIndex.pm >+++ b/Koha/Schema/Result/TagsIndex.pm >@@ -30,18 +30,24 @@ __PACKAGE__->table("tags_index"); > is_nullable: 0 > size: 191 > >+the tag >+ > =head2 biblionumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+the bib record this tag was used on (biblio.biblionumber) >+ > =head2 weight > > data_type: 'integer' > default_value: 1 > is_nullable: 0 > >+the number of times this term was used on this bib record >+ > =cut > > __PACKAGE__->add_columns( >@@ -100,8 +106,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-01-18 08:31:57 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ewTrnc9D1jcoyf65+MrSGQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jZ7PoeDTmrR68PwcnrLKLg > > sub koha_object_class { > 'Koha::Tags::Index'; >diff --git a/Koha/Schema/Result/Virtualshelfcontent.pm b/Koha/Schema/Result/Virtualshelfcontent.pm >index a8ad19d4b0..65a2c0fd6a 100644 >--- a/Koha/Schema/Result/Virtualshelfcontent.pm >+++ b/Koha/Schema/Result/Virtualshelfcontent.pm >@@ -30,6 +30,8 @@ __PACKAGE__->table("virtualshelfcontents"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key linking to the virtualshelves table, defines the list that this record has been added to >+ > =head2 biblionumber > > data_type: 'integer' >@@ -37,6 +39,8 @@ __PACKAGE__->table("virtualshelfcontents"); > is_foreign_key: 1 > is_nullable: 0 > >+foreign key linking to the biblio table, defines the bib record that has been added to the list >+ > =head2 flags > > data_type: 'integer' >@@ -49,12 +53,16 @@ __PACKAGE__->table("virtualshelfcontents"); > default_value: current_timestamp > is_nullable: 0 > >+date and time this bib record was added to the list >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrower number that created this list entry (only the first one is saved: no need for use in/as key) >+ > =cut > > __PACKAGE__->add_columns( >@@ -138,8 +146,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:ie3Gx+/HthZQ/4fHjcPF0w >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HwRg0l+b4O1Q7vEh46s1RQ > > #TODO See BZ 14544: Should be resolved by db revision > __PACKAGE__->set_primary_key("shelfnumber","biblionumber"); >diff --git a/Koha/Schema/Result/Virtualshelfshare.pm b/Koha/Schema/Result/Virtualshelfshare.pm >index 0adaf2b113..d94c0d7fb1 100644 >--- a/Koha/Schema/Result/Virtualshelfshare.pm >+++ b/Koha/Schema/Result/Virtualshelfshare.pm >@@ -29,30 +29,40 @@ __PACKAGE__->table("virtualshelfshares"); > is_auto_increment: 1 > is_nullable: 0 > >+unique key >+ > =head2 shelfnumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 0 > >+foreign key for virtualshelves >+ > =head2 borrowernumber > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+borrower that accepted access to this list >+ > =head2 invitekey > > data_type: 'varchar' > is_nullable: 1 > size: 10 > >+temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet >+ > =head2 sharedate > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 1 > >+date of invitation or acceptance of invitation >+ > =cut > > __PACKAGE__->add_columns( >@@ -122,8 +132,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:gle9hUqefRoNSilv0gFc1w >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ef6dMgGrMT354DaTdY8TdQ > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Virtualshelve.pm b/Koha/Schema/Result/Virtualshelve.pm >index 83334f8ac4..a10497ceb0 100644 >--- a/Koha/Schema/Result/Virtualshelve.pm >+++ b/Koha/Schema/Result/Virtualshelve.pm >@@ -29,24 +29,32 @@ __PACKAGE__->table("virtualshelves"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 shelfname > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+name of the list >+ > =head2 owner > > data_type: 'integer' > is_foreign_key: 1 > is_nullable: 1 > >+foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) >+ > =head2 category > > data_type: 'varchar' > is_nullable: 1 > size: 1 > >+type of list (private [1], public [2]) >+ > =head2 sortfield > > data_type: 'varchar' >@@ -54,6 +62,8 @@ __PACKAGE__->table("virtualshelves"); > is_nullable: 1 > size: 16 > >+the field this list is sorted on >+ > =head2 lastmodified > > data_type: 'timestamp' >@@ -61,24 +71,32 @@ __PACKAGE__->table("virtualshelves"); > default_value: current_timestamp > is_nullable: 0 > >+date and time the list was last modified >+ > =head2 created_on > > data_type: 'datetime' > datetime_undef_if_invalid: 1 > is_nullable: 0 > >+creation time >+ > =head2 allow_change_from_owner > > data_type: 'tinyint' > default_value: 1 > is_nullable: 1 > >+can owner change contents? >+ > =head2 allow_change_from_others > > data_type: 'tinyint' > default_value: 0 > is_nullable: 1 > >+can others change contents? >+ > =cut > > __PACKAGE__->add_columns( >@@ -181,8 +199,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-03-08 14:19:17 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xoq0lhLouCbkAp6F4ZyMGQ >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ffp0sPdLMjk5q3BLxXf1+Q > > sub koha_object_class { > 'Koha::Virtualshelf'; >diff --git a/Koha/Schema/Result/Z3950server.pm b/Koha/Schema/Result/Z3950server.pm >index 65ecc2ec1a..7931a56e2a 100644 >--- a/Koha/Schema/Result/Z3950server.pm >+++ b/Koha/Schema/Result/Z3950server.pm >@@ -29,62 +29,84 @@ __PACKAGE__->table("z3950servers"); > is_auto_increment: 1 > is_nullable: 0 > >+unique identifier assigned by Koha >+ > =head2 host > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+target's host name >+ > =head2 port > > data_type: 'integer' > is_nullable: 1 > >+port number used to connect to target >+ > =head2 db > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+target's database name >+ > =head2 userid > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+username needed to log in to target >+ > =head2 password > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+password needed to log in to target >+ > =head2 servername > > data_type: 'longtext' > is_nullable: 0 > >+name given to the target by the library >+ > =head2 checked > > data_type: 'smallint' > is_nullable: 1 > >+whether this target is checked by default (1 for yes, 0 for no) >+ > =head2 rank > > data_type: 'integer' > is_nullable: 1 > >+where this target appears in the list of targets >+ > =head2 syntax > > data_type: 'varchar' > is_nullable: 1 > size: 80 > >+marc format provided by this target >+ > =head2 timeout > > data_type: 'integer' > default_value: 0 > is_nullable: 0 > >+number of seconds before Koha stops trying to access this server >+ > =head2 servertype > > data_type: 'enum' >@@ -92,11 +114,15 @@ __PACKAGE__->table("z3950servers"); > extra: {list => ["zed","sru"]} > is_nullable: 0 > >+zed means z39.50 server >+ > =head2 encoding > > data_type: 'mediumtext' > is_nullable: 1 > >+characters encoding provided by this target >+ > =head2 recordtype > > data_type: 'enum' >@@ -104,28 +130,38 @@ __PACKAGE__->table("z3950servers"); > extra: {list => ["authority","biblio"]} > is_nullable: 0 > >+server contains bibliographic or authority records >+ > =head2 sru_options > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+options like sru=get, sru_version=1.1; will be passed to the server via ZOOM >+ > =head2 sru_fields > > data_type: 'longtext' > is_nullable: 1 > >+contains the mapping between the Z3950 search fields and the specific SRU server indexes >+ > =head2 add_xslt > > data_type: 'longtext' > is_nullable: 1 > >+zero or more paths to XSLT files to be processed on the search results >+ > =head2 attributes > > data_type: 'varchar' > is_nullable: 1 > size: 255 > >+additional attributes passed to PQF queries >+ > =cut > > __PACKAGE__->add_columns( >@@ -190,8 +226,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07047 @ 2018-02-20 01:04:22 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YUp6TnDwq7/oLaSmSdVE3A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-01-21 11:55:32 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xux7rgcpAESaWO+ll5RnQg > > sub koha_object_class { > 'Koha::Z3950Server'; >-- >2.24.1 (Apple Git-126)
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 26995
:
115532
|
115533
|
115534
|
115537
|
115538
|
115539
|
120399
|
120400
|
120451
|
120452
|
120453
|
120744
|
120745
|
120746
|
120775
|
120793
|
120826