Attachment 117791 Details for Bug 17656 – Bug 17656: [DO NOT PUSH] provide schema file

[patch] Bug 17656: [DO NOT PUSH] provide schema file

Bug-17656-DO-NOT-PUSH-provide-schema-file.patch (text/plain), 5.39 KB, created by Alex Arnaud on 2021-03-05 08:47:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Arnaud

Created: 2021-03-05 08:47:22 UTC

Size: 5.39 KB

patch

obsolete

>From fd091b8fed15fbb5efb3b2577ae0ec2e8475d437 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
>
>---
> 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 2d6c322..3ed3976 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.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 17656: 68259 | 68261 | 68607 | 68608 | 68665 | 69124 | 69207 | 69279 | 69553 | 69814 | 69820 | 69915 | 70335 | 70336 | 70430 | 70619 | 75403 | 75404 | 75405 | 75406 | 75407 | 75408 | 75721 | 75722 | 75723 | 75724 | 75725 | 75726 | 75953 | 102724 | 102725 | 102726 | 102727 | 102728 | 102729 | 102730 | 102860 | 102861 | 102862 | 102863 | 102864 | 102865 | 102866 | 102867 | 102960 | 102961 | 102962 | 102963 | 102964 | 102965 | 102966 | 102967 | 102968 | 103623 | 103624 | 103625 | 103626 | 103627 | 103628 | 103629 | 103630 | 103631 | 103657 | 103658 | 103659 | 103660 | 103661 | 103662 | 103663 | 103664 | 103665 | 103667 | 117789 | 117790 | 117791 | 117792 | 117846 | 117851 | 117852 | 118856 | 119106 | 120863 | 121082 | 121083 | 121084 | 121085 | 121086 | 121087 | 121088 | 121192 | 121193 | 121194 | 121195 | 121196 | 121197 | 121198 | 121296 | 121297 | 121298 | 121299 | 121300 | 121301 | 121302 | 128489 | 128491 | 128492 | 128493 | 128494 | 128495 | 128496 | 128498 | 128499 | 128500 | 128501 | 128502 | 128503 | 128504 | 132412 | 132413 | 132415 | 132416 | 132417 | 132418 | 132447 | 132448 | 132692 | 132779