=== CPP Complete Exam Rebuild ===

Course ID: 21, Domain 1: 23, Domain 2: 25, Domain 3: 26

✓ Pre-Assessment Test (CPP Domain 1) (ID: 38, 25 questions, 100 answers, 25 correct)
✓ Test 01 - Information Security (ID: 39, 40 questions, 160 answers, 40 correct)
✓ Test 02 - Information Security (ID: 40, 50 questions, 200 answers, 50 correct)
✓ Test 03 - Information Security (Domain 1 Final) (ID: 41, 100 questions, 400 answers, 100 correct)
✓ Test 04 - BPP (Domain 2) (ID: 45, 50 questions, 200 answers, 50 correct)
✓ Test 05 - BPP (Domain 2) (ID: 46, 30 questions, 120 answers, 30 correct)
✓ Test 06 - BPP (Domain 2 Final) (ID: 47, 100 questions, 400 answers, 100 correct)
✓ Test 07 - Crisis Management (ID: 48, 27 questions, 108 answers, 27 correct)
✓ Test 08 - Crisis Management (ID: 49, 49 questions, 196 answers, 49 correct)
✓ Test 09 - Crisis Management (ID: 50, 39 questions, 156 answers, 39 correct)
✓ Test 10 - Crisis Management (Domain 3 Final) (ID: 51, 100 questions, 400 answers, 100 correct)

--- Running rebuild scripts for real question text ---
Not found: rebuild-domain1-exams.php (answer keys are correct, just missing real text)
Not found: rebuild-domain2-exams.php (answer keys are correct, just missing real text)
Not found: rebuild-domain3-exams.php (answer keys are correct, just missing real text)

--- Re-adding foreign keys ---
✓ fk_ea_question restored
Note: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`u962548319_secure_m_ac`.`#sql-alter-30dcad-a1cdbfa`, CONSTRAINT `fk_sa_answer` FOREIGN KEY (`selected_answer_id`) REFERENCES `exam_answers` (`id`) ON DELETE SET NULL)

=== VERIFICATION ===
Exam                                              Q       Correct
----------------------------------------------------------------------
✓ Pre-Assessment Test (CPP Domain 1)              25      25
✓ Test 01 - Information Security                  40      40
✓ Test 02 - Information Security                  50      50
✓ Test 03 - Information Security (Domain 1 Final) 100     100
✓ Test 04 - BPP (Domain 2)                        50      50
✓ Test 05 - BPP (Domain 2)                        30      30
✓ Test 06 - BPP (Domain 2 Final)                  100     100
✓ Test 07 - Crisis Management                     27      27
✓ Test 08 - Crisis Management                     49      49
✓ Test 09 - Crisis Management                     39      39
✓ Test 10 - Crisis Management (Domain 3 Final)    100     100

✓ ALL EXAMS CORRECT!

DELETE THIS FILE (run-rebuilds.php) NOW!