-- Default 20/20/60 split (common Nigerian termly convention).
-- Set is_active=1 only on the one currently in force; results.marks_allocation_id
-- should point at whichever row was active when the score was entered,
-- so historical results stay correct even if the split changes later.

INSERT IGNORE INTO marks_allocations (id, ca1_max, ca2_max, exam_max, is_active) VALUES
(1, 20, 20, 60, 1);
