diff options
Diffstat (limited to 'query/notifications.sql')
| -rw-r--r-- | query/notifications.sql | 6 |
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 (?, ?, ?); |