-- ---------------------------------------------------------------
--  ecole.db - base d'exemple du cours SQLite
--  Recree la base a partir de zero :
--      sqlite3 ecole.db < ecole.sql
-- ---------------------------------------------------------------

PRAGMA foreign_keys = ON;

DROP TABLE IF EXISTS note;
DROP TABLE IF EXISTS inscription;
DROP TABLE IF EXISTS cours;
DROP TABLE IF EXISTS eleve;
DROP TABLE IF EXISTS professeur;
DROP TABLE IF EXISTS classe;

-- Une classe : 5TTR, 6TTR...
CREATE TABLE classe (
    id      INTEGER PRIMARY KEY,
    nom     TEXT    NOT NULL UNIQUE,
    annee   INTEGER NOT NULL CHECK (annee BETWEEN 1 AND 6),
    local   TEXT
);

CREATE TABLE professeur (
    id      INTEGER PRIMARY KEY,
    nom     TEXT NOT NULL,
    prenom  TEXT NOT NULL,
    email   TEXT UNIQUE
);

-- classe_id peut etre NULL : un eleve vient d'arriver, pas encore affecte
CREATE TABLE eleve (
    id              INTEGER PRIMARY KEY,
    nom             TEXT NOT NULL,
    prenom          TEXT NOT NULL,
    date_naissance  TEXT,                 -- SQLite n'a pas de type DATE
    classe_id       INTEGER REFERENCES classe(id)
);

CREATE TABLE cours (
    id            INTEGER PRIMARY KEY,
    intitule      TEXT    NOT NULL,
    periodes      INTEGER NOT NULL,
    professeur_id INTEGER NOT NULL REFERENCES professeur(id)
);

-- Table d'association : un eleve suit plusieurs cours,
-- un cours est suivi par plusieurs eleves.
CREATE TABLE inscription (
    eleve_id INTEGER NOT NULL REFERENCES eleve(id),
    cours_id INTEGER NOT NULL REFERENCES cours(id),
    PRIMARY KEY (eleve_id, cours_id)
);

CREATE TABLE note (
    id       INTEGER PRIMARY KEY,
    eleve_id INTEGER NOT NULL REFERENCES eleve(id),
    cours_id INTEGER NOT NULL REFERENCES cours(id),
    date     TEXT    NOT NULL,
    periode  INTEGER NOT NULL CHECK (periode IN (1, 2)),
    valeur   INTEGER NOT NULL CHECK (valeur BETWEEN 0 AND 20)
);

CREATE INDEX idx_eleve_classe ON eleve(classe_id);
CREATE INDEX idx_note_eleve   ON note(eleve_id);


-- ------------------------------------------------------ donnees ---

INSERT INTO classe (id, nom, annee, local) VALUES
  (1, '3TTR', 3, 'B12'),
  (2, '4TTR', 4, 'B14'),
  (3, '5TTR', 5, 'A21'),
  (4, '6TTR', 6, 'A23');

INSERT INTO professeur (id, nom, prenom, email) VALUES
  (1, 'Lambrechts', 'Ludovic', 'l.lambrechts@ecole.be'),
  (2, 'Dubois', 'Sophie', 's.dubois@ecole.be'),
  (3, 'Vermeulen', 'Marc', 'm.vermeulen@ecole.be'),
  (4, 'Leroy', 'Anne', 'a.leroy@ecole.be'),
  (5, 'Depré', 'Nathalie', 'n.depre@ecole.be'),
  (6, 'Martin', 'Julien', 'j.martin@ecole.be'),
  (7, 'Peeters', 'Wim', 'w.peeters@ecole.be'),
  (8, 'Colin', 'Fatima', 'f.colin@ecole.be');

INSERT INTO cours (id, intitule, periodes, professeur_id) VALUES
  (1, 'Bases de données', 4, 1),
  (2, 'Programmation Python', 6, 1),
  (3, 'Réseaux', 4, 3),
  (4, 'Systèmes d''exploitation', 4, 3),
  (5, 'Mathématiques', 4, 2),
  (6, 'Français', 4, 4),
  (7, 'Anglais technique', 2, 7),
  (8, 'Électronique', 4, 6),
  (9, 'Gestion de projet', 2, 5),
  (10, 'Éducation physique', 2, 8),
  (11, 'Néerlandais', 2, 7);

