From 58984c7c82ff6dfe16c0123ce27884978f07b89a Mon Sep 17 00:00:00 2001
From: Alex Arnaud <alex.arnaud@biblibre.com>
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 <victor@tuxayo.net>
---
 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