Attachment 123775 Details for Bug 27945 – Bug 27945: Add article_request_limit in categories table

[patch] Bug 27945: Add article_request_limit in categories table

Bug-27945-Add-articlerequestlimit-in-categories-ta.patch (text/plain), 2.22 KB, created by David Nind on 2021-08-11 10:21:08 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Nind

Created: 2021-08-11 10:21:08 UTC

Size: 2.22 KB

patch

obsolete

>From ac188b5d3a1afd054235affbafb06c081178a9fb Mon Sep 17 00:00:00 2001
>From: Agustin Moyano <agustinmoyano@theke.io>
>Date: Thu, 22 Jul 2021 01:24:08 +0000
>Subject: [PATCH] Bug 27945: Add article_request_limit in categories table
>
>Signed-off-by: David Nind <david@davidnind.com>
>---
> installer/data/mysql/atomicupdate/bug_27945.perl | 15 +++++++++++++++
> installer/data/mysql/kohastructure.sql           |  1 +
> 2 files changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_27945.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_27945.perl b/installer/data/mysql/atomicupdate/bug_27945.perl
>new file mode 100644
>index 0000000000..4a39162019
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_27945.perl
>@@ -0,0 +1,15 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    # you can use $dbh here like:
>+    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
>+
>+    # or perform some test and warn
>+    if( !column_exists( 'categories', 'article_request_limit' ) ) {
>+      $dbh->do(q{
>+        ALTER TABLE `categories` ADD COLUMN `article_request_limit` tinyint(4) DEFAULT NULL COMMENT 'Limit article scan requests per day' AFTER `article_request_fee`
>+      });
>+    }
>+
>+    # Always end with this (adjust the bug info)
>+    NewVersion( $DBversion, 27945, "Add article_request_limit to categories table");
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index a266c6346a..f072b21362 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1624,6 +1624,7 @@ CREATE TABLE `categories` (
>   `require_strong_password` tinyint(1) DEFAULT NULL COMMENT 'set required password strength for patrons in this category',
>   `exclude_from_local_holds_priority` tinyint(1) DEFAULT NULL COMMENT 'Exclude patrons of this category from local holds priority',
>   `article_request_fee` decimal(28,6) DEFAULT NULL COMMENT 'Cost for article scan request',
>+  `article_request_limit` tinyint(4) DEFAULT NULL COMMENT 'Limit article scan requests per day',
>   PRIMARY KEY (`categorycode`),
>   UNIQUE KEY `categorycode` (`categorycode`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 27945: 123217 | 123218 | 123219 | 123220 | 123714 | 123715 | 123774 | 123775 | 123776 | 123777 | 123778 | 123820 | 124066 | 124067 | 124068 | 124069 | 124070 | 124071 | 124072 | 124073 | 124074 | 124075 | 124076 | 124077 | 124078 | 124079 | 124284 | 124285 | 124633 | 124673 | 124674 | 124675 | 124676 | 124677 | 124678 | 124679 | 124680 | 124681 | 124682 | 125140 | 125142 | 125143 | 125144 | 125145 | 125146 | 125147 | 125148 | 125149 | 125150 | 125151 | 125152 | 125178 | 125179 | 125569 | 125571 | 125638 | 125690 | 125702 | 125703 | 125704 | 125705 | 125706 | 125707 | 125726 | 125741 | 125761