Select Git revision
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');