From 052572cd1efc751804bdba28f6ad43fe0e3210c7 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 16 Feb 2018 17:56:05 -0300 Subject: [PATCH] Bug 18336: DBIC Schema changes Signed-off-by: Jonathan Druart --- Koha/Schema/Result/Accountline.pm | 16 +-- Koha/Schema/Result/ActionLog.pm | 16 +-- Koha/Schema/Result/Aqbasket.pm | 16 +-- Koha/Schema/Result/Aqbasketgroup.pm | 8 +- Koha/Schema/Result/Aqbookseller.pm | 52 ++++---- Koha/Schema/Result/Aqbudget.pm | 8 +- Koha/Schema/Result/Aqbudgetperiod.pm | 8 +- Koha/Schema/Result/Aqcontact.pm | 8 +- Koha/Schema/Result/Aqcontract.pm | 8 +- Koha/Schema/Result/Aqinvoice.pm | 8 +- Koha/Schema/Result/Aqorder.pm | 24 ++-- Koha/Schema/Result/ArticleRequest.pm | 40 +++--- Koha/Schema/Result/AuthHeader.pm | 8 +- Koha/Schema/Result/AuthSubfieldStructure.pm | 8 +- Koha/Schema/Result/AuthType.pm | 8 +- Koha/Schema/Result/Biblio.pm | 28 ++-- Koha/Schema/Result/Biblioitem.pm | 60 ++++----- Koha/Schema/Result/Borrower.pm | 120 +++++++++--------- Koha/Schema/Result/BorrowerDebarment.pm | 8 +- Koha/Schema/Result/BorrowerModification.pm | 120 +++++++++--------- Koha/Schema/Result/Branch.pm | 64 +++++----- Koha/Schema/Result/Branchtransfer.pm | 8 +- Koha/Schema/Result/Category.pm | 8 +- Koha/Schema/Result/ClassSortRule.pm | 8 +- Koha/Schema/Result/ClassSource.pm | 8 +- Koha/Schema/Result/Club.pm | 12 +- Koha/Schema/Result/ClubEnrollmentField.pm | 8 +- Koha/Schema/Result/ClubField.pm | 8 +- Koha/Schema/Result/ClubTemplate.pm | 12 +- .../Result/ClubTemplateEnrollmentField.pm | 12 +- Koha/Schema/Result/ClubTemplateField.pm | 12 +- Koha/Schema/Result/Collection.pm | 8 +- Koha/Schema/Result/Course.pm | 12 +- Koha/Schema/Result/CourseReserve.pm | 12 +- Koha/Schema/Result/CreatorLayout.pm | 8 +- Koha/Schema/Result/Deletedbiblio.pm | 28 ++-- Koha/Schema/Result/Deletedbiblioitem.pm | 60 ++++----- Koha/Schema/Result/Deletedborrower.pm | 120 +++++++++--------- Koha/Schema/Result/Deleteditem.pm | 28 ++-- Koha/Schema/Result/EdifactMessage.pm | 16 +-- Koha/Schema/Result/ExportFormat.pm | 12 +- Koha/Schema/Result/HouseboundProfile.pm | 32 ++--- Koha/Schema/Result/Illrequest.pm | 12 +- Koha/Schema/Result/Illrequestattribute.pm | 8 +- Koha/Schema/Result/ImportBatch.pm | 8 +- Koha/Schema/Result/ImportItem.pm | 8 +- Koha/Schema/Result/ImportRecord.pm | 8 +- Koha/Schema/Result/Issue.pm | 8 +- Koha/Schema/Result/Item.pm | 28 ++-- Koha/Schema/Result/Itemtype.pm | 12 +- Koha/Schema/Result/Letter.pm | 8 +- Koha/Schema/Result/LibraryGroup.pm | 8 +- Koha/Schema/Result/Linktracker.pm | 8 +- Koha/Schema/Result/Localization.pm | 8 +- .../Schema/Result/MarcModificationTemplate.pm | 8 +- .../Result/MarcModificationTemplateAction.pm | 20 +-- Koha/Schema/Result/MarcSubfieldStructure.pm | 8 +- Koha/Schema/Result/Message.pm | 8 +- Koha/Schema/Result/MessageQueue.pm | 28 ++-- Koha/Schema/Result/NeedMergeAuthority.pm | 8 +- Koha/Schema/Result/OldIssue.pm | 8 +- Koha/Schema/Result/OldReserve.pm | 8 +- Koha/Schema/Result/OpacNews.pm | 8 +- Koha/Schema/Result/PluginData.pm | 8 +- Koha/Schema/Result/Quote.pm | 12 +- Koha/Schema/Result/RepeatableHoliday.pm | 8 +- Koha/Schema/Result/ReportsDictionary.pm | 12 +- Koha/Schema/Result/Reserve.pm | 8 +- Koha/Schema/Result/Review.pm | 8 +- Koha/Schema/Result/SavedSql.pm | 12 +- Koha/Schema/Result/SearchHistory.pm | 8 +- Koha/Schema/Result/Serial.pm | 12 +- Koha/Schema/Result/Session.pm | 8 +- Koha/Schema/Result/SpecialHoliday.pm | 8 +- Koha/Schema/Result/Statistic.pm | 8 +- Koha/Schema/Result/Subscription.pm | 20 +-- Koha/Schema/Result/SubscriptionFrequency.pm | 8 +- .../Result/SubscriptionNumberpattern.pm | 8 +- Koha/Schema/Result/Suggestion.pm | 20 +-- Koha/Schema/Result/Systempreference.pm | 16 +-- Koha/Schema/Result/TmpHoldsqueue.pm | 24 ++-- Koha/Schema/Result/UploadedFile.pm | 16 +-- Koha/Schema/Result/VendorEdiAccount.pm | 16 +-- Koha/Schema/Result/Z3950server.pm | 20 +-- 84 files changed, 778 insertions(+), 778 deletions(-) diff --git a/Koha/Schema/Result/Accountline.pm b/Koha/Schema/Result/Accountline.pm index daafd2be6f..4ca754d230 100644 --- a/Koha/Schema/Result/Accountline.pm +++ b/Koha/Schema/Result/Accountline.pm @@ -67,12 +67,12 @@ __PACKAGE__->table("accountlines"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 dispute - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 accounttype @@ -102,7 +102,7 @@ __PACKAGE__->table("accountlines"); =head2 note - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 manager_id @@ -133,9 +133,9 @@ __PACKAGE__->add_columns( "amount", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "dispute", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "accounttype", { data_type => "varchar", is_nullable => 1, size => 5 }, "amountoutstanding", @@ -150,7 +150,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "note", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "manager_id", { data_type => "integer", is_nullable => 1 }, ); @@ -235,8 +235,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-23 12:27:23 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:S70xVMIJONd30d0kDrgF2A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nqx+Byr+p91Kbsuncau0Ng # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ActionLog.pm b/Koha/Schema/Result/ActionLog.pm index 5705404f68..78236ea9eb 100644 --- a/Koha/Schema/Result/ActionLog.pm +++ b/Koha/Schema/Result/ActionLog.pm @@ -44,12 +44,12 @@ __PACKAGE__->table("action_logs"); =head2 module - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 action - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 object @@ -59,7 +59,7 @@ __PACKAGE__->table("action_logs"); =head2 info - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 interface @@ -83,13 +83,13 @@ __PACKAGE__->add_columns( "user", { data_type => "integer", default_value => 0, is_nullable => 0 }, "module", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "action", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "object", { data_type => "integer", is_nullable => 1 }, "info", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "interface", { data_type => "varchar", is_nullable => 1, size => 30 }, ); @@ -107,8 +107,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("action_id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-06-25 13:10:24 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Wmjd736WUdPfIn581rXTzw +# 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 # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqbasket.pm b/Koha/Schema/Result/Aqbasket.pm index d820708b36..bb1e5a78aa 100644 --- a/Koha/Schema/Result/Aqbasket.pm +++ b/Koha/Schema/Result/Aqbasket.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("aqbasket"); =head2 note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 booksellernote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contractnumber @@ -78,7 +78,7 @@ __PACKAGE__->table("aqbasket"); =head2 booksellerinvoicenumber - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 basketgroupid @@ -126,9 +126,9 @@ __PACKAGE__->add_columns( "basketname", { data_type => "varchar", is_nullable => 1, size => 50 }, "note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "booksellernote", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contractnumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "creationdate", @@ -145,7 +145,7 @@ __PACKAGE__->add_columns( "authorisedby", { data_type => "varchar", is_nullable => 1, size => 10 }, "booksellerinvoicenumber", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "basketgroupid", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "deliveryplace", @@ -309,8 +309,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-10 14:27:08 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4lGbfEcXLR67RbYp4aNzTg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSw/f4JmMBzEssEFRg2fAQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqbasketgroup.pm b/Koha/Schema/Result/Aqbasketgroup.pm index 6b3348e3af..618ebd9632 100644 --- a/Koha/Schema/Result/Aqbasketgroup.pm +++ b/Koha/Schema/Result/Aqbasketgroup.pm @@ -54,7 +54,7 @@ __PACKAGE__->table("aqbasketgroups"); =head2 freedeliveryplace - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 deliverycomment @@ -83,7 +83,7 @@ __PACKAGE__->add_columns( "deliveryplace", { data_type => "varchar", is_nullable => 1, size => 10 }, "freedeliveryplace", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "deliverycomment", { data_type => "varchar", is_nullable => 1, size => 255 }, "billingplace", @@ -135,8 +135,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:tT40YZgK7gOfNG3DVFTHiA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9cEWAMwcFKPYPEG1CaaD3w # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqbookseller.pm b/Koha/Schema/Result/Aqbookseller.pm index e59b7057e8..159ade6599 100644 --- a/Koha/Schema/Result/Aqbookseller.pm +++ b/Koha/Schema/Result/Aqbookseller.pm @@ -31,27 +31,27 @@ __PACKAGE__->table("aqbooksellers"); =head2 name - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 address1 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address2 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address3 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address4 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 phone @@ -62,12 +62,12 @@ __PACKAGE__->table("aqbooksellers"); =head2 accountnumber - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 othersupplier - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 currency @@ -79,27 +79,27 @@ __PACKAGE__->table("aqbooksellers"); =head2 booksellerfax - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 bookselleremail - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 booksellerurl - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 postal - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 url @@ -171,33 +171,33 @@ __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "name", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "address1", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address2", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address3", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address4", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "phone", { data_type => "varchar", is_nullable => 1, size => 30 }, "accountnumber", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "othersupplier", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "currency", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "booksellerfax", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "bookselleremail", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "booksellerurl", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "postal", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "url", { data_type => "varchar", is_nullable => 1, size => 255 }, "active", @@ -382,8 +382,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-09 13:43:30 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:b3aUNZsdvNzEuKScGD7ZPQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DyaF9RbcNAOjPQ1lrxHV3A __PACKAGE__->add_columns( '+active' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Aqbudget.pm b/Koha/Schema/Result/Aqbudget.pm index 12a8c8d730..68a93afbb6 100644 --- a/Koha/Schema/Result/Aqbudget.pm +++ b/Koha/Schema/Result/Aqbudget.pm @@ -75,7 +75,7 @@ __PACKAGE__->table("aqbudgets"); =head2 budget_notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 timestamp @@ -148,7 +148,7 @@ __PACKAGE__->add_columns( size => [28, 6], }, "budget_notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -283,8 +283,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07033 @ 2015-03-04 10:26:49 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E4J/D0+2j0/8JZd0YRnoeA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9MY8aD6YBjuLy8c7tDnZeg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqbudgetperiod.pm b/Koha/Schema/Result/Aqbudgetperiod.pm index 6015893516..1d76ec00d9 100644 --- a/Koha/Schema/Result/Aqbudgetperiod.pm +++ b/Koha/Schema/Result/Aqbudgetperiod.pm @@ -49,7 +49,7 @@ __PACKAGE__->table("aqbudgetperiods"); =head2 budget_period_description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 budget_period_total @@ -87,7 +87,7 @@ __PACKAGE__->add_columns( "budget_period_active", { data_type => "tinyint", default_value => 0, is_nullable => 1 }, "budget_period_description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "budget_period_total", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "budget_period_locked", @@ -111,8 +111,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("budget_period_id"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SaTTCao0N80iDL8pgf5k1A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqcontact.pm b/Koha/Schema/Result/Aqcontact.pm index c7ab475119..b02bcbaa35 100644 --- a/Koha/Schema/Result/Aqcontact.pm +++ b/Koha/Schema/Result/Aqcontact.pm @@ -67,7 +67,7 @@ __PACKAGE__->table("aqcontacts"); =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 orderacquisition @@ -124,7 +124,7 @@ __PACKAGE__->add_columns( "email", { data_type => "varchar", is_nullable => 1, size => 100 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "orderacquisition", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "claimacquisition", @@ -169,8 +169,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-14 07:14:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9sJ0ALCjIsvdUcqgpej1JA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2x8Z9Db2oDULEODgLuw8Q # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqcontract.pm b/Koha/Schema/Result/Aqcontract.pm index 59fe41a5bc..564d78ff2e 100644 --- a/Koha/Schema/Result/Aqcontract.pm +++ b/Koha/Schema/Result/Aqcontract.pm @@ -49,7 +49,7 @@ __PACKAGE__->table("aqcontract"); =head2 contractdescription - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 booksellerid @@ -70,7 +70,7 @@ __PACKAGE__->add_columns( "contractname", { data_type => "varchar", is_nullable => 1, size => 50 }, "contractdescription", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "booksellerid", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, ); @@ -120,8 +120,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:PF3RUnj5urQYDFzxsVxOcw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ar69aHSxYQohZDQ+GtIIqA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqinvoice.pm b/Koha/Schema/Result/Aqinvoice.pm index 365379e58e..3ec1475950 100644 --- a/Koha/Schema/Result/Aqinvoice.pm +++ b/Koha/Schema/Result/Aqinvoice.pm @@ -31,7 +31,7 @@ __PACKAGE__->table("aqinvoices"); =head2 invoicenumber - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 booksellerid @@ -82,7 +82,7 @@ __PACKAGE__->add_columns( "invoiceid", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "invoicenumber", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "booksellerid", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "shipmentdate", @@ -184,8 +184,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-09-18 16:21:46 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FPZXlNt8dkjhgt2Rtc+krQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SAUxWSdpMJK4atxhfgCAGg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Aqorder.pm b/Koha/Schema/Result/Aqorder.pm index af849d7882..bafbe91b7f 100644 --- a/Koha/Schema/Result/Aqorder.pm +++ b/Koha/Schema/Result/Aqorder.pm @@ -109,22 +109,22 @@ __PACKAGE__->table("aqorders"); =head2 cancellationreason - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 order_internalnote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 order_vendornote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 purchaseordernumber - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 basketno @@ -309,7 +309,7 @@ __PACKAGE__->table("aqorders"); =head2 suppliers_report - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -344,13 +344,13 @@ __PACKAGE__->add_columns( "datecancellationprinted", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "cancellationreason", - { data_type => "text", is_nullable => 1 }, - "order_internalnote", { data_type => "mediumtext", is_nullable => 1 }, + "order_internalnote", + { data_type => "longtext", is_nullable => 1 }, "order_vendornote", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "purchaseordernumber", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "basketno", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "timestamp", @@ -422,7 +422,7 @@ __PACKAGE__->add_columns( "suppliers_reference_qualifier", { data_type => "varchar", is_nullable => 1, size => 3 }, "suppliers_report", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -625,8 +625,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-28 15:05:37 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FyZsBWGJ8wsPkFdYUAetmg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:K0GnMGYtZUQ1WCesHKIxHw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ArticleRequest.pm b/Koha/Schema/Result/ArticleRequest.pm index 0cc7ccc791..e26f5c4304 100644 --- a/Koha/Schema/Result/ArticleRequest.pm +++ b/Koha/Schema/Result/ArticleRequest.pm @@ -56,42 +56,42 @@ __PACKAGE__->table("article_requests"); =head2 title - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 author - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 volume - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 issue - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 date - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 pages - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 chapters - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 patron_notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 status @@ -103,7 +103,7 @@ __PACKAGE__->table("article_requests"); =head2 notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 created_on @@ -133,21 +133,21 @@ __PACKAGE__->add_columns( "branchcode", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "title", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "author", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "volume", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "issue", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "date", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "pages", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "chapters", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "patron_notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "status", { data_type => "enum", @@ -156,7 +156,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "created_on", { data_type => "timestamp", @@ -257,8 +257,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-05-25 13:08:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UcnwdgEHzMcmRY6vP9B61A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BOBB3vld8wY75u45YldoEg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AuthHeader.pm b/Koha/Schema/Result/AuthHeader.pm index ce656a8485..56afb9bb80 100644 --- a/Koha/Schema/Result/AuthHeader.pm +++ b/Koha/Schema/Result/AuthHeader.pm @@ -58,7 +58,7 @@ __PACKAGE__->table("auth_header"); =head2 authtrees - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 marc @@ -100,7 +100,7 @@ __PACKAGE__->add_columns( "origincode", { data_type => "varchar", is_nullable => 1, size => 20 }, "authtrees", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "marc", { data_type => "blob", is_nullable => 1 }, "linkid", @@ -122,8 +122,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("authid"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-29 15:07:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H93XLwvtYfEGFBes5PJCyA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kHEdfMFYFtn3sQ20qsdFyg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AuthSubfieldStructure.pm b/Koha/Schema/Result/AuthSubfieldStructure.pm index 0ae35a7083..06bc0c9db2 100644 --- a/Koha/Schema/Result/AuthSubfieldStructure.pm +++ b/Koha/Schema/Result/AuthSubfieldStructure.pm @@ -127,7 +127,7 @@ __PACKAGE__->table("auth_subfield_structure"); =head2 defaultvalue - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -172,7 +172,7 @@ __PACKAGE__->add_columns( "frameworkcode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "defaultvalue", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -209,8 +209,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-05-18 11:22:30 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ymm26DwMwBskOjIj1qhWFA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5Prv/DCQk32mTQaqtYhUuA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/AuthType.pm b/Koha/Schema/Result/AuthType.pm index 7191a9f0d2..f15a6056bc 100644 --- a/Koha/Schema/Result/AuthType.pm +++ b/Koha/Schema/Result/AuthType.pm @@ -46,7 +46,7 @@ __PACKAGE__->table("auth_types"); =head2 summary - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =cut @@ -59,7 +59,7 @@ __PACKAGE__->add_columns( "auth_tag_to_report", { data_type => "varchar", default_value => "", is_nullable => 0, size => 3 }, "summary", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -107,8 +107,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-05-18 11:22:30 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FELYJXziUcU7+b/X8SaDwA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:USULz4Y8i0JC73GxcxJ+BA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Biblio.pm b/Koha/Schema/Result/Biblio.pm index f4af407f74..b118011f27 100644 --- a/Koha/Schema/Result/Biblio.pm +++ b/Koha/Schema/Result/Biblio.pm @@ -38,22 +38,22 @@ __PACKAGE__->table("biblio"); =head2 author - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 unititle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 serial @@ -63,7 +63,7 @@ __PACKAGE__->table("biblio"); =head2 seriestitle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 copyrightdate @@ -86,7 +86,7 @@ __PACKAGE__->table("biblio"); =head2 abstract - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -97,17 +97,17 @@ __PACKAGE__->add_columns( "frameworkcode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 }, "author", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "title", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "unititle", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "serial", { data_type => "tinyint", is_nullable => 1 }, "seriestitle", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "copyrightdate", { data_type => "smallint", is_nullable => 1 }, "timestamp", @@ -120,7 +120,7 @@ __PACKAGE__->add_columns( "datecreated", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 }, "abstract", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -348,7 +348,7 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-13 08:36:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jis7Sm5+9lVKav+o18JLtA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bUv00JjY09Hj2Zj4klqyxA 1; diff --git a/Koha/Schema/Result/Biblioitem.pm b/Koha/Schema/Result/Biblioitem.pm index cdf2e245b6..49e52e7678 100644 --- a/Koha/Schema/Result/Biblioitem.pm +++ b/Koha/Schema/Result/Biblioitem.pm @@ -38,12 +38,12 @@ __PACKAGE__->table("biblioitems"); =head2 volume - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 number - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 itemtype @@ -54,22 +54,22 @@ __PACKAGE__->table("biblioitems"); =head2 isbn - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 issn - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 ean - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 publicationyear - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 publishercode @@ -86,32 +86,32 @@ __PACKAGE__->table("biblioitems"); =head2 volumedesc - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 collectiontitle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 collectionissn - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 collectionvolume - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 editionstatement - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 editionresponsibility - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 timestamp @@ -135,7 +135,7 @@ __PACKAGE__->table("biblioitems"); =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 size @@ -158,7 +158,7 @@ __PACKAGE__->table("biblioitems"); =head2 url - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 cn_source @@ -215,35 +215,35 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "volume", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "number", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "itemtype", { data_type => "varchar", is_nullable => 1, size => 10 }, "isbn", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "issn", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "ean", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "publicationyear", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "publishercode", { data_type => "varchar", is_nullable => 1, size => 255 }, "volumedate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "volumedesc", - { data_type => "text", is_nullable => 1 }, - "collectiontitle", { data_type => "mediumtext", is_nullable => 1 }, + "collectiontitle", + { data_type => "longtext", is_nullable => 1 }, "collectionissn", - { data_type => "text", is_nullable => 1 }, - "collectionvolume", { data_type => "mediumtext", is_nullable => 1 }, + "collectionvolume", + { data_type => "longtext", is_nullable => 1 }, "editionstatement", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "editionresponsibility", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -256,7 +256,7 @@ __PACKAGE__->add_columns( "pages", { data_type => "varchar", is_nullable => 1, size => 255 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "size", { data_type => "varchar", is_nullable => 1, size => 255 }, "place", @@ -264,7 +264,7 @@ __PACKAGE__->add_columns( "lccn", { data_type => "varchar", is_nullable => 1, size => 25 }, "url", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "cn_source", { data_type => "varchar", is_nullable => 1, size => 10 }, "cn_class", @@ -326,8 +326,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-10 14:22:49 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yNRDfNQ7yEvqsJV94x8b9A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ogVRTKNaUQSI3BE2xC2lww __PACKAGE__->belongs_to( biblio => "Koha::Schema::Result::Biblio", "biblionumber" ); diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 21ad72f0b1..18655ccfe1 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -37,27 +37,27 @@ __PACKAGE__->table("borrowers"); =head2 surname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 firstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 othernames - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 initials - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 streetnumber @@ -74,22 +74,22 @@ __PACKAGE__->table("borrowers"); =head2 address - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address2 - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 city - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 state - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 zipcode @@ -100,17 +100,17 @@ __PACKAGE__->table("borrowers"); =head2 country - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 email - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 phone - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 mobile @@ -121,17 +121,17 @@ __PACKAGE__->table("borrowers"); =head2 fax - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 emailpro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 phonepro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_streetnumber @@ -158,19 +158,19 @@ __PACKAGE__->table("borrowers"); =head2 B_address2 accessor: 'b_address2' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_city accessor: 'b_city' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 B_state accessor: 'b_state' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_zipcode @@ -183,19 +183,19 @@ __PACKAGE__->table("borrowers"); =head2 B_country accessor: 'b_country' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_email accessor: 'b_email' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_phone accessor: 'b_phone' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 dateofbirth @@ -262,17 +262,17 @@ __PACKAGE__->table("borrowers"); =head2 contactname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactfirstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 contacttitle - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 guarantorid @@ -282,7 +282,7 @@ __PACKAGE__->table("borrowers"); =head2 borrowernotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 relationship @@ -316,7 +316,7 @@ __PACKAGE__->table("borrowers"); =head2 opacnote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactnote @@ -369,7 +369,7 @@ __PACKAGE__->table("borrowers"); =head2 altcontactstate - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactzipcode @@ -380,7 +380,7 @@ __PACKAGE__->table("borrowers"); =head2 altcontactcountry - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactphone @@ -448,7 +448,7 @@ __PACKAGE__->table("borrowers"); =head2 overdrive_auth_token - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -459,43 +459,43 @@ __PACKAGE__->add_columns( "cardnumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "surname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "firstname", - { data_type => "text", is_nullable => 1 }, - "title", { data_type => "mediumtext", is_nullable => 1 }, + "title", + { data_type => "longtext", is_nullable => 1 }, "othernames", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "initials", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "streetnumber", { data_type => "varchar", is_nullable => 1, size => 10 }, "streettype", { data_type => "varchar", is_nullable => 1, size => 50 }, "address", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address2", - { data_type => "text", is_nullable => 1 }, - "city", { data_type => "mediumtext", is_nullable => 1 }, + "city", + { data_type => "longtext", is_nullable => 1 }, "state", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "zipcode", { data_type => "varchar", is_nullable => 1, size => 25 }, "country", - { data_type => "text", is_nullable => 1 }, - "email", { data_type => "mediumtext", is_nullable => 1 }, + "email", + { data_type => "longtext", is_nullable => 1 }, "phone", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "mobile", { data_type => "varchar", is_nullable => 1, size => 50 }, "fax", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "emailpro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "phonepro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "B_streetnumber", { accessor => "b_streetnumber", @@ -518,11 +518,11 @@ __PACKAGE__->add_columns( size => 100, }, "B_address2", - { accessor => "b_address2", data_type => "text", is_nullable => 1 }, + { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 }, "B_city", - { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_city", data_type => "longtext", is_nullable => 1 }, "B_state", - { accessor => "b_state", data_type => "text", is_nullable => 1 }, + { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", { accessor => "b_zipcode", @@ -531,11 +531,11 @@ __PACKAGE__->add_columns( size => 25, }, "B_country", - { accessor => "b_country", data_type => "text", is_nullable => 1 }, + { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", - { accessor => "b_email", data_type => "text", is_nullable => 1 }, + { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 }, "B_phone", - { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_phone", data_type => "longtext", is_nullable => 1 }, "dateofbirth", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "branchcode", @@ -569,15 +569,15 @@ __PACKAGE__->add_columns( "debarredcomment", { data_type => "varchar", is_nullable => 1, size => 255 }, "contactname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactfirstname", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "contacttitle", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "guarantorid", { data_type => "integer", is_nullable => 1 }, "borrowernotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "relationship", { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", @@ -589,7 +589,7 @@ __PACKAGE__->add_columns( "userid", { data_type => "varchar", is_nullable => 1, size => 75 }, "opacnote", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactnote", { data_type => "varchar", is_nullable => 1, size => 255 }, "sort1", @@ -607,11 +607,11 @@ __PACKAGE__->add_columns( "altcontactaddress3", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactstate", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", { data_type => "varchar", is_nullable => 1, size => 50 }, "altcontactcountry", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", { data_type => "varchar", is_nullable => 1, size => 50 }, "smsalertnumber", @@ -652,7 +652,7 @@ __PACKAGE__->add_columns( "login_attempts", { data_type => "integer", default_value => 0, is_nullable => 1 }, "overdrive_auth_token", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -1386,8 +1386,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-13 14:08:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pxhUnV9IMvVGml9HFheMLw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wM40W+toV8ca5LFwinkHxA __PACKAGE__->belongs_to( "guarantor", diff --git a/Koha/Schema/Result/BorrowerDebarment.pm b/Koha/Schema/Result/BorrowerDebarment.pm index 45a25ff14c..0a603de58a 100644 --- a/Koha/Schema/Result/BorrowerDebarment.pm +++ b/Koha/Schema/Result/BorrowerDebarment.pm @@ -50,7 +50,7 @@ __PACKAGE__->table("borrower_debarments"); =head2 comment - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 manager_id @@ -88,7 +88,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "comment", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "manager_id", { data_type => "integer", is_nullable => 1 }, "created", @@ -136,8 +136,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2014-01-07 17:25:44 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4KkoPNcgZoANIScMWUyS/w +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:J9J1ReRLqhVasOQXvde2Uw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm index 2b0977d4b3..013da7753a 100644 --- a/Koha/Schema/Result/BorrowerModification.pm +++ b/Koha/Schema/Result/BorrowerModification.pm @@ -51,27 +51,27 @@ __PACKAGE__->table("borrower_modifications"); =head2 surname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 firstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 othernames - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 initials - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 streetnumber @@ -88,22 +88,22 @@ __PACKAGE__->table("borrower_modifications"); =head2 address - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address2 - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 city - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 state - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 zipcode @@ -114,17 +114,17 @@ __PACKAGE__->table("borrower_modifications"); =head2 country - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 email - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 phone - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 mobile @@ -135,17 +135,17 @@ __PACKAGE__->table("borrower_modifications"); =head2 fax - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 emailpro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 phonepro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_streetnumber @@ -172,19 +172,19 @@ __PACKAGE__->table("borrower_modifications"); =head2 B_address2 accessor: 'b_address2' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_city accessor: 'b_city' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 B_state accessor: 'b_state' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_zipcode @@ -197,19 +197,19 @@ __PACKAGE__->table("borrower_modifications"); =head2 B_country accessor: 'b_country' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_email accessor: 'b_email' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_phone accessor: 'b_phone' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 dateofbirth @@ -272,17 +272,17 @@ __PACKAGE__->table("borrower_modifications"); =head2 contactname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactfirstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 contacttitle - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 guarantorid @@ -292,7 +292,7 @@ __PACKAGE__->table("borrower_modifications"); =head2 borrowernotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 relationship @@ -326,7 +326,7 @@ __PACKAGE__->table("borrower_modifications"); =head2 opacnote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactnote @@ -379,7 +379,7 @@ __PACKAGE__->table("borrower_modifications"); =head2 altcontactstate - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactzipcode @@ -390,7 +390,7 @@ __PACKAGE__->table("borrower_modifications"); =head2 altcontactcountry - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactphone @@ -412,7 +412,7 @@ __PACKAGE__->table("borrower_modifications"); =head2 extended_attributes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -432,43 +432,43 @@ __PACKAGE__->add_columns( "cardnumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "surname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "firstname", - { data_type => "text", is_nullable => 1 }, - "title", { data_type => "mediumtext", is_nullable => 1 }, + "title", + { data_type => "longtext", is_nullable => 1 }, "othernames", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "initials", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "streetnumber", { data_type => "varchar", is_nullable => 1, size => 10 }, "streettype", { data_type => "varchar", is_nullable => 1, size => 50 }, "address", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address2", - { data_type => "text", is_nullable => 1 }, - "city", { data_type => "mediumtext", is_nullable => 1 }, + "city", + { data_type => "longtext", is_nullable => 1 }, "state", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "zipcode", { data_type => "varchar", is_nullable => 1, size => 25 }, "country", - { data_type => "text", is_nullable => 1 }, - "email", { data_type => "mediumtext", is_nullable => 1 }, + "email", + { data_type => "longtext", is_nullable => 1 }, "phone", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "mobile", { data_type => "varchar", is_nullable => 1, size => 50 }, "fax", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "emailpro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "phonepro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "B_streetnumber", { accessor => "b_streetnumber", @@ -491,11 +491,11 @@ __PACKAGE__->add_columns( size => 100, }, "B_address2", - { accessor => "b_address2", data_type => "text", is_nullable => 1 }, + { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 }, "B_city", - { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_city", data_type => "longtext", is_nullable => 1 }, "B_state", - { accessor => "b_state", data_type => "text", is_nullable => 1 }, + { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", { accessor => "b_zipcode", @@ -504,11 +504,11 @@ __PACKAGE__->add_columns( size => 25, }, "B_country", - { accessor => "b_country", data_type => "text", is_nullable => 1 }, + { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", - { accessor => "b_email", data_type => "text", is_nullable => 1 }, + { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 }, "B_phone", - { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_phone", data_type => "longtext", is_nullable => 1 }, "dateofbirth", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "branchcode", @@ -530,15 +530,15 @@ __PACKAGE__->add_columns( "debarredcomment", { data_type => "varchar", is_nullable => 1, size => 255 }, "contactname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactfirstname", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "contacttitle", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "guarantorid", { data_type => "integer", is_nullable => 1 }, "borrowernotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "relationship", { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", @@ -550,7 +550,7 @@ __PACKAGE__->add_columns( "userid", { data_type => "varchar", is_nullable => 1, size => 75 }, "opacnote", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactnote", { data_type => "varchar", is_nullable => 1, size => 255 }, "sort1", @@ -568,11 +568,11 @@ __PACKAGE__->add_columns( "altcontactaddress3", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactstate", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", { data_type => "varchar", is_nullable => 1, size => 50 }, "altcontactcountry", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", { data_type => "varchar", is_nullable => 1, size => 50 }, "smsalertnumber", @@ -580,7 +580,7 @@ __PACKAGE__->add_columns( "privacy", { data_type => "integer", is_nullable => 1 }, "extended_attributes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -598,8 +598,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-27 13:24:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PUS/k4r20connTfZWAWmxg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vv0bJqR71Ust1MZAkYqTig # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm index 2d0276ff30..bb571b18de 100644 --- a/Koha/Schema/Result/Branch.pm +++ b/Koha/Schema/Result/Branch.pm @@ -32,22 +32,22 @@ __PACKAGE__->table("branches"); =head2 branchname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 branchaddress1 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchaddress2 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchaddress3 - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchzip @@ -58,47 +58,47 @@ __PACKAGE__->table("branches"); =head2 branchcity - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchstate - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchcountry - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 branchphone - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchfax - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchemail - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchreplyto - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchreturnpath - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 branchurl - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 issuing @@ -120,12 +120,12 @@ __PACKAGE__->table("branches"); =head2 branchnotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 opac_info - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 geolocation @@ -146,33 +146,33 @@ __PACKAGE__->add_columns( "branchcode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "branchname", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "branchaddress1", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchaddress2", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchaddress3", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchzip", { data_type => "varchar", is_nullable => 1, size => 25 }, "branchcity", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchstate", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchcountry", - { data_type => "text", is_nullable => 1 }, - "branchphone", { data_type => "mediumtext", is_nullable => 1 }, + "branchphone", + { data_type => "longtext", is_nullable => 1 }, "branchfax", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchemail", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchreplyto", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchreturnpath", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "branchurl", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "issuing", { data_type => "tinyint", is_nullable => 1 }, "branchip", @@ -180,9 +180,9 @@ __PACKAGE__->add_columns( "branchprinter", { data_type => "varchar", is_nullable => 1, size => 100 }, "branchnotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "opac_info", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "geolocation", { data_type => "varchar", is_nullable => 1, size => 255 }, "marcorgcode", @@ -609,8 +609,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-12-05 14:08:18 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g+WicMjGntjAgcKrbn4IdQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QOMUFz2EjvAVWCkIpNmvtg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Branchtransfer.pm b/Koha/Schema/Result/Branchtransfer.pm index 9c5b76b959..7410108d98 100644 --- a/Koha/Schema/Result/Branchtransfer.pm +++ b/Koha/Schema/Result/Branchtransfer.pm @@ -66,7 +66,7 @@ __PACKAGE__->table("branchtransfers"); =head2 comments - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -110,7 +110,7 @@ __PACKAGE__->add_columns( size => 10, }, "comments", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -173,8 +173,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-13 12:22:24 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8cnatLrGkNwyTo35PCOm2A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uPQzv0lMxfnu75SzS6UpVQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index fc26a7d496..42865a8239 100644 --- a/Koha/Schema/Result/Category.pm +++ b/Koha/Schema/Result/Category.pm @@ -32,7 +32,7 @@ __PACKAGE__->table("categories"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 enrolmentperiod @@ -129,7 +129,7 @@ __PACKAGE__->add_columns( "categorycode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "enrolmentperiod", { data_type => "smallint", is_nullable => 1 }, "enrolmentperioddate", @@ -267,8 +267,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-07-08 13:37:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LH3DdDDYXaGsNsILAUZzng +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TGAiiFICSjlKNvnfa87kFQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClassSortRule.pm b/Koha/Schema/Result/ClassSortRule.pm index 567c01af58..14f8220202 100644 --- a/Koha/Schema/Result/ClassSortRule.pm +++ b/Koha/Schema/Result/ClassSortRule.pm @@ -32,7 +32,7 @@ __PACKAGE__->table("class_sort_rules"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 sort_routine @@ -48,7 +48,7 @@ __PACKAGE__->add_columns( "class_sort_rule", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "sort_routine", { data_type => "varchar", default_value => "", is_nullable => 0, size => 30 }, ); @@ -83,8 +83,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xvTm4GLMb6N4qHQEv8EhSw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HvJeH/EdCoaiMvCyFLKr+A # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClassSource.pm b/Koha/Schema/Result/ClassSource.pm index c6de4c48be..6c7a4413d5 100644 --- a/Koha/Schema/Result/ClassSource.pm +++ b/Koha/Schema/Result/ClassSource.pm @@ -32,7 +32,7 @@ __PACKAGE__->table("class_sources"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 used @@ -55,7 +55,7 @@ __PACKAGE__->add_columns( "cn_source", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "used", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "class_sort_rule", @@ -98,8 +98,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:2O58Q7wdbfAl6xmiW02PAA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tu9NZrk0s8VBgtc1kNpXgg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Club.pm b/Koha/Schema/Result/Club.pm index ae2368d41a..7011cd54e6 100644 --- a/Koha/Schema/Result/Club.pm +++ b/Koha/Schema/Result/Club.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("clubs"); =head2 name - data_type: 'tinytext' + data_type: 'text' is_nullable: 0 =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 date_start @@ -85,9 +85,9 @@ __PACKAGE__->add_columns( "club_template_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "name", - { data_type => "tinytext", is_nullable => 0 }, + { data_type => "text", is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "date_start", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "date_end", @@ -189,8 +189,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-27 18:47:08 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKvHFP2y+c5hjpjzKsEQXA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6EB6FURHN+brOhDoPZVeGQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClubEnrollmentField.pm b/Koha/Schema/Result/ClubEnrollmentField.pm index 6ba0fded46..e86f543e9e 100644 --- a/Koha/Schema/Result/ClubEnrollmentField.pm +++ b/Koha/Schema/Result/ClubEnrollmentField.pm @@ -43,7 +43,7 @@ __PACKAGE__->table("club_enrollment_fields"); =head2 value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =cut @@ -56,7 +56,7 @@ __PACKAGE__->add_columns( "club_template_enrollment_field_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "value", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -104,8 +104,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-01-12 09:56:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2ANAs3mh3i/kd3Qxrcd5IA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tr8INu1+veRdWkRT4BgBOQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClubField.pm b/Koha/Schema/Result/ClubField.pm index eab0f4b322..c3f8ada6c4 100644 --- a/Koha/Schema/Result/ClubField.pm +++ b/Koha/Schema/Result/ClubField.pm @@ -43,7 +43,7 @@ __PACKAGE__->table("club_fields"); =head2 value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -56,7 +56,7 @@ __PACKAGE__->add_columns( "club_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "value", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -104,8 +104,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-01-12 09:56:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:m4GLLIVIHgRpRhCGLh12DQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2ySSLrl8GXRXJ38AWg6kng # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClubTemplate.pm b/Koha/Schema/Result/ClubTemplate.pm index 1bfb1a2bc7..197e8ded12 100644 --- a/Koha/Schema/Result/ClubTemplate.pm +++ b/Koha/Schema/Result/ClubTemplate.pm @@ -31,12 +31,12 @@ __PACKAGE__->table("club_templates"); =head2 name - data_type: 'tinytext' + data_type: 'text' is_nullable: 0 =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 is_enrollable_from_opac @@ -83,9 +83,9 @@ __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "name", - { data_type => "tinytext", is_nullable => 0 }, + { data_type => "text", is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "is_enrollable_from_opac", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "is_email_required", @@ -189,7 +189,7 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-26 16:17:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:29ssLVCIoLxBmUi8E5gHqg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1UuejI9kkTb9eeNKvSLAQQ 1; diff --git a/Koha/Schema/Result/ClubTemplateEnrollmentField.pm b/Koha/Schema/Result/ClubTemplateEnrollmentField.pm index 3b3907d96a..c45720ac1f 100644 --- a/Koha/Schema/Result/ClubTemplateEnrollmentField.pm +++ b/Koha/Schema/Result/ClubTemplateEnrollmentField.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("club_template_enrollment_fields"); =head2 name - data_type: 'tinytext' + data_type: 'text' is_nullable: 0 =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 authorised_value_category @@ -59,9 +59,9 @@ __PACKAGE__->add_columns( "club_template_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "name", - { data_type => "tinytext", is_nullable => 0 }, + { data_type => "text", is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "authorised_value_category", { data_type => "varchar", is_nullable => 1, size => 16 }, ); @@ -111,8 +111,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-01-12 09:56:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KGo2mEIAkTVYSPsOLoaBCg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lN5Shnqo+va0tCdiM/iwNg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ClubTemplateField.pm b/Koha/Schema/Result/ClubTemplateField.pm index 3485ef371b..9629e1741c 100644 --- a/Koha/Schema/Result/ClubTemplateField.pm +++ b/Koha/Schema/Result/ClubTemplateField.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("club_template_fields"); =head2 name - data_type: 'tinytext' + data_type: 'text' is_nullable: 0 =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 authorised_value_category @@ -59,9 +59,9 @@ __PACKAGE__->add_columns( "club_template_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "name", - { data_type => "tinytext", is_nullable => 0 }, + { data_type => "text", is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "authorised_value_category", { data_type => "varchar", is_nullable => 1, size => 16 }, ); @@ -111,8 +111,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-27 18:47:08 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pZ/iYdUn2LUeDNI2I+h+hQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LRnLRjyMHuEd3KMRMHd3KA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Collection.pm b/Koha/Schema/Result/Collection.pm index 38353ea3dc..f8c3d8e46b 100644 --- a/Koha/Schema/Result/Collection.pm +++ b/Koha/Schema/Result/Collection.pm @@ -41,7 +41,7 @@ __PACKAGE__->table("collections"); =head2 colDesc accessor: 'col_desc' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 colBranchcode @@ -71,7 +71,7 @@ __PACKAGE__->add_columns( size => 100, }, "colDesc", - { accessor => "col_desc", data_type => "text", is_nullable => 0 }, + { accessor => "col_desc", data_type => "mediumtext", is_nullable => 0 }, "colBranchcode", { accessor => "col_branchcode", @@ -117,8 +117,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-11-06 15:26:36 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gb7EYny5ULsZw8rYQQ/hjA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Nx6GPmSO3ckjDmF7dz0DKA # 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 ceef5bc20a..cd1ede28e3 100644 --- a/Koha/Schema/Result/Course.pm +++ b/Koha/Schema/Result/Course.pm @@ -61,12 +61,12 @@ __PACKAGE__->table("courses"); =head2 staff_note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 public_note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 students_count @@ -105,9 +105,9 @@ __PACKAGE__->add_columns( "term", { data_type => "varchar", is_nullable => 1, size => 80 }, "staff_note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "public_note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "students_count", { data_type => "varchar", is_nullable => 1, size => 20 }, "enabled", @@ -181,8 +181,8 @@ Composing rels: L -> borrowernumber __PACKAGE__->many_to_many("borrowernumbers", "course_instructors", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:crKCFQ80qo2p885ebiBfnw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o0EBOuJCHxH5IG/PgsJfxg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/CourseReserve.pm b/Koha/Schema/Result/CourseReserve.pm index ed930c93f5..080d699cba 100644 --- a/Koha/Schema/Result/CourseReserve.pm +++ b/Koha/Schema/Result/CourseReserve.pm @@ -43,12 +43,12 @@ __PACKAGE__->table("course_reserves"); =head2 staff_note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 public_note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 timestamp @@ -68,9 +68,9 @@ __PACKAGE__->add_columns( "ci_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "staff_note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "public_note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -141,8 +141,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-09-02 09:46:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4RbSgGvSM5wH1jpE+deLlA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8SDdUrbxKuAwp6rgn85RmA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/CreatorLayout.pm b/Koha/Schema/Result/CreatorLayout.pm index 88fda029a3..c37c662604 100644 --- a/Koha/Schema/Result/CreatorLayout.pm +++ b/Koha/Schema/Result/CreatorLayout.pm @@ -110,7 +110,7 @@ __PACKAGE__->table("creator_layouts"); =head2 layout_xml - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 creator @@ -165,7 +165,7 @@ __PACKAGE__->add_columns( size => 210, }, "layout_xml", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "creator", { data_type => "char", @@ -188,8 +188,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("layout_id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-05-16 17:38:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BDNkfgqz53LCR2Ij7cVCow +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GdBVaqH0rfn1Jy/t57ieNA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deletedbiblio.pm b/Koha/Schema/Result/Deletedbiblio.pm index f3d314a108..f809b9324d 100644 --- a/Koha/Schema/Result/Deletedbiblio.pm +++ b/Koha/Schema/Result/Deletedbiblio.pm @@ -38,22 +38,22 @@ __PACKAGE__->table("deletedbiblio"); =head2 author - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 unititle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 serial @@ -63,7 +63,7 @@ __PACKAGE__->table("deletedbiblio"); =head2 seriestitle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 copyrightdate @@ -86,7 +86,7 @@ __PACKAGE__->table("deletedbiblio"); =head2 abstract - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -97,17 +97,17 @@ __PACKAGE__->add_columns( "frameworkcode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 }, "author", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "title", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "unititle", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "serial", { data_type => "tinyint", is_nullable => 1 }, "seriestitle", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "copyrightdate", { data_type => "smallint", is_nullable => 1 }, "timestamp", @@ -120,7 +120,7 @@ __PACKAGE__->add_columns( "datecreated", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 }, "abstract", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -153,8 +153,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-13 08:36:25 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HBjJjCdFsEUOPmxexvK27g +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dP0HOIp/+I93Y/u92TDI1g # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deletedbiblioitem.pm b/Koha/Schema/Result/Deletedbiblioitem.pm index c17e181f82..c83134788c 100644 --- a/Koha/Schema/Result/Deletedbiblioitem.pm +++ b/Koha/Schema/Result/Deletedbiblioitem.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("deletedbiblioitems"); =head2 volume - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 number - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 itemtype @@ -53,22 +53,22 @@ __PACKAGE__->table("deletedbiblioitems"); =head2 isbn - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 issn - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 ean - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 publicationyear - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 publishercode @@ -85,32 +85,32 @@ __PACKAGE__->table("deletedbiblioitems"); =head2 volumedesc - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 collectiontitle - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 collectionissn - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 collectionvolume - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 editionstatement - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 editionresponsibility - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 timestamp @@ -134,7 +134,7 @@ __PACKAGE__->table("deletedbiblioitems"); =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 size @@ -157,7 +157,7 @@ __PACKAGE__->table("deletedbiblioitems"); =head2 url - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 cn_source @@ -209,35 +209,35 @@ __PACKAGE__->add_columns( "biblionumber", { data_type => "integer", default_value => 0, is_nullable => 0 }, "volume", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "number", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "itemtype", { data_type => "varchar", is_nullable => 1, size => 10 }, "isbn", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "issn", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "ean", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "publicationyear", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "publishercode", { data_type => "varchar", is_nullable => 1, size => 255 }, "volumedate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "volumedesc", - { data_type => "text", is_nullable => 1 }, - "collectiontitle", { data_type => "mediumtext", is_nullable => 1 }, + "collectiontitle", + { data_type => "longtext", is_nullable => 1 }, "collectionissn", - { data_type => "text", is_nullable => 1 }, - "collectionvolume", { data_type => "mediumtext", is_nullable => 1 }, + "collectionvolume", + { data_type => "longtext", is_nullable => 1 }, "editionstatement", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "editionresponsibility", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -250,7 +250,7 @@ __PACKAGE__->add_columns( "pages", { data_type => "varchar", is_nullable => 1, size => 255 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "size", { data_type => "varchar", is_nullable => 1, size => 255 }, "place", @@ -258,7 +258,7 @@ __PACKAGE__->add_columns( "lccn", { data_type => "varchar", is_nullable => 1, size => 25 }, "url", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "cn_source", { data_type => "varchar", is_nullable => 1, size => 10 }, "cn_class", @@ -288,8 +288,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("biblioitemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-10 14:22:50 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NFNV+3zrgb1wOCVv5wRNwQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QLYBa1Ea8Jau2Wy6U+wyQw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index 825b503532..4d15e35c1f 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -37,27 +37,27 @@ __PACKAGE__->table("deletedborrowers"); =head2 surname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 firstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 othernames - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 initials - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 streetnumber @@ -74,22 +74,22 @@ __PACKAGE__->table("deletedborrowers"); =head2 address - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 address2 - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 city - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 state - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 zipcode @@ -100,17 +100,17 @@ __PACKAGE__->table("deletedborrowers"); =head2 country - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 email - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 phone - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 mobile @@ -121,17 +121,17 @@ __PACKAGE__->table("deletedborrowers"); =head2 fax - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 emailpro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 phonepro - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_streetnumber @@ -158,19 +158,19 @@ __PACKAGE__->table("deletedborrowers"); =head2 B_address2 accessor: 'b_address2' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_city accessor: 'b_city' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 B_state accessor: 'b_state' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_zipcode @@ -183,19 +183,19 @@ __PACKAGE__->table("deletedborrowers"); =head2 B_country accessor: 'b_country' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_email accessor: 'b_email' - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 B_phone accessor: 'b_phone' - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 dateofbirth @@ -260,17 +260,17 @@ __PACKAGE__->table("deletedborrowers"); =head2 contactname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactfirstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 contacttitle - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 guarantorid @@ -280,7 +280,7 @@ __PACKAGE__->table("deletedborrowers"); =head2 borrowernotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 relationship @@ -314,7 +314,7 @@ __PACKAGE__->table("deletedborrowers"); =head2 opacnote - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 contactnote @@ -367,7 +367,7 @@ __PACKAGE__->table("deletedborrowers"); =head2 altcontactstate - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactzipcode @@ -378,7 +378,7 @@ __PACKAGE__->table("deletedborrowers"); =head2 altcontactcountry - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 altcontactphone @@ -445,7 +445,7 @@ __PACKAGE__->table("deletedborrowers"); =head2 overdrive_auth_token - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -456,43 +456,43 @@ __PACKAGE__->add_columns( "cardnumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "surname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "firstname", - { data_type => "text", is_nullable => 1 }, - "title", { data_type => "mediumtext", is_nullable => 1 }, + "title", + { data_type => "longtext", is_nullable => 1 }, "othernames", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "initials", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "streetnumber", { data_type => "varchar", is_nullable => 1, size => 10 }, "streettype", { data_type => "varchar", is_nullable => 1, size => 50 }, "address", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "address2", - { data_type => "text", is_nullable => 1 }, - "city", { data_type => "mediumtext", is_nullable => 1 }, + "city", + { data_type => "longtext", is_nullable => 1 }, "state", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "zipcode", { data_type => "varchar", is_nullable => 1, size => 25 }, "country", - { data_type => "text", is_nullable => 1 }, - "email", { data_type => "mediumtext", is_nullable => 1 }, + "email", + { data_type => "longtext", is_nullable => 1 }, "phone", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "mobile", { data_type => "varchar", is_nullable => 1, size => 50 }, "fax", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "emailpro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "phonepro", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "B_streetnumber", { accessor => "b_streetnumber", @@ -515,11 +515,11 @@ __PACKAGE__->add_columns( size => 100, }, "B_address2", - { accessor => "b_address2", data_type => "text", is_nullable => 1 }, + { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 }, "B_city", - { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_city", data_type => "longtext", is_nullable => 1 }, "B_state", - { accessor => "b_state", data_type => "text", is_nullable => 1 }, + { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 }, "B_zipcode", { accessor => "b_zipcode", @@ -528,11 +528,11 @@ __PACKAGE__->add_columns( size => 25, }, "B_country", - { accessor => "b_country", data_type => "text", is_nullable => 1 }, + { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 }, "B_email", - { accessor => "b_email", data_type => "text", is_nullable => 1 }, + { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 }, "B_phone", - { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 }, + { accessor => "b_phone", data_type => "longtext", is_nullable => 1 }, "dateofbirth", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "branchcode", @@ -554,15 +554,15 @@ __PACKAGE__->add_columns( "debarredcomment", { data_type => "varchar", is_nullable => 1, size => 255 }, "contactname", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactfirstname", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "contacttitle", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "guarantorid", { data_type => "integer", is_nullable => 1 }, "borrowernotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "relationship", { data_type => "varchar", is_nullable => 1, size => 100 }, "sex", @@ -574,7 +574,7 @@ __PACKAGE__->add_columns( "userid", { data_type => "varchar", is_nullable => 1, size => 75 }, "opacnote", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "contactnote", { data_type => "varchar", is_nullable => 1, size => 255 }, "sort1", @@ -592,11 +592,11 @@ __PACKAGE__->add_columns( "altcontactaddress3", { data_type => "varchar", is_nullable => 1, size => 255 }, "altcontactstate", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactzipcode", { data_type => "varchar", is_nullable => 1, size => 50 }, "altcontactcountry", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "altcontactphone", { data_type => "varchar", is_nullable => 1, size => 50 }, "smsalertnumber", @@ -637,12 +637,12 @@ __PACKAGE__->add_columns( "login_attempts", { data_type => "integer", default_value => 0, is_nullable => 1 }, "overdrive_auth_token", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-13 14:08:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C0Zr5b+5mXPKJKCMWL0Q/w +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Deleteditem.pm b/Koha/Schema/Result/Deleteditem.pm index 38286e8ea1..a2cc3db7f7 100644 --- a/Koha/Schema/Result/Deleteditem.pm +++ b/Koha/Schema/Result/Deleteditem.pm @@ -55,7 +55,7 @@ __PACKAGE__->table("deleteditems"); =head2 booksellerid - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 homebranch @@ -169,12 +169,12 @@ __PACKAGE__->table("deleteditems"); =head2 itemnotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 itemnotes_nonpublic - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 holdingbranch @@ -185,7 +185,7 @@ __PACKAGE__->table("deleteditems"); =head2 paidfor - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 timestamp @@ -233,7 +233,7 @@ __PACKAGE__->table("deleteditems"); =head2 materials - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 uri @@ -255,7 +255,7 @@ __PACKAGE__->table("deleteditems"); =head2 enumchron - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 copynumber @@ -290,7 +290,7 @@ __PACKAGE__->add_columns( "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "homebranch", { data_type => "varchar", is_nullable => 1, size => 10 }, "price", @@ -338,13 +338,13 @@ __PACKAGE__->add_columns( "restricted", { data_type => "tinyint", is_nullable => 1 }, "itemnotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "itemnotes_nonpublic", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "holdingbranch", { data_type => "varchar", is_nullable => 1, size => 10 }, "paidfor", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -365,7 +365,7 @@ __PACKAGE__->add_columns( "ccode", { data_type => "varchar", is_nullable => 1, size => 10 }, "materials", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "uri", { data_type => "varchar", is_nullable => 1, size => 255 }, "itype", @@ -373,7 +373,7 @@ __PACKAGE__->add_columns( "more_subfields_xml", { data_type => "longtext", is_nullable => 1 }, "enumchron", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "copynumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "stocknumber", @@ -395,8 +395,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("itemnumber"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-31 17:10:17 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:npNexLgE7AxLp6iVy1FxgQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RaHchgIC64wq0q4MXqEITA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/EdifactMessage.pm b/Koha/Schema/Result/EdifactMessage.pm index 98c8b02a6f..7e0c4feff2 100644 --- a/Koha/Schema/Result/EdifactMessage.pm +++ b/Koha/Schema/Result/EdifactMessage.pm @@ -55,7 +55,7 @@ __PACKAGE__->table("edifact_messages"); =head2 status - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 basketno @@ -66,12 +66,12 @@ __PACKAGE__->table("edifact_messages"); =head2 raw_msg - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 filename - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 deleted @@ -94,13 +94,13 @@ __PACKAGE__->add_columns( "edi_acct", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "status", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "basketno", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "raw_msg", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "filename", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "deleted", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); @@ -195,8 +195,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-29 10:32:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R20sqhX9IbPaonx9HnRKeQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHUEsQ+kXjGTRxxc2FFSjQ 1; diff --git a/Koha/Schema/Result/ExportFormat.pm b/Koha/Schema/Result/ExportFormat.pm index 9d486e4c28..819451a83b 100644 --- a/Koha/Schema/Result/ExportFormat.pm +++ b/Koha/Schema/Result/ExportFormat.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("export_format"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 content - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 csv_separator @@ -93,9 +93,9 @@ __PACKAGE__->add_columns( "profile", { data_type => "varchar", is_nullable => 0, size => 255 }, "description", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "content", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "csv_separator", { data_type => "varchar", default_value => ",", is_nullable => 0, size => 2 }, "field_separator", @@ -138,8 +138,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("export_format_id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-13 14:16:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RTcPpu1SdseBlKI9MEdUWA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YSQshI3mJfO0LsOlwvdIdg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/HouseboundProfile.pm b/Koha/Schema/Result/HouseboundProfile.pm index 1661eb5c63..2c50c9a202 100644 --- a/Koha/Schema/Result/HouseboundProfile.pm +++ b/Koha/Schema/Result/HouseboundProfile.pm @@ -31,37 +31,37 @@ __PACKAGE__->table("housebound_profile"); =head2 day - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 frequency - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 fav_itemtypes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 fav_subjects - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 fav_authors - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 referral - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -70,19 +70,19 @@ __PACKAGE__->add_columns( "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "day", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "frequency", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "fav_itemtypes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "fav_subjects", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "fav_authors", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "referral", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -130,8 +130,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-25 13:21:23 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kY+BhDo9g/YCShkmFUVDYA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ESpGqu3oX9qad3elnDvOiw # 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 d965012c9d..1b207ff002 100644 --- a/Koha/Schema/Result/Illrequest.pm +++ b/Koha/Schema/Result/Illrequest.pm @@ -99,12 +99,12 @@ __PACKAGE__->table("illrequests"); =head2 notesopac - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 notesstaff - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 orderid @@ -157,9 +157,9 @@ __PACKAGE__->add_columns( "cost", { data_type => "varchar", is_nullable => 1, size => 20 }, "notesopac", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "notesstaff", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "orderid", { data_type => "varchar", is_nullable => 1, size => 50 }, "backend", @@ -231,8 +231,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-09 11:42:45 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Iirysr/XU9b8Scssd4A0OQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Rh8DSs3xj3KRmyd7WNGDAg # 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 2be7984802..cb9cb182d7 100644 --- a/Koha/Schema/Result/Illrequestattribute.pm +++ b/Koha/Schema/Result/Illrequestattribute.pm @@ -38,7 +38,7 @@ __PACKAGE__->table("illrequestattributes"); =head2 value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =cut @@ -54,7 +54,7 @@ __PACKAGE__->add_columns( "type", { data_type => "varchar", is_nullable => 0, size => 200 }, "value", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -89,8 +89,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-09 11:42:45 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:COXHn3Q7RglF6Cl7kKHqLA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X9SxZP1PGXTwDJ6lUkx8Fg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ImportBatch.pm b/Koha/Schema/Result/ImportBatch.pm index 5413d39f8d..c2fd81c79a 100644 --- a/Koha/Schema/Result/ImportBatch.pm +++ b/Koha/Schema/Result/ImportBatch.pm @@ -114,7 +114,7 @@ __PACKAGE__->table("import_batches"); =head2 comments - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -202,7 +202,7 @@ __PACKAGE__->add_columns( "file_name", { data_type => "varchar", is_nullable => 1, size => 100 }, "comments", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -235,8 +235,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-30 03:46:54 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4UfJtTeAzzsuBycjsn2foQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:41giNJCRD9WXC4IGO/1D3A # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ImportItem.pm b/Koha/Schema/Result/ImportItem.pm index 2949e366f8..6d13719ee1 100644 --- a/Koha/Schema/Result/ImportItem.pm +++ b/Koha/Schema/Result/ImportItem.pm @@ -60,7 +60,7 @@ __PACKAGE__->table("import_items"); =head2 import_error - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -84,7 +84,7 @@ __PACKAGE__->add_columns( "marcxml", { data_type => "longtext", is_nullable => 0 }, "import_error", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -117,8 +117,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:xJd76DD3iljc4uFm7iZeLQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GaUyqPnOhETQO8YuuKvfNQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/ImportRecord.pm b/Koha/Schema/Result/ImportRecord.pm index 2d27bd8eec..66b44cb11f 100644 --- a/Koha/Schema/Result/ImportRecord.pm +++ b/Koha/Schema/Result/ImportRecord.pm @@ -98,7 +98,7 @@ __PACKAGE__->table("import_records"); =head2 import_error - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 encoding @@ -173,7 +173,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "import_error", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "encoding", { data_type => "varchar", default_value => "", is_nullable => 0, size => 40 }, "z3950random", @@ -270,8 +270,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jhzXlqw5mA1lGsI9SZEv/Q +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yCx/kRJXjPIB5Uuv40TB7g # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Issue.pm b/Koha/Schema/Result/Issue.pm index eef46af3b6..7fb084c06d 100644 --- a/Koha/Schema/Result/Issue.pm +++ b/Koha/Schema/Result/Issue.pm @@ -103,7 +103,7 @@ __PACKAGE__->table("issues"); =head2 note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 notedate @@ -163,7 +163,7 @@ __PACKAGE__->add_columns( "onsite_checkout", { data_type => "integer", default_value => 0, is_nullable => 0 }, "note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "notedate", { data_type => "datetime", @@ -241,8 +241,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-03 04:12:22 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ozRQZiF1LlOJy4KI53OpFw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:skFfce3y1eEx3rSdFaLmPg __PACKAGE__->belongs_to( "borrower", diff --git a/Koha/Schema/Result/Item.pm b/Koha/Schema/Result/Item.pm index ce85bd7b72..4161770fd0 100644 --- a/Koha/Schema/Result/Item.pm +++ b/Koha/Schema/Result/Item.pm @@ -57,7 +57,7 @@ __PACKAGE__->table("items"); =head2 booksellerid - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 homebranch @@ -172,12 +172,12 @@ __PACKAGE__->table("items"); =head2 itemnotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 itemnotes_nonpublic - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 holdingbranch @@ -189,7 +189,7 @@ __PACKAGE__->table("items"); =head2 paidfor - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 timestamp @@ -237,7 +237,7 @@ __PACKAGE__->table("items"); =head2 materials - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 uri @@ -259,7 +259,7 @@ __PACKAGE__->table("items"); =head2 enumchron - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 copynumber @@ -304,7 +304,7 @@ __PACKAGE__->add_columns( "dateaccessioned", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "booksellerid", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "homebranch", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "price", @@ -352,13 +352,13 @@ __PACKAGE__->add_columns( "restricted", { data_type => "tinyint", is_nullable => 1 }, "itemnotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "itemnotes_nonpublic", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "holdingbranch", { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 }, "paidfor", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -379,7 +379,7 @@ __PACKAGE__->add_columns( "ccode", { data_type => "varchar", is_nullable => 1, size => 10 }, "materials", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "uri", { data_type => "varchar", is_nullable => 1, size => 255 }, "itype", @@ -387,7 +387,7 @@ __PACKAGE__->add_columns( "more_subfields_xml", { data_type => "longtext", is_nullable => 1 }, "enumchron", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "copynumber", { data_type => "varchar", is_nullable => 1, size => 32 }, "stocknumber", @@ -675,8 +675,8 @@ __PACKAGE__->might_have( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-24 13:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vf1sBZrpUo0Cvi896fjNuA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:50sZaqt8I9HG2reLqzSSVQ __PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" ); diff --git a/Koha/Schema/Result/Itemtype.pm b/Koha/Schema/Result/Itemtype.pm index 331db3ba77..0e36247b50 100644 --- a/Koha/Schema/Result/Itemtype.pm +++ b/Koha/Schema/Result/Itemtype.pm @@ -32,7 +32,7 @@ __PACKAGE__->table("itemtypes"); =head2 description - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 rentalcharge @@ -66,7 +66,7 @@ __PACKAGE__->table("itemtypes"); =head2 summary - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 checkinmsg @@ -106,7 +106,7 @@ __PACKAGE__->add_columns( "itemtype", { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 }, "description", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "rentalcharge", { data_type => "decimal", is_nullable => 1, size => [28, 6] }, "defaultreplacecost", @@ -118,7 +118,7 @@ __PACKAGE__->add_columns( "imageurl", { data_type => "varchar", is_nullable => 1, size => 200 }, "summary", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "checkinmsg", { data_type => "varchar", is_nullable => 1, size => 255 }, "checkinmsgtype", @@ -211,8 +211,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-10 14:27:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vERtWCf17tayLdzgnXpQcA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cNP7/nYGdVeKZ8L7sp1+FQ # Use the ItemtypeLocalization view to create the join on localization our $LANGUAGE; diff --git a/Koha/Schema/Result/Letter.pm b/Koha/Schema/Result/Letter.pm index 36e335245f..152cea19c6 100644 --- a/Koha/Schema/Result/Letter.pm +++ b/Koha/Schema/Result/Letter.pm @@ -66,7 +66,7 @@ __PACKAGE__->table("letter"); =head2 content - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 message_transport_type @@ -100,7 +100,7 @@ __PACKAGE__->add_columns( "title", { data_type => "varchar", default_value => "", is_nullable => 0, size => 200 }, "content", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "message_transport_type", { data_type => "varchar", @@ -156,8 +156,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-09 21:01:19 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WZxxDvP7M/Ns/e9cFseeNA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fOuu1Fj8Uo3114QKS2qLkQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/LibraryGroup.pm b/Koha/Schema/Result/LibraryGroup.pm index 972ed43e13..306075b355 100644 --- a/Koha/Schema/Result/LibraryGroup.pm +++ b/Koha/Schema/Result/LibraryGroup.pm @@ -50,7 +50,7 @@ __PACKAGE__->table("library_groups"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 ft_hide_patron_info @@ -96,7 +96,7 @@ __PACKAGE__->add_columns( "title", { data_type => "varchar", is_nullable => 1, size => 100 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "ft_hide_patron_info", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "ft_search_groups_opac", @@ -202,8 +202,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-09 16:35:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hy7zXPiHGs832yvEBIO6Uw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8hvTh2lWoG/MpfSdq4kx5Q # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Linktracker.pm b/Koha/Schema/Result/Linktracker.pm index a1ca30a800..d36c177a09 100644 --- a/Koha/Schema/Result/Linktracker.pm +++ b/Koha/Schema/Result/Linktracker.pm @@ -46,7 +46,7 @@ __PACKAGE__->table("linktracker"); =head2 url - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 timeclicked @@ -67,7 +67,7 @@ __PACKAGE__->add_columns( "borrowernumber", { data_type => "integer", is_nullable => 1 }, "url", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "timeclicked", { data_type => "datetime", @@ -89,8 +89,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:4Ox7j2FHewUd09dX9i+T6w +# 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 # 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 b5422ca867..dec7ebff50 100644 --- a/Koha/Schema/Result/Localization.pm +++ b/Koha/Schema/Result/Localization.pm @@ -49,7 +49,7 @@ __PACKAGE__->table("localization"); =head2 translation - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -64,7 +64,7 @@ __PACKAGE__->add_columns( "lang", { data_type => "varchar", is_nullable => 0, size => 25 }, "translation", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -98,8 +98,8 @@ __PACKAGE__->set_primary_key("localization_id"); __PACKAGE__->add_unique_constraint("entity_code_lang", ["entity", "code", "lang"]); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-27 12:51:15 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bYEuhKEE13txmjNiRHk8tA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4642LmshpGd3JW7YxM5pIA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/MarcModificationTemplate.pm b/Koha/Schema/Result/MarcModificationTemplate.pm index 7590f19999..e94ee1e8e5 100644 --- a/Koha/Schema/Result/MarcModificationTemplate.pm +++ b/Koha/Schema/Result/MarcModificationTemplate.pm @@ -31,7 +31,7 @@ __PACKAGE__->table("marc_modification_templates"); =head2 name - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =cut @@ -40,7 +40,7 @@ __PACKAGE__->add_columns( "template_id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "name", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -73,8 +73,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 22:03:59 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:igqidvfP0AgV5RRBa1huew +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bu3u1X0RBx4c35kkph05/A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/MarcModificationTemplateAction.pm b/Koha/Schema/Result/MarcModificationTemplateAction.pm index 00aefb3933..a69b459a79 100644 --- a/Koha/Schema/Result/MarcModificationTemplateAction.pm +++ b/Koha/Schema/Result/MarcModificationTemplateAction.pm @@ -84,12 +84,12 @@ __PACKAGE__->table("marc_modification_template_actions"); =head2 to_regex_search - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 to_regex_replace - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 to_regex_modifiers @@ -125,7 +125,7 @@ __PACKAGE__->table("marc_modification_template_actions"); =head2 conditional_value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 conditional_regex @@ -136,7 +136,7 @@ __PACKAGE__->table("marc_modification_template_actions"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -175,9 +175,9 @@ __PACKAGE__->add_columns( "to_subfield", { data_type => "varchar", is_nullable => 1, size => 1 }, "to_regex_search", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "to_regex_replace", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "to_regex_modifiers", { data_type => "varchar", default_value => "", is_nullable => 1, size => 8 }, "conditional", @@ -197,11 +197,11 @@ __PACKAGE__->add_columns( is_nullable => 1, }, "conditional_value", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "conditional_regex", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -234,8 +234,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-11-05 10:39:28 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mIif3RU6QvUc0xJepUQZjw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uRkJ8yckBiNtsYgUt8BpEw # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/MarcSubfieldStructure.pm b/Koha/Schema/Result/MarcSubfieldStructure.pm index b7ebf1bc43..ac4fec5a84 100644 --- a/Koha/Schema/Result/MarcSubfieldStructure.pm +++ b/Koha/Schema/Result/MarcSubfieldStructure.pm @@ -79,7 +79,7 @@ __PACKAGE__->table("marc_subfield_structure"); data_type: 'varchar' is_foreign_key: 1 is_nullable: 1 - size: 32 + size: 20 =head2 authtypecode @@ -153,7 +153,7 @@ __PACKAGE__->add_columns( "tab", { data_type => "tinyint", is_nullable => 1 }, "authorised_value", - { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 32 }, + { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 20 }, "authtypecode", { data_type => "varchar", is_nullable => 1, size => 20 }, "value_builder", @@ -213,8 +213,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/gnyZuGje+sg82HfxMLI0g +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V++tjMyI92SwFjikQAAJFg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Message.pm b/Koha/Schema/Result/Message.pm index 085cb69590..9fd862eee6 100644 --- a/Koha/Schema/Result/Message.pm +++ b/Koha/Schema/Result/Message.pm @@ -48,7 +48,7 @@ __PACKAGE__->table("messages"); =head2 message - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 message_date @@ -76,7 +76,7 @@ __PACKAGE__->add_columns( "message_type", { data_type => "varchar", is_nullable => 0, size => 1 }, "message", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "message_date", { data_type => "timestamp", @@ -123,8 +123,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:36 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lmkl/u8Lr1cQumfZvn5D4A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cNf9ogl9bN+0BC63dS1rmA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/MessageQueue.pm b/Koha/Schema/Result/MessageQueue.pm index 346b463b89..f1ddb5e766 100644 --- a/Koha/Schema/Result/MessageQueue.pm +++ b/Koha/Schema/Result/MessageQueue.pm @@ -37,17 +37,17 @@ __PACKAGE__->table("message_queue"); =head2 subject - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 content - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 metadata - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 letter_code @@ -79,17 +79,17 @@ __PACKAGE__->table("message_queue"); =head2 to_address - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 from_address - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 content_type - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -100,11 +100,11 @@ __PACKAGE__->add_columns( "borrowernumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "subject", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "content", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "metadata", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "letter_code", { data_type => "varchar", is_nullable => 1, size => 64 }, "message_transport_type", @@ -124,11 +124,11 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "to_address", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "from_address", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "content_type", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -181,8 +181,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-06-22 16:37:20 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nQcmtLCbGEeLFLFP4jwy2g +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9u39S/GLtZwnZGp+xcZOBA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/NeedMergeAuthority.pm b/Koha/Schema/Result/NeedMergeAuthority.pm index 614be246c1..bbe16cefda 100644 --- a/Koha/Schema/Result/NeedMergeAuthority.pm +++ b/Koha/Schema/Result/NeedMergeAuthority.pm @@ -41,7 +41,7 @@ __PACKAGE__->table("need_merge_authorities"); =head2 reportxml - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 timestamp @@ -67,7 +67,7 @@ __PACKAGE__->add_columns( "authid_new", { data_type => "bigint", is_nullable => 1 }, "reportxml", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "timestamp", { data_type => "timestamp", @@ -92,8 +92,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-12 19:42:42 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BW1u1si2H88+GS/Ok8fuGA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7LzwIYvExKvNgr8/HDZlsg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/OldIssue.pm b/Koha/Schema/Result/OldIssue.pm index 4a03bc900f..b9c5b234b5 100644 --- a/Koha/Schema/Result/OldIssue.pm +++ b/Koha/Schema/Result/OldIssue.pm @@ -102,7 +102,7 @@ __PACKAGE__->table("old_issues"); =head2 note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 notedate @@ -162,7 +162,7 @@ __PACKAGE__->add_columns( "onsite_checkout", { data_type => "integer", default_value => 0, is_nullable => 0 }, "note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "notedate", { data_type => "datetime", @@ -226,8 +226,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-03 04:12:22 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rvUGkBhLE7AwPNp1viI23Q +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKLeDDEz22G5BU/ZAl7QLA sub koha_objects_class { 'Koha::Old::Checkouts'; diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm index b1c44e25ac..851f00c90d 100644 --- a/Koha/Schema/Result/OldReserve.pm +++ b/Koha/Schema/Result/OldReserve.pm @@ -72,7 +72,7 @@ __PACKAGE__->table("old_reserves"); =head2 reservenotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 priority @@ -157,7 +157,7 @@ __PACKAGE__->add_columns( "cancellationdate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "reservenotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "priority", { data_type => "smallint", is_nullable => 1 }, "found", @@ -289,8 +289,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-13 14:08:34 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1QLyttziZfEWRa64oTH1yA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ynb6NtiTN8ZZur2YCvxlNg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/OpacNews.pm b/Koha/Schema/Result/OpacNews.pm index fcd25c140c..120128edde 100644 --- a/Koha/Schema/Result/OpacNews.pm +++ b/Koha/Schema/Result/OpacNews.pm @@ -46,7 +46,7 @@ __PACKAGE__->table("opac_news"); =head2 content - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 lang @@ -95,7 +95,7 @@ __PACKAGE__->add_columns( "title", { data_type => "varchar", default_value => "", is_nullable => 0, size => 250 }, "content", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "lang", { data_type => "varchar", default_value => "", is_nullable => 0, size => 25 }, "timestamp", @@ -168,8 +168,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-01-21 12:39:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wfBMbKlWykwfNNNLGkl4BA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gApTRM/dF6uZSMYyvkt4OQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/PluginData.pm b/Koha/Schema/Result/PluginData.pm index 869e450ee0..f40a2f6f4a 100644 --- a/Koha/Schema/Result/PluginData.pm +++ b/Koha/Schema/Result/PluginData.pm @@ -37,7 +37,7 @@ __PACKAGE__->table("plugin_data"); =head2 plugin_value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -48,7 +48,7 @@ __PACKAGE__->add_columns( "plugin_key", { data_type => "varchar", is_nullable => 0, size => 255 }, "plugin_value", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -66,8 +66,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("plugin_class", "plugin_key"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/incxJUcobgYLR1a9g8cOQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g4MbnMszG6BGSG0vHxWQig # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Quote.pm b/Koha/Schema/Result/Quote.pm index 2f34bb2e75..94b06eeb2f 100644 --- a/Koha/Schema/Result/Quote.pm +++ b/Koha/Schema/Result/Quote.pm @@ -31,12 +31,12 @@ __PACKAGE__->table("quotes"); =head2 source - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 text - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 timestamp @@ -51,9 +51,9 @@ __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "source", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "text", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "timestamp", { data_type => "datetime", @@ -75,8 +75,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:WhRbBrQ4jMV+pjgKnOhErg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8xSMrGuJH9rbm73qOvU8Xg # 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 44515138d9..d1185c4fe8 100644 --- a/Koha/Schema/Result/RepeatableHoliday.pm +++ b/Koha/Schema/Result/RepeatableHoliday.pm @@ -60,7 +60,7 @@ __PACKAGE__->table("repeatable_holidays"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =cut @@ -79,7 +79,7 @@ __PACKAGE__->add_columns( "title", { data_type => "varchar", default_value => "", is_nullable => 0, size => 50 }, "description", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -95,8 +95,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:15Ot3jdlgFpmCbVgUDqZRg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tp+p/e8mXWJv33yYXNMoww # 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 de433a5d91..e81b1aa52c 100644 --- a/Koha/Schema/Result/ReportsDictionary.pm +++ b/Koha/Schema/Result/ReportsDictionary.pm @@ -37,7 +37,7 @@ __PACKAGE__->table("reports_dictionary"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 date_created @@ -54,7 +54,7 @@ __PACKAGE__->table("reports_dictionary"); =head2 saved_sql - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 report_area @@ -71,7 +71,7 @@ __PACKAGE__->add_columns( "name", { data_type => "varchar", is_nullable => 1, size => 255 }, "description", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "date_created", { data_type => "datetime", @@ -85,7 +85,7 @@ __PACKAGE__->add_columns( is_nullable => 1, }, "saved_sql", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "report_area", { data_type => "varchar", is_nullable => 1, size => 6 }, ); @@ -103,8 +103,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:Cnru3/NTfEScxeVggDa5RA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0akgYM7kqiLxz95xUCdrdQ # 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 3bfb1a41d1..1ba1c974f6 100644 --- a/Koha/Schema/Result/Reserve.pm +++ b/Koha/Schema/Result/Reserve.pm @@ -76,7 +76,7 @@ __PACKAGE__->table("reserves"); =head2 reservenotes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 priority @@ -171,7 +171,7 @@ __PACKAGE__->add_columns( "cancellationdate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "reservenotes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "priority", { data_type => "smallint", is_nullable => 1 }, "found", @@ -313,8 +313,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-13 14:08:34 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IP2cVX4M3BKM4zZvpyGHPQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2GCET9quFpUvzuN7MUWZNw __PACKAGE__->belongs_to( "item", diff --git a/Koha/Schema/Result/Review.pm b/Koha/Schema/Result/Review.pm index a066f2a079..6c628b41c2 100644 --- a/Koha/Schema/Result/Review.pm +++ b/Koha/Schema/Result/Review.pm @@ -43,7 +43,7 @@ __PACKAGE__->table("reviews"); =head2 review - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 approved @@ -68,7 +68,7 @@ __PACKAGE__->add_columns( "biblionumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "review", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "approved", { data_type => "tinyint", default_value => 0, is_nullable => 1 }, "datereviewed", @@ -134,8 +134,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-09 10:38:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZjW8uHIL0m7+pwOTE0pcxQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gEngecP849wzHprYW7H2tw # 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 cb32ef0cb2..622f588f52 100644 --- a/Koha/Schema/Result/SavedSql.pm +++ b/Koha/Schema/Result/SavedSql.pm @@ -48,7 +48,7 @@ __PACKAGE__->table("saved_sql"); =head2 savedsql - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 last_run @@ -72,7 +72,7 @@ __PACKAGE__->table("saved_sql"); =head2 notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 cache_expiry @@ -125,7 +125,7 @@ __PACKAGE__->add_columns( is_nullable => 1, }, "savedsql", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "last_run", { data_type => "datetime", @@ -137,7 +137,7 @@ __PACKAGE__->add_columns( "type", { data_type => "varchar", is_nullable => 1, size => 255 }, "notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "cache_expiry", { data_type => "integer", default_value => 300, is_nullable => 0 }, "public", @@ -163,8 +163,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-24 09:58:16 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eGWRRzpe1+EBialePAIhMQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7UCqSsNMGdq+S7MwZulmwA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SearchHistory.pm b/Koha/Schema/Result/SearchHistory.pm index 809619e1dd..e2886df82c 100644 --- a/Koha/Schema/Result/SearchHistory.pm +++ b/Koha/Schema/Result/SearchHistory.pm @@ -48,7 +48,7 @@ __PACKAGE__->table("search_history"); =head2 query_cgi - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 type @@ -82,7 +82,7 @@ __PACKAGE__->add_columns( "query_desc", { data_type => "varchar", is_nullable => 0, size => 255 }, "query_cgi", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "type", { data_type => "varchar", @@ -114,8 +114,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-03-11 14:59:09 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IDEfmaznxc6sCi0r/8ibhg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d+Qf8sL7wLldvw2qPLoBgQ # 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 892ab21c92..58aed2c012 100644 --- a/Koha/Schema/Result/Serial.pm +++ b/Koha/Schema/Result/Serial.pm @@ -82,7 +82,7 @@ __PACKAGE__->table("serial"); =head2 notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 publisheddate @@ -111,7 +111,7 @@ __PACKAGE__->table("serial"); =head2 routingnotes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =cut @@ -136,7 +136,7 @@ __PACKAGE__->add_columns( "planneddate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "publisheddate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "publisheddatetext", @@ -146,7 +146,7 @@ __PACKAGE__->add_columns( "claims_count", { data_type => "integer", default_value => 0, is_nullable => 1 }, "routingnotes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -179,8 +179,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-01-06 12:19:30 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZwOGHLaGRVFow9J/DeKSGg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sRygXoIOnqpdk0lqVMcBdA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Session.pm b/Koha/Schema/Result/Session.pm index 322c0913ea..38b2aac159 100644 --- a/Koha/Schema/Result/Session.pm +++ b/Koha/Schema/Result/Session.pm @@ -31,7 +31,7 @@ __PACKAGE__->table("sessions"); =head2 a_session - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =cut @@ -40,7 +40,7 @@ __PACKAGE__->add_columns( "id", { data_type => "varchar", is_nullable => 0, size => 32 }, "a_session", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -56,8 +56,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-23 13:21:59 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsbP76fskUOelxUl8nAVMQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YyoQx5Kb6G7W0CVV96chpQ # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SpecialHoliday.pm b/Koha/Schema/Result/SpecialHoliday.pm index 45f884f87a..29ff8bb0e1 100644 --- a/Koha/Schema/Result/SpecialHoliday.pm +++ b/Koha/Schema/Result/SpecialHoliday.pm @@ -69,7 +69,7 @@ __PACKAGE__->table("special_holidays"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =cut @@ -90,7 +90,7 @@ __PACKAGE__->add_columns( "title", { data_type => "varchar", default_value => "", is_nullable => 0, size => 50 }, "description", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, ); =head1 PRIMARY KEY @@ -106,8 +106,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:mRo3D1nPRJsMY6hPxp/Ojg +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Qc6VbOUqX83upThUC//oA # 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 f424d5636b..20b55f3944 100644 --- a/Koha/Schema/Result/Statistic.pm +++ b/Koha/Schema/Result/Statistic.pm @@ -55,7 +55,7 @@ __PACKAGE__->table("statistics"); =head2 other - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 usercode @@ -115,7 +115,7 @@ __PACKAGE__->add_columns( "type", { data_type => "varchar", is_nullable => 1, size => 16 }, "other", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "usercode", { data_type => "varchar", is_nullable => 1, size => 10 }, "itemnumber", @@ -133,8 +133,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-11-08 13:32:13 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9xOR9IMMUNysXOlsHnRfHA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RI3X/GXlBlUEgG0oxToIIA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Subscription.pm b/Koha/Schema/Result/Subscription.pm index dadb5650da..c493b73b60 100644 --- a/Koha/Schema/Result/Subscription.pm +++ b/Koha/Schema/Result/Subscription.pm @@ -98,7 +98,7 @@ __PACKAGE__->table("subscription"); =head2 notes - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 status @@ -155,7 +155,7 @@ __PACKAGE__->table("subscription"); =head2 irregularity - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 skip_serialseq @@ -184,7 +184,7 @@ __PACKAGE__->table("subscription"); =head2 distributedto - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 internalnotes @@ -194,7 +194,7 @@ __PACKAGE__->table("subscription"); =head2 callnumber - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 location @@ -299,7 +299,7 @@ __PACKAGE__->add_columns( "countissuesperunit", { data_type => "integer", default_value => 1, is_nullable => 0 }, "notes", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "status", { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 }, "lastvalue1", @@ -319,7 +319,7 @@ __PACKAGE__->add_columns( "manualhistory", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "irregularity", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "skip_serialseq", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "letter", @@ -329,11 +329,11 @@ __PACKAGE__->add_columns( "locale", { data_type => "varchar", is_nullable => 1, size => 80 }, "distributedto", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "internalnotes", { data_type => "longtext", is_nullable => 1 }, "callnumber", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "location", { data_type => "varchar", default_value => "", is_nullable => 1, size => 80 }, "branchcode", @@ -445,8 +445,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-09-12 09:39:32 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jAZGa1b6DkY8Sr12reD4nw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZRLfM/4h8VMLTgW7LkUYYA # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SubscriptionFrequency.pm b/Koha/Schema/Result/SubscriptionFrequency.pm index 0226a02b6c..654b223ab6 100644 --- a/Koha/Schema/Result/SubscriptionFrequency.pm +++ b/Koha/Schema/Result/SubscriptionFrequency.pm @@ -31,7 +31,7 @@ __PACKAGE__->table("subscription_frequencies"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 displayorder @@ -63,7 +63,7 @@ __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "displayorder", { data_type => "integer", is_nullable => 1 }, "unit", @@ -108,8 +108,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-30 02:42:01 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kOm4+reRTMxUBfVJl4UPig +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AMA/p9t1S6NmZTAHThLROQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/SubscriptionNumberpattern.pm b/Koha/Schema/Result/SubscriptionNumberpattern.pm index 88e0a36d68..c5b59b4a40 100644 --- a/Koha/Schema/Result/SubscriptionNumberpattern.pm +++ b/Koha/Schema/Result/SubscriptionNumberpattern.pm @@ -42,7 +42,7 @@ __PACKAGE__->table("subscription_numberpatterns"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 numberingmethod @@ -157,7 +157,7 @@ __PACKAGE__->add_columns( "displayorder", { data_type => "integer", is_nullable => 1 }, "description", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "numberingmethod", { data_type => "varchar", is_nullable => 0, size => 255 }, "label1", @@ -228,8 +228,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-30 02:42:01 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MtVt8WNuJfkeJ2FVoghG5A +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UxpUui+IbCUkKDIJOpYyUA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Suggestion.pm b/Koha/Schema/Result/Suggestion.pm index 22bdbb56a1..ac08c1e5c1 100644 --- a/Koha/Schema/Result/Suggestion.pm +++ b/Koha/Schema/Result/Suggestion.pm @@ -84,7 +84,7 @@ __PACKAGE__->table("suggestions"); =head2 note - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 author @@ -148,12 +148,12 @@ __PACKAGE__->table("suggestions"); =head2 reason - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 patronreason - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 budgetid @@ -170,7 +170,7 @@ __PACKAGE__->table("suggestions"); =head2 collectiontitle - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 itemtype @@ -232,7 +232,7 @@ __PACKAGE__->add_columns( size => 10, }, "note", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "author", { data_type => "varchar", is_nullable => 1, size => 80 }, "title", @@ -259,15 +259,15 @@ __PACKAGE__->add_columns( "biblionumber", { data_type => "integer", is_nullable => 1 }, "reason", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "patronreason", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "budgetid", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "branchcode", { data_type => "varchar", is_nullable => 1, size => 10 }, "collectiontitle", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "itemtype", { data_type => "varchar", is_nullable => 1, size => 30 }, "quantity", @@ -315,8 +315,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-03-09 15:14:35 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FlZsyhm/ugCqtMJ+HoYOkw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dOt4/U4rLcXq+aACRwcpYw # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Systempreference.pm b/Koha/Schema/Result/Systempreference.pm index ef05bd8031..22269d7397 100644 --- a/Koha/Schema/Result/Systempreference.pm +++ b/Koha/Schema/Result/Systempreference.pm @@ -32,17 +32,17 @@ __PACKAGE__->table("systempreferences"); =head2 value - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 options - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 explanation - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 type @@ -57,11 +57,11 @@ __PACKAGE__->add_columns( "variable", { data_type => "varchar", default_value => "", is_nullable => 0, size => 50 }, "value", - { data_type => "text", is_nullable => 1 }, - "options", { data_type => "mediumtext", is_nullable => 1 }, + "options", + { data_type => "longtext", is_nullable => 1 }, "explanation", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "type", { data_type => "varchar", is_nullable => 1, size => 20 }, ); @@ -79,8 +79,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("variable"); -# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WalVf/kVVNRcfYely910iQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QI7OL4VHrXe8FridIOCZ4A # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/TmpHoldsqueue.pm b/Koha/Schema/Result/TmpHoldsqueue.pm index 5a0f4bf2d8..6a8c76e4d6 100644 --- a/Koha/Schema/Result/TmpHoldsqueue.pm +++ b/Koha/Schema/Result/TmpHoldsqueue.pm @@ -41,17 +41,17 @@ __PACKAGE__->table("tmp_holdsqueue"); =head2 surname - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 firstname - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 phone - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 borrowernumber @@ -73,7 +73,7 @@ __PACKAGE__->table("tmp_holdsqueue"); =head2 title - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 itemcallnumber @@ -96,7 +96,7 @@ __PACKAGE__->table("tmp_holdsqueue"); =head2 notes - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 item_level_request @@ -115,11 +115,11 @@ __PACKAGE__->add_columns( "barcode", { data_type => "varchar", is_nullable => 1, size => 20 }, "surname", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "firstname", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "phone", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "borrowernumber", { data_type => "integer", is_nullable => 0 }, "cardnumber", @@ -127,7 +127,7 @@ __PACKAGE__->add_columns( "reservedate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "title", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "itemcallnumber", { data_type => "varchar", is_nullable => 1, size => 255 }, "holdingbranch", @@ -135,14 +135,14 @@ __PACKAGE__->add_columns( "pickbranch", { data_type => "varchar", is_nullable => 1, size => 10 }, "notes", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "item_level_request", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-10-27 13:24:06 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2uCsPkQk5ul3ntBdbKFx8Q +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1Wa4h3u3FePOhGPD8SHEWg # You can replace this text with custom content, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/UploadedFile.pm b/Koha/Schema/Result/UploadedFile.pm index 1eaab71f00..5a4397db69 100644 --- a/Koha/Schema/Result/UploadedFile.pm +++ b/Koha/Schema/Result/UploadedFile.pm @@ -37,12 +37,12 @@ __PACKAGE__->table("uploaded_files"); =head2 filename - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 dir - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 filesize @@ -59,7 +59,7 @@ __PACKAGE__->table("uploaded_files"); =head2 uploadcategorycode - data_type: 'tinytext' + data_type: 'text' is_nullable: 1 =head2 owner @@ -85,9 +85,9 @@ __PACKAGE__->add_columns( "hashvalue", { data_type => "char", is_nullable => 0, size => 40 }, "filename", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "dir", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "filesize", { data_type => "integer", is_nullable => 1 }, "dtcreated", @@ -98,7 +98,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "uploadcategorycode", - { data_type => "tinytext", is_nullable => 1 }, + { data_type => "text", is_nullable => 1 }, "owner", { data_type => "integer", is_nullable => 1 }, "public", @@ -120,8 +120,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-09-25 15:20:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Cq/HSuTaBxZH2qSGEddoaQ +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kJUbIULQMBo3t51HvWC8cg # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/VendorEdiAccount.pm b/Koha/Schema/Result/VendorEdiAccount.pm index 9a60720b94..e8e7d810fc 100644 --- a/Koha/Schema/Result/VendorEdiAccount.pm +++ b/Koha/Schema/Result/VendorEdiAccount.pm @@ -31,7 +31,7 @@ __PACKAGE__->table("vendor_edi_accounts"); =head2 description - data_type: 'text' + data_type: 'mediumtext' is_nullable: 0 =head2 host @@ -66,12 +66,12 @@ __PACKAGE__->table("vendor_edi_accounts"); =head2 download_directory - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 upload_directory - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 san @@ -143,7 +143,7 @@ __PACKAGE__->add_columns( "id", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "description", - { data_type => "text", is_nullable => 0 }, + { data_type => "mediumtext", is_nullable => 0 }, "host", { data_type => "varchar", is_nullable => 1, size => 40 }, "username", @@ -155,9 +155,9 @@ __PACKAGE__->add_columns( "vendor_id", { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "download_directory", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "upload_directory", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "san", { data_type => "varchar", is_nullable => 1, size => 20 }, "id_code_qualifier", @@ -250,8 +250,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-01 21:58:03 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rsSTteR7nV22B/kxr33BBA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TtWuTpP4Ac6/+T6OPMSsRA # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/Koha/Schema/Result/Z3950server.pm b/Koha/Schema/Result/Z3950server.pm index d3f3f50466..f2a5de2647 100644 --- a/Koha/Schema/Result/Z3950server.pm +++ b/Koha/Schema/Result/Z3950server.pm @@ -60,7 +60,7 @@ __PACKAGE__->table("z3950servers"); =head2 servername - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 0 =head2 checked @@ -94,7 +94,7 @@ __PACKAGE__->table("z3950servers"); =head2 encoding - data_type: 'text' + data_type: 'mediumtext' is_nullable: 1 =head2 recordtype @@ -112,12 +112,12 @@ __PACKAGE__->table("z3950servers"); =head2 sru_fields - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =head2 add_xslt - data_type: 'mediumtext' + data_type: 'longtext' is_nullable: 1 =cut @@ -136,7 +136,7 @@ __PACKAGE__->add_columns( "password", { data_type => "varchar", is_nullable => 1, size => 255 }, "servername", - { data_type => "mediumtext", is_nullable => 0 }, + { data_type => "longtext", is_nullable => 0 }, "checked", { data_type => "smallint", is_nullable => 1 }, "rank", @@ -153,7 +153,7 @@ __PACKAGE__->add_columns( is_nullable => 0, }, "encoding", - { data_type => "text", is_nullable => 1 }, + { data_type => "mediumtext", is_nullable => 1 }, "recordtype", { data_type => "enum", @@ -164,9 +164,9 @@ __PACKAGE__->add_columns( "sru_options", { data_type => "varchar", is_nullable => 1, size => 255 }, "sru_fields", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, "add_xslt", - { data_type => "mediumtext", is_nullable => 1 }, + { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY @@ -182,8 +182,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("id"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-09-01 10:16:04 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q0y03nGYIt0eDIVui0UUdw +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KK2y1pbgVh1hOVLAXL1e/w # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.39.2