diff options
| author | Kyren223 <Kyren223@proton.me> | 2024-11-02 13:13:11 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2024-11-02 13:18:21 +0200 |
| commit | 7ad5f5aa60cc940dbd4c6ec6cb091e7214a3fdb4 (patch) | |
| tree | 4a24d486c9257bae5dc11623832e158fe3591625 /query/messages.sql | |
| parent | 8e3d1c5beebac25c15b348b073b253ec30c1b3f4 (diff) | |
feat(data): update message queries
Diffstat (limited to 'query/messages.sql')
| -rw-r--r-- | query/messages.sql | 12 |
1 files changed, 2 insertions, 10 deletions
diff --git a/query/messages.sql b/query/messages.sql index 1e982b1..a598754 100644 --- a/query/messages.sql +++ b/query/messages.sql @@ -2,18 +2,10 @@ SELECT * FROM messages ORDER BY id; --- name: CreateDirectMessage :one -INSERT INTO messages ( - id, content, sender_id, receiver_id -) VALUES ( - ?, ?, ?, ? -) -RETURNING *; - -- name: CreateMessage :one INSERT INTO messages ( - id, content, sender_id, frequency_id + id, content, sender_id, frequency_id, receiver_id ) VALUES ( - ?, ?, ?, ? + ?, ?, ?, ?, ? ) RETURNING *; |