logging for scheduled mails

1 files changed, 45 insertions, 2 deletions

diff --git a/lib/Migration/Version0010Date20191221183157.php b/lib/Migration/Version0010Date20191221183157.php
index 98b26af5..a1bef29f 100644
--- a/lib/Migration/Version0010Date20191221183157.php
+++ b/lib/Migration/Version0010Date20191221183157.php
@@ -66,8 +66,8 @@ class Version0010Date20191221183157 extends SimpleMigrationStep {
 		/** @var ISchemaWrapper $schema */
 		$schema = $schemaClosure();
 
-		if (!$schema->hasTable('polls_send_mail')) {
-			$table = $schema->createTable('polls_send_mail');
+		if (!$schema->hasTable('polls_notice')) {
+			$table = $schema->createTable('polls_notice');
 			$table->addColumn('id', Type::INTEGER, [
 				'autoincrement' => true,
 				'notnull' => true,
@@ -75,6 +75,10 @@ class Version0010Date20191221183157 extends SimpleMigrationStep {
 			$table->addColumn('poll_id', Type::INTEGER, [
 				'notnull' => true
 			]);
+			$table->addColumn('channel', Type::STRING, [
+				'notnull' => false,
+				'length' => 64
+			]);
 			$table->addColumn('user_id', Type::STRING, [
 				'notnull' => false,
 				'length' => 1024
@@ -95,6 +99,45 @@ class Version0010Date20191221183157 extends SimpleMigrationStep {
 				'notnull' => false,
 				'length' => 1024
 			]);
+
+			$table->setPrimaryKey(['id']);
+		}
+
+		if (!$schema->hasTable('polls_log')) {
+			$table = $schema->createTable('polls_log');
+			$table->addColumn('id', Type::INTEGER, [
+				'autoincrement' => true,
+				'notnull' => true
+			]);
+			$table->addColumn('created', Type::DATETIME, [
+				'notnull' => true
+			]);
+			$table->addColumn('processed', Type::BOOLEAN, [
+				'notnull' => true,
+				'default' => false
+			]);
+			$table->addColumn('processed_date', Type::DATETIME, [
+				'notnull' => true
+			]);
+			$table->addColumn('poll_id', Type::INTEGER, [
+				'notnull' => true
+			]);
+			$table->addColumn('user_id', Type::STRING, [
+				'notnull' => false,
+				'length' => 1024
+			]);
+			$table->addColumn('display_name', Type::STRING, [
+				'notnull' => false,
+				'length' => 64
+			]);
+			$table->addColumn('message_id', Type::STRING, [
+				'notnull' => false,
+				'length' => 64
+			]);
+			$table->addColumn('message', Type::STRING, [
+				'notnull' => false,
+				'length' => 1024
+			]);
 			$table->setPrimaryKey(['id']);
 		}