Skip to content
Snippets Groups Projects
Select Git revision
  • 6d5c473595218790755ac39563593ce7b00d40f3
  • main default protected
  • 39-retour-utilisateur-sur-le-compteur
3 results

Main.java

Blame
  • data.sql 1.11 KiB
    INSERT INTO userAccount (username, password) VALUES ('toto', 'totopwd123'),
                                    ('tata', 'tatapwd'),
                                    ('titi', 'lepwdDeTiti'),
                                    ('tutu', '1234567890');
    
    
    INSERT INTO thread VALUES (1, 2, 'Gaming'),
                                (2, 3, 'Animaux'),
                                (3, 3, 'Objet perdu'),
                                (4, 1, 'Discussion');
    
    
    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 !', TO_DATE('11/02/2025', 'DD/MM/YYYY')),
                            (2, 4, 1, 'Hello !', TO_DATE('18/02/2025', 'DD/MM/YYYY')),
                            (3, 1, 3, 'Mon objet était ici.', TO_DATE('02/02/2025', 'DD/MM/YYYY'));
    
    
    INSERT INTO reactions VALUES (2, 1, 'TRUE'),
                                    (4,3, 'FALSE'),
                                    (3, 3, 'TRUE');