CREATE TABLE usuarios (
  id INT AUTO_INCREMENT PRIMARY KEY,
  imagem_url VARCHAR(255),
  status_online BOOLEAN DEFAULT true,
  chat_session_id INT DEFAULT NULL,
  timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
);


CREATE TABLE mensagens (
  id INT AUTO_INCREMENT PRIMARY KEY,
  chat_session_id INT,
  remetente_id INT,
  mensagem TEXT,
  timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE favoritos (
  id INT AUTO_INCREMENT PRIMARY KEY,
  id_usuario VARCHAR(255),
  id_favoritado VARCHAR(255),
  timestamp DATETIME DEFAULT CURRENT_TIMESTAMP
);
