mirror of
https://github.com/Kyren223/eko.git
synced 2025-09-05 21:18:14 +00:00
14 lines
378 B
SQL
14 lines
378 B
SQL
-- 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 (?, ?, ?);
|