Attachment 170374 Details for Bug 10190 – Bug 10190: Drop overduerules and overduerules_transport_types

[patch] Bug 10190: Drop overduerules and overduerules_transport_types

Bug-10190-Drop-overduerules-and-overduerulestransp.patch (text/plain), 4.28 KB, created by Martin Renvoize (ashimema) on 2024-08-15 11:52:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2024-08-15 11:52:38 UTC

Size: 4.28 KB

patch

obsolete

>From 12eadad60d155b8bf1fd8b62f472a8ed18137836 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Thu, 15 Aug 2024 12:52:09 +0100
>Subject: [PATCH] Bug 10190: Drop overduerules and overduerules_transport_types
>
>---
> .../data/mysql/atomicupdate/bug_10190.pl      |  3 ++
> installer/data/mysql/kohastructure.sql        | 45 -------------------
> 2 files changed, 3 insertions(+), 45 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_10190.pl b/installer/data/mysql/atomicupdate/bug_10190.pl
>index ea62a9bf12f..aba12c397bd 100755
>--- a/installer/data/mysql/atomicupdate/bug_10190.pl
>+++ b/installer/data/mysql/atomicupdate/bug_10190.pl
>@@ -256,5 +256,8 @@ return {
> 
>             }
>         }
>+
>+        $dbh->do(q|DROP TABLE overduerules|);
>+        $dbh->do(q|DROP TABLE overduerules_transport_types|);
>     }
> };
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 07b1e78e1f9..40d9b91355b 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4953,51 +4953,6 @@ CREATE TABLE `old_reserves` (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>---
>--- Table structure for table `overduerules`
>---
>-
>-DROP TABLE IF EXISTS `overduerules`;
>-/*!40101 SET @saved_cs_client     = @@character_set_client */;
>-/*!40101 SET character_set_client = utf8 */;
>-CREATE TABLE `overduerules` (
>-  `overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules',
>-  `branchcode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)',
>-  `categorycode` varchar(10) NOT NULL DEFAULT '' COMMENT 'foreign key from the categories table to define which patron category this rule is for',
>-  `delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent',
>-  `letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice',
>-  `debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)',
>-  `delay2` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the second notice is sent',
>-  `debarred2` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the second notice is sent (1 for yes, 0 for no)',
>-  `letter2` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the second notice',
>-  `delay3` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the third notice is sent',
>-  `letter3` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the third notice',
>-  `debarred3` int(1) DEFAULT 0 COMMENT 'is the patron restricted when the third notice is sent (1 for yes, 0 for no)',
>-  PRIMARY KEY (`overduerules_id`),
>-  UNIQUE KEY `overduerules_branch_cat` (`branchcode`,`categorycode`)
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-/*!40101 SET character_set_client = @saved_cs_client */;
>-
>---
>--- Table structure for table `overduerules_transport_types`
>---
>-
>-DROP TABLE IF EXISTS `overduerules_transport_types`;
>-/*!40101 SET @saved_cs_client     = @@character_set_client */;
>-/*!40101 SET character_set_client = utf8 */;
>-CREATE TABLE `overduerules_transport_types` (
>-  `id` int(11) NOT NULL AUTO_INCREMENT,
>-  `letternumber` int(1) NOT NULL DEFAULT 1,
>-  `message_transport_type` varchar(20) NOT NULL DEFAULT 'email',
>-  `overduerules_id` int(11) NOT NULL,
>-  PRIMARY KEY (`id`),
>-  KEY `overduerules_fk` (`overduerules_id`),
>-  KEY `mtt_fk` (`message_transport_type`),
>-  CONSTRAINT `mtt_fk` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON DELETE CASCADE ON UPDATE CASCADE,
>-  CONSTRAINT `overduerules_fk` FOREIGN KEY (`overduerules_id`) REFERENCES `overduerules` (`overduerules_id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>-/*!40101 SET character_set_client = @saved_cs_client */;
>-
> --
> -- Table structure for table `patron_consent`
> --
>-- 
>2.46.0

Actions: View | Diff | Splinter Review

Attachments on bug 10190: 170357 | 170358 | 170359 | 170360 | 170361 | 170362 | 170363 | 170364 | 170365 | 170366 | 170367 | 170368 | 170369 | 170370 | 170371 | 170372 | 170373 | 170374 | 170375 | 170376 | 170380 | 170449 | 171727 | 171728 | 171729 | 171730 | 171731 | 171732 | 171733 | 171734 | 171735 | 171736 | 171737 | 171738 | 171739 | 171740 | 171741 | 171742 | 171743 | 171744 | 171745 | 171746 | 171747 | 171748 | 171749 | 171750 | 171751 | 171752 | 171753 | 171754 | 171755 | 172588 | 172589 | 172590 | 172591 | 172592 | 172593 | 172594 | 172595 | 172596 | 172597 | 172598 | 172599 | 172600 | 172601 | 172602 | 172603 | 172604 | 172605 | 172606 | 172607 | 172608 | 172609 | 172612 | 172614 | 172617 | 172619 | 172621 | 172622 | 172623 | 172624 | 172625 | 172626 | 172630 | 172631 | 172632 | 172633 | 172634 | 172635 | 172636 | 172637 | 172638 | 172639 | 172640 | 172641 | 172642 | 172643 | 172644 | 172645 | 172646 | 172647 | 172648 | 172649 | 172650 | 172651 | 172652 | 172653 | 172654 | 172655 | 172656 | 172657 | 172658 | 172659 | 172660 | 172661 | 172662 | 172663