-- Migration 004 — favicon stockée en BDD + intervalle de sync configurable
-- À exécuter UNE FOIS via phpMyAdmin > base 'monitoring' > onglet SQL.

ALTER TABLE sites
    ADD COLUMN favicon_data MEDIUMTEXT NULL AFTER url,
    ADD COLUMN favicon_mime VARCHAR(50) NULL AFTER favicon_data,
    ADD COLUMN favicon_updated_at TIMESTAMP NULL DEFAULT NULL AFTER favicon_mime,
    ADD COLUMN sync_interval_hours TINYINT UNSIGNED NOT NULL DEFAULT 24 AFTER subscription_started_at;