INSERT INTO eleve (id, nom, prenom, date_naissance, classe_id) VALUES
  (1, 'Adam', 'Lucas', '2010-04-07', 1),
  (2, 'Bastin', 'Emma', '2010-07-07', 1),
  (3, 'Charlier', 'Noah', '2010-12-20', 1),
  (4, 'Delvaux', 'Léa', '2010-04-15', 1),
  (5, 'Englebert', 'Hugo', '2010-05-28', 1),
  (6, 'Fontaine', 'Chloé', '2010-09-04', 1),
  (7, 'Gérard', 'Nathan', '2010-04-06', 1),
  (8, 'Hubert', 'Manon', '2010-06-17', 1),
  (9, 'Istas', 'Louis', '2010-05-19', 1),
  (10, 'Jacques', 'Camille', '2010-06-01', 1),
  (11, 'Kevers', 'Arthur', '2009-04-12', 2),
  (12, 'Lambert', 'Sarah', '2009-12-28', 2),
  (13, 'Mahieu', 'Jules', '2009-12-02', 2),
  (14, 'Nihoul', 'Inès', '2009-02-02', 2),
  (15, 'Ozdemir', 'Tom', '2009-01-20', 2),
  (16, 'Piret', 'Zoé', '2009-01-06', 2),
  (17, 'Quintin', 'Maxime', '2009-02-13', 2),
  (18, 'Renard', 'Julie', '2009-07-04', 2),
  (19, 'Simon', 'Théo', '2009-01-19', 2),
  (20, 'Thiry', 'Alice', '2008-05-26', 3),
  (21, 'Urbain', 'Antoine', '2008-10-03', 3),
  (22, 'Vandenbroucke', 'Elena', '2008-09-04', 3),
  (23, 'Wauters', 'Simon', '2008-04-11', 3),
  (24, 'Xhonneux', 'Nina', '2008-12-06', 3),
  (25, 'Yilmaz', 'Robin', '2008-04-11', 3),
  (26, 'Zune', 'Lina', '2008-01-18', 3),
  (27, 'Bruyère', 'Victor', '2007-08-09', 4),
  (28, 'Collard', 'Maya', '2007-02-10', 4),
  (29, 'Dethier', 'Gaspard', '2007-08-25', 4),
  (30, 'Evrard', 'Iris', '2007-07-06', 4),
  (31, 'Falize', 'Élias', '2007-12-08', 4),
  (32, 'Grégoire', 'Jade', '2007-04-11', 4),
  (33, 'Nouveau', 'Camille', '2008-03-14', NULL);

