wallos/migrations/000017.php
Miguel Ribeiro 899482982e
feat: add discord and pushover as notification agents (#300)
fix: most error messages of the notifications endpoints would not reach the frontend
2024-05-06 18:55:10 +02:00

19 lines
547 B
PHP

<?php
/*
* This migration adds tables to store the date about the new notification methods (pushover and discord)
*/
/** @noinspection PhpUndefinedVariableInspection */
$db->exec('CREATE TABLE IF NOT EXISTS pushover_notifications (
enabled BOOLEAN DEFAULT 0,
user_key TEXT DEFAULT "",
token TEXT DEFAULT ""
)');
$db->exec('CREATE TABLE IF NOT EXISTS discord_notifications (
enabled BOOLEAN DEFAULT 0,
webhook_url TEXT DEFAULT "",
bot_username TEXT DEFAULT "",
bot_avatar_url TEXT DEFAULT ""
)');