database.sql

-- Base de données Gestion AESH
-- Créé pour la circonscription de Vienne

CREATE DATABASE IF NOT EXISTS gestion_aesh CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE gestion_aesh;

-- Table des établissements
CREATE TABLE etablissements (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nom VARCHAR(200) NOT NULL,
    login VARCHAR(50) NOT NULL,
    password VARCHAR(10) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Table des élèves
CREATE TABLE eleves (
    id INT AUTO_INCREMENT PRIMARY KEY,
    nom_prenom VARCHAR(200) NOT NULL,
    etablissement_id INT NOT NULL,
    classe VARCHAR(100),
    notif_i VARCHAR(50),
    notif_m VARCHAR(50),
    plan_b TINYINT DEFAULT 0,
    aesh VARCHAR(200) DEFAULT '',
    heures_effectives DECIMAL(5,2) DEFAULT NULL,
    remarques TEXT,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (etablissement_id) REFERENCES etablissements(id)
);

-- Compte administrateur
CREATE TABLE admin (
    id INT AUTO_INCREMENT PRIMARY KEY,
    login VARCHAR(50) NOT NULL,
    password VARCHAR(255) NOT NULL
);

INSERT INTO admin (login, password) VALUES ('admin', 'aesh2025');

-- ETABLISSEMENTS
INSERT INTO etablissements (nom, login, password) VALUES
('BELLERIVE Lycée pro', 'BELLERIVE', '10137'),
('BELLERIVE ULIS Lycée', 'BELLERIVE', '10274'),
('BERT Ecole', 'BERT', '10411'),
('BUISSON Ecole', 'BUISSON', '10548'),
('CHORIER Ecole', 'CHORIER', '10685'),
('EYZIN-PINET Ecole', 'EYZIN-PINET', '10822'),
('LAFAYETTE Ecole', 'LAFAYETTE', '10959'),
('MARCEL Ecole', 'MARCEL', '11096'),
('PONSARD Collège', 'PONSARD', '11233'),
('PONSARD ULIS Collège', 'PONSARD', '11370'),
('ROBIN BTS', 'ROBIN', '11507'),
('ROBIN Collège', 'ROBIN', '11644'),
('ROBIN Ecole', 'ROBIN', '11781'),
('ROBIN Lycée', 'ROBIN', '11918'),
('ROBIN Lycée pro', 'ROBIN', '12055'),
('ROBIN ULIS Collège', 'ROBIN', '12192'),
('ROBIN ULIS Lycée pro', 'ROBIN', '12329'),
('ROSTAND Ecole', 'ROSTAND', '12466'),
('ROSTAND ULIS', 'ROSTAND', '12603'),
('RÉP Ecole maternelle', 'RÉP', '12740'),
('RÉP Ecole élémentaire', 'RÉP', '12877'),
('SAINT-CHARLES Collège', 'SAINT-CHARLES', '13014'),
('SAINT-CHARLES Ecole', 'SAINT-CHARLES', '13151'),
('SAINT-CHARLES Lycée', 'SAINT-CHARLES', '13288'),
('SAINT-LOUIS Ecole', 'SAINT-LOUIS', '13425'),
('SEPTÈME Ecole', 'SEPTÈME', '13562'),
('TABLE-RONDE Ecole', 'TABLE-RONDE', '13699');

-- ELEVES
INSERT INTO eleves (nom_prenom, etablissement_id, classe, notif_i, notif_m, plan_b) VALUES
('Abed Kenzy', 26, 'CM2', '', '', 0),
('Abid Ritèj', 9, '4°', '18H00-2025', '', 0),
('Aboab Robin', 11, 'BTS1', '', '', 0),
('Acilan Mikail', 19, 'CM1', '', 'ULIS-2027', 0),
('Aissat Romane', 9, 'G-4°SEGPA', '', 'ULIS-2027', 0),
('Akin Atalay', 22, '6°', '12H00-2026', '', 0),
('Akin Enes ', 19, 'CE2', '', 'ULIS-2028', 0),
('Aksoy Noa', 25, 'CM2', '12H00-2026', '', 0),
('Allard Axel', 9, 'G-5°SEGPA', '', 'SEGPA-2027', 0),
('Alloui Tracanelli Lenny', 23, 'CM1', '', 'M-2027', 0),
('Alloui Tracanelli Noah-gelé', 23, 'G-CM1', '', '', 0),
('Alves Maron Malone', 27, 'CE2', '12H00-2026', '', 0),
('Amador Bochatey Diego', 16, 'G-5°', '', 'ULIS-2028', 0),
('Amador Bochatey Juan', 17, 'CAP1', '12H00-2028', 'ULIS-2028', 0),
('Anastasi Hugo', 21, 'CM1', '12H00-2027', '', 0),
('Arnoux Gabriel', 16, 'G-4°', '', 'ULIS-2027', 0),
('Arslan Bouhkris Acif', 4, 'GS', '18H00-2026', '', 0),
('Arslan Emir', 25, 'CM2', '', 'M-2027', 0),
('Aydin Alisir ', 18, 'CE1', '12H00', '', 1),
('Aydogmus Baran', 10, '4°', '', 'ULIS-2027', 0),
('Badel Lucas', 3, 'GS maintien notifié', '12H00', '', 1),
('Baillon Gary', 22, '6°', '', 'M-2025', 0),
('Barata Alexis', 12, '4°', '15H00-2027', '', 0),
('Barbe Pablo', 9, '5°', '12H00', '', 1),
('Bardin Camille', 16, 'G-5°', '', 'ULIS-2028', 0),
('Bassounaik Kerson', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Bastard Lison', 13, 'MS', '18H00-2027', '', 0),
('Belbeche Jessim', 9, '6°', '', '2029', 0),
('Belghoul Mohamed', 9, '4°', '', 'M-2026', 0),
('Belouettar Imène', 9, '5°SEGPA', '', 'SEGPA-2028', 0),
('Ben Fradj Jessim', 10, '4°', '', 'M-2025', 0),
('BenaÏssa Kenzy', 9, '6°', '12H00-2026', '', 0),
('Bernadat Justine', 12, '5° ', '', '', 0),
('Bernard de Dompsure Paul', 25, 'G-CE1', '', '', 0),
('Bernet Antonin-Mâat', 22, '4°', '', 'M-2027', 0),
('Bessenay Ange Malone', 15, '3°PM', '', 'M-2026', 0),
('Bianchi Botte Alessandro', 15, 'Sde MRC', '', '', 0),
('Bikard Charlise', 23, '', '', '', 0),
('Blanchard Aubin', 13, 'CM2', '', '', 0),
('Blier Kylian', 14, 'G-1°gale', '', '', 0),
('Blier Maël', 12, 'G-4°', '', '', 0),
('Bossan Corentin', 12, '3°', '', 'M-2026', 0),
('Bouchard Sarah', 12, '4°', '', 'M-2026', 0),
('Boudraa Adem', 10, '3°', '12H00', '', 1),
('Bouquillon Lucas', 1, 'CAP1', '', 'M-2025', 0),
('Bourahli Alyia', 10, '5°', '', 'ULIS-2027', 0),
('Brahimi Dania Noursin', 5, 'CE2', '12H00-2026', '', 0),
('Bride Maxence', 13, 'CM2', '', 'M-2026', 0),
('Bruandet Emma', 12, '5°', '12H00-2028', '', 0),
('Brun Baronnat Thomas', 3, 'CM1', '12H00-2027', '', 0),
('Brunel Rayane', 10, '5°', '', 'ULIS-2028', 0),
('Bruyère Albin', 17, '3°PM', '', 'ULIS-2026', 0),
('Buffat Valencin Angelo', 22, '6°', '', 'M-2026', 0),
('Burguet Louise', 14, '1°gale', '', 'M-2027', 0),
('Cakmak Pauletto Ayhan', 23, 'CE1', '12H00-2027', '', 0),
('Carmo Mendes Mickaël', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Carmo Mendes Ruben', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Carret Ema', 22, '6°', '', 'M-2029', 0),
('Ceaglio Sullyvan', 15, '3°PM ', '', 'M-2026', 0),
('Chaïbi Lounes', 22, '5°', '', '', 0),
('Chakroun Sonia-gelé', 9, '4°', '', '', 0),
('Chalon Louis', 1, 'CAP2', '12H00-2027', '', 0),
('Chapuis Célestin', 15, '3°PM', '', 'M-2026', 0),
('Chardiny Axel', 12, '4°', '', '', 0),
('Charni Jenna', 10, '6°', '', 'ULIS-2029', 0),
('Charreton Cassie', 22, '5°', '', 'M-2026', 0),
('Charrout Farah', 12, '5°', '', 'M-2028', 0),
('Cheret Ewen', 26, 'CM1', '12H00-2027', '', 0),
('Chernov Davyd', 9, '4°', '12H00', '', 1),
('Chernov Levko', 8, 'GS', '15H00-2026', '', 0),
('Cheurfa Jessime', 10, '6°', '', 'ULIS-2029', 0),
('Chiverton Ruben', 23, 'CE2', '', 'M-2028', 0),
('Chougui Nahil', 18, 'G-CM2', '', '', 0),
('Cisse Franck- Adama', 7, 'GS', '12H00', '', 1),
('Clair Kays', 9, '4°', '', 'M-2027', 0),
('Claudon Mélinda', 15, '1°pro', '12H00-2027', '', 0),
('Clavel Romain', 9, '4°', '', 'M-2025', 0),
('Clement Johakim', 23, 'CP', '12H00-2026', '', 0),
('Cognat Mathys', 5, 'CE1', '12H00-2026', '', 0),
('Colovray Emma', 10, '4°', '', 'ULIS-2024', 0),
('Colovray Penel Gabriel', 27, 'CM1', '', '', 0),
('Cornet Enora', 9, '5°SEGPA', '', 'SEGPA-2026', 0),
('Cornet Théo', 9, '3°SEGPA', '', 'ULIS-2026', 1),
('Coruk Feyyaz', 18, '', '12H00-2026', '', 0),
('Coudray Mathias', 9, '5°SEGPA', '', 'SEGPA-2028', 0),
('Cuneyt Ali', 27, 'CM1', '12H00', '', 1),
('Cuneyt Ezo', 8, 'GS acceptation demande maintien', '12H00', '', 1),
('Cuneyt Melek', 8, '', '12H00-2028', '', 0),
('Da Costa Bolant Axel', 24, 'G-1°', '12H00-2029', '', 0),
('Da Costa Liam', 16, '6°', '', 'ULIS-2029', 0),
('Dahbi Salma', 9, '5°SEGPA ??', '', '', 0),
('Dahou Ibrahim', 18, 'CE1', '12H00', '', 1),
('Damak Youssef', 11, 'BTS1', '12H00-2025', '', 0),
('Dambas Pellier Kaïna', 12, '4°', '', '2027', 0),
('Danican Timéo', 25, 'CM2', '', 'M-2030', 0),
('De Felice Raphaël', 23, 'CM1', '', 'M-2027', 0),
('Del Carmine Alexis', 14, '1°gale', '', '', 0),
('Delabre Océane', 2, 'CAP2', '', 'ULIS-2027', 0),
('Delpivar Margaux', 15, 'CAP1', '', 'M-2028', 0),
('Demirci Belinay', 18, 'Maintien CP confirmé par l''inspectrice', '12H00', '', 1),
('Denizot Clément', 15, 'Sde MRC', '18H00-2025', '', 0),
('Desfonds Schartz Hugo', 9, '6°', '15H00-2029', '', 0),
('Dahbi Salma', 9, '4°SEGPA ', '', '', 0),
('Dhennin Faustine', 22, '6°', '', 'M-2029', 0),
('Diallo De Santis Jade', 22, '', '', 'M-2029', 0),
('Diamubeni Joseph', 9, '3°', '', 'M-2026', 0),
('Diop Nouh', 8, 'GS', '12H00-2027', '', 0),
('Disicurik Beyza', 19, 'CM2', '', 'ULIS-2026', 0),
('Dogan Salih', 16, '6°', '', 'ULIS-2026', 0),
('Dokoutchaef Matarelli Ambre', 9, '4°', '', 'M-2027', 0),
('Dominguez Maxime', 12, '4°', '12H00-2027', '', 0),
('Dougerre Corona Paul', 24, '2°Gale', '', '2025', 0),
('Doyen Giaï Pron Adam', 20, 'maintien GS notifié', '12H00', '', 1),
('Draai Mohamed', 18, 'CM1', '12H00', '', 1),
('Dubien Jules', 26, 'GS', '', 'M-2026', 0),
('Duchêne Walter', 2, 'CAP1', '', 'ULIS-2028', 0),
('Duranton Théo', 3, 'CM1', '12H00-2025', '', 0),
('Eken Elifsu', 7, 'CM2', '', 'M-2026', 0),
('El Bouroumi Amir', 25, 'CP', '12H00-2026', '', 0),
('El Goutbi Salma', 27, 'Maintien CM2', '12H00', '', 1),
('Erben Metehan', 18, 'CP', '', 'M-2028', 0),
('Erdik Omer', 10, '3°', '', 'ULIS-2026', 0),
('Eynard Causse Sohan', 18, 'CM2', '12H00-2027', '', 0),
('Fabris Augustin', 12, '5°', '', 'M', 0),
('Fauveau Malpel Hadrien', 24, '2°Gale', '', 'M-2025', 0),
('Ferrer Samper Miguel', 1, 'CAP1', '', 'M-2025', 0),
('Fournel Nohlan', 22, '5°', '', '', 0),
('Fournier Berthalin Tom', 22, '3°', '', 'M-2026', 0),
('Fournier Lise', 19, 'CE1 elle a redoublé son CP', '', 'ULIS-2029', 0),
('Fournier Maël', 22, '5°', '', '', 0),
('Gambier Louane', 17, 'CAP1', '', 'ULIS-2028', 0),
('Garnier Bolanos Amélia', 22, 'G-5°', '', 'M-2028', 0),
('Garon Timéo', 12, '5°', '12H00-2028', '', 0),
('Gaugain Kahlan', 16, '6°', '', 'ULIS-2029', 0),
('Gauthe Neela', 23, 'CM1', '12H00-2027', '', 0),
('Gayvallet Lorenzo', 8, 'GS', '12H00-2027', '', 0),
('Geay Esteban', 5, 'CM1', '', 'M-2027', 0),
('Gelatto Slenn', 15, '3°PM', '', '', 0),
('Ghedjati Haniya', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Ghenam Aridj', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Ghocham Zinedine', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Gilibert Lina', 16, '4°', '', 'ULIS-2027', 0),
('Giraudo Maxime', 1, 'CAP1', '', '2027', 0),
('Giroud Clément', 12, '5°', '', '', 0),
('Gnidach Maël', 22, '6°', '', 'M-2025', 0),
('Gökgul Abdulkadir', 9, '4°', '', 'ULIS-2027', 1),
('Gokkuyu Alya', 18, 'CE2', '', 'M-2027', 0),
('Gonzalez Elena', 26, 'CM1', '', 'M-2027', 0),
('Grigor Minas Mirhan', 24, 'G-1°gale', '', '', 0),
('Gsouma Maïssane', 19, 'CM1', '', 'ULIS-2027', 0),
('Gucenmez Damla', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Gucenmez Kamil', 18, 'CM2', '', 'M-2026', 0),
('Gucenmez Okan', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Guebili Kamel', 10, '6°', '', 'ULIS-2026', 0),
('Guendez Lina', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Guérin Mattys', 5, 'CP', '12H00', '', 1),
('Hadjira Youssef', 19, 'CE2', '', 'ULIS-2026', 0),
('Hagui Younes', 9, '4°', '12H00', '', 1),
('Hasdi Rayan', 9, '5°', '24H00-2028', '', 0),
('Hoarau Elsa', 15, 'CAP2', '30H00-2026', '', 0),
('Houssaini Abdel Malik', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('IMACK QUESAIDI Devrik', 10, '4°', '', 'ULIS-2029', 0),
('Imre Alizée', 12, 'G-5°', '', '', 0),
('Irmak Göcke', 10, '6°', '', 'ULIS-2029', 0),
('Janin Chloé', 22, '6°', '', '', 0),
('Jolly Alya', 18, 'CE2', '', 'M-2029', 0),
('Jonin Soares Lucille', 22, '3°', '', 'M-2028', 0),
('Joulain Jean', 22, '6°', '', '', 0),
('Kadi Sanaa', 9, '5°', '12H00', '', 1),
('Kamanda Mbuyi Jonah', 22, '5°', '15H00-2028', '', 0),
('Kamuanya Tyler', 20, 'MS', '18H00-2027', '', 0),
('Kanmaz Eymen', 3, 'CP', '12H00-2028', '', 0),
('Kanmaz Meylin', 9, '6°', '', 'M-2026', 0),
('Katirci Ali', 9, 'G-4°SEGPA', '', 'SEGPA-2027', 0),
('Khaldi Ilyan', 23, 'CP', '', '', 0),
('Kibabi Adam', 18, 'CM2', '', '', 0),
('KOCAER Murat', 9, '6°', '12H00-2027', '', 1),
('Koksal Ali-Han', 9, '4° plan B', '', 'ULIS-2027', 1),
('Lamarque Charline', 6, 'MS', '24H00-2027', '', 0),
('Laroussi-Troster Rayan', 7, 'CM2', '12H00-2026', '', 0),
('Lelièvre Romain', 22, '6°', '', '', 0),
('Leprêtre Ludovic', 24, '2°Gale', '', '', 0),
('Lesouef Thomas', 12, '6°', '', 'M-2029', 0),
('Letourneur Léna', 16, 'G-5°', '', 'ULIS-2028', 0),
('Lo Diarra', 24, '2°Gale', '', '', 0),
('Lopez Shaïm', 27, 'CM2', '', '', 0),
('Madekour Adam', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Magand Diogo', 9, '4°', '12H00-2025', '', 0),
('Mahsas Nahil', 18, 'Redoublement CP l''inspectrice n''est pas informée pour le moment.', '12H00-2026', '', 0),
('Maiorano Nina', 19, 'CM2', '', 'ULIS-2026', 0),
('Maisonneuve Ernest', 13, 'CM2', '', 'M-2026', 0),
('Maleau Kylian', 21, 'CP', '12H00-2028', '', 0),
('Marie Andréa', 9, '6°SEGPA', '', 'SEGPA-2026', 0),
('Marnas Augustin', 23, 'CE1', '12H00-2027', '', 0),
('Marras Thomas', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Marrocco Milo', 22, '4°', '', '', 0),
('Martin Léopold', 12, '5°', '', 'M-2028', 0),
('Martinez Surble Maëly', 10, '5°', '', 'ULIS-2028', 0),
('Martinez Surble Yohan', 9, 'G-4°SEGPA', '', 'SEGPA-2027', 0),
('Matera Josué', 9, '3°', '', 'M-2025', 0),
('Mazoyzer Alessandro', 9, '3°', '', '', 0),
('Mboh Ekossono Tyron', 18, 'GS', '15H00-2027', '', 0),
('MBOH Ekossono Eemer', 18, 'PS', '15H00-2028', '', 0),
('Mebarki Ambrien', 11, 'BTS1', '', '2027', 0),
('Mechtaoui Keylian', 4, 'GS', '12H00-2025', '', 0),
('Michaud Auxilien Marius', 13, 'CM2', '15H00-2026', '', 0),
('Miguel Lagrava Anton', 14, '2°', '', '', 0),
('Misir Kerem', 3, 'CE2', '', '2028', 0),
('Misir Muhammed', 22, '4°', '', 'M-2027', 0),
('Montaboud Luna', 22, '5°', '', 'M-2027', 0),
('Montagny Léane', 15, 'CAP2', '', 'M-2025', 0),
('Moreira Raphaël', 9, '6°', '', 'M-2025', 0),
('Morel Lana', 15, 'Sde ASSP', '', 'M', 0),
('Morgado Silva Béatrice', 9, 'G-5°SEGPA', '', '', 0),
('Morin Aaliyah', 15, '3°PM', '', 'M-2026', 0),
('Morin-Marty François', 2, 'Sde bac pro ok', '15H00-2028', 'ULIS-2028', 0),
('Moulin Poulenard Quentin', 1, 'CAP2', '', 'M-2027', 0),
('Moutier Ethan', 5, 'CE1', '12H00', '', 1),
('Mtiri Sarah', 7, 'CP', '12H00-2025', '', 0),
('MUHO Alkid', 9, '6°', '', 'M-2029', 0),
('Munk Flavie', 22, '5°', '', 'M-2028', 0),
('Munoz Ambre', 9, '6°', '', 'M-2029', 0),
('Munoz Anaïs', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Nacia Nayla', 17, 'CAP2', '', 'ULIS-2028', 0),
('Najem Yaakoub', 21, 'CP', '15H00-2028', '', 0),
('Navarette Piaton Yvain', 22, '6°', '12H00-2029', '', 0),
('Navarro Théo', 22, '6°', '12H00-2026', '', 0),
('Noir Loui ', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Nossant Damien Sacha', 5, 'CM2', '12H00-2026', '', 0),
('Nouatin Nathan', 12, '3°', '', 'M-2026', 0),
('Nunes Djenzy', 9, 'G-4°SEGPA', '', 'SEGPA-2027', 0),
('Olagnon Andy', 22, '5°', '', 'M-2026', 0),
('Ondoua Ondoua Maryam', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Ondoua Ondoua Soumeyma', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Ordek Talia', 10, '5°', '', 'ULIS-2028', 0),
('Oriol Evann', 17, '3°PM', '', 'ULIS-2026', 0),
('Ouachem Ayhem', 9, '3°', '', 'M-2026', 0),
('Ozdal Ibrahim', 7, 'CE2', '15H00-2025', '', 1),
('Ozkan Eymen', 18, 'CE1', '12H00-2027', '', 0),
('Paret Roméo', 16, '6°', '', 'M-2026', 0),
('Partouche Isaiah', 18, 'CE1', '15H00-2027', '', 0),
('Pellier (Dambas)Sarah', 12, '4°', '', 'M-2027', 0),
('Penalver Hélio', 9, '6°', '', 'M-2029', 0),
('Pernot Driouch Otis', 14, 'T°Gale', '', '', 0),
('Perret Alison', 9, '3°', '', 'M-2026', 0),
('Perrin Fanny', 17, '3°PM', '', '', 0),
('Perrin Félix', 22, '4°', '15H00-2026', '', 0),
('Piedbout Thibaut', 9, '6°', '18H00-2026', '', 0),
('Pinaz Cassandra', 16, 'G-5°', '', 'ULIS-2027', 0),
('Pisanu Andréa', 25, 'CM1', '', 'M-2025', 0),
('Poitroisson Eléonor', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Porcher Gladys', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Poulmarc''h Maël', 14, '1°gale', '', '', 0),
('Pulido Leandro', 13, 'CM1', '12H00-2027', '', 0),
('Regnier Arthur', 9, '5°', '', 'M-2028', 0),
('Rodrigues Goncalves Lucia', 23, '', '', 'M-2027', 0),
('Rollet Maïa', 24, '2°Gale', '', '', 0),
('Romero Nolan', 9, '5°', '', 'M-2028', 0),
('Rondel Matis', 15, '3°PM', '12H00-2026', '', 0),
('Rostaing Noémie', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Rouchon Loris', 12, '4°', '', 'M-2025', 0),
('Roy Dos Santos Danaé', 9, '5°', '', '', 0),
('Royer Esteban', 9, '3°', '', '', 0),
('Rubagotti Léna', 26, 'CM2', '', 'M-2026', 0),
('Saïdani Omar', 9, 'G-4°SEGPA', '', '', 0),
('Samier Andréas ', 16, 'G-4°', '', '2027', 0),
('Sanchez Nino', 17, 'CAP1', '', 'ULIS-2028', 0),
('Sanchez Ornella', 16, '5°', '', 'ULIS-2027', 0),
('Sanchez Piaton Noah', 9, '4°SEGPA plan B', '', 'ULIS-2027', 0),
('Sargsyan Arthur', 9, '3°', '', '', 0),
('Sari Ayhan', 19, 'CM1', '', 'ULIS-2027', 0),
('Sauvayre Chegallon Aurélien', 16, '6°', '', 'ULIS-2029', 0),
('Scafi Ella', 13, 'GS', '', 'M-2026', 0),
('Schiavo Anaël', 22, '5°', '12H00-2028', '', 0),
('Sen Cemre', 10, '5°', '', 'ULIS-2028', 0),
('Seneclauze Capucine', 12, '5°', '', '', 0),
('Servant Léa', 15, '1°pro', '', 'M-2027', 0),
('Silva Araujo Hugo', 18, 'CE2', '12H00-2026', '', 0),
('Slimane Amel', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Slimane Manel', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Sonmez Ayaz', 19, 'CM2', '', 'ULIS-2027', 0),
('Soyer Laly', 25, 'CE2', '12H00-2028', '', 0),
('Stelllian Baptiste', 12, '5°', '', 'M-2028', 0),
('Tadjine Hayet', 18, 'GS', '18H00-2026', '', 0),
('Taib Hinde', 18, 'CE2', '12H00-2026', '', 0),
('Taïr Nail', 23, 'CM1', '12H00-2028', '', 0),
('Tedesco Maxence', 9, '4°', '', 'M-2027', 0),
('Texeira Kevin', 9, 'G-5°SEGPA', '', 'SEGPA-2028', 0),
('Themyr Loris', 23, 'CE1', '18H00-2027', '', 0),
('Thevenet Ethan', 23, 'CM1', '12H00-2025', '', 0),
('Thot Lana', 9, '3°SEGPA', '', 'SEGPA-2026', 0),
('Tolsy Manon', 23, 'CM2', '', 'M-2026', 0),
('Touchais Ignacio', 9, '6°', '', '', 0),
('Toulmatine Mohamed', 19, 'CE2', '', 'ULIS-2028', 0),
('Tricaud Noah', 17, 'CAP1', '', 'ULIS-2025', 0),
('Trignac Jusselme Lola', 15, '?', '', '2028', 0),
('Trouba Iglesias Cloé', 15, 'CAP2', '', 'M-2027', 0),
('Truchet Mathéo', 1, 'Bellerive mise à niveau', '', '', 0),
('Turki Farah', 8, 'PS', '18H00-2026', '', 0),
('Umut Bayram', 9, '6°SEGPA', '', 'SEGPA-2029', 0),
('Uzel Corentin', 12, '5°', '', 'M-2028', 0),
('Vaisseau Raphaël', 12, '4°', '', 'M-2027', 0),
('Valette Gabriel', 1, 'T°pro', '15H00-2028', '', 0),
('Valette Lily Rose', 16, 'G-4°', '', 'ULIS-2027', 0),
('Vermeille Aelis', 11, 'BTS1', '', 'M-2026', 0),
('Vidal Gabriel', 3, 'GS', '12H00-2026', '', 0),
('Vilhem Arthur', 22, '5°', '', 'M-2028', 0),
('Wojtowicz Adam ', 12, 'G-5°', '', 'M-2028', 0),
('Yayman Asli Dilan', 9, '6°SEGPA', '', 'ULIS-2026', 1),
('Yilmaz Rumeysa', 16, 'G-5°', '', 'ULIS-2028', 0),
('Zghouri Mohamed', 9, '6°', '12H00-2026', '', 0);