-- Chat data for conversations
INSERT INTO chat_rooms (id, name, type, study_id, created_by, created_at) VALUES
(101, 'Discussion on PCOS Study', 'study', 1, 1, NOW()),
(102, 'Maternal Mortality Review Chat', 'study', 2, 2, NOW()),
(103, 'Endometriosis Pain Study Group', 'study', 3, 3, NOW());

INSERT INTO chat_participants (id, room_id, user_id, joined_at) VALUES
(101, 101, 1, NOW()),
(102, 101, 2, NOW()),
(103, 102, 2, NOW()),
(104, 102, 3, NOW()),
(105, 103, 3, NOW()),
(106, 103, 4, NOW());

INSERT INTO messages (room_id, sender_id, message, message_type, is_read, created_at) VALUES
(101, 2, 'Did you see the latest publication?', 'text', 0, NOW()),
(101, 1, 'Yes, it was very insightful.', 'text', 0, NOW()),
(102, 3, 'Let''s discuss the study results tomorrow.', 'text', 0, NOW()),
(102, 4, 'Sure, I''ll prepare the slides.', 'text', 0, NOW());