From 32f0677dbca9e3347b931c1d0105eb37aa57e90d Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Fri, 25 Jun 2021 16:21:17 +0200
Subject: [eventlog] Add event filtering and notification system

---
 modules-available/main/install.inc.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)

(limited to 'modules-available/main/install.inc.php')

diff --git a/modules-available/main/install.inc.php b/modules-available/main/install.inc.php
index fe572487..b7dd2c4d 100644
--- a/modules-available/main/install.inc.php
+++ b/modules-available/main/install.inc.php
@@ -59,6 +59,31 @@ $res[] = tableCreate('session', "
 	KEY `dateline` (`dateline`)
 ");
 
+$res[] = tableCreate('mail_queue', "
+	`mailid` int(10) unsigned NOT NULL AUTO_INCREMENT,
+	`rcpt` varchar(200) NOT NULL,
+	`subject` varchar(500) NOT NULL,
+	`body` blob NOT NULL,
+	`dateline` int(10) unsigned NOT NULL,
+	`configid` int(10) unsigned NOT NULL,
+	`nexttry` int(10) unsigned NOT NULL DEFAULT '0',
+	PRIMARY KEY (`mailid`),
+	KEY (`configid`),
+	KEY (`nexttry`)
+");
+
+$res[] = tableCreate('mail_config', "
+	`configid` int(10) unsigned NOT NULL AUTO_INCREMENT,
+	`host` varchar(100) NOT NULL,
+	`port` smallint(5) UNSIGNED NOT NULL,
+	`ssl` ENUM('FORCE_NONE', 'NONE', 'IMPLICIT', 'EXPLICIT') NOT NULL,
+	`senderaddress` varchar(100) NOT NULL,
+	`replyto` varchar(100) NOT NULL,
+	`username` varchar(100) NOT NULL,
+	`password` varchar(100) NOT NULL,
+	PRIMARY KEY (`configid`)
+");
+
 // Update path
 
 // #######################
@@ -98,6 +123,9 @@ if ($someUser !== false && (int)$someUser['userid'] !== 1) {
 	Database::exec('UPDATE user SET userid = 1 WHERE userid = :oldid', ['oldid' => $someUser['userid']]);
 }
 
+$res[] = tableAddConstraint('mail_queue', 'configid', 'mail_config', 'configid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
 // Create response for browser
 
 if (in_array(UPDATE_DONE, $res)) {
-- 
cgit v1.2.3-55-g7522