Attachment 153353 Details for Bug 33537 – Bug 33537: Database revision, adding table mail_domain_limits

[patch] Bug 33537: Database revision, adding table mail_domain_limits

Bug-33537-Database-revision-adding-table-maildomai.patch (text/plain), 3.12 KB, created by Marcel de Rooy on 2023-07-12 12:37:16 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2023-07-12 12:37:16 UTC

Size: 3.12 KB

patch

obsolete

>From 9f2bcaceb6eb9074ed526d3c285687c449eddad2 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Wed, 28 Jun 2023 12:18:53 +0000
>Subject: [PATCH] Bug 33537: Database revision, adding table mail_domain_limits
>Content-Type: text/plain; charset=utf-8
>
>Test plan:
>Run dbrev or new install.
>Verify that table is created as expected.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> installer/data/mysql/atomicupdate/bug33537.pl | 28 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        | 18 ++++++++++++
> 2 files changed, 46 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug33537.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug33537.pl b/installer/data/mysql/atomicupdate/bug33537.pl
>new file mode 100755
>index 0000000000..8a621d9f81
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug33537.pl
>@@ -0,0 +1,28 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => 33537,
>+    description => "Add table mail_domain_limits",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+
>+        if ( !table_exists('mail_domain_limits') ) {
>+            $dbh->do(q{
>+CREATE TABLE `mail_domain_limits` (
>+  `id` int(11) NOT NULL AUTO_INCREMENT,
>+  `domain_name` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
>+  `domain_limit` int(11) DEFAULT NULL,
>+  `units` int(11) DEFAULT NULL,
>+  `unit_type` enum('minutes','hours','days') COLLATE utf8mb4_unicode_ci,
>+  `belongs_to` int(11) DEFAULT NULL,
>+  PRIMARY KEY (`id`),
>+  UNIQUE KEY `mail_domain_limits_uniq1` (`domain_name`(191)),
>+  KEY `mail_domain_limits_fk1` (`belongs_to`),
>+  CONSTRAINT `mail_domain_limits_fk1` FOREIGN KEY (`belongs_to`) REFERENCES `mail_domain_limits` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+            });
>+            say $out "Added new table 'mail_domain_limits'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 8c05d11cd9..f88c8b96e8 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4005,6 +4005,24 @@ CREATE TABLE `localization` (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>+--
>+-- Table structure for table `mail_domain_limits`
>+--
>+
>+CREATE TABLE `mail_domain_limits` (
>+  `id` int(11) NOT NULL AUTO_INCREMENT,
>+  `domain_name` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
>+  `domain_limit` int(11) DEFAULT NULL,
>+  `units` int(11),
>+  `unit_type` enum('minutes','hours','days') COLLATE utf8mb4_unicode_ci,
>+  `belongs_to` int(11) DEFAULT NULL,
>+  PRIMARY KEY (`id`),
>+  UNIQUE KEY `mail_domain_limits_uniq1` (`domain_name`(191)),
>+  KEY `mail_domain_limits_fk1` (`belongs_to`),
>+  CONSTRAINT `mail_domain_limits_fk1` FOREIGN KEY (`belongs_to`) REFERENCES `mail_domain_limits` (`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 `marc_matchers`
> --
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 33537: 153351 | 153352 | 153353 | 153354 | 153355 | 153356 | 153357 | 153358 | 153359 | 153361 | 153362 | 153363 | 153364 | 154769 | 154770 | 154771 | 154772 | 154773 | 154774 | 154775 | 154776 | 154777 | 154778 | 154779 | 154818 | 154819 | 154820 | 154821 | 154822 | 154823 | 154824 | 154825 | 154826 | 154827 | 154828 | 154829 | 154830 | 154831 | 154832 | 154833 | 154869 | 154870 | 154871 | 154872 | 154873 | 157017 | 157018 | 157019 | 157020 | 157021 | 157022 | 157023 | 157024 | 157025 | 157026 | 157027 | 157028 | 157029 | 157030 | 157031 | 157032 | 157038 | 157039 | 157040 | 157041 | 157042 | 157043 | 157044 | 157045 | 157046 | 157047 | 157048