-- #migration 2026_07_31_167_admin_quiz_views
-- Tracking des quiz vus par les admins

CREATE TABLE IF NOT EXISTS admin_quiz_views (
    id         VARCHAR(36)  NOT NULL PRIMARY KEY DEFAULT (UUID()),
    admin_id   VARCHAR(36)  NOT NULL,
    user_id    VARCHAR(36)  NOT NULL,
    quiz_type  VARCHAR(50)  NOT NULL,  -- 'audit' | 'quiz_profil' | 'activite'
    quiz_id    VARCHAR(36)  NOT NULL,  -- id de l'audit ou du feedback
    viewed_at  DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_view (admin_id, quiz_type, quiz_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;