-- Placeholder session/term for initial setup. Confirm real dates with the
-- school before go-live — this just gets the system in a usable state.

INSERT IGNORE INTO sessions (name, start_date, end_date, is_current) VALUES
('2025/2026', '2025-09-01', '2026-07-31', 1);

INSERT IGNORE INTO terms (session_id, name, start_date, end_date, next_term_begins, is_current)
SELECT id, 'First Term', '2025-09-01', '2025-12-12', '2026-01-05', 1
FROM sessions WHERE name = '2025/2026';

INSERT IGNORE INTO terms (session_id, name, start_date, end_date, next_term_begins, is_current)
SELECT id, 'Second Term', '2026-01-05', '2026-04-03', '2026-04-20', 0
FROM sessions WHERE name = '2025/2026';

INSERT IGNORE INTO terms (session_id, name, start_date, end_date, next_term_begins, is_current)
SELECT id, 'Third Term', '2026-04-20', '2026-07-31', NULL, 0
FROM sessions WHERE name = '2025/2026';

-- Standard Nigerian class-level ladder — trim to what the school actually runs.
INSERT IGNORE INTO class_levels (name, category, sequence_order, adm_no_initial) VALUES
('Creche','creche',1,'CR'),
('Pre-Nursery','nursery',2,'PN'),
('Nursery 1','nursery',3,'N1'),
('Nursery 2','nursery',4,'N2'),
('Primary 1','primary',5,'P1'),
('Primary 2','primary',6,'P2'),
('Primary 3','primary',7,'P3'),
('Primary 4','primary',8,'P4'),
('Primary 5','primary',9,'P5'),
('Primary 6','primary',10,'P6'),
('JSS 1','jss',11,'J1'),
('JSS 2','jss',12,'J2'),
('JSS 3','jss',13,'J3'),
('SSS 1','sss',14,'S1'),
('SSS 2','sss',15,'S2'),
('SSS 3','sss',16,'S3');
