From 12eadad60d155b8bf1fd8b62f472a8ed18137836 Mon Sep 17 00:00:00 2001 From: Martin Renvoize 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