blob: 72a05f1a37d0c87669ca6edb0aa0ada2096c61d3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- name: SetLastReadMessage :exec
INSERT INTO last_read_messages (
user_id, source_id, last_read
) VALUES (?, ?, ?)
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 (?, ?, ?);
|
