-- database/fixtures/phase05_quiz_fixture.sql
--
-- REFERENCE ONLY. The actual fixture loader is a PHP class
-- (Tfb\Install\Phase05Fixture::load()) because auto-increment ids
-- must be captured and threaded between INSERTs (profile ids into
-- option_profile_scores, question ids into question_options, etc.)
-- — a plain .sql file cannot express that portably.
--
-- Load it with:
--   php bin/load_phase05_fixture.php
--
-- What it creates (test slug: phase05-quiz-fixture):
--   - 1 test, result_display_mode='single', threshold=3
--   - 3 profiles: پروفایل الف (A), پروفایل ب (B), پروفایل ج (C)
--   - 3 questions, 2-3 options each, all option->profile scores >= 0
--   - 3 results, one per profile, each with a DIFFERENT content
--     shape on purpose (see Phase05Fixture class docblock):
--       result_a: description text + CTA button       (full content)
--       result_b: voice attachment only, no text/CTA   (media-only)
--       result_c: no text, no media, CTA button only   (CTA-only)
--
-- Answer paths and the score scenario they exercise:
--   [q1_a, q2_a, q3_a] -> profile A = 10, clear single winner
--   [q1_a, q2_b, q3_b] -> profile A = 5, profile B = 5, exact tie
--   [q1_a, q2_a, q3_c] -> profile A = 8, profile C = 3, gap = 5
--
-- See tests/phase05_runtime_smoke.php for the automated assertions
-- built on top of this fixture.