-- Run this on an existing database that already has the Evony bot tables.
-- Records which pre-SvS bubble reminders were already sent so cron does not repeat them.

CREATE TABLE IF NOT EXISTS svs_reminders (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    svs_starts_at DATETIME NOT NULL,
    kind ENUM('d3', 'h24', 'h8', 'h3') NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_svs_reminders_start_kind (svs_starts_at, kind)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
