Modern Docker Management, Designed for Everyone
Go composecontainer-managementcontainersdockerdocker-composedocker-managementgoself-hostedsveltekittypescriptweb-ui
-- +goose Up
CREATE TABLE IF NOT EXISTS notification_settings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
provider VARCHAR(50) NOT NULL,
enabled BOOLEAN DEFAULT 0,
config TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX idx_notification_settings_provider ON notification_settings(provider);
CREATE TABLE IF NOT EXISTS notification_logs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
provider VARCHAR(50) NOT NULL,
image_ref VARCHAR(255) NOT NULL,
status VARCHAR(50) NOT NULL,
error TEXT,
metadata TEXT,
sent_at DATETIME NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX idx_notification_logs_provider ON notification_logs(provider);
CREATE INDEX idx_notification_logs_sent_at ON notification_logs(sent_at);
-- +goose Down
DROP TABLE IF EXISTS notification_logs;
DROP TABLE IF EXISTS notification_settings;