When a user sends a message "signal" and the receiving user doesn't have

the signal already open, it will be added as the first signal

1 files changed, 6 insertions, 0 deletions

diff --git a/query/notifications.sql b/query/notifications.sql
index 5dd4d5a..72a05f1 100644
--- a/query/notifications.sql
+++ b/query/notifications.sql
@@ -5,3 +5,9 @@ INSERT INTO last_read_messages (
 ON CONFLICT DO
 UPDATE SET last_read = EXCLUDED.last_read
 WHERE user_id = EXCLUDED.user_id AND source_id = EXCLUDED.source_id;
+
+
+-- name: InsertLastReadMessage :exec
+INSERT OR IGNORE INTO last_read_messages (
+  user_id, source_id, last_read
+) VALUES (?, ?, ?);