From bc4734d9be292070bb50bc89603ad479fb71bf59 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 1 Dec 2021 17:23:18 +0100
Subject: [eventlog] install: Fix SQL

---
 modules-available/eventlog/install.inc.php                        | 4 ++--
 modules-available/eventlog/templates/page-filters-transports.html | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'modules-available/eventlog')

diff --git a/modules-available/eventlog/install.inc.php b/modules-available/eventlog/install.inc.php
index 3d252138..f6057d23 100644
--- a/modules-available/eventlog/install.inc.php
+++ b/modules-available/eventlog/install.inc.php
@@ -17,7 +17,7 @@ $res[] = tableCreate('notification_rule', '
   `ruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
   `title` varchar(100) NOT NULL,
   `description` text,
-  `type` varchar(40) NOT NULL CHARACTER SET ascii,
+  `type` varchar(40) CHARACTER SET ascii NOT NULL,
   `datafilter` blob NOT NULL,
   `subject` varchar(200) NOT NULL,
   `message` text NOT NULL,
@@ -44,7 +44,7 @@ $res[] = tableCreate('notification_rule_x_transport', '
 $res[] = tableCreate('notification_sample', '
   `type` varchar(40) CHARACTER SET ascii NOT NULL,
   `dateline` int(10) UNSIGNED NOT NULL,
-  `data` blob,
+  `data` mediumblob,
   KEY (`type`, `dateline`)
 ');
 
diff --git a/modules-available/eventlog/templates/page-filters-transports.html b/modules-available/eventlog/templates/page-filters-transports.html
index 34015f2f..3047e437 100644
--- a/modules-available/eventlog/templates/page-filters-transports.html
+++ b/modules-available/eventlog/templates/page-filters-transports.html
@@ -25,7 +25,7 @@
 					href="?do=eventlog&show=transports&id={{transportid}}">
 					<span class="glyphicon glyphicon-edit" aria-label="{{lang_edit}}"></span>
 				</a>
-				<button class="btn btn-xs btn-danger" type="submit" name="id" value="{{ruleid}}"
+				<button class="btn btn-xs btn-danger" type="submit" name="id" value="{{transportid}}"
 						  data-confirm="{{lang_reallyDelete}}">
 					<span class="glyphicon glyphicon-trash"></span>
 				</button>
-- 
cgit v1.2.3-55-g7522