INSERT INTO inscription (eleve_id, cours_id) VALUES
  (1, 5),
  (1, 6),
  (1, 7),
  (1, 10),
  (1, 2),
  (2, 5),
  (2, 6),
  (2, 7),
  (2, 10),
  (2, 2),
  (3, 5),
  (3, 6),
  (3, 7),
  (3, 10),
  (3, 2),
  (4, 5),
  (4, 6),
  (4, 7),
  (4, 10),
  (4, 2),
  (5, 5),
  (5, 6),
  (5, 7),
  (5, 10),
  (5, 2),
  (6, 5),
  (6, 6),
  (6, 7),
  (6, 10),
  (6, 2),
  (7, 5),
  (7, 6),
  (7, 7),
  (7, 10),
  (7, 2),
  (8, 5),
  (8, 6),
  (8, 7),
  (8, 10),
  (8, 2),
  (9, 5),
  (9, 6),
  (9, 7),
  (9, 10),
  (9, 2),
  (10, 5),
  (10, 6),
  (10, 7),
  (10, 10),
  (10, 2),
  (11, 5),
  (11, 6),
  (11, 7),
  (11, 10),
  (11, 2),
  (11, 8),
  (12, 5),
  (12, 6),
  (12, 7),
  (12, 10),
  (12, 2),
  (12, 8),
  (13, 5),
  (13, 6),
  (13, 7),
  (13, 10),
  (13, 2),
  (13, 8),
  (14, 5),
  (14, 6),
  (14, 7),
  (14, 10),
  (14, 2),
  (14, 8),
  (15, 5),
  (15, 6),
  (15, 7),
  (15, 10),
  (15, 2),
  (15, 8),
  (16, 5),
  (16, 6),
  (16, 7),
  (16, 10),
  (16, 2),
  (16, 8),
  (17, 5),
  (17, 6),
  (17, 7),
  (17, 10),
  (17, 2),
  (17, 8),
  (18, 5),
  (18, 6),
  (18, 7),
  (18, 10),
  (18, 2),
  (18, 8),
  (19, 5),
  (19, 6),
  (19, 7),
  (19, 10),
  (19, 2),
  (19, 8),
  (20, 5),
  (20, 6),
  (20, 7),
  (20, 10),
  (20, 1),
  (20, 2),
  (20, 3),
  (21, 5),
  (21, 6),
  (21, 7),
  (21, 10),
  (21, 1),
  (21, 2),
  (21, 3),
  (22, 5),
  (22, 6),
  (22, 7),
  (22, 10),
  (22, 1),
  (22, 2),
  (22, 3),
  (23, 5),
  (23, 6),
  (23, 7),
  (23, 10),
  (23, 1),
  (23, 2),
  (23, 3),
  (24, 5),
  (24, 6),
  (24, 7),
  (24, 10),
  (24, 1),
  (24, 2),
  (24, 3),
  (25, 5),
  (25, 6),
  (25, 7),
  (25, 10),
  (25, 1),
  (25, 2),
  (25, 3),
  (26, 5),
  (26, 6),
  (26, 7),
  (26, 10),
  (26, 1),
  (26, 2),
  (26, 3),
  (27, 5),
  (27, 6),
  (27, 7),
  (27, 10),
  (27, 1),
  (27, 2),
  (27, 3),
  (27, 4),
  (27, 9),
  (28, 5),
  (28, 6),
  (28, 7),
  (28, 10),
  (28, 1),
  (28, 2),
  (28, 3),
  (28, 4),
  (28, 9),
  (29, 5),
  (29, 6),
  (29, 7),
  (29, 10),
  (29, 1),
  (29, 2),
  (29, 3),
  (29, 4),
  (29, 9),
  (30, 5),
  (30, 6),
  (30, 7),
  (30, 10),
  (30, 1),
  (30, 2),
  (30, 3),
  (30, 4),
  (30, 9),
  (31, 5),
  (31, 6),
  (31, 7),
  (31, 10),
  (31, 1),
  (31, 2),
  (31, 3),
  (31, 4),
  (31, 9),
  (32, 5),
  (32, 6),
  (32, 7),
  (32, 10),
  (32, 1),
  (32, 2),
  (32, 3),
  (32, 4),
  (32, 9);

