qt-chat-app

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs

U1766771022__update.sql (124B)


      1 CREATE VIEW user_chats AS
      2 SELECT cp.user_id, c.*
      3 FROM chat AS c
      4 INNER JOIN chat_participation AS cp
      5   ON cp.chat_id = c.id;