From 58984c7c82ff6dfe16c0123ce27884978f07b89a Mon Sep 17 00:00:00 2001 From: Alex Arnaud Date: Thu, 4 Mar 2021 17:23:18 +0100 Subject: [PATCH] Bug 17656: [DO NOT PUSH] provide schema file Signed-off-by: Victor Grousset/tuxayo --- Koha/Schema/Result/Subscription.pm | 61 ++++-------------------------- 1 file changed, 8 insertions(+), 53 deletions(-) diff --git a/Koha/Schema/Result/Subscription.pm b/Koha/Schema/Result/Subscription.pm index 2d6c322320..3ed3976932 100644 --- a/Koha/Schema/Result/Subscription.pm +++ b/Koha/Schema/Result/Subscription.pm @@ -29,16 +29,12 @@ __PACKAGE__->table("subscription"); is_foreign_key: 1 is_nullable: 0 -foreign key for biblio.biblionumber that this subscription is attached to - =head2 subscriptionid data_type: 'integer' is_auto_increment: 1 is_nullable: 0 -unique key for this subscription - =head2 librarian data_type: 'varchar' @@ -46,24 +42,18 @@ unique key for this subscription is_nullable: 1 size: 100 -the librarian's username from borrowers.userid - =head2 startdate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -start date for this subscription - =head2 aqbooksellerid data_type: 'integer' default_value: 0 is_nullable: 1 -foreign key for aqbooksellers.id to link to the vendor - =head2 cost data_type: 'integer' @@ -82,32 +72,24 @@ foreign key for aqbooksellers.id to link to the vendor default_value: 0 is_nullable: 1 -subscription length in weeks (will not be filled in if monthlength or numberlength is set) - =head2 monthlength data_type: 'integer' default_value: 0 is_nullable: 1 -subscription length in weeks (will not be filled in if weeklength or numberlength is set) - =head2 numberlength data_type: 'integer' default_value: 0 is_nullable: 1 -subscription length in weeks (will not be filled in if monthlength or weeklength is set) - =head2 periodicity data_type: 'integer' is_foreign_key: 1 is_nullable: 1 -frequency type links to subscription_frequencies.id - =head2 countissuesperunit data_type: 'integer' @@ -119,8 +101,6 @@ frequency type links to subscription_frequencies.id data_type: 'longtext' is_nullable: 1 -notes - =head2 status data_type: 'varchar' @@ -128,8 +108,6 @@ notes is_nullable: 0 size: 100 -status of this subscription - =head2 lastvalue1 data_type: 'integer' @@ -169,22 +147,21 @@ status of this subscription datetime_undef_if_invalid: 1 is_nullable: 1 -first issue received date - =head2 manualhistory data_type: 'tinyint' default_value: 0 is_nullable: 0 -yes or no to managing the history manually - =head2 irregularity data_type: 'mediumtext' is_nullable: 1 -any irregularities in the subscription +=head2 permanent_irregularity + + data_type: 'mediumtext' + is_nullable: 1 =head2 skip_serialseq @@ -204,16 +181,12 @@ any irregularities in the subscription is_foreign_key: 1 is_nullable: 1 -the numbering pattern used links to subscription_numberpatterns.id - =head2 locale data_type: 'varchar' is_nullable: 1 size: 80 -for foreign language subscriptions to display months, seasons, etc correctly - =head2 distributedto data_type: 'mediumtext' @@ -229,8 +202,6 @@ for foreign language subscriptions to display months, seasons, etc correctly data_type: 'mediumtext' is_nullable: 1 -default call number - =head2 location data_type: 'varchar' @@ -238,8 +209,6 @@ default call number is_nullable: 1 size: 80 -default shelving location (items.location) - =head2 branchcode data_type: 'varchar' @@ -247,8 +216,6 @@ default shelving location (items.location) is_nullable: 0 size: 10 -default branches (items.homebranch) - =head2 lastbranch data_type: 'varchar' @@ -261,56 +228,42 @@ default branches (items.homebranch) default_value: 0 is_nullable: 0 -does receiving this serial create an item record - =head2 staffdisplaycount data_type: 'varchar' is_nullable: 1 size: 10 -how many issues to show to the staff - =head2 opacdisplaycount data_type: 'varchar' is_nullable: 1 size: 10 -how many issues to show to the public - =head2 graceperiod data_type: 'integer' default_value: 0 is_nullable: 0 -grace period in days - =head2 enddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -subscription end date - =head2 closed data_type: 'tinyint' default_value: 0 is_nullable: 0 -yes / no if the subscription is closed - =head2 reneweddate data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1 -date of last renewal for the subscription - =head2 itemtype data_type: 'varchar' @@ -377,6 +330,8 @@ __PACKAGE__->add_columns( { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "irregularity", { data_type => "mediumtext", is_nullable => 1 }, + "permanent_irregularity", + { data_type => "mediumtext", is_nullable => 1 }, "skip_serialseq", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "letter", @@ -549,8 +504,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RA/Z4pcP53tB0kXgo0W6fQ +# Created by DBIx::Class::Schema::Loader v0.07046 @ 2021-03-04 15:52:23 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Pt/RPOtwhz5vHtPGljxfg __PACKAGE__->has_many( "additional_field_values", -- 2.25.1