INSERT INTO note (id, eleve_id, cours_id, date, periode, valeur) VALUES
  (1, 1, 5, '2026-06-15', 2, 11),
  (2, 1, 6, '2026-12-15', 1, 16),
  (3, 1, 6, '2026-06-15', 2, 8),
  (4, 1, 7, '2026-12-15', 1, 4),
  (5, 1, 10, '2026-12-15', 1, 9),
  (6, 1, 10, '2026-06-15', 2, 13),
  (7, 1, 2, '2026-12-15', 1, 17),
  (8, 1, 2, '2026-06-15', 2, 18),
  (9, 2, 6, '2026-06-15', 2, 12),
  (10, 2, 7, '2026-12-15', 1, 12),
  (11, 2, 7, '2026-06-15', 2, 10),
  (12, 2, 10, '2026-12-15', 1, 13),
  (13, 2, 2, '2026-12-15', 1, 11),
  (14, 2, 2, '2026-06-15', 2, 12),
  (15, 3, 5, '2026-12-15', 1, 13),
  (16, 3, 6, '2026-12-15', 1, 16),
  (17, 3, 6, '2026-06-15', 2, 15),
  (18, 3, 7, '2026-12-15', 1, 15),
  (19, 3, 7, '2026-06-15', 2, 10),
  (20, 3, 10, '2026-06-15', 2, 15),
  (21, 3, 2, '2026-12-15', 1, 16),
  (22, 3, 2, '2026-06-15', 2, 7),
  (23, 4, 5, '2026-12-15', 1, 16),
  (24, 4, 5, '2026-06-15', 2, 11),
  (25, 4, 6, '2026-06-15', 2, 16),
  (26, 4, 7, '2026-12-15', 1, 13),
  (27, 4, 7, '2026-06-15', 2, 14),
  (28, 4, 10, '2026-12-15', 1, 13),
  (29, 4, 10, '2026-06-15', 2, 10),
  (30, 4, 2, '2026-12-15', 1, 9),
  (31, 4, 2, '2026-06-15', 2, 16),
  (32, 5, 5, '2026-12-15', 1, 14),
  (33, 5, 5, '2026-06-15', 2, 11),
  (34, 5, 6, '2026-12-15', 1, 12),
  (35, 5, 6, '2026-06-15', 2, 11),
  (36, 5, 7, '2026-12-15', 1, 10),
  (37, 5, 7, '2026-06-15', 2, 16),
  (38, 5, 10, '2026-12-15', 1, 13),
  (39, 5, 10, '2026-06-15', 2, 16),
  (40, 5, 2, '2026-12-15', 1, 18),
  (41, 5, 2, '2026-06-15', 2, 13),
  (42, 6, 5, '2026-12-15', 1, 11),
  (43, 6, 5, '2026-06-15', 2, 17),
  (44, 6, 6, '2026-12-15', 1, 19),
  (45, 6, 6, '2026-06-15', 2, 17),
  (46, 6, 7, '2026-12-15', 1, 15),
  (47, 6, 7, '2026-06-15', 2, 13),
  (48, 6, 10, '2026-12-15', 1, 10),
  (49, 6, 10, '2026-06-15', 2, 17),
  (50, 6, 2, '2026-06-15', 2, 12),
  (51, 7, 5, '2026-12-15', 1, 10),
  (52, 7, 5, '2026-06-15', 2, 14),
  (53, 7, 6, '2026-12-15', 1, 9),
  (54, 7, 6, '2026-06-15', 2, 5),
  (55, 7, 7, '2026-12-15', 1, 8),
  (56, 7, 7, '2026-06-15', 2, 15),
  (57, 7, 10, '2026-12-15', 1, 9),
  (58, 7, 10, '2026-06-15', 2, 13),
  (59, 7, 2, '2026-12-15', 1, 17),
  (60, 7, 2, '2026-06-15', 2, 11),
  (61, 8, 5, '2026-12-15', 1, 15),
  (62, 8, 5, '2026-06-15', 2, 19),
  (63, 8, 6, '2026-12-15', 1, 16),
  (64, 8, 7, '2026-12-15', 1, 12),
  (65, 8, 10, '2026-12-15', 1, 9),
  (66, 8, 2, '2026-12-15', 1, 13),
  (67, 9, 5, '2026-12-15', 1, 13),
  (68, 9, 5, '2026-06-15', 2, 16),
  (69, 9, 6, '2026-12-15', 1, 16),
  (70, 9, 6, '2026-06-15', 2, 15),
  (71, 9, 7, '2026-12-15', 1, 12),
  (72, 9, 7, '2026-06-15', 2, 13),
  (73, 9, 10, '2026-12-15', 1, 12),
  (74, 9, 10, '2026-06-15', 2, 16),
  (75, 9, 2, '2026-12-15', 1, 18),
  (76, 9, 2, '2026-06-15', 2, 9),
  (77, 10, 5, '2026-12-15', 1, 16),
  (78, 10, 6, '2026-12-15', 1, 14),
  (79, 10, 6, '2026-06-15', 2, 13),
  (80, 10, 7, '2026-12-15', 1, 18),
  (81, 10, 7, '2026-06-15', 2, 10),
  (82, 10, 10, '2026-12-15', 1, 13),
  (83, 10, 10, '2026-06-15', 2, 13),
  (84, 10, 2, '2026-06-15', 2, 16),
  (85, 11, 5, '2026-06-15', 2, 10),
  (86, 11, 6, '2026-06-15', 2, 13),
  (87, 11, 7, '2026-12-15', 1, 20),
  (88, 11, 7, '2026-06-15', 2, 12),
  (89, 11, 10, '2026-12-15', 1, 18),
  (90, 11, 10, '2026-06-15', 2, 16),
  (91, 11, 2, '2026-12-15', 1, 10),
  (92, 11, 2, '2026-06-15', 2, 14),
  (93, 11, 8, '2026-12-15', 1, 12),
  (94, 11, 8, '2026-06-15', 2, 14),
  (95, 12, 5, '2026-12-15', 1, 10),
  (96, 12, 5, '2026-06-15', 2, 11),
  (97, 12, 6, '2026-12-15', 1, 8),
  (98, 12, 6, '2026-06-15', 2, 16),
  (99, 12, 7, '2026-12-15', 1, 6),
  (100, 12, 7, '2026-06-15', 2, 13),
  (101, 12, 10, '2026-12-15', 1, 14),
  (102, 12, 10, '2026-06-15', 2, 13),
  (103, 12, 2, '2026-12-15', 1, 13),
  (104, 12, 2, '2026-06-15', 2, 11),
  (105, 12, 8, '2026-12-15', 1, 12),
  (106, 12, 8, '2026-06-15', 2, 16),
  (107, 13, 5, '2026-12-15', 1, 13),
  (108, 13, 5, '2026-06-15', 2, 11),
  (109, 13, 6, '2026-12-15', 1, 19),
  (110, 13, 6, '2026-06-15', 2, 17),
  (111, 13, 7, '2026-06-15', 2, 13),
  (112, 13, 10, '2026-12-15', 1, 13),
  (113, 13, 10, '2026-06-15', 2, 8),
  (114, 13, 2, '2026-12-15', 1, 10),
  (115, 13, 2, '2026-06-15', 2, 12),
  (116, 13, 8, '2026-12-15', 1, 14),
  (117, 13, 8, '2026-06-15', 2, 15),
  (118, 14, 5, '2026-12-15', 1, 14),
  (119, 14, 5, '2026-06-15', 2, 13),
  (120, 14, 6, '2026-12-15', 1, 14),
  (121, 14, 6, '2026-06-15', 2, 10),
  (122, 14, 7, '2026-12-15', 1, 8),
  (123, 14, 7, '2026-06-15', 2, 12),
  (124, 14, 10, '2026-12-15', 1, 15),
  (125, 14, 10, '2026-06-15', 2, 17),
  (126, 14, 2, '2026-12-15', 1, 14),
  (127, 14, 2, '2026-06-15', 2, 14),
  (128, 14, 8, '2026-12-15', 1, 11),
  (129, 14, 8, '2026-06-15', 2, 14),
  (130, 15, 5, '2026-06-15', 2, 8),
  (131, 15, 6, '2026-12-15', 1, 12),
  (132, 15, 6, '2026-06-15', 2, 15),
  (133, 15, 7, '2026-12-15', 1, 12),
  (134, 15, 7, '2026-06-15', 2, 15),
  (135, 15, 10, '2026-12-15', 1, 9),
  (136, 15, 10, '2026-06-15', 2, 9),
  (137, 15, 2, '2026-12-15', 1, 11),
  (138, 15, 2, '2026-06-15', 2, 9),
  (139, 15, 8, '2026-12-15', 1, 14),
  (140, 16, 5, '2026-12-15', 1, 15),
  (141, 16, 5, '2026-06-15', 2, 14),
  (142, 16, 6, '2026-12-15', 1, 11),
  (143, 16, 6, '2026-06-15', 2, 20),
  (144, 16, 7, '2026-12-15', 1, 13),
  (145, 16, 7, '2026-06-15', 2, 14),
  (146, 16, 10, '2026-12-15', 1, 17),
  (147, 16, 10, '2026-06-15', 2, 8),
  (148, 16, 2, '2026-06-15', 2, 17),
  (149, 16, 8, '2026-06-15', 2, 17),
  (150, 17, 5, '2026-12-15', 1, 17),
  (151, 17, 5, '2026-06-15', 2, 8),
  (152, 17, 6, '2026-12-15', 1, 6),
  (153, 17, 6, '2026-06-15', 2, 15),
  (154, 17, 7, '2026-12-15', 1, 16),
  (155, 17, 10, '2026-12-15', 1, 18),
  (156, 17, 10, '2026-06-15', 2, 14),
  (157, 17, 2, '2026-12-15', 1, 11),
  (158, 17, 2, '2026-06-15', 2, 14),
  (159, 17, 8, '2026-12-15', 1, 11),
  (160, 17, 8, '2026-06-15', 2, 16),
  (161, 18, 5, '2026-12-15', 1, 17),
  (162, 18, 6, '2026-12-15', 1, 15),
  (163, 18, 6, '2026-06-15', 2, 17),
  (164, 18, 7, '2026-12-15', 1, 14),
  (165, 18, 7, '2026-06-15', 2, 11),
  (166, 18, 10, '2026-12-15', 1, 13),
  (167, 18, 10, '2026-06-15', 2, 15),
  (168, 18, 2, '2026-12-15', 1, 17),
  (169, 18, 2, '2026-06-15', 2, 13),
  (170, 18, 8, '2026-12-15', 1, 15),
  (171, 18, 8, '2026-06-15', 2, 12),
  (172, 19, 5, '2026-12-15', 1, 16),
  (173, 19, 6, '2026-12-15', 1, 15),
  (174, 19, 6, '2026-06-15', 2, 10),
  (175, 19, 7, '2026-12-15', 1, 18),
  (176, 19, 7, '2026-06-15', 2, 10),
  (177, 19, 10, '2026-12-15', 1, 11),
  (178, 19, 10, '2026-06-15', 2, 16),
  (179, 19, 2, '2026-12-15', 1, 15),
  (180, 19, 2, '2026-06-15', 2, 13),
  (181, 19, 8, '2026-12-15', 1, 10),
  (182, 20, 5, '2026-06-15', 2, 14),
  (183, 20, 6, '2026-12-15', 1, 7),
  (184, 20, 7, '2026-12-15', 1, 13),
  (185, 20, 7, '2026-06-15', 2, 15),
  (186, 20, 10, '2026-12-15', 1, 12),
  (187, 20, 10, '2026-06-15', 2, 11),
  (188, 20, 1, '2026-12-15', 1, 11),
  (189, 20, 1, '2026-06-15', 2, 11),
  (190, 20, 2, '2026-12-15', 1, 16),
  (191, 20, 2, '2026-06-15', 2, 6),
  (192, 20, 3, '2026-12-15', 1, 9),
  (193, 20, 3, '2026-06-15', 2, 11),
  (194, 21, 5, '2026-12-15', 1, 14),
  (195, 21, 5, '2026-06-15', 2, 10),
  (196, 21, 6, '2026-12-15', 1, 18),
  (197, 21, 6, '2026-06-15', 2, 8),
  (198, 21, 7, '2026-06-15', 2, 11),
  (199, 21, 10, '2026-06-15', 2, 14),
  (200, 21, 1, '2026-12-15', 1, 13),
  (201, 21, 1, '2026-06-15', 2, 12),
  (202, 21, 2, '2026-12-15', 1, 16),
  (203, 21, 2, '2026-06-15', 2, 20),
  (204, 21, 3, '2026-12-15', 1, 10),
  (205, 21, 3, '2026-06-15', 2, 20),
  (206, 22, 5, '2026-12-15', 1, 18),
  (207, 22, 5, '2026-06-15', 2, 10),
  (208, 22, 6, '2026-12-15', 1, 11),
  (209, 22, 6, '2026-06-15', 2, 13),
  (210, 22, 7, '2026-12-15', 1, 17),
  (211, 22, 7, '2026-06-15', 2, 16),
  (212, 22, 10, '2026-12-15', 1, 17),
  (213, 22, 10, '2026-06-15', 2, 11),
  (214, 22, 1, '2026-12-15', 1, 19),
  (215, 22, 1, '2026-06-15', 2, 12),
  (216, 22, 2, '2026-12-15', 1, 13),
  (217, 22, 2, '2026-06-15', 2, 20),
  (218, 22, 3, '2026-12-15', 1, 10),
  (219, 22, 3, '2026-06-15', 2, 14),
  (220, 23, 5, '2026-12-15', 1, 15),
  (221, 23, 5, '2026-06-15', 2, 14),
  (222, 23, 6, '2026-12-15', 1, 9),
  (223, 23, 6, '2026-06-15', 2, 12),
  (224, 23, 7, '2026-06-15', 2, 15),
  (225, 23, 10, '2026-12-15', 1, 10),
  (226, 23, 10, '2026-06-15', 2, 16),
  (227, 23, 1, '2026-12-15', 1, 4),
  (228, 23, 1, '2026-06-15', 2, 16),
  (229, 23, 2, '2026-12-15', 1, 13),
  (230, 23, 2, '2026-06-15', 2, 16),
  (231, 23, 3, '2026-12-15', 1, 19),
  (232, 23, 3, '2026-06-15', 2, 14),
  (233, 24, 5, '2026-06-15', 2, 17),
  (234, 24, 6, '2026-12-15', 1, 19),
  (235, 24, 6, '2026-06-15', 2, 16),
  (236, 24, 7, '2026-12-15', 1, 12),
  (237, 24, 7, '2026-06-15', 2, 16),
  (238, 24, 10, '2026-12-15', 1, 15),
  (239, 24, 10, '2026-06-15', 2, 13),
  (240, 24, 1, '2026-12-15', 1, 13),
  (241, 24, 2, '2026-12-15', 1, 14),
  (242, 24, 2, '2026-06-15', 2, 16),
  (243, 24, 3, '2026-06-15', 2, 13),
  (244, 25, 5, '2026-12-15', 1, 14),
  (245, 25, 5, '2026-06-15', 2, 15),
  (246, 25, 6, '2026-12-15', 1, 15),
  (247, 25, 7, '2026-12-15', 1, 14),
  (248, 25, 7, '2026-06-15', 2, 11),
  (249, 25, 10, '2026-12-15', 1, 9),
  (250, 25, 10, '2026-06-15', 2, 9),
  (251, 25, 1, '2026-12-15', 1, 9),
  (252, 25, 1, '2026-06-15', 2, 10),
  (253, 25, 2, '2026-12-15', 1, 15),
  (254, 25, 2, '2026-06-15', 2, 13),
  (255, 25, 3, '2026-12-15', 1, 11),
  (256, 25, 3, '2026-06-15', 2, 15),
  (257, 26, 5, '2026-12-15', 1, 9),
  (258, 26, 5, '2026-06-15', 2, 10),
  (259, 26, 6, '2026-12-15', 1, 19),
  (260, 26, 6, '2026-06-15', 2, 16),
  (261, 26, 7, '2026-12-15', 1, 10),
  (262, 26, 7, '2026-06-15', 2, 20),
  (263, 26, 10, '2026-12-15', 1, 12),
  (264, 26, 10, '2026-06-15', 2, 15),
  (265, 26, 1, '2026-12-15', 1, 16),
  (266, 26, 1, '2026-06-15', 2, 13),
  (267, 26, 2, '2026-12-15', 1, 11),
  (268, 26, 2, '2026-06-15', 2, 12),
  (269, 26, 3, '2026-06-15', 2, 12),
  (270, 27, 5, '2026-12-15', 1, 8),
  (271, 27, 5, '2026-06-15', 2, 12),
  (272, 27, 6, '2026-12-15', 1, 15),
  (273, 27, 6, '2026-06-15', 2, 13),
  (274, 27, 7, '2026-12-15', 1, 14),
  (275, 27, 7, '2026-06-15', 2, 9),
  (276, 27, 10, '2026-12-15', 1, 12),
  (277, 27, 10, '2026-06-15', 2, 18),
  (278, 27, 1, '2026-12-15', 1, 10),
  (279, 27, 1, '2026-06-15', 2, 17),
  (280, 27, 2, '2026-06-15', 2, 11),
  (281, 27, 3, '2026-12-15', 1, 16),
  (282, 27, 3, '2026-06-15', 2, 17),
  (283, 27, 4, '2026-12-15', 1, 12),
  (284, 27, 4, '2026-06-15', 2, 14),
  (285, 27, 9, '2026-12-15', 1, 20),
  (286, 27, 9, '2026-06-15', 2, 15),
  (287, 28, 5, '2026-12-15', 1, 14),
  (288, 28, 5, '2026-06-15', 2, 12),
  (289, 28, 6, '2026-12-15', 1, 15),
  (290, 28, 6, '2026-06-15', 2, 13),
  (291, 28, 7, '2026-12-15', 1, 10),
  (292, 28, 7, '2026-06-15', 2, 14),
  (293, 28, 10, '2026-12-15', 1, 9),
  (294, 28, 10, '2026-06-15', 2, 14),
  (295, 28, 1, '2026-12-15', 1, 14),
  (296, 28, 1, '2026-06-15', 2, 13),
  (297, 28, 2, '2026-12-15', 1, 15),
  (298, 28, 3, '2026-06-15', 2, 11),
  (299, 28, 4, '2026-12-15', 1, 17),
  (300, 28, 4, '2026-06-15', 2, 10),
  (301, 28, 9, '2026-12-15', 1, 13),
  (302, 28, 9, '2026-06-15', 2, 14),
  (303, 29, 5, '2026-12-15', 1, 11),
  (304, 29, 5, '2026-06-15', 2, 14),
  (305, 29, 6, '2026-12-15', 1, 14),
  (306, 29, 6, '2026-06-15', 2, 14),
  (307, 29, 7, '2026-12-15', 1, 10),
  (308, 29, 7, '2026-06-15', 2, 13),
  (309, 29, 10, '2026-12-15', 1, 15),
  (310, 29, 10, '2026-06-15', 2, 15),
  (311, 29, 1, '2026-12-15', 1, 11),
  (312, 29, 1, '2026-06-15', 2, 10),
  (313, 29, 2, '2026-12-15', 1, 11),
  (314, 29, 2, '2026-06-15', 2, 13),
  (315, 29, 3, '2026-12-15', 1, 13),
  (316, 29, 3, '2026-06-15', 2, 10),
  (317, 29, 4, '2026-12-15', 1, 6),
  (318, 29, 4, '2026-06-15', 2, 10),
  (319, 29, 9, '2026-12-15', 1, 8),
  (320, 29, 9, '2026-06-15', 2, 15),
  (321, 30, 5, '2026-12-15', 1, 12),
  (322, 30, 5, '2026-06-15', 2, 11),
  (323, 30, 6, '2026-12-15', 1, 13),
  (324, 30, 6, '2026-06-15', 2, 15),
  (325, 30, 7, '2026-12-15', 1, 13),
  (326, 30, 7, '2026-06-15', 2, 12),
  (327, 30, 10, '2026-12-15', 1, 13),
  (328, 30, 10, '2026-06-15', 2, 15),
  (329, 30, 1, '2026-12-15', 1, 10),
  (330, 30, 1, '2026-06-15', 2, 9),
  (331, 30, 2, '2026-12-15', 1, 17),
  (332, 30, 2, '2026-06-15', 2, 10),
  (333, 30, 3, '2026-12-15', 1, 16),
  (334, 30, 3, '2026-06-15', 2, 19),
  (335, 30, 4, '2026-12-15', 1, 19),
  (336, 30, 4, '2026-06-15', 2, 16),
  (337, 30, 9, '2026-06-15', 2, 18),
  (338, 31, 5, '2026-06-15', 2, 19),
  (339, 31, 6, '2026-06-15', 2, 16),
  (340, 31, 7, '2026-12-15', 1, 11),
  (341, 31, 7, '2026-06-15', 2, 13),
  (342, 31, 10, '2026-12-15', 1, 14),
  (343, 31, 10, '2026-06-15', 2, 14),
  (344, 31, 1, '2026-12-15', 1, 9),
  (345, 31, 1, '2026-06-15', 2, 13),
  (346, 31, 3, '2026-12-15', 1, 10),
  (347, 31, 3, '2026-06-15', 2, 13),
  (348, 31, 4, '2026-12-15', 1, 12),
  (349, 31, 4, '2026-06-15', 2, 9),
  (350, 31, 9, '2026-12-15', 1, 14),
  (351, 31, 9, '2026-06-15', 2, 13),
  (352, 32, 5, '2026-12-15', 1, 9),
  (353, 32, 5, '2026-06-15', 2, 12),
  (354, 32, 6, '2026-12-15', 1, 14),
  (355, 32, 6, '2026-06-15', 2, 12),
  (356, 32, 7, '2026-12-15', 1, 12),
  (357, 32, 7, '2026-06-15', 2, 8),
  (358, 32, 10, '2026-12-15', 1, 9),
  (359, 32, 1, '2026-12-15', 1, 11),
  (360, 32, 1, '2026-06-15', 2, 16),
  (361, 32, 2, '2026-06-15', 2, 10),
  (362, 32, 3, '2026-12-15', 1, 9),
  (363, 32, 3, '2026-06-15', 2, 17),
  (364, 32, 4, '2026-12-15', 1, 18),
  (365, 32, 4, '2026-06-15', 2, 12),
  (366, 32, 9, '2026-12-15', 1, 12),
  (367, 32, 9, '2026-06-15', 2, 16);