-- #migration
CREATE TABLE IF NOT EXISTS quiz_feedback (
  id              INT AUTO_INCREMENT PRIMARY KEY,
  user_id         INT NULL,
  user_email      VARCHAR(255) NULL,
  profile_id      VARCHAR(20) NULL,
  profile_name    VARCHAR(100) NULL,
  rejected_cards  TEXT NULL,        -- [{ id, title }]
  explanation     TEXT NULL,
  quiz_answers    TEXT NULL,        -- [{ question, answer }]
  created_at      DATETIME DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_user_id (user_id),
  INDEX idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS quiz_secondary_answers (
  id              INT AUTO_INCREMENT PRIMARY KEY,
  feedback_id     INT NULL,          -- référence quiz_feedback.id (optionnel)
  user_id         INT NULL,
  user_email      VARCHAR(255) NULL,
  profile_id      VARCHAR(20) NULL,
  profile_name    VARCHAR(100) NULL,
  answers         TEXT NULL,         -- [{ question, answer }]
  created_at      DATETIME DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_feedback_id (feedback_id),
  INDEX idx_user_id (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;