data.sql

INSERT INTO userAccount VALUES (1, 'toto', 'totopwd123'),
                                (2, 'tata', 'tatapwd'),
                                (3, 'titi', 'lepwdDeTiti'),
                                (4, 'tutu', '1234567890');


INSERT INTO thread VALUES (1, 2, 'Gaming'),
                            (2, 3, 'Animaux'),
                            (3, 3, 'Objet perdu'),
                            (4, 1, 'Discution');


INSERT INTO follow VALUES (2,1, TO_DATE('11/02/2025', 'DD/MM/YYYY')),
                            (3,2, TO_DATE('05/01/2025', 'DD/MM/YYYY')),
                            (3,3, TO_DATE('01/03/2025', 'DD/MM/YYYY')),
                            (1,4, TO_DATE('20/09/2025', 'DD/MM/YYYY'));


INSERT INTO msg VALUES (1, 3 , 1, 'Bonjour !'),
                        (2, 4, 1, 'Hello !'),
                        (3, 1, 3, 'Mon objet était ici.');


INSERT INTO reactions VALUES (2, 1, 'TRUE'),
                                (4,3, 'FALSE'),
                                (3, 3, 'TRUE');