SET NAMES utf8mb4;

ALTER TABLE content_variants ADD COLUMN IF NOT EXISTS media_id BIGINT UNSIGNED NULL;

CREATE INDEX IF NOT EXISTS idx_variant_media ON content_variants(media_id);

CREATE TABLE IF NOT EXISTS app_health_checks (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    check_name VARCHAR(150) NOT NULL,
    status ENUM('ok','warning','error') NOT NULL,
    details TEXT NULL,
    checked_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_health_name_time(check_name,checked_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
